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.

[Home] [Help]

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.5 2009/01/03 11:04:28 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 804: hr_utility.trace('record_approvals completed alright ');

800: END IF;
801:
802: IF g_debug
803: THEN
804: hr_utility.trace('record_approvals completed alright ');
805: END IF;
806:
807:
808:

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

866: -- Insert these including the transaction_ids into HXC_RPT_TC_AUDIT.
867:
868: IF g_debug
869: THEN
870: hr_utility.trace('record_deletions for '||p_resource_id
871: ||' from '||p_start_time
872: ||' to '||p_stop_time);
873: END IF;
874:

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

886: CLOSE get_deletions;
887:
888: IF g_debug
889: THEN
890: hr_utility.trace('Fetched from get_deletions ');
891: hr_utility.trace('Total number of deletions : '||l_del_id_tab.COUNT);
892: END IF;
893:
894:

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

887:
888: IF g_debug
889: THEN
890: hr_utility.trace('Fetched from get_deletions ');
891: hr_utility.trace('Total number of deletions : '||l_del_id_tab.COUNT);
892: END IF;
893:
894:
895: IF l_del_id_tab.COUNT > 0

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

959: END IF;
960:
961: IF g_debug
962: THEN
963: hr_utility.trace('record_deletions completed alright ');
964: END IF;
965:
966:
967: END record_deletions ;

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

1139: -- HXC_RPT_TC_AUDIT.
1140:
1141: IF g_debug
1142: THEN
1143: hr_utility.trace('Inserting details into hxc_rpt_tc_audit ');
1144:
1145: -- Commenting the below code, which logs all the detail info to be
1146: -- recorded into HXC_RPT_TC_AUDIT. Not too much hit to performance,
1147: -- but uncomment and run only if you see that there is an issue in the way

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

1149: -- of lines to your log files, nothing more.
1150:
1151: -- FOR i IN l_audit_details.FIRST..l_audit_details.LAST
1152: -- LOOP
1153: -- hr_utility.trace('Record No.'||i);
1154: -- hr_utility.trace('time_entry_date : '||l_audit_details(i).time_entry_date);
1155: -- hr_utility.trace('attribute_info : '||l_audit_details(i).attribute_info);
1156: -- hr_utility.trace('hours : '||l_audit_details(i).hours);
1157: -- hr_utility.trace('action : '||l_audit_details(i).action);

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

1150:
1151: -- FOR i IN l_audit_details.FIRST..l_audit_details.LAST
1152: -- LOOP
1153: -- hr_utility.trace('Record No.'||i);
1154: -- hr_utility.trace('time_entry_date : '||l_audit_details(i).time_entry_date);
1155: -- hr_utility.trace('attribute_info : '||l_audit_details(i).attribute_info);
1156: -- hr_utility.trace('hours : '||l_audit_details(i).hours);
1157: -- hr_utility.trace('action : '||l_audit_details(i).action);
1158: -- hr_utility.trace('action_date : '||l_audit_details(i).action_date);

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

1151: -- FOR i IN l_audit_details.FIRST..l_audit_details.LAST
1152: -- LOOP
1153: -- hr_utility.trace('Record No.'||i);
1154: -- hr_utility.trace('time_entry_date : '||l_audit_details(i).time_entry_date);
1155: -- hr_utility.trace('attribute_info : '||l_audit_details(i).attribute_info);
1156: -- hr_utility.trace('hours : '||l_audit_details(i).hours);
1157: -- hr_utility.trace('action : '||l_audit_details(i).action);
1158: -- hr_utility.trace('action_date : '||l_audit_details(i).action_date);
1159: -- hr_utility.trace('action_by : '||l_audit_details(i).action_by);

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

1152: -- LOOP
1153: -- hr_utility.trace('Record No.'||i);
1154: -- hr_utility.trace('time_entry_date : '||l_audit_details(i).time_entry_date);
1155: -- hr_utility.trace('attribute_info : '||l_audit_details(i).attribute_info);
1156: -- hr_utility.trace('hours : '||l_audit_details(i).hours);
1157: -- hr_utility.trace('action : '||l_audit_details(i).action);
1158: -- hr_utility.trace('action_date : '||l_audit_details(i).action_date);
1159: -- hr_utility.trace('action_by : '||l_audit_details(i).action_by);
1160: -- hr_utility.trace('comments : '||l_audit_details(i).comments);

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

1153: -- hr_utility.trace('Record No.'||i);
1154: -- hr_utility.trace('time_entry_date : '||l_audit_details(i).time_entry_date);
1155: -- hr_utility.trace('attribute_info : '||l_audit_details(i).attribute_info);
1156: -- hr_utility.trace('hours : '||l_audit_details(i).hours);
1157: -- hr_utility.trace('action : '||l_audit_details(i).action);
1158: -- hr_utility.trace('action_date : '||l_audit_details(i).action_date);
1159: -- hr_utility.trace('action_by : '||l_audit_details(i).action_by);
1160: -- hr_utility.trace('comments : '||l_audit_details(i).comments);
1161: -- hr_utility.trace('reasons : '||l_audit_details(i).reasons);

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

1154: -- hr_utility.trace('time_entry_date : '||l_audit_details(i).time_entry_date);
1155: -- hr_utility.trace('attribute_info : '||l_audit_details(i).attribute_info);
1156: -- hr_utility.trace('hours : '||l_audit_details(i).hours);
1157: -- hr_utility.trace('action : '||l_audit_details(i).action);
1158: -- hr_utility.trace('action_date : '||l_audit_details(i).action_date);
1159: -- hr_utility.trace('action_by : '||l_audit_details(i).action_by);
1160: -- hr_utility.trace('comments : '||l_audit_details(i).comments);
1161: -- hr_utility.trace('reasons : '||l_audit_details(i).reasons);
1162: -- hr_utility.trace('transaction_id : '||l_audit_details(i).transaction_id);

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

1155: -- hr_utility.trace('attribute_info : '||l_audit_details(i).attribute_info);
1156: -- hr_utility.trace('hours : '||l_audit_details(i).hours);
1157: -- hr_utility.trace('action : '||l_audit_details(i).action);
1158: -- hr_utility.trace('action_date : '||l_audit_details(i).action_date);
1159: -- hr_utility.trace('action_by : '||l_audit_details(i).action_by);
1160: -- hr_utility.trace('comments : '||l_audit_details(i).comments);
1161: -- hr_utility.trace('reasons : '||l_audit_details(i).reasons);
1162: -- hr_utility.trace('transaction_id : '||l_audit_details(i).transaction_id);
1163: -- hr_utility.trace('detail_bb_id : '||l_audit_details(i).detail_bb_id);

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

1156: -- hr_utility.trace('hours : '||l_audit_details(i).hours);
1157: -- hr_utility.trace('action : '||l_audit_details(i).action);
1158: -- hr_utility.trace('action_date : '||l_audit_details(i).action_date);
1159: -- hr_utility.trace('action_by : '||l_audit_details(i).action_by);
1160: -- hr_utility.trace('comments : '||l_audit_details(i).comments);
1161: -- hr_utility.trace('reasons : '||l_audit_details(i).reasons);
1162: -- hr_utility.trace('transaction_id : '||l_audit_details(i).transaction_id);
1163: -- hr_utility.trace('detail_bb_id : '||l_audit_details(i).detail_bb_id);
1164: -- hr_utility.trace('detail_bb_ovn : '||l_audit_details(i).detail_bb_ovn);

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

1157: -- hr_utility.trace('action : '||l_audit_details(i).action);
1158: -- hr_utility.trace('action_date : '||l_audit_details(i).action_date);
1159: -- hr_utility.trace('action_by : '||l_audit_details(i).action_by);
1160: -- hr_utility.trace('comments : '||l_audit_details(i).comments);
1161: -- hr_utility.trace('reasons : '||l_audit_details(i).reasons);
1162: -- hr_utility.trace('transaction_id : '||l_audit_details(i).transaction_id);
1163: -- hr_utility.trace('detail_bb_id : '||l_audit_details(i).detail_bb_id);
1164: -- hr_utility.trace('detail_bb_ovn : '||l_audit_details(i).detail_bb_ovn);
1165: -- hr_utility.trace('tc_bb_id : '||l_audit_details(i).tc_bb_id);

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

1158: -- hr_utility.trace('action_date : '||l_audit_details(i).action_date);
1159: -- hr_utility.trace('action_by : '||l_audit_details(i).action_by);
1160: -- hr_utility.trace('comments : '||l_audit_details(i).comments);
1161: -- hr_utility.trace('reasons : '||l_audit_details(i).reasons);
1162: -- hr_utility.trace('transaction_id : '||l_audit_details(i).transaction_id);
1163: -- hr_utility.trace('detail_bb_id : '||l_audit_details(i).detail_bb_id);
1164: -- hr_utility.trace('detail_bb_ovn : '||l_audit_details(i).detail_bb_ovn);
1165: -- hr_utility.trace('tc_bb_id : '||l_audit_details(i).tc_bb_id);
1166: -- hr_utility.trace('tc_bb_ovn : '||l_audit_details(i).tc_bb_ovn);

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

1159: -- hr_utility.trace('action_by : '||l_audit_details(i).action_by);
1160: -- hr_utility.trace('comments : '||l_audit_details(i).comments);
1161: -- hr_utility.trace('reasons : '||l_audit_details(i).reasons);
1162: -- hr_utility.trace('transaction_id : '||l_audit_details(i).transaction_id);
1163: -- hr_utility.trace('detail_bb_id : '||l_audit_details(i).detail_bb_id);
1164: -- hr_utility.trace('detail_bb_ovn : '||l_audit_details(i).detail_bb_ovn);
1165: -- hr_utility.trace('tc_bb_id : '||l_audit_details(i).tc_bb_id);
1166: -- hr_utility.trace('tc_bb_ovn : '||l_audit_details(i).tc_bb_ovn);
1167: -- hr_utility.trace('action_type : '||l_audit_details(i).action_type);

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

1160: -- hr_utility.trace('comments : '||l_audit_details(i).comments);
1161: -- hr_utility.trace('reasons : '||l_audit_details(i).reasons);
1162: -- hr_utility.trace('transaction_id : '||l_audit_details(i).transaction_id);
1163: -- hr_utility.trace('detail_bb_id : '||l_audit_details(i).detail_bb_id);
1164: -- hr_utility.trace('detail_bb_ovn : '||l_audit_details(i).detail_bb_ovn);
1165: -- hr_utility.trace('tc_bb_id : '||l_audit_details(i).tc_bb_id);
1166: -- hr_utility.trace('tc_bb_ovn : '||l_audit_details(i).tc_bb_ovn);
1167: -- hr_utility.trace('action_type : '||l_audit_details(i).action_type);
1168: -- hr_utility.trace('resource_id : '||l_audit_details(i).resource_id);

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

1161: -- hr_utility.trace('reasons : '||l_audit_details(i).reasons);
1162: -- hr_utility.trace('transaction_id : '||l_audit_details(i).transaction_id);
1163: -- hr_utility.trace('detail_bb_id : '||l_audit_details(i).detail_bb_id);
1164: -- hr_utility.trace('detail_bb_ovn : '||l_audit_details(i).detail_bb_ovn);
1165: -- hr_utility.trace('tc_bb_id : '||l_audit_details(i).tc_bb_id);
1166: -- hr_utility.trace('tc_bb_ovn : '||l_audit_details(i).tc_bb_ovn);
1167: -- hr_utility.trace('action_type : '||l_audit_details(i).action_type);
1168: -- hr_utility.trace('resource_id : '||l_audit_details(i).resource_id);
1169: -- hr_utility.trace('tc_start_time : '||l_audit_details(i).tc_start_time);

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

1162: -- hr_utility.trace('transaction_id : '||l_audit_details(i).transaction_id);
1163: -- hr_utility.trace('detail_bb_id : '||l_audit_details(i).detail_bb_id);
1164: -- hr_utility.trace('detail_bb_ovn : '||l_audit_details(i).detail_bb_ovn);
1165: -- hr_utility.trace('tc_bb_id : '||l_audit_details(i).tc_bb_id);
1166: -- hr_utility.trace('tc_bb_ovn : '||l_audit_details(i).tc_bb_ovn);
1167: -- hr_utility.trace('action_type : '||l_audit_details(i).action_type);
1168: -- hr_utility.trace('resource_id : '||l_audit_details(i).resource_id);
1169: -- hr_utility.trace('tc_start_time : '||l_audit_details(i).tc_start_time);
1170: -- hr_utility.trace('tc_stop_time : '||l_audit_details(i).tc_stop_time);

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

1163: -- hr_utility.trace('detail_bb_id : '||l_audit_details(i).detail_bb_id);
1164: -- hr_utility.trace('detail_bb_ovn : '||l_audit_details(i).detail_bb_ovn);
1165: -- hr_utility.trace('tc_bb_id : '||l_audit_details(i).tc_bb_id);
1166: -- hr_utility.trace('tc_bb_ovn : '||l_audit_details(i).tc_bb_ovn);
1167: -- hr_utility.trace('action_type : '||l_audit_details(i).action_type);
1168: -- hr_utility.trace('resource_id : '||l_audit_details(i).resource_id);
1169: -- hr_utility.trace('tc_start_time : '||l_audit_details(i).tc_start_time);
1170: -- hr_utility.trace('tc_stop_time : '||l_audit_details(i).tc_stop_time);
1171: -- hr_utility.trace('action_by_person : '||l_audit_details(i).action_by_person);

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

1164: -- hr_utility.trace('detail_bb_ovn : '||l_audit_details(i).detail_bb_ovn);
1165: -- hr_utility.trace('tc_bb_id : '||l_audit_details(i).tc_bb_id);
1166: -- hr_utility.trace('tc_bb_ovn : '||l_audit_details(i).tc_bb_ovn);
1167: -- hr_utility.trace('action_type : '||l_audit_details(i).action_type);
1168: -- hr_utility.trace('resource_id : '||l_audit_details(i).resource_id);
1169: -- hr_utility.trace('tc_start_time : '||l_audit_details(i).tc_start_time);
1170: -- hr_utility.trace('tc_stop_time : '||l_audit_details(i).tc_stop_time);
1171: -- hr_utility.trace('action_by_person : '||l_audit_details(i).action_by_person);
1172: -- hr_utility.trace('cla_reason : '||l_audit_details(i).cla_reason);

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

1165: -- hr_utility.trace('tc_bb_id : '||l_audit_details(i).tc_bb_id);
1166: -- hr_utility.trace('tc_bb_ovn : '||l_audit_details(i).tc_bb_ovn);
1167: -- hr_utility.trace('action_type : '||l_audit_details(i).action_type);
1168: -- hr_utility.trace('resource_id : '||l_audit_details(i).resource_id);
1169: -- hr_utility.trace('tc_start_time : '||l_audit_details(i).tc_start_time);
1170: -- hr_utility.trace('tc_stop_time : '||l_audit_details(i).tc_stop_time);
1171: -- hr_utility.trace('action_by_person : '||l_audit_details(i).action_by_person);
1172: -- hr_utility.trace('cla_reason : '||l_audit_details(i).cla_reason);
1173: -- hr_utility.trace('resource_name : '||l_audit_details(i).resource_name);

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

1166: -- hr_utility.trace('tc_bb_ovn : '||l_audit_details(i).tc_bb_ovn);
1167: -- hr_utility.trace('action_type : '||l_audit_details(i).action_type);
1168: -- hr_utility.trace('resource_id : '||l_audit_details(i).resource_id);
1169: -- hr_utility.trace('tc_start_time : '||l_audit_details(i).tc_start_time);
1170: -- hr_utility.trace('tc_stop_time : '||l_audit_details(i).tc_stop_time);
1171: -- hr_utility.trace('action_by_person : '||l_audit_details(i).action_by_person);
1172: -- hr_utility.trace('cla_reason : '||l_audit_details(i).cla_reason);
1173: -- hr_utility.trace('resource_name : '||l_audit_details(i).resource_name);
1174: -- END LOOP;

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

1167: -- hr_utility.trace('action_type : '||l_audit_details(i).action_type);
1168: -- hr_utility.trace('resource_id : '||l_audit_details(i).resource_id);
1169: -- hr_utility.trace('tc_start_time : '||l_audit_details(i).tc_start_time);
1170: -- hr_utility.trace('tc_stop_time : '||l_audit_details(i).tc_stop_time);
1171: -- hr_utility.trace('action_by_person : '||l_audit_details(i).action_by_person);
1172: -- hr_utility.trace('cla_reason : '||l_audit_details(i).cla_reason);
1173: -- hr_utility.trace('resource_name : '||l_audit_details(i).resource_name);
1174: -- END LOOP;
1175:

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

1168: -- hr_utility.trace('resource_id : '||l_audit_details(i).resource_id);
1169: -- hr_utility.trace('tc_start_time : '||l_audit_details(i).tc_start_time);
1170: -- hr_utility.trace('tc_stop_time : '||l_audit_details(i).tc_stop_time);
1171: -- hr_utility.trace('action_by_person : '||l_audit_details(i).action_by_person);
1172: -- hr_utility.trace('cla_reason : '||l_audit_details(i).cla_reason);
1173: -- hr_utility.trace('resource_name : '||l_audit_details(i).resource_name);
1174: -- END LOOP;
1175:
1176: END IF;

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

1169: -- hr_utility.trace('tc_start_time : '||l_audit_details(i).tc_start_time);
1170: -- hr_utility.trace('tc_stop_time : '||l_audit_details(i).tc_stop_time);
1171: -- hr_utility.trace('action_by_person : '||l_audit_details(i).action_by_person);
1172: -- hr_utility.trace('cla_reason : '||l_audit_details(i).cla_reason);
1173: -- hr_utility.trace('resource_name : '||l_audit_details(i).resource_name);
1174: -- END LOOP;
1175:
1176: END IF;
1177:

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

1237: END IF;
1238:
1239: IF g_debug
1240: THEN
1241: hr_utility.trace('Fetched details ');
1242: hr_utility.trace('Total Number of details fetched : '||l_tc_details.COUNT);
1243: END IF;
1244:
1245:

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

1238:
1239: IF g_debug
1240: THEN
1241: hr_utility.trace('Fetched details ');
1242: hr_utility.trace('Total Number of details fetched : '||l_tc_details.COUNT);
1243: END IF;
1244:
1245:
1246: IF l_tc_details.COUNT > 0

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

1438:
1439:
1440: IF g_debug
1441: THEN
1442: hr_utility.trace('execute_audit_trail_reporting');
1443: hr_utility.trace('Parameters ');
1444: hr_utility.trace('===========');
1445: hr_utility.trace('p_date_from '||p_date_from);
1446: hr_utility.trace('p_date_to '||p_date_to);

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

1439:
1440: IF g_debug
1441: THEN
1442: hr_utility.trace('execute_audit_trail_reporting');
1443: hr_utility.trace('Parameters ');
1444: hr_utility.trace('===========');
1445: hr_utility.trace('p_date_from '||p_date_from);
1446: hr_utility.trace('p_date_to '||p_date_to);
1447: hr_utility.trace('p_data_regen '||p_data_regen);

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

1440: IF g_debug
1441: THEN
1442: hr_utility.trace('execute_audit_trail_reporting');
1443: hr_utility.trace('Parameters ');
1444: hr_utility.trace('===========');
1445: hr_utility.trace('p_date_from '||p_date_from);
1446: hr_utility.trace('p_date_to '||p_date_to);
1447: hr_utility.trace('p_data_regen '||p_data_regen);
1448: hr_utility.trace('p_record_save '||p_record_save);

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

1441: THEN
1442: hr_utility.trace('execute_audit_trail_reporting');
1443: hr_utility.trace('Parameters ');
1444: hr_utility.trace('===========');
1445: hr_utility.trace('p_date_from '||p_date_from);
1446: hr_utility.trace('p_date_to '||p_date_to);
1447: hr_utility.trace('p_data_regen '||p_data_regen);
1448: hr_utility.trace('p_record_save '||p_record_save);
1449: hr_utility.trace('p_org_id '||p_org_id);

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

1442: hr_utility.trace('execute_audit_trail_reporting');
1443: hr_utility.trace('Parameters ');
1444: hr_utility.trace('===========');
1445: hr_utility.trace('p_date_from '||p_date_from);
1446: hr_utility.trace('p_date_to '||p_date_to);
1447: hr_utility.trace('p_data_regen '||p_data_regen);
1448: hr_utility.trace('p_record_save '||p_record_save);
1449: hr_utility.trace('p_org_id '||p_org_id);
1450: hr_utility.trace('p_locn_id '||p_locn_id);

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

1443: hr_utility.trace('Parameters ');
1444: hr_utility.trace('===========');
1445: hr_utility.trace('p_date_from '||p_date_from);
1446: hr_utility.trace('p_date_to '||p_date_to);
1447: hr_utility.trace('p_data_regen '||p_data_regen);
1448: hr_utility.trace('p_record_save '||p_record_save);
1449: hr_utility.trace('p_org_id '||p_org_id);
1450: hr_utility.trace('p_locn_id '||p_locn_id);
1451: hr_utility.trace('p_payroll_id '||p_payroll_id);

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

1444: hr_utility.trace('===========');
1445: hr_utility.trace('p_date_from '||p_date_from);
1446: hr_utility.trace('p_date_to '||p_date_to);
1447: hr_utility.trace('p_data_regen '||p_data_regen);
1448: hr_utility.trace('p_record_save '||p_record_save);
1449: hr_utility.trace('p_org_id '||p_org_id);
1450: hr_utility.trace('p_locn_id '||p_locn_id);
1451: hr_utility.trace('p_payroll_id '||p_payroll_id);
1452: hr_utility.trace('p_supervisor_id '||p_supervisor_id);

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

1445: hr_utility.trace('p_date_from '||p_date_from);
1446: hr_utility.trace('p_date_to '||p_date_to);
1447: hr_utility.trace('p_data_regen '||p_data_regen);
1448: hr_utility.trace('p_record_save '||p_record_save);
1449: hr_utility.trace('p_org_id '||p_org_id);
1450: hr_utility.trace('p_locn_id '||p_locn_id);
1451: hr_utility.trace('p_payroll_id '||p_payroll_id);
1452: hr_utility.trace('p_supervisor_id '||p_supervisor_id);
1453: hr_utility.trace('p_person_id '||p_person_id);

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

1446: hr_utility.trace('p_date_to '||p_date_to);
1447: hr_utility.trace('p_data_regen '||p_data_regen);
1448: hr_utility.trace('p_record_save '||p_record_save);
1449: hr_utility.trace('p_org_id '||p_org_id);
1450: hr_utility.trace('p_locn_id '||p_locn_id);
1451: hr_utility.trace('p_payroll_id '||p_payroll_id);
1452: hr_utility.trace('p_supervisor_id '||p_supervisor_id);
1453: hr_utility.trace('p_person_id '||p_person_id);
1454: END IF;

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

1447: hr_utility.trace('p_data_regen '||p_data_regen);
1448: hr_utility.trace('p_record_save '||p_record_save);
1449: hr_utility.trace('p_org_id '||p_org_id);
1450: hr_utility.trace('p_locn_id '||p_locn_id);
1451: hr_utility.trace('p_payroll_id '||p_payroll_id);
1452: hr_utility.trace('p_supervisor_id '||p_supervisor_id);
1453: hr_utility.trace('p_person_id '||p_person_id);
1454: END IF;
1455:

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

1448: hr_utility.trace('p_record_save '||p_record_save);
1449: hr_utility.trace('p_org_id '||p_org_id);
1450: hr_utility.trace('p_locn_id '||p_locn_id);
1451: hr_utility.trace('p_payroll_id '||p_payroll_id);
1452: hr_utility.trace('p_supervisor_id '||p_supervisor_id);
1453: hr_utility.trace('p_person_id '||p_person_id);
1454: END IF;
1455:
1456:

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

1449: hr_utility.trace('p_org_id '||p_org_id);
1450: hr_utility.trace('p_locn_id '||p_locn_id);
1451: hr_utility.trace('p_payroll_id '||p_payroll_id);
1452: hr_utility.trace('p_supervisor_id '||p_supervisor_id);
1453: hr_utility.trace('p_person_id '||p_person_id);
1454: END IF;
1455:
1456:
1457: -- Calling Load timecard snapshot passing the required parameters.

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

1472: COMMIT;
1473:
1474: IF l_data_load_request_id = 0
1475: THEN
1476: hr_utility.trace('There was an error in submitting Load Timecard Snapshot ');
1477: hr_utility.trace('Sql Error : '||SQLCODE);
1478: END IF;
1479:
1480:

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

1473:
1474: IF l_data_load_request_id = 0
1475: THEN
1476: hr_utility.trace('There was an error in submitting Load Timecard Snapshot ');
1477: hr_utility.trace('Sql Error : '||SQLCODE);
1478: END IF;
1479:
1480:
1481: -- Translate_parameters is to translate the given parameters to the process

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

1486: translate_parameters;
1487:
1488: IF g_debug
1489: THEN
1490: hr_utility.trace('Request went to wait at '||to_char(sysdate,'dd-MON-yyyy HH:MI:SS'));
1491: END IF;
1492:
1493: l_call_status := FND_CONCURRENT.WAIT_FOR_REQUEST( request_id => l_data_load_request_id,
1494: interval => l_interval,

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

1500: message => l_message );
1501:
1502: IF g_debug
1503: THEN
1504: hr_utility.trace('Request stopped at '||to_char(sysdate,'dd-MON-yyyy HH:MI:SS'));
1505: END IF;
1506:
1507: IF l_call_status = FALSE
1508: THEN

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

1507: IF l_call_status = FALSE
1508: THEN
1509: IF g_debug
1510: THEN
1511: hr_utility.trace('There was an error in executing Load Timecard Snapshot ');
1512: hr_utility.trace('Sql Error : '||SQLCODE);
1513: END IF;
1514: END IF;
1515:

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

1508: THEN
1509: IF g_debug
1510: THEN
1511: hr_utility.trace('There was an error in executing Load Timecard Snapshot ');
1512: hr_utility.trace('Sql Error : '||SQLCODE);
1513: END IF;
1514: END IF;
1515:
1516: -- Just in case the previous run crashed, clear the reporting table before you

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

1526: EXIT WHEN get_timecards%NOTFOUND;
1527:
1528: IF g_debug
1529: THEN
1530: hr_utility.trace('Fetched from get_timecards ');
1531: hr_utility.trace('Resource id : '||l_resource_id);
1532: hr_utility.trace('TC start time : '||l_start_time);
1533: hr_utility.trace('TC stop time : '||l_stop_time);
1534: END IF;

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

1527:
1528: IF g_debug
1529: THEN
1530: hr_utility.trace('Fetched from get_timecards ');
1531: hr_utility.trace('Resource id : '||l_resource_id);
1532: hr_utility.trace('TC start time : '||l_start_time);
1533: hr_utility.trace('TC stop time : '||l_stop_time);
1534: END IF;
1535:

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

1528: IF g_debug
1529: THEN
1530: hr_utility.trace('Fetched from get_timecards ');
1531: hr_utility.trace('Resource id : '||l_resource_id);
1532: hr_utility.trace('TC start time : '||l_start_time);
1533: hr_utility.trace('TC stop time : '||l_stop_time);
1534: END IF;
1535:
1536: IF l_resource_count = 100

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

1529: THEN
1530: hr_utility.trace('Fetched from get_timecards ');
1531: hr_utility.trace('Resource id : '||l_resource_id);
1532: hr_utility.trace('TC start time : '||l_start_time);
1533: hr_utility.trace('TC stop time : '||l_stop_time);
1534: END IF;
1535:
1536: IF l_resource_count = 100
1537: THEN

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

1565: CLOSE get_timecards;
1566: COMMIT;
1567: IF g_debug
1568: THEN
1569: hr_utility.trace('Completed Audit Trail Reporting normally ');
1570: hr_utility.trace('Finished processing at '||TO_CHAR(SYSDATE,'dd-MON-yyyy HH:MI:SS'));
1571: END IF;
1572:
1573: EXCEPTION

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

1566: COMMIT;
1567: IF g_debug
1568: THEN
1569: hr_utility.trace('Completed Audit Trail Reporting normally ');
1570: hr_utility.trace('Finished processing at '||TO_CHAR(SYSDATE,'dd-MON-yyyy HH:MI:SS'));
1571: END IF;
1572:
1573: EXCEPTION
1574: WHEN NO_DATA_FOUND THEN

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

1571: END IF;
1572:
1573: EXCEPTION
1574: WHEN NO_DATA_FOUND THEN
1575: hr_utility.trace('No Data Found from execute_audit_trail_reporting ');
1576:
1577: END execute_audit_trail_reporting;
1578:
1579: