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

Line 1: PACKAGE BODY hxc_timecard_deposit AS

1: PACKAGE BODY hxc_timecard_deposit AS
2: /* $Header: hxctimedp.pkb 120.19.12020000.5 2013/02/08 09:18:03 pravesk ship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5:

Line 10: ,p_transaction_info in out nocopy hxc_timecard.transaction_info

6: Procedure add_transaction_info
7: (p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type
8: ,p_object_version_number in hxc_time_building_blocks.object_version_number%type
9: ,p_exception_desc in varchar2
10: ,p_transaction_info in out nocopy hxc_timecard.transaction_info
11: ,p_messages in out nocopy hxc_message_table_type
12: ) is
13:
14: l_index number;

Line 21: hxc_timecard_message_helper.addErrorToCollection

17: Begin
18:
19: if(p_time_building_block_id is null) then
20:
21: hxc_timecard_message_helper.addErrorToCollection
22: (p_messages
23: ,'HXC_NULL_TRANS_BLOCK'
24: ,hxc_timecard.c_error
25: ,null

Line 24: ,hxc_timecard.c_error

20:
21: hxc_timecard_message_helper.addErrorToCollection
22: (p_messages
23: ,'HXC_NULL_TRANS_BLOCK'
24: ,hxc_timecard.c_error
25: ,null
26: ,null
27: ,'HXC'
28: ,null

Line 40: l_status := hxc_timecard.c_trans_error;

36:
37: l_index := p_transaction_info.count + 1;
38:
39: if(p_exception_desc is not null) then
40: l_status := hxc_timecard.c_trans_error;
41: else
42: l_status := hxc_timecard.c_trans_success;
43: end if;
44:

Line 42: l_status := hxc_timecard.c_trans_success;

38:
39: if(p_exception_desc is not null) then
40: l_status := hxc_timecard.c_trans_error;
41: else
42: l_status := hxc_timecard.c_trans_success;
43: end if;
44:
45: p_transaction_info(l_index).time_building_block_id := p_time_building_block_id;
46: p_transaction_info(l_index).object_version_number := p_object_version_number;

Line 56: ,p_transaction_info in out nocopy hxc_timecard.transaction_info

52: End add_transaction_info;
53:
54: Procedure deposit_error
55: (p_messages in out nocopy hxc_message_table_type
56: ,p_transaction_info in out nocopy hxc_timecard.transaction_info
57: ,p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type
58: ,p_time_building_block_ovn in hxc_time_building_blocks.object_version_number%type
59: ) is
60:

Line 77: hxc_timecard_message_helper.addErrorToCollection

73: -- the reason is that we have no corresponding web beans
74: -- on the page at this point to set the item level errors
75: -- on.
76:
77: hxc_timecard_message_helper.addErrorToCollection
78: (p_messages
79: ,hr_message.last_message_name
80: ,hxc_timecard.c_error
81: ,null

Line 80: ,hxc_timecard.c_error

76:
77: hxc_timecard_message_helper.addErrorToCollection
78: (p_messages
79: ,hr_message.last_message_name
80: ,hxc_timecard.c_error
81: ,null
82: ,null
83: ,hr_message.last_message_app
84: ,null

Line 97: hxc_timecard_message_helper.addErrorToCollection

93:
94: if(SQLERRM is not null) then
95: -- fix for 3266231, v115.6
96: -- adding 'BLK_AND_CHILDREN' for "MESSAGE_EXTENT"
97: hxc_timecard_message_helper.addErrorToCollection
98: (p_messages
99: ,'HXC_HXT_DEP_VAL_ORAERR'
100: ,hxc_timecard.c_error
101: ,null

Line 100: ,hxc_timecard.c_error

96: -- adding 'BLK_AND_CHILDREN' for "MESSAGE_EXTENT"
97: hxc_timecard_message_helper.addErrorToCollection
98: (p_messages
99: ,'HXC_HXT_DEP_VAL_ORAERR'
100: ,hxc_timecard.c_error
101: ,null
102: ,substr('ERROR&' || SQLERRM,1,240)
103: ,'HXC'
104: ,null

Line 117: hxc_timecard_message_helper.addErrorToCollection

113: else
114: -- Unable to determine error from stack or SQLERRM,
115: -- set to internal block deposit error.
116:
117: hxc_timecard_message_helper.addErrorToCollection
118: (p_messages
119: ,'HXC_XXXXXX_UNKN_BLOCK_DEP'
120: ,hxc_timecard.c_error
121: ,null

Line 120: ,hxc_timecard.c_error

116:
117: hxc_timecard_message_helper.addErrorToCollection
118: (p_messages
119: ,'HXC_XXXXXX_UNKN_BLOCK_DEP'
120: ,hxc_timecard.c_error
121: ,null
122: ,null
123: ,hxc_timecard.c_hxc
124: ,p_time_building_block_id

Line 123: ,hxc_timecard.c_hxc

119: ,'HXC_XXXXXX_UNKN_BLOCK_DEP'
120: ,hxc_timecard.c_error
121: ,null
122: ,null
123: ,hxc_timecard.c_hxc
124: ,p_time_building_block_id
125: ,p_time_building_block_ovn
126: ,null
127: ,null

Line 131: ||' HXC_TIMECARD_DEPOSIT.DEPOSIT_ERROR';

127: ,null
128: );
129:
130: l_exception_desc := 'An Unknown error has occurred.'
131: ||' HXC_TIMECARD_DEPOSIT.DEPOSIT_ERROR';
132: end if;
133:
134: end if;
135:

Line 171: if(hxc_timecard_attribute_utils.is_corresponding_block

167: EXIT WHEN NOT p_attributes.exists(l_index);
168:
169: l_attribute := p_attributes(l_index);
170:
171: if(hxc_timecard_attribute_utils.is_corresponding_block
172: (p_attribute => l_attribute
173: ,p_block_id => p_building_block_id
174: )
175: ) then

Line 193: if(hxc_timecard_block_utils.is_new_block(p_block)) then

189: return varchar2 is
190:
191: Begin
192:
193: if(hxc_timecard_block_utils.is_new_block(p_block)) then
194: --
195: -- Process flag is set to No for new block.
196: -- User probably entered it, then deleted it
197: -- without commit to db inbetween. Don't

Line 278: ,p_block_list in hxc_timecard.block_list

274: Procedure maintain_dependents
275: (p_blocks in out nocopy hxc_block_table_type
276: ,p_attributes in out nocopy hxc_attribute_table_type
277: ,p_messages in out nocopy hxc_message_table_type
278: ,p_block_list in hxc_timecard.block_list
279: ,l_old_bb_id in hxc_time_building_blocks.time_building_block_id%type
280: ,l_old_ovn in hxc_time_building_blocks.object_version_number%type
281: ,l_new_bb_id in hxc_time_building_blocks.time_building_block_id%type
282: ,l_new_ovn in hxc_time_building_blocks.object_version_number%type

Line 302: l_parent_chk := hxc_timecard_block_utils.is_parent_block

298: EXIT WHEN NOT p_block_list.exists(l_index);
299:
300: l_block := p_blocks(p_block_list(l_index));
301:
302: l_parent_chk := hxc_timecard_block_utils.is_parent_block
303: (p_block => l_block,
304: p_parent_id => l_old_bb_id,
305: p_parent_ovn => l_old_ovn,
306: p_check_id => true

Line 323: hxc_timecard_message_helper.addErrorToCollection

319: -- This means the id matched, but the ovn did not.
320: -- This should never happen when depositing a timecard
321: -- Some likely corruption going on, raise error.
322: --
323: hxc_timecard_message_helper.addErrorToCollection
324: (p_messages
325: ,'HXC_366502_INVALID_PARENT_DEP'
326: ,hxc_timecard.c_error
327: ,null

Line 326: ,hxc_timecard.c_error

322: --
323: hxc_timecard_message_helper.addErrorToCollection
324: (p_messages
325: ,'HXC_366502_INVALID_PARENT_DEP'
326: ,hxc_timecard.c_error
327: ,null
328: ,null
329: ,'HXC'
330: ,l_block.time_building_block_id

Line 351: if(hxc_timecard_attribute_utils.is_corresponding_block

347: EXIT WHEN NOT p_attributes.exists(l_index);
348:
349: --l_attribute := p_attributes(l_index);
350:
351: if(hxc_timecard_attribute_utils.is_corresponding_block
352: (p_attribute => p_attributes(l_index)
353: ,p_block_id => l_old_bb_id
354: )
355: ) then

Line 387: ,p_transaction_info in out nocopy hxc_timecard.transaction_info

383: Procedure deposit_new_block
384: (p_block in out nocopy HXC_BLOCK_TYPE
385: ,p_old_bb_id out nocopy NUMBER
386: ,p_new_bb_id out nocopy NUMBER
387: ,p_transaction_info in out nocopy hxc_timecard.transaction_info
388: ,p_messages in out nocopy hxc_message_table_type
389: ) is
390:
391: l_object_version_number HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE;

Line 406: ,p_start_time => hxc_timecard_block_utils.date_value(p_block.start_time)

402: (p_effective_date => sysdate
403: ,p_type => p_block.type
404: ,p_measure => p_block.measure
405: ,p_unit_of_measure => p_block.unit_of_measure
406: ,p_start_time => hxc_timecard_block_utils.date_value(p_block.start_time)
407: ,p_stop_time => hxc_timecard_block_utils.date_value(p_block.stop_time)
408: ,p_parent_building_block_id => p_block.parent_building_block_id
409: ,p_parent_building_block_ovn => p_block.parent_building_block_ovn
410: ,p_scope => p_block.scope

Line 407: ,p_stop_time => hxc_timecard_block_utils.date_value(p_block.stop_time)

403: ,p_type => p_block.type
404: ,p_measure => p_block.measure
405: ,p_unit_of_measure => p_block.unit_of_measure
406: ,p_start_time => hxc_timecard_block_utils.date_value(p_block.start_time)
407: ,p_stop_time => hxc_timecard_block_utils.date_value(p_block.stop_time)
408: ,p_parent_building_block_id => p_block.parent_building_block_id
409: ,p_parent_building_block_ovn => p_block.parent_building_block_ovn
410: ,p_scope => p_block.scope
411: ,p_approval_style_id => p_block.approval_style_id

Line 456: p_deleted_blocks in out nocopy hxc_timecard.block_list,

452: Procedure deposit_old_block
453: (p_block in out nocopy hxc_block_type,
454: p_old_ovn out nocopy number,
455: p_new_ovn out nocopy number,
456: p_deleted_blocks in out nocopy hxc_timecard.block_list,
457: p_transaction_info in out nocopy hxc_timecard.transaction_info,
458: p_messages in out nocopy hxc_message_table_type
459: ) is
460:

Line 457: p_transaction_info in out nocopy hxc_timecard.transaction_info,

453: (p_block in out nocopy hxc_block_type,
454: p_old_ovn out nocopy number,
455: p_new_ovn out nocopy number,
456: p_deleted_blocks in out nocopy hxc_timecard.block_list,
457: p_transaction_info in out nocopy hxc_timecard.transaction_info,
458: p_messages in out nocopy hxc_message_table_type
459: ) is
460:
461: l_object_version_number hxc_time_building_blocks.object_version_number%type;

Line 480: if(hxc_timecard_block_utils.is_active_block(p_block)) then

476: -- Call the API, with the real values!
477: --
478:
479:
480: if(hxc_timecard_block_utils.is_active_block(p_block)) then
481:
482: hxc_building_block_api.create_building_block
483: (p_effective_date => sysdate
484: ,p_type => p_block.type

Line 487: ,p_start_time => hxc_timecard_block_utils.date_value(p_block.start_time)

483: (p_effective_date => sysdate
484: ,p_type => p_block.type
485: ,p_measure => p_block.measure
486: ,p_unit_of_measure => p_block.unit_of_measure
487: ,p_start_time => hxc_timecard_block_utils.date_value(p_block.start_time)
488: ,p_stop_time => hxc_timecard_block_utils.date_value(p_block.stop_time)
489: ,p_parent_building_block_id => p_block.parent_building_block_id
490: ,p_parent_building_block_ovn => p_block.parent_building_block_ovn
491: ,p_scope => p_block.scope

Line 488: ,p_stop_time => hxc_timecard_block_utils.date_value(p_block.stop_time)

484: ,p_type => p_block.type
485: ,p_measure => p_block.measure
486: ,p_unit_of_measure => p_block.unit_of_measure
487: ,p_start_time => hxc_timecard_block_utils.date_value(p_block.start_time)
488: ,p_stop_time => hxc_timecard_block_utils.date_value(p_block.stop_time)
489: ,p_parent_building_block_id => p_block.parent_building_block_id
490: ,p_parent_building_block_ovn => p_block.parent_building_block_ovn
491: ,p_scope => p_block.scope
492: ,p_approval_style_id => p_block.approval_style_id

Line 550: p_timecard_blocks in hxc_timecard.block_list,

546:
547: Procedure deposit_timecard_blocks
548: (p_blocks in out nocopy hxc_block_table_type,
549: p_attributes in out nocopy hxc_attribute_table_type,
550: p_timecard_blocks in hxc_timecard.block_list,
551: p_day_blocks in hxc_timecard.block_list,
552: p_deleted_blocks in out nocopy hxc_timecard.block_list,
553: p_transaction_info in out nocopy hxc_timecard.transaction_info,
554: p_messages in out nocopy hxc_message_table_type

Line 551: p_day_blocks in hxc_timecard.block_list,

547: Procedure deposit_timecard_blocks
548: (p_blocks in out nocopy hxc_block_table_type,
549: p_attributes in out nocopy hxc_attribute_table_type,
550: p_timecard_blocks in hxc_timecard.block_list,
551: p_day_blocks in hxc_timecard.block_list,
552: p_deleted_blocks in out nocopy hxc_timecard.block_list,
553: p_transaction_info in out nocopy hxc_timecard.transaction_info,
554: p_messages in out nocopy hxc_message_table_type
555: ) is

Line 552: p_deleted_blocks in out nocopy hxc_timecard.block_list,

548: (p_blocks in out nocopy hxc_block_table_type,
549: p_attributes in out nocopy hxc_attribute_table_type,
550: p_timecard_blocks in hxc_timecard.block_list,
551: p_day_blocks in hxc_timecard.block_list,
552: p_deleted_blocks in out nocopy hxc_timecard.block_list,
553: p_transaction_info in out nocopy hxc_timecard.transaction_info,
554: p_messages in out nocopy hxc_message_table_type
555: ) is
556:

Line 553: p_transaction_info in out nocopy hxc_timecard.transaction_info,

549: p_attributes in out nocopy hxc_attribute_table_type,
550: p_timecard_blocks in hxc_timecard.block_list,
551: p_day_blocks in hxc_timecard.block_list,
552: p_deleted_blocks in out nocopy hxc_timecard.block_list,
553: p_transaction_info in out nocopy hxc_timecard.transaction_info,
554: p_messages in out nocopy hxc_message_table_type
555: ) is
556:
557: l_index NUMBER;

Line 574: if(hxc_timecard_block_utils.process_block(l_block)) then

570: EXIT WHEN NOT p_timecard_blocks.exists(l_index);
571:
572: l_block := p_blocks(p_timecard_blocks(l_index));
573: -- if(p_messages.count < 1) then
574: if(hxc_timecard_block_utils.process_block(l_block)) then
575: if(hxc_timecard_block_utils.is_timecard_block(l_block)) then
576:
577: if(hxc_timecard_block_utils.is_new_block(l_block)) then
578: deposit_new_block(l_block,l_old_bb_id,l_new_bb_id,p_transaction_info,p_messages);

Line 575: if(hxc_timecard_block_utils.is_timecard_block(l_block)) then

571:
572: l_block := p_blocks(p_timecard_blocks(l_index));
573: -- if(p_messages.count < 1) then
574: if(hxc_timecard_block_utils.process_block(l_block)) then
575: if(hxc_timecard_block_utils.is_timecard_block(l_block)) then
576:
577: if(hxc_timecard_block_utils.is_new_block(l_block)) then
578: deposit_new_block(l_block,l_old_bb_id,l_new_bb_id,p_transaction_info,p_messages);
579: if(l_new_bb_id is not null) then

Line 577: if(hxc_timecard_block_utils.is_new_block(l_block)) then

573: -- if(p_messages.count < 1) then
574: if(hxc_timecard_block_utils.process_block(l_block)) then
575: if(hxc_timecard_block_utils.is_timecard_block(l_block)) then
576:
577: if(hxc_timecard_block_utils.is_new_block(l_block)) then
578: deposit_new_block(l_block,l_old_bb_id,l_new_bb_id,p_transaction_info,p_messages);
579: if(l_new_bb_id is not null) then
580: add_transaction_info(l_new_bb_id,1,null,p_transaction_info,p_messages);
581: end if;

Line 625: p_day_blocks in hxc_timecard.block_list,

621:
622: Procedure deposit_day_blocks
623: (p_blocks in out nocopy hxc_block_table_type,
624: p_attributes in out nocopy hxc_attribute_table_type,
625: p_day_blocks in hxc_timecard.block_list,
626: p_detail_blocks in hxc_timecard.block_list,
627: p_deleted_blocks in out nocopy hxc_timecard.block_list,
628: p_transaction_info in out nocopy hxc_timecard.transaction_info,
629: p_messages in out nocopy hxc_message_table_type,

Line 626: p_detail_blocks in hxc_timecard.block_list,

622: Procedure deposit_day_blocks
623: (p_blocks in out nocopy hxc_block_table_type,
624: p_attributes in out nocopy hxc_attribute_table_type,
625: p_day_blocks in hxc_timecard.block_list,
626: p_detail_blocks in hxc_timecard.block_list,
627: p_deleted_blocks in out nocopy hxc_timecard.block_list,
628: p_transaction_info in out nocopy hxc_timecard.transaction_info,
629: p_messages in out nocopy hxc_message_table_type,
630: p_timecard_id in number,

Line 627: p_deleted_blocks in out nocopy hxc_timecard.block_list,

623: (p_blocks in out nocopy hxc_block_table_type,
624: p_attributes in out nocopy hxc_attribute_table_type,
625: p_day_blocks in hxc_timecard.block_list,
626: p_detail_blocks in hxc_timecard.block_list,
627: p_deleted_blocks in out nocopy hxc_timecard.block_list,
628: p_transaction_info in out nocopy hxc_timecard.transaction_info,
629: p_messages in out nocopy hxc_message_table_type,
630: p_timecard_id in number,
631: p_timecard_ovn in number

Line 628: p_transaction_info in out nocopy hxc_timecard.transaction_info,

624: p_attributes in out nocopy hxc_attribute_table_type,
625: p_day_blocks in hxc_timecard.block_list,
626: p_detail_blocks in hxc_timecard.block_list,
627: p_deleted_blocks in out nocopy hxc_timecard.block_list,
628: p_transaction_info in out nocopy hxc_timecard.transaction_info,
629: p_messages in out nocopy hxc_message_table_type,
630: p_timecard_id in number,
631: p_timecard_ovn in number
632: ) is

Line 651: if(hxc_timecard_block_utils.process_block(l_block)) then

647: EXIT WHEN NOT p_day_blocks.exists(l_index);
648:
649: l_block := p_blocks(p_day_blocks(l_index));
650:
651: if(hxc_timecard_block_utils.process_block(l_block)) then
652: if(hxc_timecard_block_utils.is_day_block(l_block)) then
653:
654: if(hxc_timecard_block_utils.is_new_block(l_block)) then
655: deposit_new_block(l_block,l_old_bb_id,l_new_bb_id,p_transaction_info,p_messages);

Line 652: if(hxc_timecard_block_utils.is_day_block(l_block)) then

648:
649: l_block := p_blocks(p_day_blocks(l_index));
650:
651: if(hxc_timecard_block_utils.process_block(l_block)) then
652: if(hxc_timecard_block_utils.is_day_block(l_block)) then
653:
654: if(hxc_timecard_block_utils.is_new_block(l_block)) then
655: deposit_new_block(l_block,l_old_bb_id,l_new_bb_id,p_transaction_info,p_messages);
656: add_transaction_info(l_new_bb_id,1,null,p_transaction_info,p_messages);

Line 654: if(hxc_timecard_block_utils.is_new_block(l_block)) then

650:
651: if(hxc_timecard_block_utils.process_block(l_block)) then
652: if(hxc_timecard_block_utils.is_day_block(l_block)) then
653:
654: if(hxc_timecard_block_utils.is_new_block(l_block)) then
655: deposit_new_block(l_block,l_old_bb_id,l_new_bb_id,p_transaction_info,p_messages);
656: add_transaction_info(l_new_bb_id,1,null,p_transaction_info,p_messages);
657: p_blocks(p_day_blocks(l_index)) := l_block;
658: maintain_dependents

Line 1015: p_detail_blocks in hxc_timecard.block_list,

1011:
1012: Procedure deposit_detail_blocks
1013: (p_blocks in out nocopy hxc_block_table_type,
1014: p_attributes in out nocopy hxc_attribute_table_type,
1015: p_detail_blocks in hxc_timecard.block_list,
1016: p_deleted_blocks in out nocopy hxc_timecard.block_list,
1017: p_transaction_info in out nocopy hxc_timecard.transaction_info,
1018: p_messages in out nocopy hxc_message_table_type,
1019: p_timecard_id in number,

Line 1016: p_deleted_blocks in out nocopy hxc_timecard.block_list,

1012: Procedure deposit_detail_blocks
1013: (p_blocks in out nocopy hxc_block_table_type,
1014: p_attributes in out nocopy hxc_attribute_table_type,
1015: p_detail_blocks in hxc_timecard.block_list,
1016: p_deleted_blocks in out nocopy hxc_timecard.block_list,
1017: p_transaction_info in out nocopy hxc_timecard.transaction_info,
1018: p_messages in out nocopy hxc_message_table_type,
1019: p_timecard_id in number,
1020: p_timecard_ovn in number

Line 1017: p_transaction_info in out nocopy hxc_timecard.transaction_info,

1013: (p_blocks in out nocopy hxc_block_table_type,
1014: p_attributes in out nocopy hxc_attribute_table_type,
1015: p_detail_blocks in hxc_timecard.block_list,
1016: p_deleted_blocks in out nocopy hxc_timecard.block_list,
1017: p_transaction_info in out nocopy hxc_timecard.transaction_info,
1018: p_messages in out nocopy hxc_message_table_type,
1019: p_timecard_id in number,
1020: p_timecard_ovn in number
1021: ) is

Line 1025: l_list hxc_timecard.block_list;

1021: ) is
1022:
1023: l_index NUMBER;
1024: l_block HXC_BLOCK_TYPE;
1025: l_list hxc_timecard.block_list;
1026:
1027: l_new_bb_id hxc_time_building_blocks.time_building_block_id%type;
1028: l_old_bb_id hxc_time_building_blocks.time_building_block_id%type;
1029: l_new_ovn hxc_time_building_blocks.object_version_number%type;

Line 1082: if(hxc_timecard_block_utils.is_active_block(l_block) AND is_duplicate_block(p_blocks, l_block)) then

1078: EXIT WHEN NOT p_detail_blocks.exists(l_index) OR l_duplicate_block;
1079:
1080: l_block := p_blocks(p_detail_blocks(l_index));
1081:
1082: if(hxc_timecard_block_utils.is_active_block(l_block) AND is_duplicate_block(p_blocks, l_block)) then
1083: hr_utility.trace(' DUPLICATE BLOCK is TRUE ');
1084: l_duplicate_block := true;
1085: end if;
1086:

Line 1107: hxc_timecard_message_helper.addErrorToCollection

1103: IF g_debug THEN
1104: hr_utility.trace('Found Detail Building Block mapped to wrong line in the timecard .. raise an error');
1105: END IF;
1106:
1107: hxc_timecard_message_helper.addErrorToCollection
1108: (p_messages
1109: ,'HXC_TBB_WRONG_LINE'
1110: ,hxc_timecard.c_error
1111: ,null

Line 1110: ,hxc_timecard.c_error

1106:
1107: hxc_timecard_message_helper.addErrorToCollection
1108: (p_messages
1109: ,'HXC_TBB_WRONG_LINE'
1110: ,hxc_timecard.c_error
1111: ,null
1112: ,null
1113: ,'HXC'
1114: ,null

Line 1123: hxc_timecard_message_helper.addErrorToCollection

1119:
1120: ELSIF(l_duplicate_block) THEN
1121:
1122: hr_utility.trace(' Adding error to table for block : ' || l_block.time_building_block_id);
1123: hxc_timecard_message_helper.addErrorToCollection
1124: (p_messages
1125: ,'HXC_DUP_TIME_BUILDING_BLOCKS'
1126: ,hxc_timecard.c_error
1127: ,null

Line 1126: ,hxc_timecard.c_error

1122: hr_utility.trace(' Adding error to table for block : ' || l_block.time_building_block_id);
1123: hxc_timecard_message_helper.addErrorToCollection
1124: (p_messages
1125: ,'HXC_DUP_TIME_BUILDING_BLOCKS'
1126: ,hxc_timecard.c_error
1127: ,null
1128: ,null
1129: ,'HXC'
1130: ,null

Line 1147: if(hxc_timecard_block_utils.process_block(l_block)) then

1143: EXIT WHEN NOT p_detail_blocks.exists(l_index);
1144:
1145: l_block := p_blocks(p_detail_blocks(l_index));
1146:
1147: if(hxc_timecard_block_utils.process_block(l_block)) then
1148: if(hxc_timecard_block_utils.is_detail_block(l_block)) then
1149:
1150: if(hxc_timecard_block_utils.is_new_block(l_block)) then
1151: if(hxc_timecard_block_utils.is_active_block(l_block)) then

Line 1148: if(hxc_timecard_block_utils.is_detail_block(l_block)) then

1144:
1145: l_block := p_blocks(p_detail_blocks(l_index));
1146:
1147: if(hxc_timecard_block_utils.process_block(l_block)) then
1148: if(hxc_timecard_block_utils.is_detail_block(l_block)) then
1149:
1150: if(hxc_timecard_block_utils.is_new_block(l_block)) then
1151: if(hxc_timecard_block_utils.is_active_block(l_block)) then
1152: deposit_new_block(l_block,l_old_bb_id,l_new_bb_id,p_transaction_info,p_messages);

Line 1150: if(hxc_timecard_block_utils.is_new_block(l_block)) then

1146:
1147: if(hxc_timecard_block_utils.process_block(l_block)) then
1148: if(hxc_timecard_block_utils.is_detail_block(l_block)) then
1149:
1150: if(hxc_timecard_block_utils.is_new_block(l_block)) then
1151: if(hxc_timecard_block_utils.is_active_block(l_block)) then
1152: deposit_new_block(l_block,l_old_bb_id,l_new_bb_id,p_transaction_info,p_messages);
1153: -- OTL - ABS Integration
1154: l_element := find_element(p_attributes,l_old_bb_id);

Line 1151: if(hxc_timecard_block_utils.is_active_block(l_block)) then

1147: if(hxc_timecard_block_utils.process_block(l_block)) then
1148: if(hxc_timecard_block_utils.is_detail_block(l_block)) then
1149:
1150: if(hxc_timecard_block_utils.is_new_block(l_block)) then
1151: if(hxc_timecard_block_utils.is_active_block(l_block)) then
1152: deposit_new_block(l_block,l_old_bb_id,l_new_bb_id,p_transaction_info,p_messages);
1153: -- OTL - ABS Integration
1154: l_element := find_element(p_attributes,l_old_bb_id);
1155: IF g_debug

Line 1185: IF hxc_timecard_block_utils.is_active_block(l_block)

1181: end if;
1182: else
1183: deposit_old_block(l_block,l_old_ovn,l_new_ovn,p_deleted_blocks,p_transaction_info,p_messages);
1184: -- OTL - ABS Integration
1185: IF hxc_timecard_block_utils.is_active_block(l_block)
1186: then
1187: l_element := find_element(p_attributes,l_block.time_building_block_id);
1188: IF g_debug
1189: THEN

Line 1295: p_deleted_blocks in out nocopy hxc_timecard.block_list,

1291: (p_attributes in out nocopy hxc_attribute_table_type,
1292: p_messages in out nocopy hxc_message_table_type,
1293: p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
1294: p_timecard_ovn in hxc_time_building_blocks.object_version_number%type,
1295: p_deleted_blocks in out nocopy hxc_timecard.block_list,
1296: p_blocks in out nocopy hxc_block_table_type,
1297: p_transaction_info in out nocopy hxc_timecard.transaction_info
1298: ) is
1299:

Line 1297: p_transaction_info in out nocopy hxc_timecard.transaction_info

1293: p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
1294: p_timecard_ovn in hxc_time_building_blocks.object_version_number%type,
1295: p_deleted_blocks in out nocopy hxc_timecard.block_list,
1296: p_blocks in out nocopy hxc_block_table_type,
1297: p_transaction_info in out nocopy hxc_timecard.transaction_info
1298: ) is
1299:
1300: l_index number;
1301: l_attribute hxc_attribute_type;

Line 1322: l_list hxc_timecard.block_list;

1318: l_block_index number;
1319: l_old_ovn number;
1320: l_new_ovn number;
1321: l_block HXC_BLOCK_TYPE;
1322: l_list hxc_timecard.block_list;
1323: l_timecard_id number;
1324: l_timecard_ovn number;
1325: l_block_updated number := -999;
1326:

Line 1329: l_updated_blocks hxc_timecard.block_list;

1325: l_block_updated number := -999;
1326:
1327: l_new_bb_id hxc_time_building_blocks.time_building_block_id%type;
1328: l_old_bb_id hxc_time_building_blocks.time_building_block_id%type;
1329: l_updated_blocks hxc_timecard.block_list;
1330: l_local_index number;
1331:
1332: Begin
1333:

Line 1335: l_active_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);

1331:
1332: Begin
1333:
1334: --***********DAYS Vs HOURS - Start ************
1335: l_active_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
1336: l_timecard_id := p_blocks(l_active_index).time_building_block_id;
1337: l_timecard_ovn := p_blocks(l_active_index).object_version_number;
1338: l_start_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).start_time);
1339: l_stop_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).stop_time);

Line 1338: l_start_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).start_time);

1334: --***********DAYS Vs HOURS - Start ************
1335: l_active_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
1336: l_timecard_id := p_blocks(l_active_index).time_building_block_id;
1337: l_timecard_ovn := p_blocks(l_active_index).object_version_number;
1338: l_start_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).start_time);
1339: l_stop_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).stop_time);
1340: l_resource_id := p_blocks(l_active_index).resource_id;
1341:
1342: --Get the Preference value - Time Store Days to Hour Conversion

Line 1339: l_stop_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).stop_time);

1335: l_active_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
1336: l_timecard_id := p_blocks(l_active_index).time_building_block_id;
1337: l_timecard_ovn := p_blocks(l_active_index).object_version_number;
1338: l_start_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).start_time);
1339: l_stop_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).stop_time);
1340: l_resource_id := p_blocks(l_active_index).resource_id;
1341:
1342: --Get the Preference value - Time Store Days to Hour Conversion
1343: hxc_preference_evaluation.resource_preferences(p_resource_id => l_resource_id,

Line 1391: if l_attribute.process <> hxc_timecard.c_process

1387:
1388: IF (l_attribute.ATTRIBUTE_CATEGORY LIKE 'ELEMENT%' OR
1389: l_attribute.ATTRIBUTE_CATEGORY = 'PROJECTS')THEN -- Process only Payroll and Projects attributes
1390:
1391: if l_attribute.process <> hxc_timecard.c_process
1392: and not l_updated_blocks.exists(l_attribute.BUILDING_BLOCK_ID) then
1393:
1394: --When the block/atribute not touched, but the value of the Preference changed like
1395: --Time Category chnaged from NULL => TC1 or TC1=> NULL or TC1=>TC2, so in this case

Line 1422: if l_attribute.process <> hxc_timecard.c_process

1418: ELSE
1419: IF (l_attribute.ATTRIBUTE_CATEGORY = 'PROJECTS')THEN
1420: --l_attribute.ATTRIBUTE_CATEGORY LIKE 'ELEMENT%' OR
1421:
1422: if l_attribute.process <> hxc_timecard.c_process
1423: and nvl(l_attribute.ATTRIBUTE26,1) <> 1
1424: and not l_updated_blocks.exists(l_attribute.BUILDING_BLOCK_ID)
1425: then
1426: --When the Time category is changed from TC1 => NULL, although the block is not touched

Line 1459: if(hxc_timecard_attribute_utils.is_corresponding_block

1455:
1456: LOOP
1457: EXIT WHEN NOT p_attributes.exists(l_local_index);
1458:
1459: if(hxc_timecard_attribute_utils.is_corresponding_block
1460: (p_attribute => p_attributes(l_local_index)
1461: ,p_block_id => l_block.time_building_block_id
1462: )
1463: ) then

Line 1467: p_attributes(l_local_index).process := hxc_timecard.c_process;

1463: ) then
1464:
1465: p_attributes(l_local_index).building_block_id := l_block.time_building_block_id;
1466: p_attributes(l_local_index).building_block_ovn := l_new_ovn;
1467: p_attributes(l_local_index).process := hxc_timecard.c_process;
1468: end if;
1469:
1470: l_local_index := p_attributes.next(l_local_index);
1471:

Line 1482: if((hxc_timecard_attribute_utils.process_attribute(p_attribute => l_attribute))

1478: END IF;
1479:
1480: --***********DAYS Vs HOURS - End ************
1481:
1482: if((hxc_timecard_attribute_utils.process_attribute(p_attribute => l_attribute))
1483: AND
1484: (not p_deleted_blocks.exists(l_attribute.building_block_id))
1485: ) then
1486:

Line 1522: hxc_timecard_attribute_utils.get_bld_blk_info_type_id(l_attribute.bld_blk_info_type)),

1518: P_ATTRIBUTE30 => l_attribute.ATTRIBUTE30,
1519: P_TIME_BUILDING_BLOCK_ID => l_attribute.BUILDING_BLOCK_ID,
1520: P_TBB_OVN => l_attribute.BUILDING_BLOCK_OVN,
1521: P_BLD_BLK_INFO_TYPE_ID => nvl(l_attribute.BLD_BLK_INFO_TYPE_ID,
1522: hxc_timecard_attribute_utils.get_bld_blk_info_type_id(l_attribute.bld_blk_info_type)),
1523: P_TIME_ATTRIBUTE_ID => l_time_attribute_id,
1524: P_OBJECT_VERSION_NUMBER => l_object_version_number
1525: );
1526: --

Line 1553: procedure populate_transaction_data_set(p_transaction_info in out nocopy hxc_timecard.transaction_info)

1549:
1550: End deposit_attributes;
1551:
1552:
1553: procedure populate_transaction_data_set(p_transaction_info in out nocopy hxc_timecard.transaction_info)
1554: is
1555:
1556: cursor c_get_data_set_id(p_tbb_id number,p_tbb_ovn number) is
1557: select data_set_id

Line 1590: p_timecard_blocks in hxc_timecard.block_list,

1586:
1587: Procedure execute
1588: (p_blocks in out nocopy hxc_block_table_type,
1589: p_attributes in out nocopy hxc_attribute_table_type,
1590: p_timecard_blocks in hxc_timecard.block_list,
1591: p_day_blocks in hxc_timecard.block_list,
1592: p_detail_blocks in hxc_timecard.block_list,
1593: p_messages in out nocopy hxc_message_table_type,
1594: p_transaction_info in out nocopy hxc_timecard.transaction_info

Line 1591: p_day_blocks in hxc_timecard.block_list,

1587: Procedure execute
1588: (p_blocks in out nocopy hxc_block_table_type,
1589: p_attributes in out nocopy hxc_attribute_table_type,
1590: p_timecard_blocks in hxc_timecard.block_list,
1591: p_day_blocks in hxc_timecard.block_list,
1592: p_detail_blocks in hxc_timecard.block_list,
1593: p_messages in out nocopy hxc_message_table_type,
1594: p_transaction_info in out nocopy hxc_timecard.transaction_info
1595: ) is

Line 1592: p_detail_blocks in hxc_timecard.block_list,

1588: (p_blocks in out nocopy hxc_block_table_type,
1589: p_attributes in out nocopy hxc_attribute_table_type,
1590: p_timecard_blocks in hxc_timecard.block_list,
1591: p_day_blocks in hxc_timecard.block_list,
1592: p_detail_blocks in hxc_timecard.block_list,
1593: p_messages in out nocopy hxc_message_table_type,
1594: p_transaction_info in out nocopy hxc_timecard.transaction_info
1595: ) is
1596:

Line 1594: p_transaction_info in out nocopy hxc_timecard.transaction_info

1590: p_timecard_blocks in hxc_timecard.block_list,
1591: p_day_blocks in hxc_timecard.block_list,
1592: p_detail_blocks in hxc_timecard.block_list,
1593: p_messages in out nocopy hxc_message_table_type,
1594: p_transaction_info in out nocopy hxc_timecard.transaction_info
1595: ) is
1596:
1597: l_timecard_id hxc_time_building_blocks.time_building_block_id%type;
1598: l_timecard_ovn hxc_time_building_blocks.object_version_number%type;

Line 1600: l_deleted_blocks hxc_timecard.block_list;

1596:
1597: l_timecard_id hxc_time_building_blocks.time_building_block_id%type;
1598: l_timecard_ovn hxc_time_building_blocks.object_version_number%type;
1599:
1600: l_deleted_blocks hxc_timecard.block_list;
1601: l_dummy boolean;
1602:
1603: cursor c_check_bussiness_group_id(p_person_id number, p_timecard_start_date date) is
1604: SELECT business_group_id,

Line 1628: hr_utility.trace('InvalidSecurityContext > Resource_id : '|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id);

1624:
1625: hr_utility.trace('*********************InvalidSecurityContext Trace Start**********************************');
1626: hr_utility.trace('InvalidSecurityContext > PER_BUSINESS_GROUP_ID from fnd profile : '||fnd_profile.value('PER_BUSINESS_GROUP_ID'));
1627: hr_utility.trace('InvalidSecurityContext > ORG_ID from fnd profile : '||fnd_profile.value('ORG_ID'));
1628: hr_utility.trace('InvalidSecurityContext > Resource_id : '|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id);
1629: hr_utility.trace('InvalidSecurityContext > Timecard Start Time :'|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);
1630:
1631: open c_check_bussiness_group_id(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id,
1632: hxc_timecard_block_utils.date_value(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time));

Line 1629: hr_utility.trace('InvalidSecurityContext > Timecard Start Time :'|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);

1625: hr_utility.trace('*********************InvalidSecurityContext Trace Start**********************************');
1626: hr_utility.trace('InvalidSecurityContext > PER_BUSINESS_GROUP_ID from fnd profile : '||fnd_profile.value('PER_BUSINESS_GROUP_ID'));
1627: hr_utility.trace('InvalidSecurityContext > ORG_ID from fnd profile : '||fnd_profile.value('ORG_ID'));
1628: hr_utility.trace('InvalidSecurityContext > Resource_id : '|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id);
1629: hr_utility.trace('InvalidSecurityContext > Timecard Start Time :'|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);
1630:
1631: open c_check_bussiness_group_id(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id,
1632: hxc_timecard_block_utils.date_value(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time));
1633: fetch c_check_bussiness_group_id into l_business_group_id,l_organization_id;

Line 1631: open c_check_bussiness_group_id(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id,

1627: hr_utility.trace('InvalidSecurityContext > ORG_ID from fnd profile : '||fnd_profile.value('ORG_ID'));
1628: hr_utility.trace('InvalidSecurityContext > Resource_id : '|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id);
1629: hr_utility.trace('InvalidSecurityContext > Timecard Start Time :'|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);
1630:
1631: open c_check_bussiness_group_id(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id,
1632: hxc_timecard_block_utils.date_value(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time));
1633: fetch c_check_bussiness_group_id into l_business_group_id,l_organization_id;
1634: close c_check_bussiness_group_id;
1635:

Line 1632: hxc_timecard_block_utils.date_value(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time));

1628: hr_utility.trace('InvalidSecurityContext > Resource_id : '|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id);
1629: hr_utility.trace('InvalidSecurityContext > Timecard Start Time :'|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);
1630:
1631: open c_check_bussiness_group_id(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id,
1632: hxc_timecard_block_utils.date_value(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time));
1633: fetch c_check_bussiness_group_id into l_business_group_id,l_organization_id;
1634: close c_check_bussiness_group_id;
1635:
1636: hr_utility.trace('InvalidSecurityContext > BUSINESS_GROUP_ID of the person : '||l_business_group_id);

Line 1641: hxc_timecard_message_helper.addErrorToCollection

1637: hr_utility.trace('InvalidSecurityContext > ORG_ID of the person : '||l_organization_id);
1638:
1639: IF l_business_group_id <> fnd_profile.value('PER_BUSINESS_GROUP_ID') THEN
1640:
1641: hxc_timecard_message_helper.addErrorToCollection
1642: (p_messages
1643: ,'HXC_366551_INVALID_SEC_CONTEXT' -- You cannot submit this timecard because of invalid security context. Please logout and try again or contact your system administrator.
1644: ,hxc_timecard.c_error
1645: ,null

Line 1644: ,hxc_timecard.c_error

1640:
1641: hxc_timecard_message_helper.addErrorToCollection
1642: (p_messages
1643: ,'HXC_366551_INVALID_SEC_CONTEXT' -- You cannot submit this timecard because of invalid security context. Please logout and try again or contact your system administrator.
1644: ,hxc_timecard.c_error
1645: ,null
1646: ,null
1647: ,'HXC'
1648: ,null

Line 1670: l_timecard_id := p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id;

1666: -- Blocks have to be in order, to ensure
1667: -- self referential integrity
1668:
1669: deposit_timecard_blocks(p_blocks,p_attributes,p_timecard_blocks,p_day_blocks,l_deleted_blocks,p_transaction_info,p_messages);
1670: l_timecard_id := p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id;
1671: l_timecard_ovn := p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number;
1672: deposit_day_blocks(p_blocks,p_attributes,p_day_blocks,p_detail_blocks,l_deleted_blocks,p_transaction_info,p_messages,l_timecard_id,l_timecard_ovn);
1673: deposit_detail_blocks(p_blocks,p_attributes,p_detail_blocks,l_deleted_blocks,p_transaction_info,p_messages,l_timecard_id,l_timecard_ovn);
1674: --

Line 1671: l_timecard_ovn := p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number;

1667: -- self referential integrity
1668:
1669: deposit_timecard_blocks(p_blocks,p_attributes,p_timecard_blocks,p_day_blocks,l_deleted_blocks,p_transaction_info,p_messages);
1670: l_timecard_id := p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id;
1671: l_timecard_ovn := p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number;
1672: deposit_day_blocks(p_blocks,p_attributes,p_day_blocks,p_detail_blocks,l_deleted_blocks,p_transaction_info,p_messages,l_timecard_id,l_timecard_ovn);
1673: deposit_detail_blocks(p_blocks,p_attributes,p_detail_blocks,l_deleted_blocks,p_transaction_info,p_messages,l_timecard_id,l_timecard_ovn);
1674: --
1675: -- And now corresponding attributes

Line 1686: IF p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).SCOPE <> hxc_timecard.c_template_scope THEN

1682: -- Maintain the timecard summary structures
1683: populate_transaction_data_set(p_transaction_info);
1684:
1685: -- OTL - ABS Integration
1686: IF p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).SCOPE <> hxc_timecard.c_template_scope THEN
1687:
1688: hxc_retrieve_absences.manage_retrieval_audit (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id,
1689: FND_DATE.canonical_to_date(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time),
1690: TRUNC(FND_DATE.canonical_to_date(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).stop_time)));

Line 1688: hxc_retrieve_absences.manage_retrieval_audit (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id,

1684:
1685: -- OTL - ABS Integration
1686: IF p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).SCOPE <> hxc_timecard.c_template_scope THEN
1687:
1688: hxc_retrieve_absences.manage_retrieval_audit (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id,
1689: FND_DATE.canonical_to_date(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time),
1690: TRUNC(FND_DATE.canonical_to_date(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).stop_time)));
1691: END IF;
1692:

Line 1689: FND_DATE.canonical_to_date(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time),

1685: -- OTL - ABS Integration
1686: IF p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).SCOPE <> hxc_timecard.c_template_scope THEN
1687:
1688: hxc_retrieve_absences.manage_retrieval_audit (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id,
1689: FND_DATE.canonical_to_date(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time),
1690: TRUNC(FND_DATE.canonical_to_date(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).stop_time)));
1691: END IF;
1692:
1693:

Line 1690: TRUNC(FND_DATE.canonical_to_date(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).stop_time)));

1686: IF p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).SCOPE <> hxc_timecard.c_template_scope THEN
1687:
1688: hxc_retrieve_absences.manage_retrieval_audit (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id,
1689: FND_DATE.canonical_to_date(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time),
1690: TRUNC(FND_DATE.canonical_to_date(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).stop_time)));
1691: END IF;
1692:
1693:
1694:

Line 1706: hxc_timecard_message_helper.addErrorToCollection

1702:
1703: --Pickup the last message(HXC_USAGE_DATA_MISSING) that has been set.
1704: hr_message.provide_error;
1705: if (hr_message.last_message_name is not null) then
1706: hxc_timecard_message_helper.addErrorToCollection
1707: (p_messages,
1708: hr_message.last_message_name,
1709: hxc_timecard.c_error,
1710: null,

Line 1709: hxc_timecard.c_error,

1705: if (hr_message.last_message_name is not null) then
1706: hxc_timecard_message_helper.addErrorToCollection
1707: (p_messages,
1708: hr_message.last_message_name,
1709: hxc_timecard.c_error,
1710: null,
1711: null,
1712: 'HXC',
1713: null,

Line 1724: End hxc_timecard_deposit;

1720: end if;
1721:
1722: End execute;
1723:
1724: End hxc_timecard_deposit;