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 HR_UTILITY

Line 4: g_debug boolean := hr_utility.debug_enabled;

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:
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

Line 708: hr_utility.trace(' Entering is_duplicate_block .. ');

704: Begin
705:
706: IF g_debug
707: THEN
708: hr_utility.trace(' Entering is_duplicate_block .. ');
709: hr_utility.trace(' p_block_new.time_building_block_id is : ' || p_block_new.time_building_block_id);
710: hr_utility.trace(' In is_duplicate_block p_block_new.translation_display_key is : ' || p_block_new.translation_display_key);
711: END IF;
712:

Line 709: hr_utility.trace(' p_block_new.time_building_block_id is : ' || p_block_new.time_building_block_id);

705:
706: IF g_debug
707: THEN
708: hr_utility.trace(' Entering is_duplicate_block .. ');
709: hr_utility.trace(' p_block_new.time_building_block_id is : ' || p_block_new.time_building_block_id);
710: hr_utility.trace(' In is_duplicate_block p_block_new.translation_display_key is : ' || p_block_new.translation_display_key);
711: END IF;
712:
713: l_index := p_blocks.first;

Line 710: hr_utility.trace(' In is_duplicate_block p_block_new.translation_display_key is : ' || p_block_new.translation_display_key);

706: IF g_debug
707: THEN
708: hr_utility.trace(' Entering is_duplicate_block .. ');
709: hr_utility.trace(' p_block_new.time_building_block_id is : ' || p_block_new.time_building_block_id);
710: hr_utility.trace(' In is_duplicate_block p_block_new.translation_display_key is : ' || p_block_new.translation_display_key);
711: END IF;
712:
713: l_index := p_blocks.first;
714:

Line 720: hr_utility.trace(' l_index is : ' || l_index);

716: EXIT WHEN not p_blocks.exists(l_index) or isDuplicate;
717:
718: IF g_debug
719: THEN
720: hr_utility.trace(' l_index is : ' || l_index);
721: hr_utility.trace(' time_building_block_id is : ' || p_blocks(l_index).time_building_block_id);
722: hr_utility.trace(' scope is : ' || p_blocks(l_index).scope);
723: hr_utility.trace(' translation_display_key is : ' || p_blocks(l_index).translation_display_key);
724: hr_utility.trace(' parent_building_block_id is : ' || p_blocks(l_index).parent_building_block_id);

Line 721: hr_utility.trace(' time_building_block_id is : ' || p_blocks(l_index).time_building_block_id);

717:
718: IF g_debug
719: THEN
720: hr_utility.trace(' l_index is : ' || l_index);
721: hr_utility.trace(' time_building_block_id is : ' || p_blocks(l_index).time_building_block_id);
722: hr_utility.trace(' scope is : ' || p_blocks(l_index).scope);
723: hr_utility.trace(' translation_display_key is : ' || p_blocks(l_index).translation_display_key);
724: hr_utility.trace(' parent_building_block_id is : ' || p_blocks(l_index).parent_building_block_id);
725: hr_utility.trace(' parent_building_block_ovn is : ' || p_blocks(l_index).parent_building_block_ovn);

Line 722: hr_utility.trace(' scope is : ' || p_blocks(l_index).scope);

718: IF g_debug
719: THEN
720: hr_utility.trace(' l_index is : ' || l_index);
721: hr_utility.trace(' time_building_block_id is : ' || p_blocks(l_index).time_building_block_id);
722: hr_utility.trace(' scope is : ' || p_blocks(l_index).scope);
723: hr_utility.trace(' translation_display_key is : ' || p_blocks(l_index).translation_display_key);
724: hr_utility.trace(' parent_building_block_id is : ' || p_blocks(l_index).parent_building_block_id);
725: hr_utility.trace(' parent_building_block_ovn is : ' || p_blocks(l_index).parent_building_block_ovn);
726: hr_utility.trace(' date_to is : ' || p_blocks(l_index).date_to);

Line 723: hr_utility.trace(' translation_display_key is : ' || p_blocks(l_index).translation_display_key);

719: THEN
720: hr_utility.trace(' l_index is : ' || l_index);
721: hr_utility.trace(' time_building_block_id is : ' || p_blocks(l_index).time_building_block_id);
722: hr_utility.trace(' scope is : ' || p_blocks(l_index).scope);
723: hr_utility.trace(' translation_display_key is : ' || p_blocks(l_index).translation_display_key);
724: hr_utility.trace(' parent_building_block_id is : ' || p_blocks(l_index).parent_building_block_id);
725: hr_utility.trace(' parent_building_block_ovn is : ' || p_blocks(l_index).parent_building_block_ovn);
726: hr_utility.trace(' date_to is : ' || p_blocks(l_index).date_to);
727: END IF;

Line 724: hr_utility.trace(' parent_building_block_id is : ' || p_blocks(l_index).parent_building_block_id);

720: hr_utility.trace(' l_index is : ' || l_index);
721: hr_utility.trace(' time_building_block_id is : ' || p_blocks(l_index).time_building_block_id);
722: hr_utility.trace(' scope is : ' || p_blocks(l_index).scope);
723: hr_utility.trace(' translation_display_key is : ' || p_blocks(l_index).translation_display_key);
724: hr_utility.trace(' parent_building_block_id is : ' || p_blocks(l_index).parent_building_block_id);
725: hr_utility.trace(' parent_building_block_ovn is : ' || p_blocks(l_index).parent_building_block_ovn);
726: hr_utility.trace(' date_to is : ' || p_blocks(l_index).date_to);
727: END IF;
728:

Line 725: hr_utility.trace(' parent_building_block_ovn is : ' || p_blocks(l_index).parent_building_block_ovn);

721: hr_utility.trace(' time_building_block_id is : ' || p_blocks(l_index).time_building_block_id);
722: hr_utility.trace(' scope is : ' || p_blocks(l_index).scope);
723: hr_utility.trace(' translation_display_key is : ' || p_blocks(l_index).translation_display_key);
724: hr_utility.trace(' parent_building_block_id is : ' || p_blocks(l_index).parent_building_block_id);
725: hr_utility.trace(' parent_building_block_ovn is : ' || p_blocks(l_index).parent_building_block_ovn);
726: hr_utility.trace(' date_to is : ' || p_blocks(l_index).date_to);
727: END IF;
728:
729:

Line 726: hr_utility.trace(' date_to is : ' || p_blocks(l_index).date_to);

722: hr_utility.trace(' scope is : ' || p_blocks(l_index).scope);
723: hr_utility.trace(' translation_display_key is : ' || p_blocks(l_index).translation_display_key);
724: hr_utility.trace(' parent_building_block_id is : ' || p_blocks(l_index).parent_building_block_id);
725: hr_utility.trace(' parent_building_block_ovn is : ' || p_blocks(l_index).parent_building_block_ovn);
726: hr_utility.trace(' date_to is : ' || p_blocks(l_index).date_to);
727: END IF;
728:
729:
730: if(p_blocks(l_index).scope = 'DETAIL'

Line 739: hr_utility.trace(' DUPLICATE is TRUE ');

735: AND p_block_new.translation_display_key is NOT NULL
736: AND p_blocks(l_index).translation_display_key = p_block_new.translation_display_key
737: )
738: then
739: hr_utility.trace(' DUPLICATE is TRUE ');
740: isDuplicate := true;
741: end if;
742:
743: l_index := p_blocks.next(l_index);

Line 747: hr_utility.trace(' DUPLICATE is FALSE ');

743: l_index := p_blocks.next(l_index);
744: END LOOP;
745:
746: if(NOT isDuplicate) then
747: hr_utility.trace(' DUPLICATE is FALSE ');
748: end if;
749:
750: return isDuplicate;
751:

Line 805: hr_utility.trace('In function check_for_wrong_bb');

801:
802: BEGIN
803:
804: IF g_debug THEN
805: hr_utility.trace('In function check_for_wrong_bb');
806: END IF;
807:
808: l_index_attribute := p_attributes.first;
809: LOOP -- itterate attributes and get project attached to bb

Line 813: hr_utility.trace('p_attributes(l_index_attribute).ATTRIBUTE_CATEGORY ::'

809: LOOP -- itterate attributes and get project attached to bb
810: EXIT WHEN NOT p_attributes.exists(l_index_attribute);
811:
812: IF g_debug THEN
813: hr_utility.trace('p_attributes(l_index_attribute).ATTRIBUTE_CATEGORY ::'
814: ||p_attributes(l_index_attribute).ATTRIBUTE_CATEGORY);
815: hr_utility.trace('p_attributes(l_index_attribute).BUILDING_BLOCK_ID ::'
816: ||p_attributes(l_index_attribute).BUILDING_BLOCK_ID);
817: hr_utility.trace('p_attributes(l_index_attribute).BUILDING_BLOCK_OVN ::'

Line 815: hr_utility.trace('p_attributes(l_index_attribute).BUILDING_BLOCK_ID ::'

811:
812: IF g_debug THEN
813: hr_utility.trace('p_attributes(l_index_attribute).ATTRIBUTE_CATEGORY ::'
814: ||p_attributes(l_index_attribute).ATTRIBUTE_CATEGORY);
815: hr_utility.trace('p_attributes(l_index_attribute).BUILDING_BLOCK_ID ::'
816: ||p_attributes(l_index_attribute).BUILDING_BLOCK_ID);
817: hr_utility.trace('p_attributes(l_index_attribute).BUILDING_BLOCK_OVN ::'
818: ||p_attributes(l_index_attribute).BUILDING_BLOCK_OVN);
819: END IF;

Line 817: hr_utility.trace('p_attributes(l_index_attribute).BUILDING_BLOCK_OVN ::'

813: hr_utility.trace('p_attributes(l_index_attribute).ATTRIBUTE_CATEGORY ::'
814: ||p_attributes(l_index_attribute).ATTRIBUTE_CATEGORY);
815: hr_utility.trace('p_attributes(l_index_attribute).BUILDING_BLOCK_ID ::'
816: ||p_attributes(l_index_attribute).BUILDING_BLOCK_ID);
817: hr_utility.trace('p_attributes(l_index_attribute).BUILDING_BLOCK_OVN ::'
818: ||p_attributes(l_index_attribute).BUILDING_BLOCK_OVN);
819: END IF;
820:
821: IF p_attributes(l_index_attribute).ATTRIBUTE_CATEGORY = 'PROJECTS'

Line 832: hr_utility.trace('Project ::'||l_project_id

828:
829: l_project_id := p_attributes(l_index_attribute).attribute1;
830:
831: IF g_debug THEN
832: hr_utility.trace('Project ::'||l_project_id
833: ||' is attached to one of the building block ::'||p_attributes(l_index_attribute).BUILDING_BLOCK_ID);
834: END IF;
835:
836: EXIT;

Line 843: hr_utility.trace('Check whether the same project ::'||l_project_id

839: l_index_attribute := p_attributes.next(l_index_attribute);
840: END LOOP; -- itterate attributes and get project
841:
842: IF g_debug THEN
843: hr_utility.trace('Check whether the same project ::'||l_project_id
844: ||' is attached to all building blocks on the row');
845: END IF;
846:
847: l_index_attribute := p_attributes.first;

Line 852: hr_utility.trace('p_attributes(l_index_attribute).ATTRIBUTE_CATEGORY ::'

848: LOOP -- itterate attributes and get project attached to bb
849: EXIT WHEN NOT p_attributes.exists(l_index_attribute) or l_wrong_bb;
850:
851: IF g_debug THEN
852: hr_utility.trace('p_attributes(l_index_attribute).ATTRIBUTE_CATEGORY ::'
853: ||p_attributes(l_index_attribute).ATTRIBUTE_CATEGORY);
854:
855: hr_utility.trace('p_attributes(l_index_attribute).BUILDING_BLOCK_ID ::'
856: ||p_attributes(l_index_attribute).BUILDING_BLOCK_ID);

Line 855: hr_utility.trace('p_attributes(l_index_attribute).BUILDING_BLOCK_ID ::'

851: IF g_debug THEN
852: hr_utility.trace('p_attributes(l_index_attribute).ATTRIBUTE_CATEGORY ::'
853: ||p_attributes(l_index_attribute).ATTRIBUTE_CATEGORY);
854:
855: hr_utility.trace('p_attributes(l_index_attribute).BUILDING_BLOCK_ID ::'
856: ||p_attributes(l_index_attribute).BUILDING_BLOCK_ID);
857: hr_utility.trace('p_attributes(l_index_attribute).BUILDING_BLOCK_OVN ::'
858: ||p_attributes(l_index_attribute).BUILDING_BLOCK_OVN);
859: END IF;

Line 857: hr_utility.trace('p_attributes(l_index_attribute).BUILDING_BLOCK_OVN ::'

853: ||p_attributes(l_index_attribute).ATTRIBUTE_CATEGORY);
854:
855: hr_utility.trace('p_attributes(l_index_attribute).BUILDING_BLOCK_ID ::'
856: ||p_attributes(l_index_attribute).BUILDING_BLOCK_ID);
857: hr_utility.trace('p_attributes(l_index_attribute).BUILDING_BLOCK_OVN ::'
858: ||p_attributes(l_index_attribute).BUILDING_BLOCK_OVN);
859: END IF;
860:
861: IF p_bb_table.exists(p_attributes(l_index_attribute).BUILDING_BLOCK_ID)

Line 863: hr_utility.trace('p_bb_table(p_attributes(l_index_attribute).BUILDING_BLOCK_ID).det_ovn ::'

859: END IF;
860:
861: IF p_bb_table.exists(p_attributes(l_index_attribute).BUILDING_BLOCK_ID)
862: THEN
863: hr_utility.trace('p_bb_table(p_attributes(l_index_attribute).BUILDING_BLOCK_ID).det_ovn ::'
864: ||p_bb_table(p_attributes(l_index_attribute).BUILDING_BLOCK_ID).det_ovn);
865: hr_utility.trace('p_bb_table(p_attributes(l_index_attribute).BUILDING_BLOCK_ID).det_bb ::'
866: ||p_bb_table(p_attributes(l_index_attribute).BUILDING_BLOCK_ID).det_bb);
867: END IF;

Line 865: hr_utility.trace('p_bb_table(p_attributes(l_index_attribute).BUILDING_BLOCK_ID).det_bb ::'

861: IF p_bb_table.exists(p_attributes(l_index_attribute).BUILDING_BLOCK_ID)
862: THEN
863: hr_utility.trace('p_bb_table(p_attributes(l_index_attribute).BUILDING_BLOCK_ID).det_ovn ::'
864: ||p_bb_table(p_attributes(l_index_attribute).BUILDING_BLOCK_ID).det_ovn);
865: hr_utility.trace('p_bb_table(p_attributes(l_index_attribute).BUILDING_BLOCK_ID).det_bb ::'
866: ||p_bb_table(p_attributes(l_index_attribute).BUILDING_BLOCK_ID).det_bb);
867: END IF;
868:
869: IF p_attributes(l_index_attribute).ATTRIBUTE_CATEGORY = 'PROJECTS'

Line 879: hr_utility.trace('Found missmatch for attribute ::'||p_attributes(l_index_attribute).TIME_ATTRIBUTE_ID);

875: THEN
876: IF l_project_id <> p_attributes(l_index_attribute).attribute1
877: THEN
878: IF g_debug THEN
879: hr_utility.trace('Found missmatch for attribute ::'||p_attributes(l_index_attribute).TIME_ATTRIBUTE_ID);
880: hr_utility.trace('Project attached to attribute is ::'||p_attributes(l_index_attribute).attribute1);
881: END IF;
882: l_wrong_bb := TRUE;
883: END IF;

Line 880: hr_utility.trace('Project attached to attribute is ::'||p_attributes(l_index_attribute).attribute1);

876: IF l_project_id <> p_attributes(l_index_attribute).attribute1
877: THEN
878: IF g_debug THEN
879: hr_utility.trace('Found missmatch for attribute ::'||p_attributes(l_index_attribute).TIME_ATTRIBUTE_ID);
880: hr_utility.trace('Project attached to attribute is ::'||p_attributes(l_index_attribute).attribute1);
881: END IF;
882: l_wrong_bb := TRUE;
883: END IF;
884: END IF;

Line 896: hr_utility.trace('In function check_for_wrong_line');

892:
893:
894: BEGIN
895: IF g_debug THEN
896: hr_utility.trace('In function check_for_wrong_line');
897: END IF;
898:
899: l_index_row := p_blocks.first;
900: LOOP -- itterate blocks and get unporcessed detail row

Line 918: hr_utility.trace('l_det_row ::'||l_det_row||'is processed..');

914: + 1 ));
915: IF l_det_tab_row.exists(l_det_row)
916: THEN
917: NULL;
918: hr_utility.trace('l_det_row ::'||l_det_row||'is processed..');
919: ELSE
920:
921: l_det_tab_row(l_det_row).det_row := l_det_row;
922: l_det_tab_row(l_det_row).processed := 'N';

Line 925: hr_utility.trace('l_det_tab_row(l_det_row).det_row ::'||l_det_tab_row(l_det_row).det_row);

921: l_det_tab_row(l_det_row).det_row := l_det_row;
922: l_det_tab_row(l_det_row).processed := 'N';
923:
924: IF g_debug THEN
925: hr_utility.trace('l_det_tab_row(l_det_row).det_row ::'||l_det_tab_row(l_det_row).det_row);
926: hr_utility.trace('l_det_tab_row(l_det_row).processed ::'||l_det_tab_row(l_det_row).processed);
927: END IF;
928:
929:

Line 926: hr_utility.trace('l_det_tab_row(l_det_row).processed ::'||l_det_tab_row(l_det_row).processed);

922: l_det_tab_row(l_det_row).processed := 'N';
923:
924: IF g_debug THEN
925: hr_utility.trace('l_det_tab_row(l_det_row).det_row ::'||l_det_tab_row(l_det_row).det_row);
926: hr_utility.trace('l_det_tab_row(l_det_row).processed ::'||l_det_tab_row(l_det_row).processed);
927: END IF;
928:
929:
930: -- reset det bb table of each row

Line 964: hr_utility.trace('l_det_row_mark_processed ::'||l_det_row_mark_processed);

960: := p_blocks(l_index_bb).TIME_BUILDING_BLOCK_ID;
961: l_det_tab_bb(p_blocks(l_index_bb).TIME_BUILDING_BLOCK_ID).det_ovn
962: := p_blocks(l_index_bb).OBJECT_VERSION_NUMBER;
963: IF g_debug THEN
964: hr_utility.trace('l_det_row_mark_processed ::'||l_det_row_mark_processed);
965: hr_utility.trace('p_blocks(l_index_bb).TIME_BUILDING_BLOCK_ID ::'
966: || p_blocks(l_index_bb).TIME_BUILDING_BLOCK_ID);
967: hr_utility.trace('p_blocks(l_index_bb).OBJECT_VERSION_NUMBER ::'
968: ||p_blocks(l_index_bb).OBJECT_VERSION_NUMBER);

Line 965: hr_utility.trace('p_blocks(l_index_bb).TIME_BUILDING_BLOCK_ID ::'

961: l_det_tab_bb(p_blocks(l_index_bb).TIME_BUILDING_BLOCK_ID).det_ovn
962: := p_blocks(l_index_bb).OBJECT_VERSION_NUMBER;
963: IF g_debug THEN
964: hr_utility.trace('l_det_row_mark_processed ::'||l_det_row_mark_processed);
965: hr_utility.trace('p_blocks(l_index_bb).TIME_BUILDING_BLOCK_ID ::'
966: || p_blocks(l_index_bb).TIME_BUILDING_BLOCK_ID);
967: hr_utility.trace('p_blocks(l_index_bb).OBJECT_VERSION_NUMBER ::'
968: ||p_blocks(l_index_bb).OBJECT_VERSION_NUMBER);
969: END IF;

Line 967: hr_utility.trace('p_blocks(l_index_bb).OBJECT_VERSION_NUMBER ::'

963: IF g_debug THEN
964: hr_utility.trace('l_det_row_mark_processed ::'||l_det_row_mark_processed);
965: hr_utility.trace('p_blocks(l_index_bb).TIME_BUILDING_BLOCK_ID ::'
966: || p_blocks(l_index_bb).TIME_BUILDING_BLOCK_ID);
967: hr_utility.trace('p_blocks(l_index_bb).OBJECT_VERSION_NUMBER ::'
968: ||p_blocks(l_index_bb).OBJECT_VERSION_NUMBER);
969: END IF;
970:
971: END IF; -- IF l_det_tab_row(l_det_row).det_row = l_det_row

Line 979: hr_utility.trace('call to check_for_wrong_bb');

975: END LOOP; -- itterate blocks and get bb of det_row
976: -- end get bb's of unprocessed row
977:
978: IF g_debug THEN
979: hr_utility.trace('call to check_for_wrong_bb');
980: END IF;
981:
982: -- call to check bb of a row is mapped to wrong line attributes
983: l_wrong_line := check_for_wrong_bb(l_det_tab_bb,p_attributes);

Line 988: hr_utility.trace('Corruption in Line ::'||l_det_row_mark_processed);

984:
985: IF g_debug THEN
986: IF l_wrong_line
987: THEN
988: hr_utility.trace('Corruption in Line ::'||l_det_row_mark_processed);
989: hr_utility.trace('Stop timecard submittion and raise an error');
990: ELSE
991: hr_utility.trace('NO Corruption in Line ::'||l_det_row_mark_processed||' check next row');
992: END IF;

Line 989: hr_utility.trace('Stop timecard submittion and raise an error');

985: IF g_debug THEN
986: IF l_wrong_line
987: THEN
988: hr_utility.trace('Corruption in Line ::'||l_det_row_mark_processed);
989: hr_utility.trace('Stop timecard submittion and raise an error');
990: ELSE
991: hr_utility.trace('NO Corruption in Line ::'||l_det_row_mark_processed||' check next row');
992: END IF;
993: hr_utility.trace('Mark Line ::'||l_det_row_mark_processed||' is processed');

Line 991: hr_utility.trace('NO Corruption in Line ::'||l_det_row_mark_processed||' check next row');

987: THEN
988: hr_utility.trace('Corruption in Line ::'||l_det_row_mark_processed);
989: hr_utility.trace('Stop timecard submittion and raise an error');
990: ELSE
991: hr_utility.trace('NO Corruption in Line ::'||l_det_row_mark_processed||' check next row');
992: END IF;
993: hr_utility.trace('Mark Line ::'||l_det_row_mark_processed||' is processed');
994: END IF;
995:

Line 993: hr_utility.trace('Mark Line ::'||l_det_row_mark_processed||' is processed');

989: hr_utility.trace('Stop timecard submittion and raise an error');
990: ELSE
991: hr_utility.trace('NO Corruption in Line ::'||l_det_row_mark_processed||' check next row');
992: END IF;
993: hr_utility.trace('Mark Line ::'||l_det_row_mark_processed||' is processed');
994: END IF;
995:
996:
997: -- mark processed for row l_det_row_mark_processed

Line 1054: hr_utility.trace('Ash : Time building_block '||p_attributes(l_ind).building_block_id);

1050: IF p_attributes.COUNT > 0
1051: THEN
1052: l_ind := p_attributes.FIRST;
1053: LOOP
1054: hr_utility.trace('Ash : Time building_block '||p_attributes(l_ind).building_block_id);
1055: IF p_attributes(l_ind).building_block_id = p_bb_id
1056: AND p_attributes(l_ind).attribute_category LIKE 'ELEMENT%'
1057: THEN
1058: l_element := REPLACE(p_attributes(l_ind).attribute_category,'ELEMENT - ');

Line 1083: hr_utility.trace(' DUPLICATE BLOCK is TRUE ');

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:
1087: l_index := p_detail_blocks.next(l_index);

Line 1093: hr_utility.trace('Checking detail building blocks mapped to wrong line .. calling function check_for_wrong_line');

1089: END LOOP;
1090:
1091: -- Checking detail building blocks mapped to wrong line on a timecard for Bug 14478207
1092: IF g_debug THEN
1093: hr_utility.trace('Checking detail building blocks mapped to wrong line .. calling function check_for_wrong_line');
1094: END IF;
1095:
1096: l_wrong_line := check_for_wrong_line(p_blocks,p_attributes);
1097:

Line 1104: hr_utility.trace('Found Detail Building Block mapped to wrong line in the timecard .. raise an error');

1100: -- Added for Bug 14478207
1101: IF l_wrong_line THEN
1102:
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

Line 1122: hr_utility.trace(' Adding error to table for block : ' || l_block.time_building_block_id);

1118: ,null);
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

Line 1157: hr_utility.trace('ABS : l_element '||l_element);

1153: -- OTL - ABS Integration
1154: l_element := find_element(p_attributes,l_old_bb_id);
1155: IF g_debug
1156: THEN
1157: hr_utility.trace('ABS : l_element '||l_element);
1158: hr_utility.trace('ABS : time_building_block_id '||l_block.time_building_block_id);
1159: hr_utility.trace('ABS : old time_building_block_id '||l_old_bb_id);
1160: hr_utility.trace('ABS : new time_building_block_id '||l_new_bb_id);
1161: END IF;

Line 1158: hr_utility.trace('ABS : time_building_block_id '||l_block.time_building_block_id);

1154: l_element := find_element(p_attributes,l_old_bb_id);
1155: IF g_debug
1156: THEN
1157: hr_utility.trace('ABS : l_element '||l_element);
1158: hr_utility.trace('ABS : time_building_block_id '||l_block.time_building_block_id);
1159: hr_utility.trace('ABS : old time_building_block_id '||l_old_bb_id);
1160: hr_utility.trace('ABS : new time_building_block_id '||l_new_bb_id);
1161: END IF;
1162: hxc_retrieve_absences.update_co_absences(p_old_bb_id => l_old_bb_id,

Line 1159: hr_utility.trace('ABS : old time_building_block_id '||l_old_bb_id);

1155: IF g_debug
1156: THEN
1157: hr_utility.trace('ABS : l_element '||l_element);
1158: hr_utility.trace('ABS : time_building_block_id '||l_block.time_building_block_id);
1159: hr_utility.trace('ABS : old time_building_block_id '||l_old_bb_id);
1160: hr_utility.trace('ABS : new time_building_block_id '||l_new_bb_id);
1161: END IF;
1162: hxc_retrieve_absences.update_co_absences(p_old_bb_id => l_old_bb_id,
1163: p_new_bb_id => l_new_bb_id,

Line 1160: hr_utility.trace('ABS : new time_building_block_id '||l_new_bb_id);

1156: THEN
1157: hr_utility.trace('ABS : l_element '||l_element);
1158: hr_utility.trace('ABS : time_building_block_id '||l_block.time_building_block_id);
1159: hr_utility.trace('ABS : old time_building_block_id '||l_old_bb_id);
1160: hr_utility.trace('ABS : new time_building_block_id '||l_new_bb_id);
1161: END IF;
1162: hxc_retrieve_absences.update_co_absences(p_old_bb_id => l_old_bb_id,
1163: p_new_bb_id => l_new_bb_id,
1164: p_start_time=> FND_DATE.CANONICAL_TO_DATE(l_block.start_time),

Line 1190: hr_utility.trace('ABS : l_element '||l_element);

1186: then
1187: l_element := find_element(p_attributes,l_block.time_building_block_id);
1188: IF g_debug
1189: THEN
1190: hr_utility.trace('ABS : l_element '||l_element);
1191: hr_utility.trace('ABS : time_building_block_id '||l_block.time_building_block_id);
1192: hr_utility.trace('ABS l_old_ovn '||l_old_ovn);
1193: hr_utility.trace('ABS l_old_ovn '||l_new_ovn);
1194: END IF;

Line 1191: hr_utility.trace('ABS : time_building_block_id '||l_block.time_building_block_id);

1187: l_element := find_element(p_attributes,l_block.time_building_block_id);
1188: IF g_debug
1189: THEN
1190: hr_utility.trace('ABS : l_element '||l_element);
1191: hr_utility.trace('ABS : time_building_block_id '||l_block.time_building_block_id);
1192: hr_utility.trace('ABS l_old_ovn '||l_old_ovn);
1193: hr_utility.trace('ABS l_old_ovn '||l_new_ovn);
1194: END IF;
1195: hxc_retrieve_absences.update_co_absences_ovn(p_old_bb_id => l_block.time_building_block_id,

Line 1192: hr_utility.trace('ABS l_old_ovn '||l_old_ovn);

1188: IF g_debug
1189: THEN
1190: hr_utility.trace('ABS : l_element '||l_element);
1191: hr_utility.trace('ABS : time_building_block_id '||l_block.time_building_block_id);
1192: hr_utility.trace('ABS l_old_ovn '||l_old_ovn);
1193: hr_utility.trace('ABS l_old_ovn '||l_new_ovn);
1194: END IF;
1195: hxc_retrieve_absences.update_co_absences_ovn(p_old_bb_id => l_block.time_building_block_id,
1196: p_new_ovn => l_new_ovn,

Line 1193: hr_utility.trace('ABS l_old_ovn '||l_new_ovn);

1189: THEN
1190: hr_utility.trace('ABS : l_element '||l_element);
1191: hr_utility.trace('ABS : time_building_block_id '||l_block.time_building_block_id);
1192: hr_utility.trace('ABS l_old_ovn '||l_old_ovn);
1193: hr_utility.trace('ABS l_old_ovn '||l_new_ovn);
1194: END IF;
1195: hxc_retrieve_absences.update_co_absences_ovn(p_old_bb_id => l_block.time_building_block_id,
1196: p_new_ovn => l_new_ovn,
1197: p_start_time => FND_DATE.CANONICAL_TO_DATE(l_block.start_time),

Line 1579: hr_utility.trace(p_transaction_info(l_index).time_building_block_id||'-'||p_transaction_info(l_index).data_set_id);

1575:
1576: While l_index is not null loop
1577: p_transaction_info(l_index).data_set_id := l_data_set_id;
1578: if g_debug then
1579: hr_utility.trace(p_transaction_info(l_index).time_building_block_id||'-'||p_transaction_info(l_index).data_set_id);
1580: end if;
1581: l_index := p_transaction_info.next(l_index);
1582: End loop;
1583:

Line 1618: g_debug := hr_utility.debug_enabled;

1614:
1615:
1616: Begin
1617:
1618: g_debug := hr_utility.debug_enabled;
1619:
1620: -- A new Savepoint has been introduced to makesure we rollback the
1621: -- block transaction incase of any exception being thrown.
1622: savepoint deposit_timecard;

Line 1625: hr_utility.trace('*InvalidSecurityContext Trace Start**************');

1621: -- block transaction incase of any exception being thrown.
1622: savepoint deposit_timecard;
1623:
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);

Line 1626: hr_utility.trace('InvalidSecurityContext > PER_BUSINESS_GROUP_ID from fnd profile : '||fnd_profile.value('PER_BUSINESS_GROUP_ID'));

1622: savepoint deposit_timecard;
1623:
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:

Line 1627: hr_utility.trace('InvalidSecurityContext > ORG_ID from fnd profile : '||fnd_profile.value('ORG_ID'));

1623:
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,

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 1636: hr_utility.trace('InvalidSecurityContext > BUSINESS_GROUP_ID of the person : '||l_business_group_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);
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:

Line 1637: hr_utility.trace('InvalidSecurityContext > ORG_ID of the person : '||l_organization_id);

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);
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

Line 1653: hr_utility.trace('InvalidSecurityContext >l_business_group_id <> fnd_profile.value(PER_BUSINESS_GROUP_ID) : True');

1649: ,null
1650: ,null
1651: ,null
1652: );
1653: hr_utility.trace('InvalidSecurityContext >l_business_group_id <> fnd_profile.value(PER_BUSINESS_GROUP_ID) : True');
1654:
1655: ELSE
1656: hr_utility.trace('InvalidSecurityContext >l_business_group_id <> fnd_profile.value(PER_BUSINESS_GROUP_ID) : False');
1657: l_deleted_blocks.delete;

Line 1656: hr_utility.trace('InvalidSecurityContext >l_business_group_id <> fnd_profile.value(PER_BUSINESS_GROUP_ID) : False');

1652: );
1653: hr_utility.trace('InvalidSecurityContext >l_business_group_id <> fnd_profile.value(PER_BUSINESS_GROUP_ID) : True');
1654:
1655: ELSE
1656: hr_utility.trace('InvalidSecurityContext >l_business_group_id <> fnd_profile.value(PER_BUSINESS_GROUP_ID) : False');
1657: l_deleted_blocks.delete;
1658:
1659: -- OTL - ABS Integration
1660: IF hxc_retrieve_absences.g_detail_trans_tab.COUNT > 0

Line 1696: hr_utility.trace('*InvalidSecurityContext Trace End*****************');

1692:
1693:
1694:
1695: END IF;
1696: hr_utility.trace('*********************InvalidSecurityContext Trace End*************************************');
1697:
1698:
1699: Exception
1700: When Others then