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_ABS_RETRIEVAL_PKG dependencies on HR_UTILITY

Line 5: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY hxc_abs_retrieval_pkg AS
2: /* $Header: hxcabsret.pkb 120.24.12020000.2 2012/07/04 09:11:13 amnaraya ship $ */
3:
4: g_package varchar2(30) := 'hxc_abs_retrieval_pkg.';
5: g_debug boolean := hr_utility.debug_enabled;
6:
7: g_resource_id NUMBER := NULL;
8: g_tc_start DATE := NULL;
9: g_tc_stop DATE := NULL;

Line 217: g_debug := hr_utility.debug_enabled;

213: l_timecard_id NUMBER;
214: l_timecard_ovn NUMBER;
215:
216: BEGIN
217: g_debug := hr_utility.debug_enabled;
218:
219: IF g_debug THEN
220: l_proc := g_package||'post_absences';
221: hr_utility.set_location('ABS:Processing '||l_proc, 10);

Line 221: hr_utility.set_location('ABS:Processing '||l_proc, 10);

217: g_debug := hr_utility.debug_enabled;
218:
219: IF g_debug THEN
220: l_proc := g_package||'post_absences';
221: hr_utility.set_location('ABS:Processing '||l_proc, 10);
222: END IF;
223:
224: g_abs_integ_enabled := 'N';
225: g_abs_prepop_edit := 'N';

Line 234: hr_utility.TRACE ('ABS:g_resource_id = ' || g_resource_id);

230: g_tc_stop := p_tc_stop;
231: g_tc_status := p_tc_status;
232:
233: IF g_debug THEN
234: hr_utility.TRACE ('ABS:g_resource_id = ' || g_resource_id);
235: hr_utility.TRACE ('ABS:g_tc_start = ' || g_tc_start);
236: hr_utility.TRACE ('ABS:g_tc_stop = ' || g_tc_stop);
237: hr_utility.TRACE ('ABS:g_tc_status = ' || g_tc_status);
238: END IF;

Line 235: hr_utility.TRACE ('ABS:g_tc_start = ' || g_tc_start);

231: g_tc_status := p_tc_status;
232:
233: IF g_debug THEN
234: hr_utility.TRACE ('ABS:g_resource_id = ' || g_resource_id);
235: hr_utility.TRACE ('ABS:g_tc_start = ' || g_tc_start);
236: hr_utility.TRACE ('ABS:g_tc_stop = ' || g_tc_stop);
237: hr_utility.TRACE ('ABS:g_tc_status = ' || g_tc_status);
238: END IF;
239:

Line 236: hr_utility.TRACE ('ABS:g_tc_stop = ' || g_tc_stop);

232:
233: IF g_debug THEN
234: hr_utility.TRACE ('ABS:g_resource_id = ' || g_resource_id);
235: hr_utility.TRACE ('ABS:g_tc_start = ' || g_tc_start);
236: hr_utility.TRACE ('ABS:g_tc_stop = ' || g_tc_stop);
237: hr_utility.TRACE ('ABS:g_tc_status = ' || g_tc_status);
238: END IF;
239:
240: SELECT full_name, business_group_id

Line 237: hr_utility.TRACE ('ABS:g_tc_status = ' || g_tc_status);

233: IF g_debug THEN
234: hr_utility.TRACE ('ABS:g_resource_id = ' || g_resource_id);
235: hr_utility.TRACE ('ABS:g_tc_start = ' || g_tc_start);
236: hr_utility.TRACE ('ABS:g_tc_stop = ' || g_tc_stop);
237: hr_utility.TRACE ('ABS:g_tc_status = ' || g_tc_status);
238: END IF;
239:
240: SELECT full_name, business_group_id
241: INTO l_emp_name, g_business_group_id

Line 247: hr_utility.TRACE ('ABS:g_business_group_id = ' || g_business_group_id);

243: WHERE person_id = g_resource_id
244: AND g_tc_start between effective_start_date and effective_end_date;
245:
246: IF g_debug THEN
247: hr_utility.TRACE ('ABS:g_business_group_id = ' || g_business_group_id);
248: hr_utility.TRACE ('ABS:l_emp_name = ' || l_emp_name);
249: END IF;
250:
251: IF g_retrieval_process_id IS NULL THEN

Line 248: hr_utility.TRACE ('ABS:l_emp_name = ' || l_emp_name);

244: AND g_tc_start between effective_start_date and effective_end_date;
245:
246: IF g_debug THEN
247: hr_utility.TRACE ('ABS:g_business_group_id = ' || g_business_group_id);
248: hr_utility.TRACE ('ABS:l_emp_name = ' || l_emp_name);
249: END IF;
250:
251: IF g_retrieval_process_id IS NULL THEN
252: SELECT retrieval_process_id

Line 259: hr_utility.set_location('ABS:Processing '||l_proc, 20);

255: WHERE NAME = 'BEE Retrieval Process';
256: END IF;
257:
258: IF g_debug THEN
259: hr_utility.set_location('ABS:Processing '||l_proc, 20);
260: END IF;
261:
262: -- Evaluate preferences to get the retrieval rule group preference value and
263: -- other absence preferences

Line 271: hr_utility.set_location('ABS:Processing '||l_proc, 30);

267: l_pref_table);
268:
269:
270: IF g_debug THEN
271: hr_utility.set_location('ABS:Processing '||l_proc, 30);
272: END IF;
273:
274: IF l_pref_table.COUNT > 0
275: THEN

Line 343: hr_utility.set_location('ABS:Processing '||l_proc, 40);

339: END IF;
340: END IF;
341:
342: IF g_debug THEN
343: hr_utility.set_location('ABS:Processing '||l_proc, 40);
344: END IF;
345:
346: IF g_debug THEN
347: hr_utility.TRACE ('ABS:g_abs_integ_enabled = ' || g_abs_integ_enabled);

Line 347: hr_utility.TRACE ('ABS:g_abs_integ_enabled = ' || g_abs_integ_enabled);

343: hr_utility.set_location('ABS:Processing '||l_proc, 40);
344: END IF;
345:
346: IF g_debug THEN
347: hr_utility.TRACE ('ABS:g_abs_integ_enabled = ' || g_abs_integ_enabled);
348: hr_utility.TRACE ('ABS:g_abs_prepop_edit = ' || g_abs_prepop_edit);
349: hr_utility.TRACE ('ABS:l_abs_retrieval_rule = ' || l_abs_retrieval_rule);
350: END IF;
351:

Line 348: hr_utility.TRACE ('ABS:g_abs_prepop_edit = ' || g_abs_prepop_edit);

344: END IF;
345:
346: IF g_debug THEN
347: hr_utility.TRACE ('ABS:g_abs_integ_enabled = ' || g_abs_integ_enabled);
348: hr_utility.TRACE ('ABS:g_abs_prepop_edit = ' || g_abs_prepop_edit);
349: hr_utility.TRACE ('ABS:l_abs_retrieval_rule = ' || l_abs_retrieval_rule);
350: END IF;
351:
352:

Line 349: hr_utility.TRACE ('ABS:l_abs_retrieval_rule = ' || l_abs_retrieval_rule);

345:
346: IF g_debug THEN
347: hr_utility.TRACE ('ABS:g_abs_integ_enabled = ' || g_abs_integ_enabled);
348: hr_utility.TRACE ('ABS:g_abs_prepop_edit = ' || g_abs_prepop_edit);
349: hr_utility.TRACE ('ABS:l_abs_retrieval_rule = ' || l_abs_retrieval_rule);
350: END IF;
351:
352:
353: IF ( g_abs_integ_enabled = 'Y'

Line 366: hr_utility.set_location('ABS:Processing '||l_proc, 50);

362: OR (g_tc_status = 'DELETED')
363: THEN -- if2
364:
365: IF g_debug THEN
366: hr_utility.set_location('ABS:Processing '||l_proc, 50);
367: END IF;
368:
369: -- Populate TEMP table with absences data that has to be created
370: -- Absences which are new and not yet retrieved

Line 425: hr_utility.TRACE ( 'ABS:new absences COUNT = ' || SQL%ROWCOUNT);

421: AND htd.status = 'SUCCESS') );
422:
423:
424: IF g_debug THEN
425: hr_utility.TRACE ( 'ABS:new absences COUNT = ' || SQL%ROWCOUNT);
426: END IF;
427:
428: IF g_debug THEN
429: hr_utility.set_location('ABS:Processing '||l_proc, 60);

Line 429: hr_utility.set_location('ABS:Processing '||l_proc, 60);

425: hr_utility.TRACE ( 'ABS:new absences COUNT = ' || SQL%ROWCOUNT);
426: END IF;
427:
428: IF g_debug THEN
429: hr_utility.set_location('ABS:Processing '||l_proc, 60);
430: END IF;
431:
432: -- Populate TEMP table with updated/deleted absences data
433: -- This cursor returns Absences which were retrieved earlier and have undergone a change during

Line 479: hr_utility.TRACE ('ABS:edited abs COUNT = ' || SQL%ROWCOUNT );

475: AND absco.absence_attendance_id = absatt.absence_attendance_id ) ;
476:
477:
478: IF g_debug THEN
479: hr_utility.TRACE ('ABS:edited abs COUNT = ' || SQL%ROWCOUNT );
480: END IF;
481:
482: IF g_debug THEN
483: hr_utility.set_location('ABS:Processing '||l_proc, 70);

Line 483: hr_utility.set_location('ABS:Processing '||l_proc, 70);

479: hr_utility.TRACE ('ABS:edited abs COUNT = ' || SQL%ROWCOUNT );
480: END IF;
481:
482: IF g_debug THEN
483: hr_utility.set_location('ABS:Processing '||l_proc, 70);
484: END IF;
485:
486:
487: -- Bug 9394444

Line 553: hr_utility.TRACE ('ABS:new_absences_tab.COUNT = ' || new_absences_tab.COUNT );

549:
550: END IF; -- all_abs_tab.COUNT > 0
551:
552: IF g_debug THEN
553: hr_utility.TRACE ('ABS:new_absences_tab.COUNT = ' || new_absences_tab.COUNT );
554: hr_utility.TRACE ('ABS:edited_abs_tab.COUNT = ' || edited_abs_tab.COUNT );
555: END IF;
556:
557: -- update the TEMP table with the Dummy Cost Context segment value

Line 554: hr_utility.TRACE ('ABS:edited_abs_tab.COUNT = ' || edited_abs_tab.COUNT );

550: END IF; -- all_abs_tab.COUNT > 0
551:
552: IF g_debug THEN
553: hr_utility.TRACE ('ABS:new_absences_tab.COUNT = ' || new_absences_tab.COUNT );
554: hr_utility.TRACE ('ABS:edited_abs_tab.COUNT = ' || edited_abs_tab.COUNT );
555: END IF;
556:
557: -- update the TEMP table with the Dummy Cost Context segment value
558: IF (new_absences_tab.COUNT > 0 OR edited_abs_tab.COUNT > 0)

Line 562: hr_utility.TRACE ('ABS:Update TEMP table with cost information');

558: IF (new_absences_tab.COUNT > 0 OR edited_abs_tab.COUNT > 0)
559: THEN
560:
561: IF g_debug THEN
562: hr_utility.TRACE ('ABS:Update TEMP table with cost information');
563: END IF;
564:
565: OPEN get_cost_attributes;
566:

Line 573: hr_utility.TRACE ( 'ABS:l_cost_segment.COUNT = ' || l_cost_segment.COUNT );

569:
570: CLOSE get_cost_attributes;
571:
572: IF g_debug THEN
573: hr_utility.TRACE ( 'ABS:l_cost_segment.COUNT = ' || l_cost_segment.COUNT );
574: END IF;
575:
576: IF (l_cost_segment.COUNT > 0)
577: THEN

Line 591: hr_utility.set_location('ABS:Processing '||l_proc, 80);

587:
588: l_cost_segment.DELETE;
589:
590: IF g_debug THEN
591: hr_utility.set_location('ABS:Processing '||l_proc, 80);
592: END IF;
593:
594:
595: -- The following processing is for records which only has a OVN change and no "Hours Type" or "detail" change

Line 603: hr_utility.TRACE ('ABS:Process records with only ovn updates');

599: -- This processing is only for unplanned absence records,
600: -- for prepopulated ones, this ovn update happens during validation phase itself.
601:
602: IF g_debug THEN
603: hr_utility.TRACE ('ABS:Process records with only ovn updates');
604: END IF;
605:
606: IF (new_absences_tab.COUNT > 0) THEN
607: abs_ix := new_absences_tab.FIRST;

Line 658: hr_utility.TRACE ('ABS:Delete records from temp having only OVN change'||l_id_tab.COUNT);

654: END LOOP;
655: END IF; -- new_absences_tab.COUNT > 0
656:
657: IF g_debug THEN
658: hr_utility.TRACE ('ABS:Delete records from temp having only OVN change'||l_id_tab.COUNT);
659: END IF;
660:
661: IF (l_id_tab.COUNT > 0)
662: THEN

Line 682: hr_utility.set_location('ABS:Processing '||l_proc, 90);

678: );
679: END IF;
680:
681: IF g_debug THEN
682: hr_utility.set_location('ABS:Processing '||l_proc, 90);
683: END IF;
684:
685: l_id_tab.DELETE;
686: l_ovn_tab.DELETE;

Line 704: hr_utility.TRACE ( 'ABS:Records to be processed in TEMP table = '|| all_abs_tab.COUNT );

700: FETCH c_abs_from_temp BULK COLLECT INTO all_abs_tab;
701: CLOSE c_abs_from_temp;
702:
703: IF g_debug THEN
704: hr_utility.TRACE ( 'ABS:Records to be processed in TEMP table = '|| all_abs_tab.COUNT );
705: END IF;
706:
707: IF (all_abs_tab.COUNT > 0) THEN
708: FOR abs_ix IN all_abs_tab.FIRST .. all_abs_tab.LAST

Line 781: hr_utility.TRACE( 'ABS: Prepopulation Count of prepop rows updated = ' || l_prepop_delete_absences.COUNT);

777:
778: CLOSE c_delete_prepop_abs;
779:
780: IF g_debug THEN
781: hr_utility.TRACE( 'ABS:** Prepopulation ** Count of prepop rows updated = ' || l_prepop_delete_absences.COUNT);
782: END IF;
783:
784: -- call for delete and recreation, if any
785: IF (l_prepop_delete_absences.COUNT > 0)

Line 814: hr_utility.TRACE( 'ABS:Process delete for Absence attendance id = '

810:
811: IF l_call_delete THEN
812:
813: IF g_debug THEN
814: hr_utility.TRACE( 'ABS:Process delete for Absence attendance id = '
815: || l_absence_attendance_id );
816: END IF;
817:
818: -- call delete absences for each absence_attendance_id

Line 826: hr_utility.TRACE( 'ABS:Completed delete for Absence attendance id = '

822: l_uom
823: );
824:
825: IF g_debug THEN
826: hr_utility.TRACE( 'ABS:Completed delete for Absence attendance id = '
827: || l_absence_attendance_id );
828: END IF;
829:
830: l_ed_days_ix := 0;

Line 840: hr_utility.set_location('ABS:Processing '||l_proc, 100);

836:
837: END IF;
838:
839: IF g_debug THEN
840: hr_utility.set_location('ABS:Processing '||l_proc, 100);
841: END IF;
842:
843: l_prepop_delete_absences.DELETE;
844: l_edited_days.DELETE;

Line 858: hr_utility.set_location('ABS:Processing '||l_proc, 110);

854:
855: l_call_delete := FALSE;
856:
857: IF g_debug THEN
858: hr_utility.set_location('ABS:Processing '||l_proc, 110);
859: END IF;
860:
861: OPEN c_delete_ret_abs;
862:

Line 869: hr_utility.TRACE ( 'ABS: Retrieved Count of retrieved rows updated = ' || l_ret_delete_absences.COUNT );

865:
866: CLOSE c_delete_ret_abs;
867:
868: IF g_debug THEN
869: hr_utility.TRACE ( 'ABS:** Retrieved ** Count of retrieved rows updated = ' || l_ret_delete_absences.COUNT );
870: END IF;
871:
872: l_ed_days_ix := 0;
873:

Line 904: hr_utility.TRACE( 'ABS:Process delete for Absence attendance id = '

900:
901: IF l_call_delete THEN
902:
903: IF g_debug THEN
904: hr_utility.TRACE( 'ABS:Process delete for Absence attendance id = '
905: || l_absence_attendance_id );
906: END IF;
907:
908: -- call delete absences for each absence_attendance_id

Line 916: hr_utility.TRACE( 'ABS:Completed delete for Absence attendance id = '

912: l_uom
913: );
914:
915: IF g_debug THEN
916: hr_utility.TRACE( 'ABS:Completed delete for Absence attendance id = '
917: || l_absence_attendance_id );
918: END IF;
919:
920: l_ed_days_ix := 0;

Line 931: hr_utility.set_location('ABS:Processing '||l_proc, 120);

927: END IF;
928:
929:
930: IF g_debug THEN
931: hr_utility.set_location('ABS:Processing '||l_proc, 120);
932: END IF;
933:
934: l_ret_delete_absences.DELETE;
935: l_edited_days.DELETE;

Line 938: hr_utility.trace('ABS: Start processing CREATE Absence records in TEMP table');

934: l_ret_delete_absences.DELETE;
935: l_edited_days.DELETE;
936:
937: IF g_debug THEN
938: hr_utility.trace('ABS: Start processing CREATE Absence records in TEMP table');
939: END IF;
940:
941: -- Process CREATE records with UOM = DAYS, this is for fresh unplanned absences
942: -- logic for continuous posting for DAYS

Line 947: hr_utility.TRACE ('ABS:current count - days = ' || days_tab.COUNT);

943: l_days_ix := days_tab.FIRST;
944: l_count := days_tab.COUNT;
945:
946: IF g_debug THEN
947: hr_utility.TRACE ('ABS:current count - days = ' || days_tab.COUNT);
948: END IF;
949:
950: IF (l_count > 0)
951: THEN

Line 967: hr_utility.TRACE ('ABS:difference of 1 in dates');

963: TRUNC (days_tab (l_days_ix).day_stop) + 1
964: )
965: THEN
966: IF g_debug THEN
967: hr_utility.TRACE ('ABS:difference of 1 in dates');
968: END IF;
969:
970: days_tab (l_days_ix + 1).day_start := days_tab (l_days_ix).day_start;
971:

Line 988: hr_utility.TRACE ('ABS:no difference in dates');

984: )
985: THEN
986:
987: IF g_debug THEN
988: hr_utility.TRACE ('ABS:no difference in dates');
989: END IF;
990:
991: l_temp_row := days_tab (l_days_ix);
992: days_tab (l_days_ix) := days_tab (l_days_ix + 1);

Line 1001: hr_utility.set_location('ABS:Processing '||l_proc, 130);

997: l_days_ix := l_days_ix + 1;
998: END LOOP;
999:
1000: IF g_debug THEN
1001: hr_utility.set_location('ABS:Processing '||l_proc, 130);
1002: END IF;
1003:
1004: -- send to absences module
1005: IF g_debug THEN

Line 1006: hr_utility.TRACE ('ABS:CALLING create_absences for DAYS');

1002: END IF;
1003:
1004: -- send to absences module
1005: IF g_debug THEN
1006: hr_utility.TRACE ('ABS:CALLING create_absences for DAYS');
1007: END IF;
1008:
1009: create_absences (days_tab,
1010: 'D');

Line 1013: hr_utility.TRACE ('ABS:COMPLETED create_absences for DAYS');

1009: create_absences (days_tab,
1010: 'D');
1011:
1012: IF g_debug THEN
1013: hr_utility.TRACE ('ABS:COMPLETED create_absences for DAYS');
1014: END IF;
1015:
1016: END IF;
1017:

Line 1019: hr_utility.set_location('ABS:Processing '||l_proc, 140);

1015:
1016: END IF;
1017:
1018: IF g_debug THEN
1019: hr_utility.set_location('ABS:Processing '||l_proc, 140);
1020: END IF;
1021:
1022: -- Process CREATE records with UOM = HOURS (fresh unplanned absences)
1023: IF g_debug THEN

Line 1024: hr_utility.TRACE ('ABS:current count - hours = ' || hours_tab.COUNT);

1020: END IF;
1021:
1022: -- Process CREATE records with UOM = HOURS (fresh unplanned absences)
1023: IF g_debug THEN
1024: hr_utility.TRACE ('ABS:current count - hours = ' || hours_tab.COUNT);
1025: END IF;
1026:
1027: -- send to absences module, there is no continuous posting for HOURS
1028: IF (hours_tab.COUNT > 0)

Line 1032: hr_utility.TRACE ('ABS:CALLING create_absences for HOURS');

1028: IF (hours_tab.COUNT > 0)
1029: THEN
1030:
1031: IF g_debug THEN
1032: hr_utility.TRACE ('ABS:CALLING create_absences for HOURS');
1033: END IF;
1034:
1035: create_absences (hours_tab,
1036: 'H');

Line 1039: hr_utility.TRACE ('ABS:COMPLETED create_absences for HOURS');

1035: create_absences (hours_tab,
1036: 'H');
1037:
1038: IF g_debug THEN
1039: hr_utility.TRACE ('ABS:COMPLETED create_absences for HOURS');
1040: END IF;
1041:
1042: END IF;
1043:

Line 1045: hr_utility.set_location('ABS:Processing '||l_proc, 150);

1041:
1042: END IF;
1043:
1044: IF g_debug THEN
1045: hr_utility.set_location('ABS:Processing '||l_proc, 150);
1046: END IF;
1047:
1048:
1049: -- Processing for TXN DETAILS creation starts

Line 1086: hr_utility.set_location('ABS:Processing '||l_proc, 160);

1082: END LOOP;
1083: END IF;
1084:
1085: IF g_debug THEN
1086: hr_utility.set_location('ABS:Processing '||l_proc, 160);
1087: hr_utility.trace('create txn records - '||l_create_id_tab.COUNT);
1088: hr_utility.trace('delete txn records - '||l_delete_id_tab.COUNT);
1089: END IF;
1090:

Line 1087: hr_utility.trace('create txn records - '||l_create_id_tab.COUNT);

1083: END IF;
1084:
1085: IF g_debug THEN
1086: hr_utility.set_location('ABS:Processing '||l_proc, 160);
1087: hr_utility.trace('create txn records - '||l_create_id_tab.COUNT);
1088: hr_utility.trace('delete txn records - '||l_delete_id_tab.COUNT);
1089: END IF;
1090:
1091: -- Process CREATE absence records from TEMP table which are successfully sent to Absences

Line 1088: hr_utility.trace('delete txn records - '||l_delete_id_tab.COUNT);

1084:
1085: IF g_debug THEN
1086: hr_utility.set_location('ABS:Processing '||l_proc, 160);
1087: hr_utility.trace('create txn records - '||l_create_id_tab.COUNT);
1088: hr_utility.trace('delete txn records - '||l_delete_id_tab.COUNT);
1089: END IF;
1090:
1091: -- Process CREATE absence records from TEMP table which are successfully sent to Absences
1092: -- Make an entry for these retrieved Absence details in TXN tables.

Line 1097: hr_utility.TRACE ('ABS:CALLING create_transactions for CREATE records - '||l_create_id_tab.COUNT);

1093: IF (l_create_id_tab.COUNT > 0)
1094: THEN
1095:
1096: IF g_debug THEN
1097: hr_utility.TRACE ('ABS:CALLING create_transactions for CREATE records - '||l_create_id_tab.COUNT);
1098: END IF;
1099:
1100: create_transactions (l_create_id_tab,
1101: l_create_ovn_tab,

Line 1107: hr_utility.TRACE ('ABS:COMPLETED create_transactions for CREATE records');

1103: g_success_create_msg
1104: );
1105:
1106: IF g_debug THEN
1107: hr_utility.TRACE ('ABS:COMPLETED create_transactions for CREATE records');
1108: END IF;
1109:
1110: FORALL l_tx_index IN l_create_id_tab.FIRST .. l_create_id_tab.LAST
1111: DELETE FROM hxc_abs_ret_temp

Line 1115: hr_utility.set_location('ABS:Processing '||l_proc, 170);

1111: DELETE FROM hxc_abs_ret_temp
1112: WHERE time_building_block_id = l_create_id_tab(l_tx_index);
1113:
1114: IF g_debug THEN
1115: hr_utility.set_location('ABS:Processing '||l_proc, 170);
1116: END IF;
1117:
1118: END IF;
1119:

Line 1131: hr_utility.TRACE ('ABS:CALLING create_transactions for DELETE records - '||l_delete_id_tab.COUNT);

1127: IF (l_delete_id_tab.COUNT > 0)
1128: THEN
1129:
1130: IF g_debug THEN
1131: hr_utility.TRACE ('ABS:CALLING create_transactions for DELETE records - '||l_delete_id_tab.COUNT);
1132: END IF;
1133:
1134: create_transactions (l_delete_id_tab,
1135: l_delete_ovn_tab,

Line 1141: hr_utility.TRACE ('ABS:COMPLETED create_transactions for DELETE records');

1137: g_success_delete_msg
1138: );
1139:
1140: IF g_debug THEN
1141: hr_utility.TRACE ('ABS:COMPLETED create_transactions for DELETE records');
1142: END IF;
1143:
1144: FORALL l_tx_index IN l_delete_id_tab.FIRST .. l_delete_id_tab.LAST
1145: DELETE FROM hxc_abs_ret_temp

Line 1149: hr_utility.set_location('ABS:Processing '||l_proc, 180);

1145: DELETE FROM hxc_abs_ret_temp
1146: WHERE time_building_block_id = l_delete_id_tab(l_tx_index);
1147:
1148: IF g_debug THEN
1149: hr_utility.set_location('ABS:Processing '||l_proc, 180);
1150: END IF;
1151:
1152: END IF;
1153:

Line 1158: hr_utility.set_location('ABS:Processing '||l_proc, 190);

1154: l_delete_id_tab.DELETE;
1155: l_delete_ovn_tab.DELETE;
1156:
1157: IF g_debug THEN
1158: hr_utility.set_location('ABS:Processing '||l_proc, 190);
1159: END IF;
1160:
1161:
1162: IF g_debug THEN

Line 1163: hr_utility.set_location('ABS:Leaving '||l_proc, 200);

1159: END IF;
1160:
1161:
1162: IF g_debug THEN
1163: hr_utility.set_location('ABS:Leaving '||l_proc, 200);
1164: END IF;
1165:
1166:
1167:

Line 1172: hr_utility.trace('ABS: p_tc_status ::'||p_tc_status);

1168: END IF; -- end if for g_all_id_tab.COUNT <> 0
1169: END IF; -- endif for if2
1170:
1171: IF g_debug THEN
1172: hr_utility.trace('ABS: p_tc_status ::'||p_tc_status);
1173: hr_utility.trace('ABS: p_resource_id ::'||p_resource_id);
1174: hr_utility.trace('ABS: p_tc_start ::'||p_tc_start);
1175: hr_utility.trace('ABS: p_tc_stop ::'||p_tc_stop);
1176: END IF;

Line 1173: hr_utility.trace('ABS: p_resource_id ::'||p_resource_id);

1169: END IF; -- endif for if2
1170:
1171: IF g_debug THEN
1172: hr_utility.trace('ABS: p_tc_status ::'||p_tc_status);
1173: hr_utility.trace('ABS: p_resource_id ::'||p_resource_id);
1174: hr_utility.trace('ABS: p_tc_start ::'||p_tc_start);
1175: hr_utility.trace('ABS: p_tc_stop ::'||p_tc_stop);
1176: END IF;
1177:

Line 1174: hr_utility.trace('ABS: p_tc_start ::'||p_tc_start);

1170:
1171: IF g_debug THEN
1172: hr_utility.trace('ABS: p_tc_status ::'||p_tc_status);
1173: hr_utility.trace('ABS: p_resource_id ::'||p_resource_id);
1174: hr_utility.trace('ABS: p_tc_start ::'||p_tc_start);
1175: hr_utility.trace('ABS: p_tc_stop ::'||p_tc_stop);
1176: END IF;
1177:
1178: IF p_tc_status <> 'DELETED' THEN -- Added for Bug 12533914

Line 1175: hr_utility.trace('ABS: p_tc_stop ::'||p_tc_stop);

1171: IF g_debug THEN
1172: hr_utility.trace('ABS: p_tc_status ::'||p_tc_status);
1173: hr_utility.trace('ABS: p_resource_id ::'||p_resource_id);
1174: hr_utility.trace('ABS: p_tc_start ::'||p_tc_start);
1175: hr_utility.trace('ABS: p_tc_stop ::'||p_tc_stop);
1176: END IF;
1177:
1178: IF p_tc_status <> 'DELETED' THEN -- Added for Bug 12533914
1179:

Line 1181: hr_utility.trace('ABS: Pick up timecard id to process transferred_to column');

1177:
1178: IF p_tc_status <> 'DELETED' THEN -- Added for Bug 12533914
1179:
1180: IF g_debug THEN
1181: hr_utility.trace('ABS: Pick up timecard id to process transferred_to column');
1182: hr_utility.trace('ABS: l_timecard_id ::'||l_timecard_id);
1183: hr_utility.trace('ABS: l_timecard_ovn ::'||l_timecard_ovn);
1184: END IF;
1185:

Line 1182: hr_utility.trace('ABS: l_timecard_id ::'||l_timecard_id);

1178: IF p_tc_status <> 'DELETED' THEN -- Added for Bug 12533914
1179:
1180: IF g_debug THEN
1181: hr_utility.trace('ABS: Pick up timecard id to process transferred_to column');
1182: hr_utility.trace('ABS: l_timecard_id ::'||l_timecard_id);
1183: hr_utility.trace('ABS: l_timecard_ovn ::'||l_timecard_ovn);
1184: END IF;
1185:
1186: -- Bug 9747820

Line 1183: hr_utility.trace('ABS: l_timecard_ovn ::'||l_timecard_ovn);

1179:
1180: IF g_debug THEN
1181: hr_utility.trace('ABS: Pick up timecard id to process transferred_to column');
1182: hr_utility.trace('ABS: l_timecard_id ::'||l_timecard_id);
1183: hr_utility.trace('ABS: l_timecard_ovn ::'||l_timecard_ovn);
1184: END IF;
1185:
1186: -- Bug 9747820
1187: -- Pick up the timecard id and process

Line 1200: hr_utility.trace('ABS: l_timecard_id ::'||l_timecard_id);

1196: AND stop_time = TRUNC(p_tc_stop) + 1 - (1/86400) ;
1197:
1198:
1199: IF g_debug THEN
1200: hr_utility.trace('ABS: l_timecard_id ::'||l_timecard_id);
1201: hr_utility.trace('ABS: l_timecard_ovn ::'||l_timecard_ovn);
1202: hr_utility.trace('ABS: call to hxc_timecard_summary_pkg.update_transferred_to');
1203: END IF;
1204:

Line 1201: hr_utility.trace('ABS: l_timecard_ovn ::'||l_timecard_ovn);

1197:
1198:
1199: IF g_debug THEN
1200: hr_utility.trace('ABS: l_timecard_id ::'||l_timecard_id);
1201: hr_utility.trace('ABS: l_timecard_ovn ::'||l_timecard_ovn);
1202: hr_utility.trace('ABS: call to hxc_timecard_summary_pkg.update_transferred_to');
1203: END IF;
1204:
1205: hxc_timecard_summary_pkg.update_transferred_to(l_timecard_id,

Line 1202: hr_utility.trace('ABS: call to hxc_timecard_summary_pkg.update_transferred_to');

1198:
1199: IF g_debug THEN
1200: hr_utility.trace('ABS: l_timecard_id ::'||l_timecard_id);
1201: hr_utility.trace('ABS: l_timecard_ovn ::'||l_timecard_ovn);
1202: hr_utility.trace('ABS: call to hxc_timecard_summary_pkg.update_transferred_to');
1203: END IF;
1204:
1205: hxc_timecard_summary_pkg.update_transferred_to(l_timecard_id,
1206: l_timecard_ovn,

Line 1213: hr_utility.trace('ABS: End of post_absences..');

1209:
1210: END IF; -- endif for if1 --- g_abs_integ_enabled = 'Y'
1211:
1212: IF g_debug THEN
1213: hr_utility.trace('ABS: End of post_absences..');
1214: END IF;
1215:
1216: EXCEPTION
1217:

Line 1221: hr_utility.TRACE ('ABS:EXCEPTION IN POST_ABSENCES - Retrieval Rules not set');

1217:
1218: WHEN ret_rules_not_set
1219: THEN
1220: IF g_debug THEN
1221: hr_utility.TRACE ('ABS:EXCEPTION IN POST_ABSENCES - Retrieval Rules not set');
1222: END IF;
1223:
1224: hxc_timecard_message_helper.addErrorToCollection
1225: (p_messages

Line 1241: hr_utility.TRACE ('ABS:EXCEPTION RAISED FROM POST_ABSENCES');

1237:
1238: WHEN OTHERS
1239: THEN
1240: IF g_debug THEN
1241: hr_utility.TRACE ('ABS:EXCEPTION RAISED FROM POST_ABSENCES');
1242: END IF;
1243: -- Bug 9394444
1244: -- Added this backtrace to error stack because
1245: -- we are calling an OTHERS exception.

Line 1248: hr_utility.trace(dbms_utility.format_error_backtrace);

1244: -- Added this backtrace to error stack because
1245: -- we are calling an OTHERS exception.
1246: -- Removed all other OTHERS exception blocks because that was
1247: -- either way unnecessary.
1248: hr_utility.trace(dbms_utility.format_error_backtrace);
1249:
1250: IF (g_all_id_tab.COUNT > 0) THEN
1251: create_transactions (p_tbb_id => g_all_id_tab,
1252: p_tbb_ovn => g_all_ovn_tab,

Line 1336: g_debug := hr_utility.debug_enabled;

1332: --set_to_view_only_c EXCEPTION;
1333:
1334: BEGIN
1335:
1336: g_debug := hr_utility.debug_enabled;
1337:
1338: IF g_debug THEN
1339: l_proc := g_package||'create_absences';
1340: hr_utility.set_location('ABS:Processing '||l_proc, 200);

Line 1340: hr_utility.set_location('ABS:Processing '||l_proc, 200);

1336: g_debug := hr_utility.debug_enabled;
1337:
1338: IF g_debug THEN
1339: l_proc := g_package||'create_absences';
1340: hr_utility.set_location('ABS:Processing '||l_proc, 200);
1341: END IF;
1342:
1343: IF g_debug THEN
1344: hr_utility.TRACE ('ABS:p_uom = ' || p_uom);

Line 1344: hr_utility.TRACE ('ABS:p_uom = ' || p_uom);

1340: hr_utility.set_location('ABS:Processing '||l_proc, 200);
1341: END IF;
1342:
1343: IF g_debug THEN
1344: hr_utility.TRACE ('ABS:p_uom = ' || p_uom);
1345: END IF;
1346:
1347: IF (p_uom = 'D')
1348: THEN

Line 1361: hr_utility.trace('ABS:This Absence Type is changed to VIEW ONLY before retrieval - Wrong Setup');

1357:
1358: -- Removed this check for bug 8932359
1359: /* IF (is_view_only(p_absences (l_abs_ix).absence_attendance_type_id)) THEN
1360: IF g_debug THEN
1361: hr_utility.trace('ABS:This Absence Type is changed to VIEW ONLY before retrieval - Wrong Setup');
1362: END IF;
1363:
1364: RAISE set_to_view_only_c;
1365:

Line 1388: hr_utility.TRACE ('ABS: Parameters passed to HR CREATE API');

1384: l_in_time := p_absences (l_abs_ix).in_time;
1385: l_out_time := p_absences (l_abs_ix).out_time;
1386:
1387: IF g_debug THEN
1388: hr_utility.TRACE ('ABS: Parameters passed to HR CREATE API');
1389: hr_utility.TRACE ('ABS:person_id = ' || p_absences (l_abs_ix).resource_id);
1390: hr_utility.TRACE ('ABS:g_business_group_id = ' || g_business_group_id);
1391: hr_utility.TRACE ('ABS:absence_attendance_type_id = ' || l_absence_attendance_type_id);
1392: hr_utility.TRACE ('ABS:l_day_start = ' || l_day_start);

Line 1389: hr_utility.TRACE ('ABS:person_id = ' || p_absences (l_abs_ix).resource_id);

1385: l_out_time := p_absences (l_abs_ix).out_time;
1386:
1387: IF g_debug THEN
1388: hr_utility.TRACE ('ABS: Parameters passed to HR CREATE API');
1389: hr_utility.TRACE ('ABS:person_id = ' || p_absences (l_abs_ix).resource_id);
1390: hr_utility.TRACE ('ABS:g_business_group_id = ' || g_business_group_id);
1391: hr_utility.TRACE ('ABS:absence_attendance_type_id = ' || l_absence_attendance_type_id);
1392: hr_utility.TRACE ('ABS:l_day_start = ' || l_day_start);
1393: hr_utility.TRACE ('ABS:l_time_start = ' || l_time_start);

Line 1390: hr_utility.TRACE ('ABS:g_business_group_id = ' || g_business_group_id);

1386:
1387: IF g_debug THEN
1388: hr_utility.TRACE ('ABS: Parameters passed to HR CREATE API');
1389: hr_utility.TRACE ('ABS:person_id = ' || p_absences (l_abs_ix).resource_id);
1390: hr_utility.TRACE ('ABS:g_business_group_id = ' || g_business_group_id);
1391: hr_utility.TRACE ('ABS:absence_attendance_type_id = ' || l_absence_attendance_type_id);
1392: hr_utility.TRACE ('ABS:l_day_start = ' || l_day_start);
1393: hr_utility.TRACE ('ABS:l_time_start = ' || l_time_start);
1394: hr_utility.TRACE ('ABS:l_day_stop = ' || l_day_stop);

Line 1391: hr_utility.TRACE ('ABS:absence_attendance_type_id = ' || l_absence_attendance_type_id);

1387: IF g_debug THEN
1388: hr_utility.TRACE ('ABS: Parameters passed to HR CREATE API');
1389: hr_utility.TRACE ('ABS:person_id = ' || p_absences (l_abs_ix).resource_id);
1390: hr_utility.TRACE ('ABS:g_business_group_id = ' || g_business_group_id);
1391: hr_utility.TRACE ('ABS:absence_attendance_type_id = ' || l_absence_attendance_type_id);
1392: hr_utility.TRACE ('ABS:l_day_start = ' || l_day_start);
1393: hr_utility.TRACE ('ABS:l_time_start = ' || l_time_start);
1394: hr_utility.TRACE ('ABS:l_day_stop = ' || l_day_stop);
1395: hr_utility.TRACE ('ABS:l_time_end = ' || l_time_end);

Line 1392: hr_utility.TRACE ('ABS:l_day_start = ' || l_day_start);

1388: hr_utility.TRACE ('ABS: Parameters passed to HR CREATE API');
1389: hr_utility.TRACE ('ABS:person_id = ' || p_absences (l_abs_ix).resource_id);
1390: hr_utility.TRACE ('ABS:g_business_group_id = ' || g_business_group_id);
1391: hr_utility.TRACE ('ABS:absence_attendance_type_id = ' || l_absence_attendance_type_id);
1392: hr_utility.TRACE ('ABS:l_day_start = ' || l_day_start);
1393: hr_utility.TRACE ('ABS:l_time_start = ' || l_time_start);
1394: hr_utility.TRACE ('ABS:l_day_stop = ' || l_day_stop);
1395: hr_utility.TRACE ('ABS:l_time_end = ' || l_time_end);
1396: hr_utility.TRACE ('ABS:l_absence_days = ' || l_absence_days);

Line 1393: hr_utility.TRACE ('ABS:l_time_start = ' || l_time_start);

1389: hr_utility.TRACE ('ABS:person_id = ' || p_absences (l_abs_ix).resource_id);
1390: hr_utility.TRACE ('ABS:g_business_group_id = ' || g_business_group_id);
1391: hr_utility.TRACE ('ABS:absence_attendance_type_id = ' || l_absence_attendance_type_id);
1392: hr_utility.TRACE ('ABS:l_day_start = ' || l_day_start);
1393: hr_utility.TRACE ('ABS:l_time_start = ' || l_time_start);
1394: hr_utility.TRACE ('ABS:l_day_stop = ' || l_day_stop);
1395: hr_utility.TRACE ('ABS:l_time_end = ' || l_time_end);
1396: hr_utility.TRACE ('ABS:l_absence_days = ' || l_absence_days);
1397: hr_utility.TRACE ('ABS:l_absence_hours = ' || l_absence_hours);

Line 1394: hr_utility.TRACE ('ABS:l_day_stop = ' || l_day_stop);

1390: hr_utility.TRACE ('ABS:g_business_group_id = ' || g_business_group_id);
1391: hr_utility.TRACE ('ABS:absence_attendance_type_id = ' || l_absence_attendance_type_id);
1392: hr_utility.TRACE ('ABS:l_day_start = ' || l_day_start);
1393: hr_utility.TRACE ('ABS:l_time_start = ' || l_time_start);
1394: hr_utility.TRACE ('ABS:l_day_stop = ' || l_day_stop);
1395: hr_utility.TRACE ('ABS:l_time_end = ' || l_time_end);
1396: hr_utility.TRACE ('ABS:l_absence_days = ' || l_absence_days);
1397: hr_utility.TRACE ('ABS:l_absence_hours = ' || l_absence_hours);
1398: hr_utility.TRACE ('ABS:Calling HR CREATE API');

Line 1395: hr_utility.TRACE ('ABS:l_time_end = ' || l_time_end);

1391: hr_utility.TRACE ('ABS:absence_attendance_type_id = ' || l_absence_attendance_type_id);
1392: hr_utility.TRACE ('ABS:l_day_start = ' || l_day_start);
1393: hr_utility.TRACE ('ABS:l_time_start = ' || l_time_start);
1394: hr_utility.TRACE ('ABS:l_day_stop = ' || l_day_stop);
1395: hr_utility.TRACE ('ABS:l_time_end = ' || l_time_end);
1396: hr_utility.TRACE ('ABS:l_absence_days = ' || l_absence_days);
1397: hr_utility.TRACE ('ABS:l_absence_hours = ' || l_absence_hours);
1398: hr_utility.TRACE ('ABS:Calling HR CREATE API');
1399: END IF;

Line 1396: hr_utility.TRACE ('ABS:l_absence_days = ' || l_absence_days);

1392: hr_utility.TRACE ('ABS:l_day_start = ' || l_day_start);
1393: hr_utility.TRACE ('ABS:l_time_start = ' || l_time_start);
1394: hr_utility.TRACE ('ABS:l_day_stop = ' || l_day_stop);
1395: hr_utility.TRACE ('ABS:l_time_end = ' || l_time_end);
1396: hr_utility.TRACE ('ABS:l_absence_days = ' || l_absence_days);
1397: hr_utility.TRACE ('ABS:l_absence_hours = ' || l_absence_hours);
1398: hr_utility.TRACE ('ABS:Calling HR CREATE API');
1399: END IF;
1400:

Line 1397: hr_utility.TRACE ('ABS:l_absence_hours = ' || l_absence_hours);

1393: hr_utility.TRACE ('ABS:l_time_start = ' || l_time_start);
1394: hr_utility.TRACE ('ABS:l_day_stop = ' || l_day_stop);
1395: hr_utility.TRACE ('ABS:l_time_end = ' || l_time_end);
1396: hr_utility.TRACE ('ABS:l_absence_days = ' || l_absence_days);
1397: hr_utility.TRACE ('ABS:l_absence_hours = ' || l_absence_hours);
1398: hr_utility.TRACE ('ABS:Calling HR CREATE API');
1399: END IF;
1400:
1401:

Line 1398: hr_utility.TRACE ('ABS:Calling HR CREATE API');

1394: hr_utility.TRACE ('ABS:l_day_stop = ' || l_day_stop);
1395: hr_utility.TRACE ('ABS:l_time_end = ' || l_time_end);
1396: hr_utility.TRACE ('ABS:l_absence_days = ' || l_absence_days);
1397: hr_utility.TRACE ('ABS:l_absence_hours = ' || l_absence_hours);
1398: hr_utility.TRACE ('ABS:Calling HR CREATE API');
1399: END IF;
1400:
1401:
1402: -- send data to absences

Line 1431: hr_utility.TRACE ('ABS:completed HR CREATE API');

1427: p_abs_overlap_warning => l_abs_overlap_warning
1428: );
1429:
1430: IF g_debug THEN
1431: hr_utility.TRACE ('ABS:completed HR CREATE API');
1432: hr_utility.TRACE ('ABS:Created Absence Attendance Id - '||l_absence_attendance_id);
1433: END IF;
1434:
1435: OPEN get_create_abs_details (p_absences (l_abs_ix).time_building_block_id);

Line 1432: hr_utility.TRACE ('ABS:Created Absence Attendance Id - '||l_absence_attendance_id);

1428: );
1429:
1430: IF g_debug THEN
1431: hr_utility.TRACE ('ABS:completed HR CREATE API');
1432: hr_utility.TRACE ('ABS:Created Absence Attendance Id - '||l_absence_attendance_id);
1433: END IF;
1434:
1435: OPEN get_create_abs_details (p_absences (l_abs_ix).time_building_block_id);
1436:

Line 1457: hr_utility.TRACE ('ABS:updated temp table = ' || SQL%ROWCOUNT);

1453: WHERE time_building_block_id = l_id_tab(l_index)
1454: AND absence_attendance_id IS NULL;
1455:
1456: IF g_debug THEN
1457: hr_utility.TRACE ('ABS:updated temp table = ' || SQL%ROWCOUNT);
1458: END IF;
1459:
1460: -- update absence details if it is already present in CO table
1461: FORALL l_index IN l_id_tab.FIRST .. l_id_tab.LAST

Line 1482: hr_utility.TRACE ('ABS:Updated HXC_ABS_CO_DETAILS');

1478: WHERE time_building_block_id = l_id_tab(l_index)
1479: AND stage <> 'RET';
1480:
1481: IF g_debug THEN
1482: hr_utility.TRACE ('ABS:Updated HXC_ABS_CO_DETAILS');
1483: END IF;
1484:
1485: END IF;
1486:

Line 1525: hr_utility.TRACE ('ABS:Created new records in CO table = ' || SQL%ROWCOUNT);

1521: FROM hxc_abs_co_details absco
1522: WHERE absco.time_building_block_id = temp.time_building_block_id));
1523:
1524: IF g_debug THEN
1525: hr_utility.TRACE ('ABS:Created new records in CO table = ' || SQL%ROWCOUNT);
1526: END IF;
1527:
1528: -- update the ELEMENT ENTRY with the COST CENTER information if the element is costed in HR
1529: IF (p_absences (l_abs_ix).cost_allocation_keyflex_id <> 0)

Line 1538: hr_utility.trace('ABS:Process next');

1534: );
1535: END IF;
1536:
1537: IF g_debug THEN
1538: hr_utility.trace('ABS:Process next');
1539: END IF;
1540:
1541: l_abs_ix := p_absences.NEXT (l_abs_ix);
1542: EXIT WHEN NOT p_absences.EXISTS (l_abs_ix);

Line 1546: hr_utility.set_location('ABS:Leaving '||l_proc, 210);

1542: EXIT WHEN NOT p_absences.EXISTS (l_abs_ix);
1543: END LOOP;
1544:
1545: IF g_debug THEN
1546: hr_utility.set_location('ABS:Leaving '||l_proc, 210);
1547: END IF;
1548:
1549:
1550: -- Commented code for bug 8932359

Line 1554: hr_utility.TRACE ('ABS:EXCEPTION IN CREATE_ABSENCES - set_to_view_only_c');

1550: -- Commented code for bug 8932359
1551: /*WHEN set_to_view_only_c
1552: THEN
1553: IF g_debug THEN
1554: hr_utility.TRACE ('ABS:EXCEPTION IN CREATE_ABSENCES - set_to_view_only_c');
1555: END IF;
1556:
1557: g_error_message := NULL;
1558: g_error_message := 'HXC_ABS_VIEW_ONLY';

Line 1601: g_debug := hr_utility.debug_enabled;

1597: l_proc VARCHAR2(100);
1598:
1599: BEGIN
1600:
1601: g_debug := hr_utility.debug_enabled;
1602:
1603: IF g_debug THEN
1604: l_proc := g_package||'recreate_absences';
1605: hr_utility.set_location('ABS:Processing '||l_proc, 300);

Line 1605: hr_utility.set_location('ABS:Processing '||l_proc, 300);

1601: g_debug := hr_utility.debug_enabled;
1602:
1603: IF g_debug THEN
1604: l_proc := g_package||'recreate_absences';
1605: hr_utility.set_location('ABS:Processing '||l_proc, 300);
1606: END IF;
1607:
1608: IF (p_uom = 'D')
1609: THEN

Line 1640: hr_utility.TRACE ('ABS: Recreation');

1636: l_time_end := p_absences (l_abs_ix).time_end;
1637: END IF;
1638:
1639: IF g_debug THEN
1640: hr_utility.TRACE ('ABS: Recreation');
1641: hr_utility.TRACE ('ABS: Parameters passed to HR CREATE API');
1642: hr_utility.TRACE ('ABS:person_id = ' || p_absences (l_abs_ix).person_id);
1643: hr_utility.TRACE ('ABS:g_business_group_id = ' || g_business_group_id);
1644: hr_utility.TRACE ('ABS:absence_attendance_type_id = ' || p_absences (l_abs_ix).absence_attendance_type_id);

Line 1641: hr_utility.TRACE ('ABS: Parameters passed to HR CREATE API');

1637: END IF;
1638:
1639: IF g_debug THEN
1640: hr_utility.TRACE ('ABS: Recreation');
1641: hr_utility.TRACE ('ABS: Parameters passed to HR CREATE API');
1642: hr_utility.TRACE ('ABS:person_id = ' || p_absences (l_abs_ix).person_id);
1643: hr_utility.TRACE ('ABS:g_business_group_id = ' || g_business_group_id);
1644: hr_utility.TRACE ('ABS:absence_attendance_type_id = ' || p_absences (l_abs_ix).absence_attendance_type_id);
1645: hr_utility.TRACE ('ABS:l_day_start = ' || l_date_start);

Line 1642: hr_utility.TRACE ('ABS:person_id = ' || p_absences (l_abs_ix).person_id);

1638:
1639: IF g_debug THEN
1640: hr_utility.TRACE ('ABS: Recreation');
1641: hr_utility.TRACE ('ABS: Parameters passed to HR CREATE API');
1642: hr_utility.TRACE ('ABS:person_id = ' || p_absences (l_abs_ix).person_id);
1643: hr_utility.TRACE ('ABS:g_business_group_id = ' || g_business_group_id);
1644: hr_utility.TRACE ('ABS:absence_attendance_type_id = ' || p_absences (l_abs_ix).absence_attendance_type_id);
1645: hr_utility.TRACE ('ABS:l_day_start = ' || l_date_start);
1646: hr_utility.TRACE ('ABS:l_time_start = ' || l_time_start);

Line 1643: hr_utility.TRACE ('ABS:g_business_group_id = ' || g_business_group_id);

1639: IF g_debug THEN
1640: hr_utility.TRACE ('ABS: Recreation');
1641: hr_utility.TRACE ('ABS: Parameters passed to HR CREATE API');
1642: hr_utility.TRACE ('ABS:person_id = ' || p_absences (l_abs_ix).person_id);
1643: hr_utility.TRACE ('ABS:g_business_group_id = ' || g_business_group_id);
1644: hr_utility.TRACE ('ABS:absence_attendance_type_id = ' || p_absences (l_abs_ix).absence_attendance_type_id);
1645: hr_utility.TRACE ('ABS:l_day_start = ' || l_date_start);
1646: hr_utility.TRACE ('ABS:l_time_start = ' || l_time_start);
1647: hr_utility.TRACE ('ABS:l_day_stop = ' || l_date_end);

Line 1644: hr_utility.TRACE ('ABS:absence_attendance_type_id = ' || p_absences (l_abs_ix).absence_attendance_type_id);

1640: hr_utility.TRACE ('ABS: Recreation');
1641: hr_utility.TRACE ('ABS: Parameters passed to HR CREATE API');
1642: hr_utility.TRACE ('ABS:person_id = ' || p_absences (l_abs_ix).person_id);
1643: hr_utility.TRACE ('ABS:g_business_group_id = ' || g_business_group_id);
1644: hr_utility.TRACE ('ABS:absence_attendance_type_id = ' || p_absences (l_abs_ix).absence_attendance_type_id);
1645: hr_utility.TRACE ('ABS:l_day_start = ' || l_date_start);
1646: hr_utility.TRACE ('ABS:l_time_start = ' || l_time_start);
1647: hr_utility.TRACE ('ABS:l_day_stop = ' || l_date_end);
1648: hr_utility.TRACE ('ABS:l_time_end = ' || l_time_end);

Line 1645: hr_utility.TRACE ('ABS:l_day_start = ' || l_date_start);

1641: hr_utility.TRACE ('ABS: Parameters passed to HR CREATE API');
1642: hr_utility.TRACE ('ABS:person_id = ' || p_absences (l_abs_ix).person_id);
1643: hr_utility.TRACE ('ABS:g_business_group_id = ' || g_business_group_id);
1644: hr_utility.TRACE ('ABS:absence_attendance_type_id = ' || p_absences (l_abs_ix).absence_attendance_type_id);
1645: hr_utility.TRACE ('ABS:l_day_start = ' || l_date_start);
1646: hr_utility.TRACE ('ABS:l_time_start = ' || l_time_start);
1647: hr_utility.TRACE ('ABS:l_day_stop = ' || l_date_end);
1648: hr_utility.TRACE ('ABS:l_time_end = ' || l_time_end);
1649: hr_utility.TRACE ('ABS:l_absence_days = ' || l_absence_days);

Line 1646: hr_utility.TRACE ('ABS:l_time_start = ' || l_time_start);

1642: hr_utility.TRACE ('ABS:person_id = ' || p_absences (l_abs_ix).person_id);
1643: hr_utility.TRACE ('ABS:g_business_group_id = ' || g_business_group_id);
1644: hr_utility.TRACE ('ABS:absence_attendance_type_id = ' || p_absences (l_abs_ix).absence_attendance_type_id);
1645: hr_utility.TRACE ('ABS:l_day_start = ' || l_date_start);
1646: hr_utility.TRACE ('ABS:l_time_start = ' || l_time_start);
1647: hr_utility.TRACE ('ABS:l_day_stop = ' || l_date_end);
1648: hr_utility.TRACE ('ABS:l_time_end = ' || l_time_end);
1649: hr_utility.TRACE ('ABS:l_absence_days = ' || l_absence_days);
1650: hr_utility.TRACE ('ABS:l_absence_hours = ' || l_absence_hours);

Line 1647: hr_utility.TRACE ('ABS:l_day_stop = ' || l_date_end);

1643: hr_utility.TRACE ('ABS:g_business_group_id = ' || g_business_group_id);
1644: hr_utility.TRACE ('ABS:absence_attendance_type_id = ' || p_absences (l_abs_ix).absence_attendance_type_id);
1645: hr_utility.TRACE ('ABS:l_day_start = ' || l_date_start);
1646: hr_utility.TRACE ('ABS:l_time_start = ' || l_time_start);
1647: hr_utility.TRACE ('ABS:l_day_stop = ' || l_date_end);
1648: hr_utility.TRACE ('ABS:l_time_end = ' || l_time_end);
1649: hr_utility.TRACE ('ABS:l_absence_days = ' || l_absence_days);
1650: hr_utility.TRACE ('ABS:l_absence_hours = ' || l_absence_hours);
1651: hr_utility.TRACE ('ABS:Calling HR CREATE API');

Line 1648: hr_utility.TRACE ('ABS:l_time_end = ' || l_time_end);

1644: hr_utility.TRACE ('ABS:absence_attendance_type_id = ' || p_absences (l_abs_ix).absence_attendance_type_id);
1645: hr_utility.TRACE ('ABS:l_day_start = ' || l_date_start);
1646: hr_utility.TRACE ('ABS:l_time_start = ' || l_time_start);
1647: hr_utility.TRACE ('ABS:l_day_stop = ' || l_date_end);
1648: hr_utility.TRACE ('ABS:l_time_end = ' || l_time_end);
1649: hr_utility.TRACE ('ABS:l_absence_days = ' || l_absence_days);
1650: hr_utility.TRACE ('ABS:l_absence_hours = ' || l_absence_hours);
1651: hr_utility.TRACE ('ABS:Calling HR CREATE API');
1652: END IF;

Line 1649: hr_utility.TRACE ('ABS:l_absence_days = ' || l_absence_days);

1645: hr_utility.TRACE ('ABS:l_day_start = ' || l_date_start);
1646: hr_utility.TRACE ('ABS:l_time_start = ' || l_time_start);
1647: hr_utility.TRACE ('ABS:l_day_stop = ' || l_date_end);
1648: hr_utility.TRACE ('ABS:l_time_end = ' || l_time_end);
1649: hr_utility.TRACE ('ABS:l_absence_days = ' || l_absence_days);
1650: hr_utility.TRACE ('ABS:l_absence_hours = ' || l_absence_hours);
1651: hr_utility.TRACE ('ABS:Calling HR CREATE API');
1652: END IF;
1653:

Line 1650: hr_utility.TRACE ('ABS:l_absence_hours = ' || l_absence_hours);

1646: hr_utility.TRACE ('ABS:l_time_start = ' || l_time_start);
1647: hr_utility.TRACE ('ABS:l_day_stop = ' || l_date_end);
1648: hr_utility.TRACE ('ABS:l_time_end = ' || l_time_end);
1649: hr_utility.TRACE ('ABS:l_absence_days = ' || l_absence_days);
1650: hr_utility.TRACE ('ABS:l_absence_hours = ' || l_absence_hours);
1651: hr_utility.TRACE ('ABS:Calling HR CREATE API');
1652: END IF;
1653:
1654: -- send data to absences

Line 1651: hr_utility.TRACE ('ABS:Calling HR CREATE API');

1647: hr_utility.TRACE ('ABS:l_day_stop = ' || l_date_end);
1648: hr_utility.TRACE ('ABS:l_time_end = ' || l_time_end);
1649: hr_utility.TRACE ('ABS:l_absence_days = ' || l_absence_days);
1650: hr_utility.TRACE ('ABS:l_absence_hours = ' || l_absence_hours);
1651: hr_utility.TRACE ('ABS:Calling HR CREATE API');
1652: END IF;
1653:
1654: -- send data to absences
1655: hr_person_absence_api.create_person_absence

Line 1684: hr_utility.TRACE ('ABS:completed HR CREATE API');

1680: );
1681:
1682:
1683: IF g_debug THEN
1684: hr_utility.TRACE ('ABS:completed HR CREATE API');
1685: hr_utility.TRACE ('ABS:Created Absence Attendance Id - '||l_new_absence_attendance_id);
1686: END IF;
1687:
1688: -- update the CO table with the new absence attendance id for those untouched absence details

Line 1685: hr_utility.TRACE ('ABS:Created Absence Attendance Id - '||l_new_absence_attendance_id);

1681:
1682:
1683: IF g_debug THEN
1684: hr_utility.TRACE ('ABS:completed HR CREATE API');
1685: hr_utility.TRACE ('ABS:Created Absence Attendance Id - '||l_new_absence_attendance_id);
1686: END IF;
1687:
1688: -- update the CO table with the new absence attendance id for those untouched absence details
1689: -- which are not edited but recreated

Line 1702: hr_utility.set_location('ABS:Leaving '||l_proc, 310);

1698: EXIT WHEN NOT p_absences.EXISTS (l_abs_ix);
1699: END LOOP;
1700:
1701: IF g_debug THEN
1702: hr_utility.set_location('ABS:Leaving '||l_proc, 310);
1703: END IF;
1704:
1705:
1706: END recreate_absences;

Line 1774: g_debug := hr_utility.debug_enabled;

1770: --set_to_view_only_d EXCEPTION;
1771:
1772: BEGIN
1773:
1774: g_debug := hr_utility.debug_enabled;
1775:
1776: IF g_debug THEN
1777: l_proc := g_package||'delete_absences';
1778: hr_utility.set_location('ABS:Processing '||l_proc, 400);

Line 1778: hr_utility.set_location('ABS:Processing '||l_proc, 400);

1774: g_debug := hr_utility.debug_enabled;
1775:
1776: IF g_debug THEN
1777: l_proc := g_package||'delete_absences';
1778: hr_utility.set_location('ABS:Processing '||l_proc, 400);
1779: END IF;
1780:
1781: IF g_debug THEN
1782: hr_utility.TRACE ( 'ABS:Process DELETE for Absence attendance id = ' || p_absence_attendance_id );

Line 1782: hr_utility.TRACE ( 'ABS:Process DELETE for Absence attendance id = ' || p_absence_attendance_id );

1778: hr_utility.set_location('ABS:Processing '||l_proc, 400);
1779: END IF;
1780:
1781: IF g_debug THEN
1782: hr_utility.TRACE ( 'ABS:Process DELETE for Absence attendance id = ' || p_absence_attendance_id );
1783: END IF;
1784:
1785: -- get absences information from per_absence_attendances table
1786: OPEN get_absences_details_cur;

Line 1801: hr_utility.TRACE ('ABS:Absence record already deleted from HR');

1797:
1798: IF get_absences_details_cur%NOTFOUND
1799: THEN
1800: IF g_debug THEN
1801: hr_utility.TRACE ('ABS:Absence record already deleted from HR');
1802: END IF;
1803:
1804: RETURN;
1805: END IF;

Line 1810: hr_utility.TRACE ('ABS:l_absence_attendance_type_id = '||l_absence_attendance_type_id);

1806:
1807: CLOSE get_absences_details_cur;
1808:
1809: IF g_debug THEN
1810: hr_utility.TRACE ('ABS:l_absence_attendance_type_id = '||l_absence_attendance_type_id);
1811: hr_utility.TRACE ('ABS:l_date_start = '||l_date_start);
1812: hr_utility.TRACE ('ABS:l_date_end = '||l_date_end);
1813: hr_utility.TRACE ('ABS:l_time_start = '||l_time_start);
1814: hr_utility.TRACE ('ABS:l_time_end = '||l_time_end);

Line 1811: hr_utility.TRACE ('ABS:l_date_start = '||l_date_start);

1807: CLOSE get_absences_details_cur;
1808:
1809: IF g_debug THEN
1810: hr_utility.TRACE ('ABS:l_absence_attendance_type_id = '||l_absence_attendance_type_id);
1811: hr_utility.TRACE ('ABS:l_date_start = '||l_date_start);
1812: hr_utility.TRACE ('ABS:l_date_end = '||l_date_end);
1813: hr_utility.TRACE ('ABS:l_time_start = '||l_time_start);
1814: hr_utility.TRACE ('ABS:l_time_end = '||l_time_end);
1815: hr_utility.TRACE ('ABS:l_person_id = '||l_person_id);

Line 1812: hr_utility.TRACE ('ABS:l_date_end = '||l_date_end);

1808:
1809: IF g_debug THEN
1810: hr_utility.TRACE ('ABS:l_absence_attendance_type_id = '||l_absence_attendance_type_id);
1811: hr_utility.TRACE ('ABS:l_date_start = '||l_date_start);
1812: hr_utility.TRACE ('ABS:l_date_end = '||l_date_end);
1813: hr_utility.TRACE ('ABS:l_time_start = '||l_time_start);
1814: hr_utility.TRACE ('ABS:l_time_end = '||l_time_end);
1815: hr_utility.TRACE ('ABS:l_person_id = '||l_person_id);
1816: hr_utility.TRACE ('ABS:l_program_application_id = '||l_program_application_id);

Line 1813: hr_utility.TRACE ('ABS:l_time_start = '||l_time_start);

1809: IF g_debug THEN
1810: hr_utility.TRACE ('ABS:l_absence_attendance_type_id = '||l_absence_attendance_type_id);
1811: hr_utility.TRACE ('ABS:l_date_start = '||l_date_start);
1812: hr_utility.TRACE ('ABS:l_date_end = '||l_date_end);
1813: hr_utility.TRACE ('ABS:l_time_start = '||l_time_start);
1814: hr_utility.TRACE ('ABS:l_time_end = '||l_time_end);
1815: hr_utility.TRACE ('ABS:l_person_id = '||l_person_id);
1816: hr_utility.TRACE ('ABS:l_program_application_id = '||l_program_application_id);
1817: hr_utility.TRACE ('ABS:l_edit_flag = '||l_edit_flag);

Line 1814: hr_utility.TRACE ('ABS:l_time_end = '||l_time_end);

1810: hr_utility.TRACE ('ABS:l_absence_attendance_type_id = '||l_absence_attendance_type_id);
1811: hr_utility.TRACE ('ABS:l_date_start = '||l_date_start);
1812: hr_utility.TRACE ('ABS:l_date_end = '||l_date_end);
1813: hr_utility.TRACE ('ABS:l_time_start = '||l_time_start);
1814: hr_utility.TRACE ('ABS:l_time_end = '||l_time_end);
1815: hr_utility.TRACE ('ABS:l_person_id = '||l_person_id);
1816: hr_utility.TRACE ('ABS:l_program_application_id = '||l_program_application_id);
1817: hr_utility.TRACE ('ABS:l_edit_flag = '||l_edit_flag);
1818: END IF;

Line 1815: hr_utility.TRACE ('ABS:l_person_id = '||l_person_id);

1811: hr_utility.TRACE ('ABS:l_date_start = '||l_date_start);
1812: hr_utility.TRACE ('ABS:l_date_end = '||l_date_end);
1813: hr_utility.TRACE ('ABS:l_time_start = '||l_time_start);
1814: hr_utility.TRACE ('ABS:l_time_end = '||l_time_end);
1815: hr_utility.TRACE ('ABS:l_person_id = '||l_person_id);
1816: hr_utility.TRACE ('ABS:l_program_application_id = '||l_program_application_id);
1817: hr_utility.TRACE ('ABS:l_edit_flag = '||l_edit_flag);
1818: END IF;
1819:

Line 1816: hr_utility.TRACE ('ABS:l_program_application_id = '||l_program_application_id);

1812: hr_utility.TRACE ('ABS:l_date_end = '||l_date_end);
1813: hr_utility.TRACE ('ABS:l_time_start = '||l_time_start);
1814: hr_utility.TRACE ('ABS:l_time_end = '||l_time_end);
1815: hr_utility.TRACE ('ABS:l_person_id = '||l_person_id);
1816: hr_utility.TRACE ('ABS:l_program_application_id = '||l_program_application_id);
1817: hr_utility.TRACE ('ABS:l_edit_flag = '||l_edit_flag);
1818: END IF;
1819:
1820: IF g_debug THEN

Line 1817: hr_utility.TRACE ('ABS:l_edit_flag = '||l_edit_flag);

1813: hr_utility.TRACE ('ABS:l_time_start = '||l_time_start);
1814: hr_utility.TRACE ('ABS:l_time_end = '||l_time_end);
1815: hr_utility.TRACE ('ABS:l_person_id = '||l_person_id);
1816: hr_utility.TRACE ('ABS:l_program_application_id = '||l_program_application_id);
1817: hr_utility.TRACE ('ABS:l_edit_flag = '||l_edit_flag);
1818: END IF;
1819:
1820: IF g_debug THEN
1821: hr_utility.set_location('ABS:Processing '||l_proc, 410);

Line 1821: hr_utility.set_location('ABS:Processing '||l_proc, 410);

1817: hr_utility.TRACE ('ABS:l_edit_flag = '||l_edit_flag);
1818: END IF;
1819:
1820: IF g_debug THEN
1821: hr_utility.set_location('ABS:Processing '||l_proc, 410);
1822: END IF;
1823:
1824: -- delete absences attached to HOURS based absences created by OTL from absences module
1825: IF (p_uom IN ('H', 'HOURS') AND l_program_application_id = '809')

Line 1829: hr_utility.TRACE ('ABS:Call HR DELETE API for absence (hours) = ' || p_absence_attendance_id );

1825: IF (p_uom IN ('H', 'HOURS') AND l_program_application_id = '809')
1826: THEN
1827:
1828: IF g_debug THEN
1829: hr_utility.TRACE ('ABS:Call HR DELETE API for absence (hours) = ' || p_absence_attendance_id );
1830: END IF;
1831:
1832: hr_person_absence_api.delete_person_absence
1833: (p_validate => FALSE,

Line 1844: hr_utility.TRACE ('ABS:Rows update (1) - ' || SQL%ROWCOUNT);

1840: SET absence_attendance_id = NULL
1841: WHERE absence_attendance_id = p_absence_attendance_id;
1842:
1843: IF g_debug THEN
1844: hr_utility.TRACE ('ABS:Rows update (1) - ' || SQL%ROWCOUNT);
1845: END IF;
1846:
1847: IF g_debug THEN
1848: hr_utility.set_location('ABS:Processing '||l_proc, 420);

Line 1848: hr_utility.set_location('ABS:Processing '||l_proc, 420);

1844: hr_utility.TRACE ('ABS:Rows update (1) - ' || SQL%ROWCOUNT);
1845: END IF;
1846:
1847: IF g_debug THEN
1848: hr_utility.set_location('ABS:Processing '||l_proc, 420);
1849: END IF;
1850:
1851: UPDATE hxc_abs_ret_temp
1852: SET retrieval_status = 'SUCCESS'

Line 1873: hr_utility.set_location('ABS:Processing '||l_proc, 425);

1869:
1870: IF (l_edit_flag = 'N' and l_program_application_id = '800' and g_tc_status = 'DELETED')
1871: THEN
1872: IF g_debug THEN
1873: hr_utility.set_location('ABS:Processing '||l_proc, 425);
1874: END IF;
1875:
1876: IF g_debug THEN
1877: hr_utility.trace('ABS:These prepop absences are set to View Only and not deleted from HR on timecard delete');

Line 1877: hr_utility.trace('ABS:These prepop absences are set to View Only and not deleted from HR on timecard delete');

1873: hr_utility.set_location('ABS:Processing '||l_proc, 425);
1874: END IF;
1875:
1876: IF g_debug THEN
1877: hr_utility.trace('ABS:These prepop absences are set to View Only and not deleted from HR on timecard delete');
1878: END IF;
1879:
1880: UPDATE hxc_abs_co_details
1881: SET absence_attendance_id = NULL

Line 1889: hr_utility.set_location('ABS:Processing '||l_proc, 428);

1885: SET retrieval_status = 'SUCCESS'
1886: WHERE absence_attendance_id = p_absence_attendance_id;
1887:
1888: IF g_debug THEN
1889: hr_utility.set_location('ABS:Processing '||l_proc, 428);
1890: END IF;
1891:
1892: RETURN;
1893:

Line 1898: hr_utility.TRACE ('ABS:Call HR DELETE API for absence = ' || p_absence_attendance_id );

1894: END IF;
1895:
1896:
1897: IF g_debug THEN
1898: hr_utility.TRACE ('ABS:Call HR DELETE API for absence = ' || p_absence_attendance_id );
1899: END IF;
1900:
1901: hr_person_absence_api.delete_person_absence
1902: (p_validate => FALSE,

Line 1909: hr_utility.TRACE ('ABS:Start Splitting the periods');

1905: p_called_from => 809
1906: );
1907:
1908: IF g_debug THEN
1909: hr_utility.TRACE ('ABS:Start Splitting the periods');
1910: END IF;
1911:
1912: -- when recreating DAYS based absences with program application id = 809, it has to still be
1913: -- recreated as continuous entries whereas for HOURS it has to be recreated as entry for each day

Line 1917: hr_utility.TRACE ('ABS:Splitting days' );

1913: -- recreated as continuous entries whereas for HOURS it has to be recreated as entry for each day
1914: IF (p_uom in ('D', 'DAYS')) THEN
1915:
1916: IF g_debug THEN
1917: hr_utility.TRACE ('ABS:Splitting days' );
1918: END IF;
1919: -- cut the right and left details from the current TC period, if it exists
1920: -- cutting the left
1921: IF (l_date_start < g_tc_start)

Line 1935: hr_utility.set_location('ABS:Processing '||l_proc, 430);

1931: l_left := 1;
1932: END IF;
1933:
1934: IF g_debug THEN
1935: hr_utility.set_location('ABS:Processing '||l_proc, 430);
1936: END IF;
1937:
1938: -- cutting the right
1939: IF (l_date_end > g_tc_stop)

Line 1953: hr_utility.set_location('ABS:Processing '||l_proc, 440);

1949: l_right := 1;
1950: END IF;
1951:
1952: IF g_debug THEN
1953: hr_utility.set_location('ABS:Processing '||l_proc, 440);
1954: END IF;
1955:
1956: /*
1957: 4 scenarios

Line 1989: hr_utility.set_location('ABS:Processing '||l_proc, 440);

1985: l_date_end := l_date_end; -- no change
1986: END IF;
1987:
1988: IF g_debug THEN
1989: hr_utility.set_location('ABS:Processing '||l_proc, 440);
1990: END IF;
1991:
1992:
1993: IF g_debug THEN

Line 1994: hr_utility.TRACE ('ABS:Process within timecard period');

1990: END IF;
1991:
1992:
1993: IF g_debug THEN
1994: hr_utility.TRACE ('ABS:Process within timecard period');
1995: hr_utility.TRACE ('ABS:l_date_start = ' || l_date_start);
1996: hr_utility.TRACE ('ABS:l_date_end = ' || l_date_end);
1997: hr_utility.TRACE ('ABS:p_edited_days.count = ' || p_edited_days.COUNT);
1998: END IF;

Line 1995: hr_utility.TRACE ('ABS:l_date_start = ' || l_date_start);

1991:
1992:
1993: IF g_debug THEN
1994: hr_utility.TRACE ('ABS:Process within timecard period');
1995: hr_utility.TRACE ('ABS:l_date_start = ' || l_date_start);
1996: hr_utility.TRACE ('ABS:l_date_end = ' || l_date_end);
1997: hr_utility.TRACE ('ABS:p_edited_days.count = ' || p_edited_days.COUNT);
1998: END IF;
1999:

Line 1996: hr_utility.TRACE ('ABS:l_date_end = ' || l_date_end);

1992:
1993: IF g_debug THEN
1994: hr_utility.TRACE ('ABS:Process within timecard period');
1995: hr_utility.TRACE ('ABS:l_date_start = ' || l_date_start);
1996: hr_utility.TRACE ('ABS:l_date_end = ' || l_date_end);
1997: hr_utility.TRACE ('ABS:p_edited_days.count = ' || p_edited_days.COUNT);
1998: END IF;
1999:
2000: -- split based on the days which are updated/deleted within the timecard period

Line 1997: hr_utility.TRACE ('ABS:p_edited_days.count = ' || p_edited_days.COUNT);

1993: IF g_debug THEN
1994: hr_utility.TRACE ('ABS:Process within timecard period');
1995: hr_utility.TRACE ('ABS:l_date_start = ' || l_date_start);
1996: hr_utility.TRACE ('ABS:l_date_end = ' || l_date_end);
1997: hr_utility.TRACE ('ABS:p_edited_days.count = ' || p_edited_days.COUNT);
1998: END IF;
1999:
2000: -- split based on the days which are updated/deleted within the timecard period
2001: IF (p_edited_days.COUNT > 0)

Line 2007: hr_utility.TRACE ('IF - 1');

2003: FOR l_days IN p_edited_days.FIRST .. p_edited_days.LAST
2004: LOOP
2005: IF (l_date_start < p_edited_days (l_days).day_start)
2006: THEN
2007: hr_utility.TRACE ('IF - 1');
2008: l_abs_index := l_abs_index + 1;
2009: l_absences_details (l_abs_index).absence_attendance_type_id := l_absence_attendance_type_id;
2010: l_absences_details (l_abs_index).date_start := l_date_start;
2011: l_absences_details (l_abs_index).date_end := p_edited_days (l_days).day_stop - 1;

Line 2024: hr_utility.TRACE ('IF - 2');

2020: END LOOP;
2021:
2022: IF (l_date_start <= l_date_end)
2023: THEN
2024: hr_utility.TRACE ('IF - 2');
2025: l_abs_index := l_abs_index + 1;
2026: l_absences_details (l_abs_index).absence_attendance_type_id := l_absence_attendance_type_id;
2027: l_absences_details (l_abs_index).date_start := l_date_start;
2028: l_absences_details (l_abs_index).date_end := l_date_end;

Line 2037: hr_utility.set_location('ABS:Processing '||l_proc, 450);

2033: END IF;
2034: END IF; -- p_edited_days.COUNT > 0
2035:
2036: IF g_debug THEN
2037: hr_utility.set_location('ABS:Processing '||l_proc, 450);
2038: END IF;
2039:
2040: END IF; -- p_uom in ('D', 'DAYS')
2041:

Line 2047: hr_utility.TRACE ('ABS:Splitting hours' );

2043: -- recreated for each day and hence the logic differs for HOURS and DAYS
2044: IF (p_uom in ('H', 'HOURS')) THEN
2045:
2046: IF g_debug THEN
2047: hr_utility.TRACE ('ABS:Splitting hours' );
2048: END IF;
2049:
2050: l_orig_date_start := l_date_start;
2051: l_orig_date_end := l_date_end;

Line 2059: hr_utility.TRACE ('ABS:l_co_details.COUNT = '||l_co_details.COUNT);

2055: CLOSE co_details_cur;
2056:
2057:
2058: IF g_debug THEN
2059: hr_utility.TRACE ('ABS:l_co_details.COUNT = '||l_co_details.COUNT);
2060: END IF;
2061:
2062: IF (l_co_details.COUNT = 0) THEN
2063: RETURN;

Line 2070: hr_utility.TRACE ('ABS: Processing left for HOURS');

2066: -- recreate absences for periods which fall to the left of the first start_time in l_co_details
2067: IF l_date_start < l_co_details (l_co_details.FIRST).start_time THEN
2068:
2069: IF g_debug THEN
2070: hr_utility.TRACE ('ABS: Processing left for HOURS');
2071: END IF;
2072:
2073: LOOP
2074: EXIT WHEN l_date_start = l_co_details (l_co_details.FIRST).start_time;

Line 2091: hr_utility.set_location('ABS:Processing '||l_proc, 451);

2087: END LOOP;
2088: END IF;
2089:
2090: IF g_debug THEN
2091: hr_utility.set_location('ABS:Processing '||l_proc, 451);
2092: END IF;
2093:
2094: -- recreate absences for periods which fall to the right of the last stop_time in l_co_details
2095: IF l_date_end > l_co_details (l_co_details.LAST).stop_time THEN

Line 2098: hr_utility.TRACE ('ABS: Processing right for HOURS');

2094: -- recreate absences for periods which fall to the right of the last stop_time in l_co_details
2095: IF l_date_end > l_co_details (l_co_details.LAST).stop_time THEN
2096:
2097: IF g_debug THEN
2098: hr_utility.TRACE ('ABS: Processing right for HOURS');
2099: END IF;
2100:
2101: LOOP
2102: EXIT WHEN l_date_end = l_co_details (l_co_details.LAST).stop_time;

Line 2119: hr_utility.set_location('ABS:Processing '||l_proc, 452);

2115: END LOOP;
2116: END IF;
2117:
2118: IF g_debug THEN
2119: hr_utility.set_location('ABS:Processing '||l_proc, 452);
2120: END IF;
2121:
2122: -- recreate absences with for the time periods in l_co_details
2123: IF g_debug THEN

Line 2124: hr_utility.TRACE ('ABS: Processing within CO for HOURS');

2120: END IF;
2121:
2122: -- recreate absences with for the time periods in l_co_details
2123: IF g_debug THEN
2124: hr_utility.TRACE ('ABS: Processing within CO for HOURS');
2125: END IF;
2126:
2127: FOR l_days IN l_co_details.FIRST .. l_co_details.LAST
2128: LOOP

Line 2142: hr_utility.set_location('ABS:Processing '||l_proc, 453);

2138:
2139: END LOOP;
2140:
2141: IF g_debug THEN
2142: hr_utility.set_location('ABS:Processing '||l_proc, 453);
2143: END IF;
2144:
2145: l_old_tc_start := l_co_details(l_co_details.FIRST).start_time;
2146: l_old_tc_stop := l_co_details(l_co_details.FIRST).stop_time;

Line 2155: hr_utility.TRACE ('ABS: Processing missing time periods within CO for HOURS');

2151: LOOP
2152: IF (l_co_details(l_days).start_time - l_old_tc_stop > 1) THEN
2153:
2154: IF g_debug THEN
2155: hr_utility.TRACE ('ABS: Processing missing time periods within CO for HOURS');
2156: END IF;
2157:
2158: l_temp_date := l_old_tc_stop + 1;
2159:

Line 2187: hr_utility.set_location('ABS:Processing '||l_proc, 454);

2183:
2184: END LOOP;
2185:
2186: IF g_debug THEN
2187: hr_utility.set_location('ABS:Processing '||l_proc, 454);
2188: END IF;
2189:
2190:
2191: IF (l_absences_details.COUNT > 0) THEN

Line 2202: hr_utility.set_location('ABS:Processing '||l_proc, 455);

2198: END IF;
2199: END IF;
2200:
2201: IF g_debug THEN
2202: hr_utility.set_location('ABS:Processing '||l_proc, 455);
2203: END IF;
2204:
2205: END IF; -- p_uom in ('H', 'HOURS')
2206:

Line 2208: hr_utility.set_location('ABS:Processing '||l_proc, 458);

2204:
2205: END IF; -- p_uom in ('H', 'HOURS')
2206:
2207: IF g_debug THEN
2208: hr_utility.set_location('ABS:Processing '||l_proc, 458);
2209: END IF;
2210:
2211:
2212: -- delete absences details from absco table which are updated/deleted from Timecard

Line 2224: hr_utility.set_location('ABS:Processing '||l_proc, 460);

2220: OR time_building_block_id < 0
2221: AND absence_attendance_id = p_absence_attendance_id;
2222:
2223: IF g_debug THEN
2224: hr_utility.set_location('ABS:Processing '||l_proc, 460);
2225: END IF;
2226:
2227: -- periods which has to be recreated due to absence_attendance_id deletion
2228: IF l_absences_details.COUNT > 0

Line 2231: hr_utility.TRACE ('ABS:split periods');

2227: -- periods which has to be recreated due to absence_attendance_id deletion
2228: IF l_absences_details.COUNT > 0
2229: THEN
2230: IF g_debug THEN
2231: hr_utility.TRACE ('ABS:split periods');
2232: END IF;
2233:
2234: FOR l_abs_ix IN l_absences_details.FIRST .. l_absences_details.LAST
2235: LOOP

Line 2237: hr_utility.TRACE ('ABS:abs type id'||l_absences_details (l_abs_ix).absence_attendance_type_id );

2233:
2234: FOR l_abs_ix IN l_absences_details.FIRST .. l_absences_details.LAST
2235: LOOP
2236: IF g_debug THEN
2237: hr_utility.TRACE ('ABS:abs type id'||l_absences_details (l_abs_ix).absence_attendance_type_id );
2238: hr_utility.TRACE ('ABS:start date'||l_absences_details (l_abs_ix).date_start);
2239: hr_utility.TRACE ('ABS:end date'||l_absences_details (l_abs_ix).date_end);
2240: END IF;
2241: END LOOP;

Line 2238: hr_utility.TRACE ('ABS:start date'||l_absences_details (l_abs_ix).date_start);

2234: FOR l_abs_ix IN l_absences_details.FIRST .. l_absences_details.LAST
2235: LOOP
2236: IF g_debug THEN
2237: hr_utility.TRACE ('ABS:abs type id'||l_absences_details (l_abs_ix).absence_attendance_type_id );
2238: hr_utility.TRACE ('ABS:start date'||l_absences_details (l_abs_ix).date_start);
2239: hr_utility.TRACE ('ABS:end date'||l_absences_details (l_abs_ix).date_end);
2240: END IF;
2241: END LOOP;
2242:

Line 2239: hr_utility.TRACE ('ABS:end date'||l_absences_details (l_abs_ix).date_end);

2235: LOOP
2236: IF g_debug THEN
2237: hr_utility.TRACE ('ABS:abs type id'||l_absences_details (l_abs_ix).absence_attendance_type_id );
2238: hr_utility.TRACE ('ABS:start date'||l_absences_details (l_abs_ix).date_start);
2239: hr_utility.TRACE ('ABS:end date'||l_absences_details (l_abs_ix).date_end);
2240: END IF;
2241: END LOOP;
2242:
2243: -- call recreate_absences for the split periods

Line 2245: hr_utility.TRACE ('ABS:Calling recreate_absences proc');

2241: END LOOP;
2242:
2243: -- call recreate_absences for the split periods
2244: IF g_debug THEN
2245: hr_utility.TRACE ('ABS:Calling recreate_absences proc');
2246: END IF;
2247:
2248: recreate_absences (l_absences_details,
2249: p_uom,

Line 2254: hr_utility.TRACE ('ABS:Completed recreate_absences proc');

2250: p_absence_attendance_id
2251: );
2252:
2253: IF g_debug THEN
2254: hr_utility.TRACE ('ABS:Completed recreate_absences proc');
2255: END IF;
2256:
2257: END IF;
2258:

Line 2264: hr_utility.set_location('ABS:Processing '||l_proc, 470);

2260: SET retrieval_status = 'SUCCESS'
2261: WHERE absence_attendance_id = p_absence_attendance_id;
2262:
2263: IF g_debug THEN
2264: hr_utility.set_location('ABS:Processing '||l_proc, 470);
2265: END IF;
2266:
2267: RETURN;
2268: END IF;

Line 2275: hr_utility.trace('ABS:Absences with source HR are not allowed to be deleted on timecard delete');

2271: THEN
2272: IF (g_tc_status = 'DELETED') THEN
2273:
2274: IF g_debug THEN
2275: hr_utility.trace('ABS:Absences with source HR are not allowed to be deleted on timecard delete');
2276: END IF;
2277:
2278: UPDATE hxc_abs_co_details
2279: SET absence_attendance_id = NULL

Line 2287: hr_utility.set_location('ABS:Processing '||l_proc, 480);

2283: SET retrieval_status = 'SUCCESS'
2284: WHERE absence_attendance_id = p_absence_attendance_id;
2285:
2286: IF g_debug THEN
2287: hr_utility.set_location('ABS:Processing '||l_proc, 480);
2288: END IF;
2289: ELSE
2290: IF g_debug THEN
2291: hr_utility.trace('ABS:This prepopulated absence was allowed to be edited in Timecard and later set to EDIT NOT ALLOWED before retrieval');

Line 2291: hr_utility.trace('ABS:This prepopulated absence was allowed to be edited in Timecard and later set to EDIT NOT ALLOWED before retrieval');

2287: hr_utility.set_location('ABS:Processing '||l_proc, 480);
2288: END IF;
2289: ELSE
2290: IF g_debug THEN
2291: hr_utility.trace('ABS:This prepopulated absence was allowed to be edited in Timecard and later set to EDIT NOT ALLOWED before retrieval');
2292: hr_utility.trace('ABS:Change in preference setup before Absence Retrieval - WRONG SETUP');
2293: END IF;
2294:
2295: RAISE pref_changed_before_ret;

Line 2292: hr_utility.trace('ABS:Change in preference setup before Absence Retrieval - WRONG SETUP');

2288: END IF;
2289: ELSE
2290: IF g_debug THEN
2291: hr_utility.trace('ABS:This prepopulated absence was allowed to be edited in Timecard and later set to EDIT NOT ALLOWED before retrieval');
2292: hr_utility.trace('ABS:Change in preference setup before Absence Retrieval - WRONG SETUP');
2293: END IF;
2294:
2295: RAISE pref_changed_before_ret;
2296: END IF;

Line 2305: hr_utility.TRACE ('ABS:EXCEPTION IN DELETE_ABSENCES - set_to_view_only_d');

2301: -- Commented code for bug 8932359
2302: /*WHEN set_to_view_only_d
2303: THEN
2304: IF g_debug THEN
2305: hr_utility.TRACE ('ABS:EXCEPTION IN DELETE_ABSENCES - set_to_view_only_d');
2306: END IF;
2307:
2308: g_error_message := NULL;
2309: g_error_message := 'HXC_ABS_VIEW_ONLY';

Line 2316: hr_utility.TRACE ('ABS:EXCEPTION IN DELETE_ABSENCES - pref_changed_before_ret');

2312:
2313: WHEN pref_changed_before_ret
2314: THEN
2315: IF g_debug THEN
2316: hr_utility.TRACE ('ABS:EXCEPTION IN DELETE_ABSENCES - pref_changed_before_ret');
2317: END IF;
2318:
2319: g_error_message := NULL;
2320: g_error_message := 'HXC_ABS_NO_EDIT_PREP';

Line 2502: g_debug := hr_utility.debug_enabled;

2498: l_proc VARCHAR2(100);
2499:
2500: BEGIN
2501:
2502: g_debug := hr_utility.debug_enabled;
2503:
2504: IF g_debug THEN
2505: l_proc := g_package||'update_cost_center';
2506: hr_utility.set_location('ABS:Processing '||l_proc, 500);

Line 2506: hr_utility.set_location('ABS:Processing '||l_proc, 500);

2502: g_debug := hr_utility.debug_enabled;
2503:
2504: IF g_debug THEN
2505: l_proc := g_package||'update_cost_center';
2506: hr_utility.set_location('ABS:Processing '||l_proc, 500);
2507: END IF;
2508:
2509: IF g_debug THEN
2510: hr_utility.TRACE

Line 2510: hr_utility.TRACE

2506: hr_utility.set_location('ABS:Processing '||l_proc, 500);
2507: END IF;
2508:
2509: IF g_debug THEN
2510: hr_utility.TRACE
2511: ( 'ABS:Entered update_cost_center for absence_attendance_id = ' || p_absence_attendance_id );
2512:
2513: END IF;
2514:

Line 2527: hr_utility.TRACE ('ABS:l_element_entry_id = ' || l_element_entry_id);

2523:
2524: CLOSE get_element_entry_info;
2525:
2526: IF g_debug THEN
2527: hr_utility.TRACE ('ABS:l_element_entry_id = ' || l_element_entry_id);
2528: hr_utility.TRACE ('ABS:l_costable_type = ' || l_costable_type);
2529: END IF;
2530:
2531: IF l_costable_type = 'C'

Line 2528: hr_utility.TRACE ('ABS:l_costable_type = ' || l_costable_type);

2524: CLOSE get_element_entry_info;
2525:
2526: IF g_debug THEN
2527: hr_utility.TRACE ('ABS:l_element_entry_id = ' || l_element_entry_id);
2528: hr_utility.TRACE ('ABS:l_costable_type = ' || l_costable_type);
2529: END IF;
2530:
2531: IF l_costable_type = 'C'
2532: THEN

Line 2534: hr_utility.TRACE ( 'ABS:p_cost_allocation_keyflex_id = ' || p_cost_allocation_keyflex_id );

2530:
2531: IF l_costable_type = 'C'
2532: THEN
2533: IF g_debug THEN
2534: hr_utility.TRACE ( 'ABS:p_cost_allocation_keyflex_id = ' || p_cost_allocation_keyflex_id );
2535: END IF;
2536:
2537: -- update element entries with the cost allocation keyflex id
2538: py_element_entry_api.update_element_entry

Line 2553: hr_utility.set_location('ABS:Processing '||l_proc, 520);

2549: );
2550: END IF;
2551:
2552: IF g_debug THEN
2553: hr_utility.set_location('ABS:Processing '||l_proc, 520);
2554: END IF;
2555:
2556:
2557: END update_cost_center;

Line 2570: g_debug := hr_utility.debug_enabled;

2566: l_proc VARCHAR2(100);
2567: l_cost_allocation_structure VARCHAR2(150);
2568: BEGIN
2569:
2570: g_debug := hr_utility.debug_enabled;
2571:
2572: IF g_debug THEN
2573: l_proc := g_package||'populate_cost_keyflex';
2574: hr_utility.set_location('ABS:Processing '||l_proc, 600);

Line 2574: hr_utility.set_location('ABS:Processing '||l_proc, 600);

2570: g_debug := hr_utility.debug_enabled;
2571:
2572: IF g_debug THEN
2573: l_proc := g_package||'populate_cost_keyflex';
2574: hr_utility.set_location('ABS:Processing '||l_proc, 600);
2575: END IF;
2576:
2577: l_cost_allocation_structure := get_cost_alloc_struct(g_business_group_id);
2578:

Line 2580: hr_utility.set_location('ABS:Processing '||l_proc, 610);

2576:
2577: l_cost_allocation_structure := get_cost_alloc_struct(g_business_group_id);
2578:
2579: IF g_debug THEN
2580: hr_utility.set_location('ABS:Processing '||l_proc, 610);
2581: END IF;
2582:
2583: -- Modified for Bug 14143774
2584: -- Derive the cost_allocation_keyflex_id

Line 2661: hr_utility.set_location('ABS:Leaving '||l_proc, 620);

2657: );
2658: END LOOP;
2659:
2660: IF g_debug THEN
2661: hr_utility.set_location('ABS:Leaving '||l_proc, 620);
2662: END IF;
2663:
2664: EXCEPTION
2665: WHEN OTHERS THEN

Line 2667: hr_utility.trace('ABS:In populate_cost_keyflex exception');

2663:
2664: EXCEPTION
2665: WHEN OTHERS THEN
2666:
2667: hr_utility.trace('ABS:In populate_cost_keyflex exception');
2668: hr_utility.trace('ABS:In populate_cost_keyflex dbms_utility.format_call_stack ::'||dbms_utility.format_call_stack);
2669: hr_utility.trace('ABS:In populate_cost_keyflex dbms_utility.format_error_backtrace ::'||dbms_utility.format_error_backtrace);
2670:
2671: RAISE;

Line 2668: hr_utility.trace('ABS:In populate_cost_keyflex dbms_utility.format_call_stack ::'||dbms_utility.format_call_stack);

2664: EXCEPTION
2665: WHEN OTHERS THEN
2666:
2667: hr_utility.trace('ABS:In populate_cost_keyflex exception');
2668: hr_utility.trace('ABS:In populate_cost_keyflex dbms_utility.format_call_stack ::'||dbms_utility.format_call_stack);
2669: hr_utility.trace('ABS:In populate_cost_keyflex dbms_utility.format_error_backtrace ::'||dbms_utility.format_error_backtrace);
2670:
2671: RAISE;
2672:

Line 2669: hr_utility.trace('ABS:In populate_cost_keyflex dbms_utility.format_error_backtrace ::'||dbms_utility.format_error_backtrace);

2665: WHEN OTHERS THEN
2666:
2667: hr_utility.trace('ABS:In populate_cost_keyflex exception');
2668: hr_utility.trace('ABS:In populate_cost_keyflex dbms_utility.format_call_stack ::'||dbms_utility.format_call_stack);
2669: hr_utility.trace('ABS:In populate_cost_keyflex dbms_utility.format_error_backtrace ::'||dbms_utility.format_error_backtrace);
2670:
2671: RAISE;
2672:
2673: END populate_cost_keyflex;

Line 2686: hr_utility.trace('ABS:Inside function IS_VIEW_ONLY');

2682:
2683: BEGIN
2684:
2685: IF g_debug THEN
2686: hr_utility.trace('ABS:Inside function IS_VIEW_ONLY');
2687: END IF;
2688:
2689: SELECT edit_flag INTO l_edit_flag
2690: FROM hxc_absence_type_elements

Line 2694: hr_utility.trace('ABS:l_edit_flag = '||l_edit_flag);

2690: FROM hxc_absence_type_elements
2691: WHERE absence_attendance_type_id = p_absence_attendance_type_id;
2692:
2693: IF g_debug THEN
2694: hr_utility.trace('ABS:l_edit_flag = '||l_edit_flag);
2695: END IF;
2696:
2697: IF (l_edit_flag = 'Y') THEN
2698: IF g_debug THEN

Line 2699: hr_utility.trace('ABS:View and Edit');

2695: END IF;
2696:
2697: IF (l_edit_flag = 'Y') THEN
2698: IF g_debug THEN
2699: hr_utility.trace('ABS:View and Edit');
2700: END IF;
2701:
2702: RETURN FALSE;
2703: ELSE

Line 2705: hr_utility.trace('ABS:View Only');

2701:
2702: RETURN FALSE;
2703: ELSE
2704: IF g_debug THEN
2705: hr_utility.trace('ABS:View Only');
2706: END IF;
2707:
2708: RETURN TRUE;
2709: END IF;