APPS.HXC_RPT_TC_AUDIT_TRAIL dependencies on HR_UTILITY

Line 4: g_debug BOOLEAN := hr_utility.debug_enabled;

1: PACKAGE BODY HXC_RPT_TC_AUDIT_TRAIL AS
2: /* $Header: hxcrptaudittrail.pkb 120.10.12010000.7 2010/02/16 16:56:01 asrajago ship $ */
3:
4: g_debug BOOLEAN := hr_utility.debug_enabled;
5:
6: newline VARCHAR2(1) :=
7: '
8: ';

Line 94: hr_utility.trace('translate_parameters');

90:
91:
92: IF g_debug
93: THEN
94: hr_utility.trace('translate_parameters');
95: END IF;
96:
97: lp_from_date := to_char(fnd_date.canonical_to_date(p_from_date),'dd-MON-yyyy');
98: lp_to_date := to_char(fnd_date.canonical_to_date(p_to_date),'dd-MON-yyyy');

Line 184: hr_utility.trace('Translated parameters normally ');

180:
181:
182: IF g_debug
183: THEN
184: hr_utility.trace('Translated parameters normally ');
185: hr_utility.trace('lp_from_date : '||lp_from_date);
186: hr_utility.trace('lp_to_date : '||lp_to_date);
187: hr_utility.trace('lp_dat_regen : '||lp_dat_regen);
188: hr_utility.trace('lp_record_save : '||lp_record_save);

Line 185: hr_utility.trace('lp_from_date : '||lp_from_date);

181:
182: IF g_debug
183: THEN
184: hr_utility.trace('Translated parameters normally ');
185: hr_utility.trace('lp_from_date : '||lp_from_date);
186: hr_utility.trace('lp_to_date : '||lp_to_date);
187: hr_utility.trace('lp_dat_regen : '||lp_dat_regen);
188: hr_utility.trace('lp_record_save : '||lp_record_save);
189: hr_utility.trace('lp_org : '||lp_org);

Line 186: hr_utility.trace('lp_to_date : '||lp_to_date);

182: IF g_debug
183: THEN
184: hr_utility.trace('Translated parameters normally ');
185: hr_utility.trace('lp_from_date : '||lp_from_date);
186: hr_utility.trace('lp_to_date : '||lp_to_date);
187: hr_utility.trace('lp_dat_regen : '||lp_dat_regen);
188: hr_utility.trace('lp_record_save : '||lp_record_save);
189: hr_utility.trace('lp_org : '||lp_org);
190: hr_utility.trace('lp_location : '||lp_location);

Line 187: hr_utility.trace('lp_dat_regen : '||lp_dat_regen);

183: THEN
184: hr_utility.trace('Translated parameters normally ');
185: hr_utility.trace('lp_from_date : '||lp_from_date);
186: hr_utility.trace('lp_to_date : '||lp_to_date);
187: hr_utility.trace('lp_dat_regen : '||lp_dat_regen);
188: hr_utility.trace('lp_record_save : '||lp_record_save);
189: hr_utility.trace('lp_org : '||lp_org);
190: hr_utility.trace('lp_location : '||lp_location);
191: hr_utility.trace('lp_payroll : '||lp_payroll);

Line 188: hr_utility.trace('lp_record_save : '||lp_record_save);

184: hr_utility.trace('Translated parameters normally ');
185: hr_utility.trace('lp_from_date : '||lp_from_date);
186: hr_utility.trace('lp_to_date : '||lp_to_date);
187: hr_utility.trace('lp_dat_regen : '||lp_dat_regen);
188: hr_utility.trace('lp_record_save : '||lp_record_save);
189: hr_utility.trace('lp_org : '||lp_org);
190: hr_utility.trace('lp_location : '||lp_location);
191: hr_utility.trace('lp_payroll : '||lp_payroll);
192: hr_utility.trace('lp_supervisor : '||lp_supervisor);

Line 189: hr_utility.trace('lp_org : '||lp_org);

185: hr_utility.trace('lp_from_date : '||lp_from_date);
186: hr_utility.trace('lp_to_date : '||lp_to_date);
187: hr_utility.trace('lp_dat_regen : '||lp_dat_regen);
188: hr_utility.trace('lp_record_save : '||lp_record_save);
189: hr_utility.trace('lp_org : '||lp_org);
190: hr_utility.trace('lp_location : '||lp_location);
191: hr_utility.trace('lp_payroll : '||lp_payroll);
192: hr_utility.trace('lp_supervisor : '||lp_supervisor);
193: hr_utility.trace('lp_person : '||lp_person);

Line 190: hr_utility.trace('lp_location : '||lp_location);

186: hr_utility.trace('lp_to_date : '||lp_to_date);
187: hr_utility.trace('lp_dat_regen : '||lp_dat_regen);
188: hr_utility.trace('lp_record_save : '||lp_record_save);
189: hr_utility.trace('lp_org : '||lp_org);
190: hr_utility.trace('lp_location : '||lp_location);
191: hr_utility.trace('lp_payroll : '||lp_payroll);
192: hr_utility.trace('lp_supervisor : '||lp_supervisor);
193: hr_utility.trace('lp_person : '||lp_person);
194: hr_utility.trace('lp_user : '||lp_user);

Line 191: hr_utility.trace('lp_payroll : '||lp_payroll);

187: hr_utility.trace('lp_dat_regen : '||lp_dat_regen);
188: hr_utility.trace('lp_record_save : '||lp_record_save);
189: hr_utility.trace('lp_org : '||lp_org);
190: hr_utility.trace('lp_location : '||lp_location);
191: hr_utility.trace('lp_payroll : '||lp_payroll);
192: hr_utility.trace('lp_supervisor : '||lp_supervisor);
193: hr_utility.trace('lp_person : '||lp_person);
194: hr_utility.trace('lp_user : '||lp_user);
195: END IF;

Line 192: hr_utility.trace('lp_supervisor : '||lp_supervisor);

188: hr_utility.trace('lp_record_save : '||lp_record_save);
189: hr_utility.trace('lp_org : '||lp_org);
190: hr_utility.trace('lp_location : '||lp_location);
191: hr_utility.trace('lp_payroll : '||lp_payroll);
192: hr_utility.trace('lp_supervisor : '||lp_supervisor);
193: hr_utility.trace('lp_person : '||lp_person);
194: hr_utility.trace('lp_user : '||lp_user);
195: END IF;
196:

Line 193: hr_utility.trace('lp_person : '||lp_person);

189: hr_utility.trace('lp_org : '||lp_org);
190: hr_utility.trace('lp_location : '||lp_location);
191: hr_utility.trace('lp_payroll : '||lp_payroll);
192: hr_utility.trace('lp_supervisor : '||lp_supervisor);
193: hr_utility.trace('lp_person : '||lp_person);
194: hr_utility.trace('lp_user : '||lp_user);
195: END IF;
196:
197: END translate_parameters;

Line 194: hr_utility.trace('lp_user : '||lp_user);

190: hr_utility.trace('lp_location : '||lp_location);
191: hr_utility.trace('lp_payroll : '||lp_payroll);
192: hr_utility.trace('lp_supervisor : '||lp_supervisor);
193: hr_utility.trace('lp_person : '||lp_person);
194: hr_utility.trace('lp_user : '||lp_user);
195: END IF;
196:
197: END translate_parameters;
198:

Line 532: hr_utility.trace('record_submissions for '||p_resource_id

528: -- Insert into HXC_RPT_TC_AUDIT, the picked up information.
529:
530: IF g_debug
531: THEN
532: hr_utility.trace('record_submissions for '||p_resource_id
533: ||' from '||p_start_time
534: ||' to '||p_stop_time);
535: END IF;
536:

Line 574: hr_utility.trace('Fetched from get_transactions ');

570: END IF;
571:
572: IF g_debug
573: THEN
574: hr_utility.trace('Fetched from get_transactions ');
575: hr_utility.trace('Total number of submissions : '||l_trans_id_tab.COUNT);
576: END IF;
577:
578:

Line 575: hr_utility.trace('Total number of submissions : '||l_trans_id_tab.COUNT);

571:
572: IF g_debug
573: THEN
574: hr_utility.trace('Fetched from get_transactions ');
575: hr_utility.trace('Total number of submissions : '||l_trans_id_tab.COUNT);
576: END IF;
577:
578:
579: IF l_trans_id_tab.COUNT > 0

Line 611: hr_utility.trace('record_submissions completed alright ');

607: END IF;
608:
609: IF g_debug
610: THEN
611: hr_utility.trace('record_submissions completed alright ');
612: END IF;
613:
614:
615: END record_submissions ;

Line 695: hr_utility.trace('record_approvals for '||p_resource_id

691: -- Once all the transactions are picked up, inserts the records into HXC_RPT_TC_AUDIT.
692:
693: IF g_debug
694: THEN
695: hr_utility.trace('record_approvals for '||p_resource_id
696: ||' from '||p_start_time
697: ||' to '||p_stop_time);
698: END IF;
699:

Line 717: hr_utility.trace('Fetched from get_approvals ');

713: CLOSE get_approvals;
714:
715: IF g_debug
716: THEN
717: hr_utility.trace('Fetched from get_approvals ');
718: hr_utility.trace('Total number of approvals : '||l_appr_trans_tab.COUNT);
719: END IF;
720:
721:

Line 718: hr_utility.trace('Total number of approvals : '||l_appr_trans_tab.COUNT);

714:
715: IF g_debug
716: THEN
717: hr_utility.trace('Fetched from get_approvals ');
718: hr_utility.trace('Total number of approvals : '||l_appr_trans_tab.COUNT);
719: END IF;
720:
721:
722: IF l_appr_trans_tab.COUNT > 0

Line 813: hr_utility.trace('record_approvals completed alright ');

809: END IF;
810:
811: IF g_debug
812: THEN
813: hr_utility.trace('record_approvals completed alright ');
814: END IF;
815:
816:
817:

Line 879: hr_utility.trace('record_deletions for '||p_resource_id

875: -- Insert these including the transaction_ids into HXC_RPT_TC_AUDIT.
876:
877: IF g_debug
878: THEN
879: hr_utility.trace('record_deletions for '||p_resource_id
880: ||' from '||p_start_time
881: ||' to '||p_stop_time);
882: END IF;
883:

Line 899: hr_utility.trace('Fetched from get_deletions ');

895: CLOSE get_deletions;
896:
897: IF g_debug
898: THEN
899: hr_utility.trace('Fetched from get_deletions ');
900: hr_utility.trace('Total number of deletions : '||l_del_id_tab.COUNT);
901: END IF;
902:
903:

Line 900: hr_utility.trace('Total number of deletions : '||l_del_id_tab.COUNT);

896:
897: IF g_debug
898: THEN
899: hr_utility.trace('Fetched from get_deletions ');
900: hr_utility.trace('Total number of deletions : '||l_del_id_tab.COUNT);
901: END IF;
902:
903:
904: IF l_del_id_tab.COUNT > 0

Line 972: hr_utility.trace('record_deletions completed alright ');

968: END IF;
969:
970: IF g_debug
971: THEN
972: hr_utility.trace('record_deletions completed alright ');
973: END IF;
974:
975:
976: END record_deletions ;

Line 1152: hr_utility.trace('Inserting details into hxc_rpt_tc_audit ');

1148: -- HXC_RPT_TC_AUDIT.
1149:
1150: IF g_debug
1151: THEN
1152: hr_utility.trace('Inserting details into hxc_rpt_tc_audit ');
1153:
1154: -- Commenting the below code, which logs all the detail info to be
1155: -- recorded into HXC_RPT_TC_AUDIT. Not too much hit to performance,
1156: -- but uncomment and run only if you see that there is an issue in the way

Line 1162: -- hr_utility.trace('Record No.'||i);

1158: -- of lines to your log files, nothing more.
1159:
1160: -- FOR i IN l_audit_details.FIRST..l_audit_details.LAST
1161: -- LOOP
1162: -- hr_utility.trace('Record No.'||i);
1163: -- hr_utility.trace('time_entry_date : '||l_audit_details(i).time_entry_date);
1164: -- hr_utility.trace('attribute_info : '||l_audit_details(i).attribute_info);
1165: -- hr_utility.trace('hours : '||l_audit_details(i).hours);
1166: -- hr_utility.trace('action : '||l_audit_details(i).action);

Line 1163: -- hr_utility.trace('time_entry_date : '||l_audit_details(i).time_entry_date);

1159:
1160: -- FOR i IN l_audit_details.FIRST..l_audit_details.LAST
1161: -- LOOP
1162: -- hr_utility.trace('Record No.'||i);
1163: -- hr_utility.trace('time_entry_date : '||l_audit_details(i).time_entry_date);
1164: -- hr_utility.trace('attribute_info : '||l_audit_details(i).attribute_info);
1165: -- hr_utility.trace('hours : '||l_audit_details(i).hours);
1166: -- hr_utility.trace('action : '||l_audit_details(i).action);
1167: -- hr_utility.trace('action_date : '||l_audit_details(i).action_date);

Line 1164: -- hr_utility.trace('attribute_info : '||l_audit_details(i).attribute_info);

1160: -- FOR i IN l_audit_details.FIRST..l_audit_details.LAST
1161: -- LOOP
1162: -- hr_utility.trace('Record No.'||i);
1163: -- hr_utility.trace('time_entry_date : '||l_audit_details(i).time_entry_date);
1164: -- hr_utility.trace('attribute_info : '||l_audit_details(i).attribute_info);
1165: -- hr_utility.trace('hours : '||l_audit_details(i).hours);
1166: -- hr_utility.trace('action : '||l_audit_details(i).action);
1167: -- hr_utility.trace('action_date : '||l_audit_details(i).action_date);
1168: -- hr_utility.trace('action_by : '||l_audit_details(i).action_by);

Line 1165: -- hr_utility.trace('hours : '||l_audit_details(i).hours);

1161: -- LOOP
1162: -- hr_utility.trace('Record No.'||i);
1163: -- hr_utility.trace('time_entry_date : '||l_audit_details(i).time_entry_date);
1164: -- hr_utility.trace('attribute_info : '||l_audit_details(i).attribute_info);
1165: -- hr_utility.trace('hours : '||l_audit_details(i).hours);
1166: -- hr_utility.trace('action : '||l_audit_details(i).action);
1167: -- hr_utility.trace('action_date : '||l_audit_details(i).action_date);
1168: -- hr_utility.trace('action_by : '||l_audit_details(i).action_by);
1169: -- hr_utility.trace('comments : '||l_audit_details(i).comments);

Line 1166: -- hr_utility.trace('action : '||l_audit_details(i).action);

1162: -- hr_utility.trace('Record No.'||i);
1163: -- hr_utility.trace('time_entry_date : '||l_audit_details(i).time_entry_date);
1164: -- hr_utility.trace('attribute_info : '||l_audit_details(i).attribute_info);
1165: -- hr_utility.trace('hours : '||l_audit_details(i).hours);
1166: -- hr_utility.trace('action : '||l_audit_details(i).action);
1167: -- hr_utility.trace('action_date : '||l_audit_details(i).action_date);
1168: -- hr_utility.trace('action_by : '||l_audit_details(i).action_by);
1169: -- hr_utility.trace('comments : '||l_audit_details(i).comments);
1170: -- hr_utility.trace('reasons : '||l_audit_details(i).reasons);

Line 1167: -- hr_utility.trace('action_date : '||l_audit_details(i).action_date);

1163: -- hr_utility.trace('time_entry_date : '||l_audit_details(i).time_entry_date);
1164: -- hr_utility.trace('attribute_info : '||l_audit_details(i).attribute_info);
1165: -- hr_utility.trace('hours : '||l_audit_details(i).hours);
1166: -- hr_utility.trace('action : '||l_audit_details(i).action);
1167: -- hr_utility.trace('action_date : '||l_audit_details(i).action_date);
1168: -- hr_utility.trace('action_by : '||l_audit_details(i).action_by);
1169: -- hr_utility.trace('comments : '||l_audit_details(i).comments);
1170: -- hr_utility.trace('reasons : '||l_audit_details(i).reasons);
1171: -- hr_utility.trace('transaction_id : '||l_audit_details(i).transaction_id);

Line 1168: -- hr_utility.trace('action_by : '||l_audit_details(i).action_by);

1164: -- hr_utility.trace('attribute_info : '||l_audit_details(i).attribute_info);
1165: -- hr_utility.trace('hours : '||l_audit_details(i).hours);
1166: -- hr_utility.trace('action : '||l_audit_details(i).action);
1167: -- hr_utility.trace('action_date : '||l_audit_details(i).action_date);
1168: -- hr_utility.trace('action_by : '||l_audit_details(i).action_by);
1169: -- hr_utility.trace('comments : '||l_audit_details(i).comments);
1170: -- hr_utility.trace('reasons : '||l_audit_details(i).reasons);
1171: -- hr_utility.trace('transaction_id : '||l_audit_details(i).transaction_id);
1172: -- hr_utility.trace('detail_bb_id : '||l_audit_details(i).detail_bb_id);

Line 1169: -- hr_utility.trace('comments : '||l_audit_details(i).comments);

1165: -- hr_utility.trace('hours : '||l_audit_details(i).hours);
1166: -- hr_utility.trace('action : '||l_audit_details(i).action);
1167: -- hr_utility.trace('action_date : '||l_audit_details(i).action_date);
1168: -- hr_utility.trace('action_by : '||l_audit_details(i).action_by);
1169: -- hr_utility.trace('comments : '||l_audit_details(i).comments);
1170: -- hr_utility.trace('reasons : '||l_audit_details(i).reasons);
1171: -- hr_utility.trace('transaction_id : '||l_audit_details(i).transaction_id);
1172: -- hr_utility.trace('detail_bb_id : '||l_audit_details(i).detail_bb_id);
1173: -- hr_utility.trace('detail_bb_ovn : '||l_audit_details(i).detail_bb_ovn);

Line 1170: -- hr_utility.trace('reasons : '||l_audit_details(i).reasons);

1166: -- hr_utility.trace('action : '||l_audit_details(i).action);
1167: -- hr_utility.trace('action_date : '||l_audit_details(i).action_date);
1168: -- hr_utility.trace('action_by : '||l_audit_details(i).action_by);
1169: -- hr_utility.trace('comments : '||l_audit_details(i).comments);
1170: -- hr_utility.trace('reasons : '||l_audit_details(i).reasons);
1171: -- hr_utility.trace('transaction_id : '||l_audit_details(i).transaction_id);
1172: -- hr_utility.trace('detail_bb_id : '||l_audit_details(i).detail_bb_id);
1173: -- hr_utility.trace('detail_bb_ovn : '||l_audit_details(i).detail_bb_ovn);
1174: -- hr_utility.trace('tc_bb_id : '||l_audit_details(i).tc_bb_id);

Line 1171: -- hr_utility.trace('transaction_id : '||l_audit_details(i).transaction_id);

1167: -- hr_utility.trace('action_date : '||l_audit_details(i).action_date);
1168: -- hr_utility.trace('action_by : '||l_audit_details(i).action_by);
1169: -- hr_utility.trace('comments : '||l_audit_details(i).comments);
1170: -- hr_utility.trace('reasons : '||l_audit_details(i).reasons);
1171: -- hr_utility.trace('transaction_id : '||l_audit_details(i).transaction_id);
1172: -- hr_utility.trace('detail_bb_id : '||l_audit_details(i).detail_bb_id);
1173: -- hr_utility.trace('detail_bb_ovn : '||l_audit_details(i).detail_bb_ovn);
1174: -- hr_utility.trace('tc_bb_id : '||l_audit_details(i).tc_bb_id);
1175: -- hr_utility.trace('tc_bb_ovn : '||l_audit_details(i).tc_bb_ovn);

Line 1172: -- hr_utility.trace('detail_bb_id : '||l_audit_details(i).detail_bb_id);

1168: -- hr_utility.trace('action_by : '||l_audit_details(i).action_by);
1169: -- hr_utility.trace('comments : '||l_audit_details(i).comments);
1170: -- hr_utility.trace('reasons : '||l_audit_details(i).reasons);
1171: -- hr_utility.trace('transaction_id : '||l_audit_details(i).transaction_id);
1172: -- hr_utility.trace('detail_bb_id : '||l_audit_details(i).detail_bb_id);
1173: -- hr_utility.trace('detail_bb_ovn : '||l_audit_details(i).detail_bb_ovn);
1174: -- hr_utility.trace('tc_bb_id : '||l_audit_details(i).tc_bb_id);
1175: -- hr_utility.trace('tc_bb_ovn : '||l_audit_details(i).tc_bb_ovn);
1176: -- hr_utility.trace('action_type : '||l_audit_details(i).action_type);

Line 1173: -- hr_utility.trace('detail_bb_ovn : '||l_audit_details(i).detail_bb_ovn);

1169: -- hr_utility.trace('comments : '||l_audit_details(i).comments);
1170: -- hr_utility.trace('reasons : '||l_audit_details(i).reasons);
1171: -- hr_utility.trace('transaction_id : '||l_audit_details(i).transaction_id);
1172: -- hr_utility.trace('detail_bb_id : '||l_audit_details(i).detail_bb_id);
1173: -- hr_utility.trace('detail_bb_ovn : '||l_audit_details(i).detail_bb_ovn);
1174: -- hr_utility.trace('tc_bb_id : '||l_audit_details(i).tc_bb_id);
1175: -- hr_utility.trace('tc_bb_ovn : '||l_audit_details(i).tc_bb_ovn);
1176: -- hr_utility.trace('action_type : '||l_audit_details(i).action_type);
1177: -- hr_utility.trace('resource_id : '||l_audit_details(i).resource_id);

Line 1174: -- hr_utility.trace('tc_bb_id : '||l_audit_details(i).tc_bb_id);

1170: -- hr_utility.trace('reasons : '||l_audit_details(i).reasons);
1171: -- hr_utility.trace('transaction_id : '||l_audit_details(i).transaction_id);
1172: -- hr_utility.trace('detail_bb_id : '||l_audit_details(i).detail_bb_id);
1173: -- hr_utility.trace('detail_bb_ovn : '||l_audit_details(i).detail_bb_ovn);
1174: -- hr_utility.trace('tc_bb_id : '||l_audit_details(i).tc_bb_id);
1175: -- hr_utility.trace('tc_bb_ovn : '||l_audit_details(i).tc_bb_ovn);
1176: -- hr_utility.trace('action_type : '||l_audit_details(i).action_type);
1177: -- hr_utility.trace('resource_id : '||l_audit_details(i).resource_id);
1178: -- hr_utility.trace('tc_start_time : '||l_audit_details(i).tc_start_time);

Line 1175: -- hr_utility.trace('tc_bb_ovn : '||l_audit_details(i).tc_bb_ovn);

1171: -- hr_utility.trace('transaction_id : '||l_audit_details(i).transaction_id);
1172: -- hr_utility.trace('detail_bb_id : '||l_audit_details(i).detail_bb_id);
1173: -- hr_utility.trace('detail_bb_ovn : '||l_audit_details(i).detail_bb_ovn);
1174: -- hr_utility.trace('tc_bb_id : '||l_audit_details(i).tc_bb_id);
1175: -- hr_utility.trace('tc_bb_ovn : '||l_audit_details(i).tc_bb_ovn);
1176: -- hr_utility.trace('action_type : '||l_audit_details(i).action_type);
1177: -- hr_utility.trace('resource_id : '||l_audit_details(i).resource_id);
1178: -- hr_utility.trace('tc_start_time : '||l_audit_details(i).tc_start_time);
1179: -- hr_utility.trace('tc_stop_time : '||l_audit_details(i).tc_stop_time);

Line 1176: -- hr_utility.trace('action_type : '||l_audit_details(i).action_type);

1172: -- hr_utility.trace('detail_bb_id : '||l_audit_details(i).detail_bb_id);
1173: -- hr_utility.trace('detail_bb_ovn : '||l_audit_details(i).detail_bb_ovn);
1174: -- hr_utility.trace('tc_bb_id : '||l_audit_details(i).tc_bb_id);
1175: -- hr_utility.trace('tc_bb_ovn : '||l_audit_details(i).tc_bb_ovn);
1176: -- hr_utility.trace('action_type : '||l_audit_details(i).action_type);
1177: -- hr_utility.trace('resource_id : '||l_audit_details(i).resource_id);
1178: -- hr_utility.trace('tc_start_time : '||l_audit_details(i).tc_start_time);
1179: -- hr_utility.trace('tc_stop_time : '||l_audit_details(i).tc_stop_time);
1180: -- hr_utility.trace('action_by_person : '||l_audit_details(i).action_by_person);

Line 1177: -- hr_utility.trace('resource_id : '||l_audit_details(i).resource_id);

1173: -- hr_utility.trace('detail_bb_ovn : '||l_audit_details(i).detail_bb_ovn);
1174: -- hr_utility.trace('tc_bb_id : '||l_audit_details(i).tc_bb_id);
1175: -- hr_utility.trace('tc_bb_ovn : '||l_audit_details(i).tc_bb_ovn);
1176: -- hr_utility.trace('action_type : '||l_audit_details(i).action_type);
1177: -- hr_utility.trace('resource_id : '||l_audit_details(i).resource_id);
1178: -- hr_utility.trace('tc_start_time : '||l_audit_details(i).tc_start_time);
1179: -- hr_utility.trace('tc_stop_time : '||l_audit_details(i).tc_stop_time);
1180: -- hr_utility.trace('action_by_person : '||l_audit_details(i).action_by_person);
1181: -- hr_utility.trace('cla_reason : '||l_audit_details(i).cla_reason);

Line 1178: -- hr_utility.trace('tc_start_time : '||l_audit_details(i).tc_start_time);

1174: -- hr_utility.trace('tc_bb_id : '||l_audit_details(i).tc_bb_id);
1175: -- hr_utility.trace('tc_bb_ovn : '||l_audit_details(i).tc_bb_ovn);
1176: -- hr_utility.trace('action_type : '||l_audit_details(i).action_type);
1177: -- hr_utility.trace('resource_id : '||l_audit_details(i).resource_id);
1178: -- hr_utility.trace('tc_start_time : '||l_audit_details(i).tc_start_time);
1179: -- hr_utility.trace('tc_stop_time : '||l_audit_details(i).tc_stop_time);
1180: -- hr_utility.trace('action_by_person : '||l_audit_details(i).action_by_person);
1181: -- hr_utility.trace('cla_reason : '||l_audit_details(i).cla_reason);
1182: -- hr_utility.trace('resource_name : '||l_audit_details(i).resource_name);

Line 1179: -- hr_utility.trace('tc_stop_time : '||l_audit_details(i).tc_stop_time);

1175: -- hr_utility.trace('tc_bb_ovn : '||l_audit_details(i).tc_bb_ovn);
1176: -- hr_utility.trace('action_type : '||l_audit_details(i).action_type);
1177: -- hr_utility.trace('resource_id : '||l_audit_details(i).resource_id);
1178: -- hr_utility.trace('tc_start_time : '||l_audit_details(i).tc_start_time);
1179: -- hr_utility.trace('tc_stop_time : '||l_audit_details(i).tc_stop_time);
1180: -- hr_utility.trace('action_by_person : '||l_audit_details(i).action_by_person);
1181: -- hr_utility.trace('cla_reason : '||l_audit_details(i).cla_reason);
1182: -- hr_utility.trace('resource_name : '||l_audit_details(i).resource_name);
1183: -- END LOOP;

Line 1180: -- hr_utility.trace('action_by_person : '||l_audit_details(i).action_by_person);

1176: -- hr_utility.trace('action_type : '||l_audit_details(i).action_type);
1177: -- hr_utility.trace('resource_id : '||l_audit_details(i).resource_id);
1178: -- hr_utility.trace('tc_start_time : '||l_audit_details(i).tc_start_time);
1179: -- hr_utility.trace('tc_stop_time : '||l_audit_details(i).tc_stop_time);
1180: -- hr_utility.trace('action_by_person : '||l_audit_details(i).action_by_person);
1181: -- hr_utility.trace('cla_reason : '||l_audit_details(i).cla_reason);
1182: -- hr_utility.trace('resource_name : '||l_audit_details(i).resource_name);
1183: -- END LOOP;
1184:

Line 1181: -- hr_utility.trace('cla_reason : '||l_audit_details(i).cla_reason);

1177: -- hr_utility.trace('resource_id : '||l_audit_details(i).resource_id);
1178: -- hr_utility.trace('tc_start_time : '||l_audit_details(i).tc_start_time);
1179: -- hr_utility.trace('tc_stop_time : '||l_audit_details(i).tc_stop_time);
1180: -- hr_utility.trace('action_by_person : '||l_audit_details(i).action_by_person);
1181: -- hr_utility.trace('cla_reason : '||l_audit_details(i).cla_reason);
1182: -- hr_utility.trace('resource_name : '||l_audit_details(i).resource_name);
1183: -- END LOOP;
1184:
1185: END IF;

Line 1182: -- hr_utility.trace('resource_name : '||l_audit_details(i).resource_name);

1178: -- hr_utility.trace('tc_start_time : '||l_audit_details(i).tc_start_time);
1179: -- hr_utility.trace('tc_stop_time : '||l_audit_details(i).tc_stop_time);
1180: -- hr_utility.trace('action_by_person : '||l_audit_details(i).action_by_person);
1181: -- hr_utility.trace('cla_reason : '||l_audit_details(i).cla_reason);
1182: -- hr_utility.trace('resource_name : '||l_audit_details(i).resource_name);
1183: -- END LOOP;
1184:
1185: END IF;
1186:

Line 1250: hr_utility.trace('Fetched details ');

1246: END IF;
1247:
1248: IF g_debug
1249: THEN
1250: hr_utility.trace('Fetched details ');
1251: hr_utility.trace('Total Number of details fetched : '||l_tc_details.COUNT);
1252: END IF;
1253:
1254:

Line 1251: hr_utility.trace('Total Number of details fetched : '||l_tc_details.COUNT);

1247:
1248: IF g_debug
1249: THEN
1250: hr_utility.trace('Fetched details ');
1251: hr_utility.trace('Total Number of details fetched : '||l_tc_details.COUNT);
1252: END IF;
1253:
1254:
1255: IF l_tc_details.COUNT > 0

Line 1451: hr_utility.trace('execute_audit_trail_reporting');

1447:
1448:
1449: IF g_debug
1450: THEN
1451: hr_utility.trace('execute_audit_trail_reporting');
1452: hr_utility.trace('Parameters ');
1453: hr_utility.trace('===========');
1454: hr_utility.trace('p_date_from '||p_date_from);
1455: hr_utility.trace('p_date_to '||p_date_to);

Line 1452: hr_utility.trace('Parameters ');

1448:
1449: IF g_debug
1450: THEN
1451: hr_utility.trace('execute_audit_trail_reporting');
1452: hr_utility.trace('Parameters ');
1453: hr_utility.trace('===========');
1454: hr_utility.trace('p_date_from '||p_date_from);
1455: hr_utility.trace('p_date_to '||p_date_to);
1456: hr_utility.trace('p_data_regen '||p_data_regen);

Line 1453: hr_utility.trace('===========');

1449: IF g_debug
1450: THEN
1451: hr_utility.trace('execute_audit_trail_reporting');
1452: hr_utility.trace('Parameters ');
1453: hr_utility.trace('===========');
1454: hr_utility.trace('p_date_from '||p_date_from);
1455: hr_utility.trace('p_date_to '||p_date_to);
1456: hr_utility.trace('p_data_regen '||p_data_regen);
1457: hr_utility.trace('p_record_save '||p_record_save);

Line 1454: hr_utility.trace('p_date_from '||p_date_from);

1450: THEN
1451: hr_utility.trace('execute_audit_trail_reporting');
1452: hr_utility.trace('Parameters ');
1453: hr_utility.trace('===========');
1454: hr_utility.trace('p_date_from '||p_date_from);
1455: hr_utility.trace('p_date_to '||p_date_to);
1456: hr_utility.trace('p_data_regen '||p_data_regen);
1457: hr_utility.trace('p_record_save '||p_record_save);
1458: hr_utility.trace('p_org_id '||p_org_id);

Line 1455: hr_utility.trace('p_date_to '||p_date_to);

1451: hr_utility.trace('execute_audit_trail_reporting');
1452: hr_utility.trace('Parameters ');
1453: hr_utility.trace('===========');
1454: hr_utility.trace('p_date_from '||p_date_from);
1455: hr_utility.trace('p_date_to '||p_date_to);
1456: hr_utility.trace('p_data_regen '||p_data_regen);
1457: hr_utility.trace('p_record_save '||p_record_save);
1458: hr_utility.trace('p_org_id '||p_org_id);
1459: hr_utility.trace('p_locn_id '||p_locn_id);

Line 1456: hr_utility.trace('p_data_regen '||p_data_regen);

1452: hr_utility.trace('Parameters ');
1453: hr_utility.trace('===========');
1454: hr_utility.trace('p_date_from '||p_date_from);
1455: hr_utility.trace('p_date_to '||p_date_to);
1456: hr_utility.trace('p_data_regen '||p_data_regen);
1457: hr_utility.trace('p_record_save '||p_record_save);
1458: hr_utility.trace('p_org_id '||p_org_id);
1459: hr_utility.trace('p_locn_id '||p_locn_id);
1460: hr_utility.trace('p_payroll_id '||p_payroll_id);

Line 1457: hr_utility.trace('p_record_save '||p_record_save);

1453: hr_utility.trace('===========');
1454: hr_utility.trace('p_date_from '||p_date_from);
1455: hr_utility.trace('p_date_to '||p_date_to);
1456: hr_utility.trace('p_data_regen '||p_data_regen);
1457: hr_utility.trace('p_record_save '||p_record_save);
1458: hr_utility.trace('p_org_id '||p_org_id);
1459: hr_utility.trace('p_locn_id '||p_locn_id);
1460: hr_utility.trace('p_payroll_id '||p_payroll_id);
1461: hr_utility.trace('p_supervisor_id '||p_supervisor_id);

Line 1458: hr_utility.trace('p_org_id '||p_org_id);

1454: hr_utility.trace('p_date_from '||p_date_from);
1455: hr_utility.trace('p_date_to '||p_date_to);
1456: hr_utility.trace('p_data_regen '||p_data_regen);
1457: hr_utility.trace('p_record_save '||p_record_save);
1458: hr_utility.trace('p_org_id '||p_org_id);
1459: hr_utility.trace('p_locn_id '||p_locn_id);
1460: hr_utility.trace('p_payroll_id '||p_payroll_id);
1461: hr_utility.trace('p_supervisor_id '||p_supervisor_id);
1462: hr_utility.trace('p_person_id '||p_person_id);

Line 1459: hr_utility.trace('p_locn_id '||p_locn_id);

1455: hr_utility.trace('p_date_to '||p_date_to);
1456: hr_utility.trace('p_data_regen '||p_data_regen);
1457: hr_utility.trace('p_record_save '||p_record_save);
1458: hr_utility.trace('p_org_id '||p_org_id);
1459: hr_utility.trace('p_locn_id '||p_locn_id);
1460: hr_utility.trace('p_payroll_id '||p_payroll_id);
1461: hr_utility.trace('p_supervisor_id '||p_supervisor_id);
1462: hr_utility.trace('p_person_id '||p_person_id);
1463: END IF;

Line 1460: hr_utility.trace('p_payroll_id '||p_payroll_id);

1456: hr_utility.trace('p_data_regen '||p_data_regen);
1457: hr_utility.trace('p_record_save '||p_record_save);
1458: hr_utility.trace('p_org_id '||p_org_id);
1459: hr_utility.trace('p_locn_id '||p_locn_id);
1460: hr_utility.trace('p_payroll_id '||p_payroll_id);
1461: hr_utility.trace('p_supervisor_id '||p_supervisor_id);
1462: hr_utility.trace('p_person_id '||p_person_id);
1463: END IF;
1464:

Line 1461: hr_utility.trace('p_supervisor_id '||p_supervisor_id);

1457: hr_utility.trace('p_record_save '||p_record_save);
1458: hr_utility.trace('p_org_id '||p_org_id);
1459: hr_utility.trace('p_locn_id '||p_locn_id);
1460: hr_utility.trace('p_payroll_id '||p_payroll_id);
1461: hr_utility.trace('p_supervisor_id '||p_supervisor_id);
1462: hr_utility.trace('p_person_id '||p_person_id);
1463: END IF;
1464:
1465:

Line 1462: hr_utility.trace('p_person_id '||p_person_id);

1458: hr_utility.trace('p_org_id '||p_org_id);
1459: hr_utility.trace('p_locn_id '||p_locn_id);
1460: hr_utility.trace('p_payroll_id '||p_payroll_id);
1461: hr_utility.trace('p_supervisor_id '||p_supervisor_id);
1462: hr_utility.trace('p_person_id '||p_person_id);
1463: END IF;
1464:
1465:
1466: -- Calling Load timecard snapshot passing the required parameters.

Line 1485: hr_utility.trace('There was an error in submitting Load Timecard Snapshot ');

1481: COMMIT;
1482:
1483: IF l_data_load_request_id = 0
1484: THEN
1485: hr_utility.trace('There was an error in submitting Load Timecard Snapshot ');
1486: hr_utility.trace('Sql Error : '||SQLCODE);
1487: END IF;
1488:
1489:

Line 1486: hr_utility.trace('Sql Error : '||SQLCODE);

1482:
1483: IF l_data_load_request_id = 0
1484: THEN
1485: hr_utility.trace('There was an error in submitting Load Timecard Snapshot ');
1486: hr_utility.trace('Sql Error : '||SQLCODE);
1487: END IF;
1488:
1489:
1490: -- Translate_parameters is to translate the given parameters to the process

Line 1499: hr_utility.trace('Request went to wait at '||to_char(sysdate,'dd-MON-yyyy HH:MI:SS'));

1495: translate_parameters;
1496:
1497: IF g_debug
1498: THEN
1499: hr_utility.trace('Request went to wait at '||to_char(sysdate,'dd-MON-yyyy HH:MI:SS'));
1500: END IF;
1501:
1502: l_call_status := FND_CONCURRENT.WAIT_FOR_REQUEST( request_id => l_data_load_request_id,
1503: interval => l_interval,

Line 1513: hr_utility.trace('Request stopped at '||to_char(sysdate,'dd-MON-yyyy HH:MI:SS'));

1509: message => l_message );
1510:
1511: IF g_debug
1512: THEN
1513: hr_utility.trace('Request stopped at '||to_char(sysdate,'dd-MON-yyyy HH:MI:SS'));
1514: END IF;
1515:
1516: IF l_call_status = FALSE
1517: THEN

Line 1520: hr_utility.trace('There was an error in executing Load Timecard Snapshot ');

1516: IF l_call_status = FALSE
1517: THEN
1518: IF g_debug
1519: THEN
1520: hr_utility.trace('There was an error in executing Load Timecard Snapshot ');
1521: hr_utility.trace('Sql Error : '||SQLCODE);
1522: END IF;
1523: END IF;
1524:

Line 1521: hr_utility.trace('Sql Error : '||SQLCODE);

1517: THEN
1518: IF g_debug
1519: THEN
1520: hr_utility.trace('There was an error in executing Load Timecard Snapshot ');
1521: hr_utility.trace('Sql Error : '||SQLCODE);
1522: END IF;
1523: END IF;
1524:
1525: -- Just in case the previous run crashed, clear the reporting table before you

Line 1539: hr_utility.trace('Fetched from get_timecards ');

1535: EXIT WHEN get_timecards%NOTFOUND;
1536:
1537: IF g_debug
1538: THEN
1539: hr_utility.trace('Fetched from get_timecards ');
1540: hr_utility.trace('Resource id : '||l_resource_id);
1541: hr_utility.trace('TC start time : '||l_start_time);
1542: hr_utility.trace('TC stop time : '||l_stop_time);
1543: END IF;

Line 1540: hr_utility.trace('Resource id : '||l_resource_id);

1536:
1537: IF g_debug
1538: THEN
1539: hr_utility.trace('Fetched from get_timecards ');
1540: hr_utility.trace('Resource id : '||l_resource_id);
1541: hr_utility.trace('TC start time : '||l_start_time);
1542: hr_utility.trace('TC stop time : '||l_stop_time);
1543: END IF;
1544:

Line 1541: hr_utility.trace('TC start time : '||l_start_time);

1537: IF g_debug
1538: THEN
1539: hr_utility.trace('Fetched from get_timecards ');
1540: hr_utility.trace('Resource id : '||l_resource_id);
1541: hr_utility.trace('TC start time : '||l_start_time);
1542: hr_utility.trace('TC stop time : '||l_stop_time);
1543: END IF;
1544:
1545: IF l_resource_count = 100

Line 1542: hr_utility.trace('TC stop time : '||l_stop_time);

1538: THEN
1539: hr_utility.trace('Fetched from get_timecards ');
1540: hr_utility.trace('Resource id : '||l_resource_id);
1541: hr_utility.trace('TC start time : '||l_start_time);
1542: hr_utility.trace('TC stop time : '||l_stop_time);
1543: END IF;
1544:
1545: IF l_resource_count = 100
1546: THEN

Line 1577: hr_utility.trace('Error stack ');

1573: l_stop_time,
1574: p_record_save );
1575: EXCEPTION
1576: WHEN OTHERS THEN
1577: hr_utility.trace('Error stack ');
1578: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1579: hr_utility.trace(' Exception '||SQLERRM||' while processing the following timecard ');
1580: hr_utility.trace(' Resource_id '||l_resource_id);
1581: hr_utility.trace(' Start_time '||l_start_time);

Line 1578: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1574: p_record_save );
1575: EXCEPTION
1576: WHEN OTHERS THEN
1577: hr_utility.trace('Error stack ');
1578: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1579: hr_utility.trace(' Exception '||SQLERRM||' while processing the following timecard ');
1580: hr_utility.trace(' Resource_id '||l_resource_id);
1581: hr_utility.trace(' Start_time '||l_start_time);
1582: hr_utility.trace(' Stop_time '||l_stop_time);

Line 1579: hr_utility.trace(' Exception '||SQLERRM||' while processing the following timecard ');

1575: EXCEPTION
1576: WHEN OTHERS THEN
1577: hr_utility.trace('Error stack ');
1578: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1579: hr_utility.trace(' Exception '||SQLERRM||' while processing the following timecard ');
1580: hr_utility.trace(' Resource_id '||l_resource_id);
1581: hr_utility.trace(' Start_time '||l_start_time);
1582: hr_utility.trace(' Stop_time '||l_stop_time);
1583:

Line 1580: hr_utility.trace(' Resource_id '||l_resource_id);

1576: WHEN OTHERS THEN
1577: hr_utility.trace('Error stack ');
1578: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1579: hr_utility.trace(' Exception '||SQLERRM||' while processing the following timecard ');
1580: hr_utility.trace(' Resource_id '||l_resource_id);
1581: hr_utility.trace(' Start_time '||l_start_time);
1582: hr_utility.trace(' Stop_time '||l_stop_time);
1583:
1584: END;

Line 1581: hr_utility.trace(' Start_time '||l_start_time);

1577: hr_utility.trace('Error stack ');
1578: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1579: hr_utility.trace(' Exception '||SQLERRM||' while processing the following timecard ');
1580: hr_utility.trace(' Resource_id '||l_resource_id);
1581: hr_utility.trace(' Start_time '||l_start_time);
1582: hr_utility.trace(' Stop_time '||l_stop_time);
1583:
1584: END;
1585:

Line 1582: hr_utility.trace(' Stop_time '||l_stop_time);

1578: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1579: hr_utility.trace(' Exception '||SQLERRM||' while processing the following timecard ');
1580: hr_utility.trace(' Resource_id '||l_resource_id);
1581: hr_utility.trace(' Start_time '||l_start_time);
1582: hr_utility.trace(' Stop_time '||l_stop_time);
1583:
1584: END;
1585:
1586: END LOOP;

Line 1591: hr_utility.trace('Completed Audit Trail Reporting normally ');

1587: CLOSE get_timecards;
1588: COMMIT;
1589: IF g_debug
1590: THEN
1591: hr_utility.trace('Completed Audit Trail Reporting normally ');
1592: hr_utility.trace('Finished processing at '||TO_CHAR(SYSDATE,'dd-MON-yyyy HH:MI:SS'));
1593: END IF;
1594:
1595: EXCEPTION

Line 1592: hr_utility.trace('Finished processing at '||TO_CHAR(SYSDATE,'dd-MON-yyyy HH:MI:SS'));

1588: COMMIT;
1589: IF g_debug
1590: THEN
1591: hr_utility.trace('Completed Audit Trail Reporting normally ');
1592: hr_utility.trace('Finished processing at '||TO_CHAR(SYSDATE,'dd-MON-yyyy HH:MI:SS'));
1593: END IF;
1594:
1595: EXCEPTION
1596: WHEN NO_DATA_FOUND THEN

Line 1597: hr_utility.trace('No Data Found from execute_audit_trail_reporting ');

1593: END IF;
1594:
1595: EXCEPTION
1596: WHEN NO_DATA_FOUND THEN
1597: hr_utility.trace('No Data Found from execute_audit_trail_reporting ');
1598:
1599: END execute_audit_trail_reporting;
1600:
1601: