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

Line 6: g_debug BOOLEAN := hr_utility.debug_enabled;

2: /* $Header: hxcrpttcsnpsht.pkb 120.18.12020000.2 2012/07/04 09:32:24 amnaraya ship $ */
3:
4: g_res_list_cs VARCHARTABLE;
5: g_request_id VARCHAR2(30);
6: g_debug BOOLEAN := hr_utility.debug_enabled;
7:
8:
9: newline VARCHAR2(1) :=
10: '

Line 68: hr_utility.trace('Resource_where_clause');

64: -- having a comma separated list of 20 person_ids.
65:
66: IF g_debug
67: THEN
68: hr_utility.trace('Resource_where_clause');
69: hr_utility.trace('Parameters');
70: hr_utility.trace('==========');
71: hr_utility.trace('p_date_from '||p_date_from);
72: hr_utility.trace('p_date_to '||p_date_to);

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

65:
66: IF g_debug
67: THEN
68: hr_utility.trace('Resource_where_clause');
69: hr_utility.trace('Parameters');
70: hr_utility.trace('==========');
71: hr_utility.trace('p_date_from '||p_date_from);
72: hr_utility.trace('p_date_to '||p_date_to);
73: hr_utility.trace('p_org_id '||p_org_id);

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

66: IF g_debug
67: THEN
68: hr_utility.trace('Resource_where_clause');
69: hr_utility.trace('Parameters');
70: hr_utility.trace('==========');
71: hr_utility.trace('p_date_from '||p_date_from);
72: hr_utility.trace('p_date_to '||p_date_to);
73: hr_utility.trace('p_org_id '||p_org_id);
74: hr_utility.trace('p_locn_id '||p_locn_id);

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

67: THEN
68: hr_utility.trace('Resource_where_clause');
69: hr_utility.trace('Parameters');
70: hr_utility.trace('==========');
71: hr_utility.trace('p_date_from '||p_date_from);
72: hr_utility.trace('p_date_to '||p_date_to);
73: hr_utility.trace('p_org_id '||p_org_id);
74: hr_utility.trace('p_locn_id '||p_locn_id);
75: hr_utility.trace('p_payroll_id '||p_payroll_id);

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

68: hr_utility.trace('Resource_where_clause');
69: hr_utility.trace('Parameters');
70: hr_utility.trace('==========');
71: hr_utility.trace('p_date_from '||p_date_from);
72: hr_utility.trace('p_date_to '||p_date_to);
73: hr_utility.trace('p_org_id '||p_org_id);
74: hr_utility.trace('p_locn_id '||p_locn_id);
75: hr_utility.trace('p_payroll_id '||p_payroll_id);
76: hr_utility.trace('p_supervisor_id '||p_supervisor_id);

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

69: hr_utility.trace('Parameters');
70: hr_utility.trace('==========');
71: hr_utility.trace('p_date_from '||p_date_from);
72: hr_utility.trace('p_date_to '||p_date_to);
73: hr_utility.trace('p_org_id '||p_org_id);
74: hr_utility.trace('p_locn_id '||p_locn_id);
75: hr_utility.trace('p_payroll_id '||p_payroll_id);
76: hr_utility.trace('p_supervisor_id '||p_supervisor_id);
77: hr_utility.trace('p_person_id '||p_person_id);

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

70: hr_utility.trace('==========');
71: hr_utility.trace('p_date_from '||p_date_from);
72: hr_utility.trace('p_date_to '||p_date_to);
73: hr_utility.trace('p_org_id '||p_org_id);
74: hr_utility.trace('p_locn_id '||p_locn_id);
75: hr_utility.trace('p_payroll_id '||p_payroll_id);
76: hr_utility.trace('p_supervisor_id '||p_supervisor_id);
77: hr_utility.trace('p_person_id '||p_person_id);
78: END IF;

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

71: hr_utility.trace('p_date_from '||p_date_from);
72: hr_utility.trace('p_date_to '||p_date_to);
73: hr_utility.trace('p_org_id '||p_org_id);
74: hr_utility.trace('p_locn_id '||p_locn_id);
75: hr_utility.trace('p_payroll_id '||p_payroll_id);
76: hr_utility.trace('p_supervisor_id '||p_supervisor_id);
77: hr_utility.trace('p_person_id '||p_person_id);
78: END IF;
79:

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

72: hr_utility.trace('p_date_to '||p_date_to);
73: hr_utility.trace('p_org_id '||p_org_id);
74: hr_utility.trace('p_locn_id '||p_locn_id);
75: hr_utility.trace('p_payroll_id '||p_payroll_id);
76: hr_utility.trace('p_supervisor_id '||p_supervisor_id);
77: hr_utility.trace('p_person_id '||p_person_id);
78: END IF;
79:
80: l_base_query := REPLACE(l_base_query,'p_date_from',TO_CHAR(p_date_from));

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

73: hr_utility.trace('p_org_id '||p_org_id);
74: hr_utility.trace('p_locn_id '||p_locn_id);
75: hr_utility.trace('p_payroll_id '||p_payroll_id);
76: hr_utility.trace('p_supervisor_id '||p_supervisor_id);
77: hr_utility.trace('p_person_id '||p_person_id);
78: END IF;
79:
80: l_base_query := REPLACE(l_base_query,'p_date_from',TO_CHAR(p_date_from));
81: l_base_query := REPLACE(l_base_query,'p_date_to',TO_CHAR(p_date_to));

Line 112: hr_utility.trace('Dynamic query to be executed is ');

108:
109:
110: IF g_debug
111: THEN
112: hr_utility.trace('Dynamic query to be executed is ');
113: hr_utility.trace(l_base_query);
114: END IF;
115:
116: g_res_list_cs := VARCHARTABLE(' ');

Line 113: hr_utility.trace(l_base_query);

109:
110: IF g_debug
111: THEN
112: hr_utility.trace('Dynamic query to be executed is ');
113: hr_utility.trace(l_base_query);
114: END IF;
115:
116: g_res_list_cs := VARCHARTABLE(' ');
117: l_rlc_cnt := g_res_list_cs.FIRST;

Line 133: hr_utility.trace('Resource List No.'||l_rlc_cnt);

129: END LOOP;
130: g_res_list_cs(l_rlc_cnt) := l_res_list_cs_buff;
131: IF g_debug
132: THEN
133: hr_utility.trace('Resource List No.'||l_rlc_cnt);
134: hr_utility.trace('---> '||g_res_list_cs(l_rlc_cnt));
135: END IF;
136:
137: l_resource_list.DELETE;

Line 134: hr_utility.trace('---> '||g_res_list_cs(l_rlc_cnt));

130: g_res_list_cs(l_rlc_cnt) := l_res_list_cs_buff;
131: IF g_debug
132: THEN
133: hr_utility.trace('Resource List No.'||l_rlc_cnt);
134: hr_utility.trace('---> '||g_res_list_cs(l_rlc_cnt));
135: END IF;
136:
137: l_resource_list.DELETE;
138: l_rlc_cnt := l_rlc_cnt + 1;

Line 148: hr_utility.trace('resource_where_clause completed alright');

144: CLOSE l_resource_cur;
145:
146: IF g_debug
147: THEN
148: hr_utility.trace('resource_where_clause completed alright');
149: END IF;
150:
151: EXCEPTION
152: WHEN NO_DATA_FOUND THEN

Line 153: hr_utility.trace('No Active Resources For the given criteria ');

149: END IF;
150:
151: EXCEPTION
152: WHEN NO_DATA_FOUND THEN
153: hr_utility.trace('No Active Resources For the given criteria ');
154:
155: END resource_where_clause;
156:
157:

Line 210: hr_utility.trace('load_tc_level_info');

206:
207:
208: IF g_debug
209: THEN
210: hr_utility.trace('load_tc_level_info');
211: hr_utility.trace('Parameters ');
212: hr_utility.trace('===========');
213: hr_utility.trace('p_resource_list :'||p_resource_list);
214: hr_utility.trace('p_tc_from :'||p_tc_from);

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

207:
208: IF g_debug
209: THEN
210: hr_utility.trace('load_tc_level_info');
211: hr_utility.trace('Parameters ');
212: hr_utility.trace('===========');
213: hr_utility.trace('p_resource_list :'||p_resource_list);
214: hr_utility.trace('p_tc_from :'||p_tc_from);
215: hr_utility.trace('p_tc_to :'||p_tc_to);

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

208: IF g_debug
209: THEN
210: hr_utility.trace('load_tc_level_info');
211: hr_utility.trace('Parameters ');
212: hr_utility.trace('===========');
213: hr_utility.trace('p_resource_list :'||p_resource_list);
214: hr_utility.trace('p_tc_from :'||p_tc_from);
215: hr_utility.trace('p_tc_to :'||p_tc_to);
216: hr_utility.trace('p_request_id :'||p_request_id);

Line 213: hr_utility.trace('p_resource_list :'||p_resource_list);

209: THEN
210: hr_utility.trace('load_tc_level_info');
211: hr_utility.trace('Parameters ');
212: hr_utility.trace('===========');
213: hr_utility.trace('p_resource_list :'||p_resource_list);
214: hr_utility.trace('p_tc_from :'||p_tc_from);
215: hr_utility.trace('p_tc_to :'||p_tc_to);
216: hr_utility.trace('p_request_id :'||p_request_id);
217: END IF;

Line 214: hr_utility.trace('p_tc_from :'||p_tc_from);

210: hr_utility.trace('load_tc_level_info');
211: hr_utility.trace('Parameters ');
212: hr_utility.trace('===========');
213: hr_utility.trace('p_resource_list :'||p_resource_list);
214: hr_utility.trace('p_tc_from :'||p_tc_from);
215: hr_utility.trace('p_tc_to :'||p_tc_to);
216: hr_utility.trace('p_request_id :'||p_request_id);
217: END IF;
218:

Line 215: hr_utility.trace('p_tc_to :'||p_tc_to);

211: hr_utility.trace('Parameters ');
212: hr_utility.trace('===========');
213: hr_utility.trace('p_resource_list :'||p_resource_list);
214: hr_utility.trace('p_tc_from :'||p_tc_from);
215: hr_utility.trace('p_tc_to :'||p_tc_to);
216: hr_utility.trace('p_request_id :'||p_request_id);
217: END IF;
218:
219:

Line 216: hr_utility.trace('p_request_id :'||p_request_id);

212: hr_utility.trace('===========');
213: hr_utility.trace('p_resource_list :'||p_resource_list);
214: hr_utility.trace('p_tc_from :'||p_tc_from);
215: hr_utility.trace('p_tc_to :'||p_tc_to);
216: hr_utility.trace('p_request_id :'||p_request_id);
217: END IF;
218:
219:
220:

Line 237: hr_utility.trace('Timecard select query is ');

233: time_building_block_id ';
234:
235: IF g_debug
236: THEN
237: hr_utility.trace('Timecard select query is ');
238: hr_utility.trace(l_tc_query);
239: END IF;
240: EXECUTE IMMEDIATE l_tc_query;
241:

Line 238: hr_utility.trace(l_tc_query);

234:
235: IF g_debug
236: THEN
237: hr_utility.trace('Timecard select query is ');
238: hr_utility.trace(l_tc_query);
239: END IF;
240: EXECUTE IMMEDIATE l_tc_query;
241:
242: EXCEPTION

Line 244: hr_utility.trace('No Timecards found for resource list '||p_resource_list);

240: EXECUTE IMMEDIATE l_tc_query;
241:
242: EXCEPTION
243: WHEN NO_DATA_FOUND THEN
244: hr_utility.trace('No Timecards found for resource list '||p_resource_list);
245:
246: END load_tc_level_info;
247:
248:

Line 268: hr_utility.trace('Started clear_history_data');

264: -- Commit the changes.
265:
266: IF g_debug
267: THEN
268: hr_utility.trace('Started clear_history_data');
269: END IF;
270:
271: DELETE FROM hxc_rpt_tc_hist_log;
272:

Line 279: hr_utility.trace('clear_history_data completed alright');

275: COMMIT;
276:
277: IF g_debug
278: THEN
279: hr_utility.trace('clear_history_data completed alright');
280: END IF;
281:
282: EXCEPTION
283: WHEN NO_DATA_FOUND THEN

Line 334: hr_utility.trace('Started fetch_history_from_date ');

330:
331:
332: IF g_debug
333: THEN
334: hr_utility.trace('Started fetch_history_from_date ');
335: END IF;
336:
337: OPEN get_history_date;
338: FETCH get_history_date

Line 347: hr_utility.trace('Fetched values for get_history_date ');

343: CLOSE get_history_date;
344:
345: IF g_debug
346: THEN
347: hr_utility.trace('Fetched values for get_history_date ');
348: hr_utility.trace('Total number of rows fetched :'||resource_id_tab.COUNT);
349: END IF;
350:
351: IF resource_id_tab.COUNT > 0

Line 348: hr_utility.trace('Total number of rows fetched :'||resource_id_tab.COUNT);

344:
345: IF g_debug
346: THEN
347: hr_utility.trace('Fetched values for get_history_date ');
348: hr_utility.trace('Total number of rows fetched :'||resource_id_tab.COUNT);
349: END IF;
350:
351: IF resource_id_tab.COUNT > 0
352: THEN

Line 372: hr_utility.trace('fetch_history_from_date completed alright');

368: WHERE history_from_date IS NULL ;
369:
370: IF g_debug
371: THEN
372: hr_utility.trace('fetch_history_from_date completed alright');
373: END IF;
374:
375: EXCEPTION
376: WHEN NO_DATA_FOUND THEN

Line 418: hr_utility.trace('Starting update_layout_ids');

414: -- for each of the timecard records.
415:
416: IF g_debug
417: THEN
418: hr_utility.trace('Starting update_layout_ids');
419: END IF;
420:
421: OPEN get_layout_ids;
422: LOOP

Line 431: hr_utility.trace('Fetched from get_layout_ids');

427: EXIT WHEN l_layout_id_tab.COUNT = 0;
428:
429: IF g_debug
430: THEN
431: hr_utility.trace('Fetched from get_layout_ids');
432: hr_utility.trace('Number of rows fetched '||l_layout_id_tab.COUNT);
433: END IF;
434:
435: IF l_layout_id_tab.COUNT > 0

Line 432: hr_utility.trace('Number of rows fetched '||l_layout_id_tab.COUNT);

428:
429: IF g_debug
430: THEN
431: hr_utility.trace('Fetched from get_layout_ids');
432: hr_utility.trace('Number of rows fetched '||l_layout_id_tab.COUNT);
433: END IF;
434:
435: IF l_layout_id_tab.COUNT > 0
436: THEN

Line 450: hr_utility.trace('update_layout_ids completed alright');

446: CLOSE get_layout_ids;
447:
448: IF g_debug
449: THEN
450: hr_utility.trace('update_layout_ids completed alright');
451: END IF;
452:
453: EXCEPTION
454: WHEN NO_DATA_FOUND THEN

Line 455: hr_utility.trace('No layout ids found for the timecards, something wrong ');

451: END IF;
452:
453: EXCEPTION
454: WHEN NO_DATA_FOUND THEN
455: hr_utility.trace('No layout ids found for the timecards, something wrong ');
456:
457: END update_layout_ids;
458:
459:

Line 512: hr_utility.trace('Starting update_last_touched_date');

508:
509:
510: IF g_debug
511: THEN
512: hr_utility.trace('Starting update_last_touched_date');
513: END IF;
514:
515: OPEN get_last_touched_date;
516:

Line 528: hr_utility.trace('Fetched from get_last_touched_date');

524: CLOSE get_last_touched_date;
525:
526: IF g_debug
527: THEN
528: hr_utility.trace('Fetched from get_last_touched_date');
529: hr_utility.trace('Total number of rows fetched '||bb_id_tab.COUNT);
530: END IF;
531:
532: IF bb_id_tab.COUNT > 0

Line 529: hr_utility.trace('Total number of rows fetched '||bb_id_tab.COUNT);

525:
526: IF g_debug
527: THEN
528: hr_utility.trace('Fetched from get_last_touched_date');
529: hr_utility.trace('Total number of rows fetched '||bb_id_tab.COUNT);
530: END IF;
531:
532: IF bb_id_tab.COUNT > 0
533: THEN

Line 552: hr_utility.trace('update_last_touched_date threw NO DATA FOUND');

548:
549:
550: EXCEPTION
551: WHEN NO_DATA_FOUND THEN
552: hr_utility.trace('update_last_touched_date threw NO DATA FOUND');
553:
554: END update_last_touched_date;
555:
556:

Line 593: hr_utility.trace('Starting update_timecard_comments');

589: -- Update HXC_RPT_TC_DETAILS_ALL with the comments picked up above.
590:
591: IF g_debug
592: THEN
593: hr_utility.trace('Starting update_timecard_comments');
594: END IF;
595:
596:
597: OPEN get_timecard_comments;

Line 607: hr_utility.trace('Fetched from get_timecard_comments');

603: CLOSE get_timecard_comments;
604:
605: IF g_debug
606: THEN
607: hr_utility.trace('Fetched from get_timecard_comments');
608: hr_utility.trace('Total number of rows fetched '||det_bb_tab.COUNT);
609: END IF;
610:
611: IF det_bb_tab.COUNT > 0

Line 608: hr_utility.trace('Total number of rows fetched '||det_bb_tab.COUNT);

604:
605: IF g_debug
606: THEN
607: hr_utility.trace('Fetched from get_timecard_comments');
608: hr_utility.trace('Total number of rows fetched '||det_bb_tab.COUNT);
609: END IF;
610:
611: IF det_bb_tab.COUNT > 0
612: THEN

Line 626: hr_utility.trace('Completed update_timecard_comments alright');

622: comment_tab.DELETE;
623:
624: IF g_debug
625: THEN
626: hr_utility.trace('Completed update_timecard_comments alright');
627: END IF;
628:
629:
630: EXCEPTION

Line 661: hr_utility.trace('load_detail_info begins '||p_request_sysdate);

657: -- in HXC_RPT_TC_DETAILS_ALL.
658:
659: IF g_debug
660: THEN
661: hr_utility.trace('load_detail_info begins '||p_request_sysdate);
662: END IF;
663:
664: INSERT INTO hxc_rpt_tc_details_all
665: ( resource_id,

Line 725: hr_utility.trace('load_detail_info completed alright');

721: AND detail.creation_date > gt.history_from_date ;
722:
723: IF g_debug
724: THEN
725: hr_utility.trace('load_detail_info completed alright');
726: END IF;
727:
728: EXCEPTION
729: WHEN NO_DATA_FOUND THEN

Line 730: hr_utility.trace('No detail data found, something wrong with this list ');

726: END IF;
727:
728: EXCEPTION
729: WHEN NO_DATA_FOUND THEN
730: hr_utility.trace('No detail data found, something wrong with this list ');
731:
732: END load_detail_info;
733:
734:

Line 886: hr_utility.trace('Starting initialize_dynamic_variables');

882: -- Initialize all the dynamic variables with the dynamic string constants
883:
884: IF g_debug
885: THEN
886: hr_utility.trace('Starting initialize_dynamic_variables');
887: END IF;
888:
889: dynamic_header := l_dynamic_header;
890: dynamic_cursor_select := l_dynamic_cursor_select;

Line 902: hr_utility.trace('initialize_dynamic_variables completed alright');

898: element_where := ' ) ';
899:
900: IF g_debug
901: THEN
902: hr_utility.trace('initialize_dynamic_variables completed alright');
903: END IF;
904:
905:
906: END initialize_dynamic_variables;

Line 1035: hr_utility.trace('populate_attributes');

1031: --
1032:
1033: IF g_debug
1034: THEN
1035: hr_utility.trace('populate_attributes');
1036: hr_utility.trace('Parameter - p_layout_id : '||p_layout_id);
1037: END IF;
1038:
1039: l_curr_layout := p_layout_id;

Line 1036: hr_utility.trace('Parameter - p_layout_id : '||p_layout_id);

1032:
1033: IF g_debug
1034: THEN
1035: hr_utility.trace('populate_attributes');
1036: hr_utility.trace('Parameter - p_layout_id : '||p_layout_id);
1037: END IF;
1038:
1039: l_curr_layout := p_layout_id;
1040: initialize_dynamic_variables;

Line 1052: hr_utility.trace('Ftetched from get_layout_fields ');

1048: EXIT WHEN get_layout_fields%NOTFOUND;
1049:
1050: IF g_debug
1051: THEN
1052: hr_utility.trace('Ftetched from get_layout_fields ');
1053: hr_utility.trace('l_layout_fld_column :'||l_layout_fld_column);
1054: hr_utility.trace('l_layout_fld_where :'||l_layout_fld_where);
1055: hr_utility.trace('l_layout_fld_name :'||l_layout_fld_name);
1056: hr_utility.trace('l_layout_fld_rownum :'||l_layout_fld_rownum);

Line 1053: hr_utility.trace('l_layout_fld_column :'||l_layout_fld_column);

1049:
1050: IF g_debug
1051: THEN
1052: hr_utility.trace('Ftetched from get_layout_fields ');
1053: hr_utility.trace('l_layout_fld_column :'||l_layout_fld_column);
1054: hr_utility.trace('l_layout_fld_where :'||l_layout_fld_where);
1055: hr_utility.trace('l_layout_fld_name :'||l_layout_fld_name);
1056: hr_utility.trace('l_layout_fld_rownum :'||l_layout_fld_rownum);
1057: END IF;

Line 1054: hr_utility.trace('l_layout_fld_where :'||l_layout_fld_where);

1050: IF g_debug
1051: THEN
1052: hr_utility.trace('Ftetched from get_layout_fields ');
1053: hr_utility.trace('l_layout_fld_column :'||l_layout_fld_column);
1054: hr_utility.trace('l_layout_fld_where :'||l_layout_fld_where);
1055: hr_utility.trace('l_layout_fld_name :'||l_layout_fld_name);
1056: hr_utility.trace('l_layout_fld_rownum :'||l_layout_fld_rownum);
1057: END IF;
1058:

Line 1055: hr_utility.trace('l_layout_fld_name :'||l_layout_fld_name);

1051: THEN
1052: hr_utility.trace('Ftetched from get_layout_fields ');
1053: hr_utility.trace('l_layout_fld_column :'||l_layout_fld_column);
1054: hr_utility.trace('l_layout_fld_where :'||l_layout_fld_where);
1055: hr_utility.trace('l_layout_fld_name :'||l_layout_fld_name);
1056: hr_utility.trace('l_layout_fld_rownum :'||l_layout_fld_rownum);
1057: END IF;
1058:
1059: IF l_layout_fld_where NOT LIKE 'OTL_ALIAS%'

Line 1056: hr_utility.trace('l_layout_fld_rownum :'||l_layout_fld_rownum);

1052: hr_utility.trace('Ftetched from get_layout_fields ');
1053: hr_utility.trace('l_layout_fld_column :'||l_layout_fld_column);
1054: hr_utility.trace('l_layout_fld_where :'||l_layout_fld_where);
1055: hr_utility.trace('l_layout_fld_name :'||l_layout_fld_name);
1056: hr_utility.trace('l_layout_fld_rownum :'||l_layout_fld_rownum);
1057: END IF;
1058:
1059: IF l_layout_fld_where NOT LIKE 'OTL_ALIAS%'
1060: THEN

Line 1074: hr_utility.trace('Attribute category is Element ');

1070: THEN
1071: element_where := ' OR substr(ha.attribute_category,1,7) = ''ELEMENT'')';
1072: IF g_debug
1073: THEN
1074: hr_utility.trace('Attribute category is Element ');
1075: hr_utility.trace('element_where : '||element_where);
1076: END IF;
1077: END IF;
1078: ELSE

Line 1075: hr_utility.trace('element_where : '||element_where);

1071: element_where := ' OR substr(ha.attribute_category,1,7) = ''ELEMENT'')';
1072: IF g_debug
1073: THEN
1074: hr_utility.trace('Attribute category is Element ');
1075: hr_utility.trace('element_where : '||element_where);
1076: END IF;
1077: END IF;
1078: ELSE
1079: IF g_debug

Line 1081: hr_utility.trace('This is an alias value ');

1077: END IF;
1078: ELSE
1079: IF g_debug
1080: THEN
1081: hr_utility.trace('This is an alias value ');
1082: END IF;
1083: p_alias_tab.EXTEND;
1084: alias_cnt := alias_cnt+1;
1085: p_alias_tab(alias_cnt).layout_id := p_layout_id;

Line 1103: hr_utility.trace('Dynamic Pl/Sql Block created ');

1099: dynamic_cursor_where := dynamic_cursor_where||')'||element_where;
1100:
1101: IF g_debug
1102: THEN
1103: hr_utility.trace('Dynamic Pl/Sql Block created ');
1104: hr_utility.trace('------------------------------');
1105: hr_utility.trace(' ');
1106: hr_utility.trace(dynamic_header);
1107: hr_utility.trace(dynamic_cursor_select);

Line 1104: hr_utility.trace('------------------------------');

1100:
1101: IF g_debug
1102: THEN
1103: hr_utility.trace('Dynamic Pl/Sql Block created ');
1104: hr_utility.trace('------------------------------');
1105: hr_utility.trace(' ');
1106: hr_utility.trace(dynamic_header);
1107: hr_utility.trace(dynamic_cursor_select);
1108: hr_utility.trace(dynamic_cursor_where);

Line 1105: hr_utility.trace(' ');

1101: IF g_debug
1102: THEN
1103: hr_utility.trace('Dynamic Pl/Sql Block created ');
1104: hr_utility.trace('------------------------------');
1105: hr_utility.trace(' ');
1106: hr_utility.trace(dynamic_header);
1107: hr_utility.trace(dynamic_cursor_select);
1108: hr_utility.trace(dynamic_cursor_where);
1109: hr_utility.trace(dynamic_cursor_group_by);

Line 1106: hr_utility.trace(dynamic_header);

1102: THEN
1103: hr_utility.trace('Dynamic Pl/Sql Block created ');
1104: hr_utility.trace('------------------------------');
1105: hr_utility.trace(' ');
1106: hr_utility.trace(dynamic_header);
1107: hr_utility.trace(dynamic_cursor_select);
1108: hr_utility.trace(dynamic_cursor_where);
1109: hr_utility.trace(dynamic_cursor_group_by);
1110: hr_utility.trace(dynamic_cursor_open);

Line 1107: hr_utility.trace(dynamic_cursor_select);

1103: hr_utility.trace('Dynamic Pl/Sql Block created ');
1104: hr_utility.trace('------------------------------');
1105: hr_utility.trace(' ');
1106: hr_utility.trace(dynamic_header);
1107: hr_utility.trace(dynamic_cursor_select);
1108: hr_utility.trace(dynamic_cursor_where);
1109: hr_utility.trace(dynamic_cursor_group_by);
1110: hr_utility.trace(dynamic_cursor_open);
1111: hr_utility.trace(dynamic_cursor_close);

Line 1108: hr_utility.trace(dynamic_cursor_where);

1104: hr_utility.trace('------------------------------');
1105: hr_utility.trace(' ');
1106: hr_utility.trace(dynamic_header);
1107: hr_utility.trace(dynamic_cursor_select);
1108: hr_utility.trace(dynamic_cursor_where);
1109: hr_utility.trace(dynamic_cursor_group_by);
1110: hr_utility.trace(dynamic_cursor_open);
1111: hr_utility.trace(dynamic_cursor_close);
1112: hr_utility.trace(dynamic_update);

Line 1109: hr_utility.trace(dynamic_cursor_group_by);

1105: hr_utility.trace(' ');
1106: hr_utility.trace(dynamic_header);
1107: hr_utility.trace(dynamic_cursor_select);
1108: hr_utility.trace(dynamic_cursor_where);
1109: hr_utility.trace(dynamic_cursor_group_by);
1110: hr_utility.trace(dynamic_cursor_open);
1111: hr_utility.trace(dynamic_cursor_close);
1112: hr_utility.trace(dynamic_update);
1113: hr_utility.trace(dynamic_update_where);

Line 1110: hr_utility.trace(dynamic_cursor_open);

1106: hr_utility.trace(dynamic_header);
1107: hr_utility.trace(dynamic_cursor_select);
1108: hr_utility.trace(dynamic_cursor_where);
1109: hr_utility.trace(dynamic_cursor_group_by);
1110: hr_utility.trace(dynamic_cursor_open);
1111: hr_utility.trace(dynamic_cursor_close);
1112: hr_utility.trace(dynamic_update);
1113: hr_utility.trace(dynamic_update_where);
1114: hr_utility.trace(dynamic_footer);

Line 1111: hr_utility.trace(dynamic_cursor_close);

1107: hr_utility.trace(dynamic_cursor_select);
1108: hr_utility.trace(dynamic_cursor_where);
1109: hr_utility.trace(dynamic_cursor_group_by);
1110: hr_utility.trace(dynamic_cursor_open);
1111: hr_utility.trace(dynamic_cursor_close);
1112: hr_utility.trace(dynamic_update);
1113: hr_utility.trace(dynamic_update_where);
1114: hr_utility.trace(dynamic_footer);
1115: hr_utility.trace('/');

Line 1112: hr_utility.trace(dynamic_update);

1108: hr_utility.trace(dynamic_cursor_where);
1109: hr_utility.trace(dynamic_cursor_group_by);
1110: hr_utility.trace(dynamic_cursor_open);
1111: hr_utility.trace(dynamic_cursor_close);
1112: hr_utility.trace(dynamic_update);
1113: hr_utility.trace(dynamic_update_where);
1114: hr_utility.trace(dynamic_footer);
1115: hr_utility.trace('/');
1116: END IF;

Line 1113: hr_utility.trace(dynamic_update_where);

1109: hr_utility.trace(dynamic_cursor_group_by);
1110: hr_utility.trace(dynamic_cursor_open);
1111: hr_utility.trace(dynamic_cursor_close);
1112: hr_utility.trace(dynamic_update);
1113: hr_utility.trace(dynamic_update_where);
1114: hr_utility.trace(dynamic_footer);
1115: hr_utility.trace('/');
1116: END IF;
1117:

Line 1114: hr_utility.trace(dynamic_footer);

1110: hr_utility.trace(dynamic_cursor_open);
1111: hr_utility.trace(dynamic_cursor_close);
1112: hr_utility.trace(dynamic_update);
1113: hr_utility.trace(dynamic_update_where);
1114: hr_utility.trace(dynamic_footer);
1115: hr_utility.trace('/');
1116: END IF;
1117:
1118: dynamic_query := dynamic_header||

Line 1115: hr_utility.trace('/');

1111: hr_utility.trace(dynamic_cursor_close);
1112: hr_utility.trace(dynamic_update);
1113: hr_utility.trace(dynamic_update_where);
1114: hr_utility.trace(dynamic_footer);
1115: hr_utility.trace('/');
1116: END IF;
1117:
1118: dynamic_query := dynamic_header||
1119: dynamic_cursor_select||

Line 1132: hr_utility.trace('Execute Immediate in populate attributes threw Sql Error : '||SQLCODE);

1128: BEGIN
1129: EXECUTE IMMEDIATE dynamic_query;
1130: EXCEPTION
1131: WHEN OTHERS THEN
1132: hr_utility.trace('Execute Immediate in populate attributes threw Sql Error : '||SQLCODE);
1133: RAISE;
1134: END;
1135:
1136: IF g_debug

Line 1138: hr_utility.trace('populate_attributes completed alright ');

1134: END;
1135:
1136: IF g_debug
1137: THEN
1138: hr_utility.trace('populate_attributes completed alright ');
1139: END IF;
1140:
1141: EXCEPTION
1142: WHEN NO_DATA_FOUND THEN

Line 1143: hr_utility.trace('No data found from Populate attributes');

1139: END IF;
1140:
1141: EXCEPTION
1142: WHEN NO_DATA_FOUND THEN
1143: hr_utility.trace('No data found from Populate attributes');
1144:
1145: END populate_attributes;
1146:
1147:

Line 1191: hr_utility.trace('translate_attributes');

1187:
1188:
1189: IF g_debug
1190: THEN
1191: hr_utility.trace('translate_attributes');
1192: hr_utility.trace('Parameter - p_layout_id : '||p_layout_id);
1193: END IF;
1194: l_curr_layout := p_layout_id;
1195: OPEN get_layout_queries(l_curr_layout);

Line 1192: hr_utility.trace('Parameter - p_layout_id : '||p_layout_id);

1188:
1189: IF g_debug
1190: THEN
1191: hr_utility.trace('translate_attributes');
1192: hr_utility.trace('Parameter - p_layout_id : '||p_layout_id);
1193: END IF;
1194: l_curr_layout := p_layout_id;
1195: OPEN get_layout_queries(l_curr_layout);
1196: LOOP

Line 1205: hr_utility.trace('Dynamic Update query is ');

1201: l_update := REPLACE(l_update,'current_layout',l_curr_layout);
1202: l_update := REPLACE(l_update,'THIS_REQUEST_ID',g_request_id);
1203: IF g_debug
1204: THEN
1205: hr_utility.trace('Dynamic Update query is ');
1206: hr_utility.trace(l_update);
1207: END IF;
1208:
1209: BEGIN

Line 1206: hr_utility.trace(l_update);

1202: l_update := REPLACE(l_update,'THIS_REQUEST_ID',g_request_id);
1203: IF g_debug
1204: THEN
1205: hr_utility.trace('Dynamic Update query is ');
1206: hr_utility.trace(l_update);
1207: END IF;
1208:
1209: BEGIN
1210: EXECUTE IMMEDIATE l_update;

Line 1213: hr_utility.trace('Execute Immediate in translate_attributes threw Sql Error : '||SQLCODE);

1209: BEGIN
1210: EXECUTE IMMEDIATE l_update;
1211: EXCEPTION
1212: WHEN OTHERS THEN
1213: hr_utility.trace('Execute Immediate in translate_attributes threw Sql Error : '||SQLCODE);
1214: END;
1215:
1216: END LOOP;
1217: CLOSE get_layout_queries;

Line 1221: hr_utility.trace('translate_attributes completed alright ');

1217: CLOSE get_layout_queries;
1218:
1219: IF g_debug
1220: THEN
1221: hr_utility.trace('translate_attributes completed alright ');
1222: END IF;
1223:
1224: EXCEPTION
1225: WHEN NO_DATA_FOUND THEN

Line 1226: hr_utility.trace('No Data Found from translate_attributes ');

1222: END IF;
1223:
1224: EXCEPTION
1225: WHEN NO_DATA_FOUND THEN
1226: hr_utility.trace('No Data Found from translate_attributes ');
1227:
1228: END translate_attributes;
1229:
1230:

Line 1380: hr_utility.trace('initialize_dynamic_variables');

1376: -- translate_aliases is called.
1377:
1378: IF g_debug
1379: THEN
1380: hr_utility.trace('initialize_dynamic_variables');
1381: END IF;
1382:
1383: dynamic_cursor := l_dynamic_cursor;
1384: dynamic_where := l_dynamic_where;

Line 1490: hr_utility.trace('translate_aliases');

1486:
1487:
1488: IF g_debug
1489: THEN
1490: hr_utility.trace('translate_aliases');
1491: hr_utility.trace('Parameters ');
1492: hr_utility.trace('p_layout_id : '||p_layout_id);
1493: IF p_alias_tab.COUNT > 0
1494: THEN

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

1487:
1488: IF g_debug
1489: THEN
1490: hr_utility.trace('translate_aliases');
1491: hr_utility.trace('Parameters ');
1492: hr_utility.trace('p_layout_id : '||p_layout_id);
1493: IF p_alias_tab.COUNT > 0
1494: THEN
1495: FOR i IN p_alias_tab.FIRST..p_alias_tab.LAST

Line 1492: hr_utility.trace('p_layout_id : '||p_layout_id);

1488: IF g_debug
1489: THEN
1490: hr_utility.trace('translate_aliases');
1491: hr_utility.trace('Parameters ');
1492: hr_utility.trace('p_layout_id : '||p_layout_id);
1493: IF p_alias_tab.COUNT > 0
1494: THEN
1495: FOR i IN p_alias_tab.FIRST..p_alias_tab.LAST
1496: LOOP

Line 1497: hr_utility.trace('Alias number '||i);

1493: IF p_alias_tab.COUNT > 0
1494: THEN
1495: FOR i IN p_alias_tab.FIRST..p_alias_tab.LAST
1496: LOOP
1497: hr_utility.trace('Alias number '||i);
1498: hr_utility.trace('Layout : '||p_alias_tab(i).layout_id);
1499: hr_utility.trace('Name : '||p_alias_tab(i).alias_name);
1500: hr_utility.trace('Column : '||p_alias_tab(i).alias_column);
1501: END LOOP;

Line 1498: hr_utility.trace('Layout : '||p_alias_tab(i).layout_id);

1494: THEN
1495: FOR i IN p_alias_tab.FIRST..p_alias_tab.LAST
1496: LOOP
1497: hr_utility.trace('Alias number '||i);
1498: hr_utility.trace('Layout : '||p_alias_tab(i).layout_id);
1499: hr_utility.trace('Name : '||p_alias_tab(i).alias_name);
1500: hr_utility.trace('Column : '||p_alias_tab(i).alias_column);
1501: END LOOP;
1502: END IF;

Line 1499: hr_utility.trace('Name : '||p_alias_tab(i).alias_name);

1495: FOR i IN p_alias_tab.FIRST..p_alias_tab.LAST
1496: LOOP
1497: hr_utility.trace('Alias number '||i);
1498: hr_utility.trace('Layout : '||p_alias_tab(i).layout_id);
1499: hr_utility.trace('Name : '||p_alias_tab(i).alias_name);
1500: hr_utility.trace('Column : '||p_alias_tab(i).alias_column);
1501: END LOOP;
1502: END IF;
1503: END IF;

Line 1500: hr_utility.trace('Column : '||p_alias_tab(i).alias_column);

1496: LOOP
1497: hr_utility.trace('Alias number '||i);
1498: hr_utility.trace('Layout : '||p_alias_tab(i).layout_id);
1499: hr_utility.trace('Name : '||p_alias_tab(i).alias_name);
1500: hr_utility.trace('Column : '||p_alias_tab(i).alias_column);
1501: END LOOP;
1502: END IF;
1503: END IF;
1504:

Line 1514: hr_utility.trace('Processing Alias No. '||i);

1510: LOOP
1511:
1512: IF g_debug
1513: THEN
1514: hr_utility.trace('Processing Alias No. '||i);
1515: hr_utility.trace('Alias Name :'||p_alias_tab(i).alias_name);
1516: END IF;
1517:
1518: l_attr_col := p_alias_tab(i).alias_column;

Line 1515: hr_utility.trace('Alias Name :'||p_alias_tab(i).alias_name);

1511:
1512: IF g_debug
1513: THEN
1514: hr_utility.trace('Processing Alias No. '||i);
1515: hr_utility.trace('Alias Name :'||p_alias_tab(i).alias_name);
1516: END IF;
1517:
1518: l_attr_col := p_alias_tab(i).alias_column;
1519: l_alias_name := p_alias_tab(i).alias_name;

Line 1531: hr_utility.trace('Updated alias definition ids for current list of resources ');

1527: WHERE layout_id = l_curr_layout;
1528:
1529: IF g_debug
1530: THEN
1531: hr_utility.trace('Updated alias definition ids for current list of resources ');
1532: END IF;
1533:
1534: OPEN get_alias_defs(l_curr_layout);
1535: LOOP

Line 1542: hr_utility.trace('Fetched from get_alias_defs ');

1538: EXIT WHEN get_alias_defs%NOTFOUND;
1539:
1540: IF g_debug
1541: THEN
1542: hr_utility.trace('Fetched from get_alias_defs ');
1543: END IF;
1544:
1545:
1546: initialize_dynamic_variables;

Line 1557: hr_utility.trace('Fetched from get_alias_columns ');

1553: EXIT WHEN get_alias_columns%NOTFOUND;
1554:
1555: IF g_debug
1556: THEN
1557: hr_utility.trace('Fetched from get_alias_columns ');
1558: END IF;
1559:
1560: dynamic_cursor := dynamic_cursor||l_alias_column||',
1561: ';

Line 1599: hr_utility.trace('Dynamic Pl/Sql block created ');

1595: dynamic_core3;
1596:
1597: IF g_debug
1598: THEN
1599: hr_utility.trace('Dynamic Pl/Sql block created ');
1600: hr_utility.trace('-----------------------------');
1601: hr_utility.trace(' ');
1602: hr_utility.trace(dynamic_header);
1603: hr_utility.trace(dynamic_cursor);

Line 1600: hr_utility.trace('-----------------------------');

1596:
1597: IF g_debug
1598: THEN
1599: hr_utility.trace('Dynamic Pl/Sql block created ');
1600: hr_utility.trace('-----------------------------');
1601: hr_utility.trace(' ');
1602: hr_utility.trace(dynamic_header);
1603: hr_utility.trace(dynamic_cursor);
1604: hr_utility.trace(dynamic_where);

Line 1601: hr_utility.trace(' ');

1597: IF g_debug
1598: THEN
1599: hr_utility.trace('Dynamic Pl/Sql block created ');
1600: hr_utility.trace('-----------------------------');
1601: hr_utility.trace(' ');
1602: hr_utility.trace(dynamic_header);
1603: hr_utility.trace(dynamic_cursor);
1604: hr_utility.trace(dynamic_where);
1605: hr_utility.trace(dynamic_cursor2_head);

Line 1602: hr_utility.trace(dynamic_header);

1598: THEN
1599: hr_utility.trace('Dynamic Pl/Sql block created ');
1600: hr_utility.trace('-----------------------------');
1601: hr_utility.trace(' ');
1602: hr_utility.trace(dynamic_header);
1603: hr_utility.trace(dynamic_cursor);
1604: hr_utility.trace(dynamic_where);
1605: hr_utility.trace(dynamic_cursor2_head);
1606: hr_utility.trace(dynamic_cursor2);

Line 1603: hr_utility.trace(dynamic_cursor);

1599: hr_utility.trace('Dynamic Pl/Sql block created ');
1600: hr_utility.trace('-----------------------------');
1601: hr_utility.trace(' ');
1602: hr_utility.trace(dynamic_header);
1603: hr_utility.trace(dynamic_cursor);
1604: hr_utility.trace(dynamic_where);
1605: hr_utility.trace(dynamic_cursor2_head);
1606: hr_utility.trace(dynamic_cursor2);
1607: hr_utility.trace(dynamic_core);

Line 1604: hr_utility.trace(dynamic_where);

1600: hr_utility.trace('-----------------------------');
1601: hr_utility.trace(' ');
1602: hr_utility.trace(dynamic_header);
1603: hr_utility.trace(dynamic_cursor);
1604: hr_utility.trace(dynamic_where);
1605: hr_utility.trace(dynamic_cursor2_head);
1606: hr_utility.trace(dynamic_cursor2);
1607: hr_utility.trace(dynamic_core);
1608: hr_utility.trace(dynamic_core2);

Line 1605: hr_utility.trace(dynamic_cursor2_head);

1601: hr_utility.trace(' ');
1602: hr_utility.trace(dynamic_header);
1603: hr_utility.trace(dynamic_cursor);
1604: hr_utility.trace(dynamic_where);
1605: hr_utility.trace(dynamic_cursor2_head);
1606: hr_utility.trace(dynamic_cursor2);
1607: hr_utility.trace(dynamic_core);
1608: hr_utility.trace(dynamic_core2);
1609: hr_utility.trace(dynamic_core3);

Line 1606: hr_utility.trace(dynamic_cursor2);

1602: hr_utility.trace(dynamic_header);
1603: hr_utility.trace(dynamic_cursor);
1604: hr_utility.trace(dynamic_where);
1605: hr_utility.trace(dynamic_cursor2_head);
1606: hr_utility.trace(dynamic_cursor2);
1607: hr_utility.trace(dynamic_core);
1608: hr_utility.trace(dynamic_core2);
1609: hr_utility.trace(dynamic_core3);
1610: END IF;

Line 1607: hr_utility.trace(dynamic_core);

1603: hr_utility.trace(dynamic_cursor);
1604: hr_utility.trace(dynamic_where);
1605: hr_utility.trace(dynamic_cursor2_head);
1606: hr_utility.trace(dynamic_cursor2);
1607: hr_utility.trace(dynamic_core);
1608: hr_utility.trace(dynamic_core2);
1609: hr_utility.trace(dynamic_core3);
1610: END IF;
1611:

Line 1608: hr_utility.trace(dynamic_core2);

1604: hr_utility.trace(dynamic_where);
1605: hr_utility.trace(dynamic_cursor2_head);
1606: hr_utility.trace(dynamic_cursor2);
1607: hr_utility.trace(dynamic_core);
1608: hr_utility.trace(dynamic_core2);
1609: hr_utility.trace(dynamic_core3);
1610: END IF;
1611:
1612: BEGIN

Line 1609: hr_utility.trace(dynamic_core3);

1605: hr_utility.trace(dynamic_cursor2_head);
1606: hr_utility.trace(dynamic_cursor2);
1607: hr_utility.trace(dynamic_core);
1608: hr_utility.trace(dynamic_core2);
1609: hr_utility.trace(dynamic_core3);
1610: END IF;
1611:
1612: BEGIN
1613:

Line 1618: hr_utility.trace('Execute Immediate in translate_aliases threw Sql Error :'

1614: EXECUTE IMMEDIATE dynamic_query;
1615:
1616: EXCEPTION
1617: WHEN OTHERS THEN
1618: hr_utility.trace('Execute Immediate in translate_aliases threw Sql Error :'
1619: ||SQLCODE);
1620: RAISE;
1621: END;
1622:

Line 1630: hr_utility.trace('translate_aliases completed alright ');

1626: END IF;
1627:
1628: IF g_debug
1629: THEN
1630: hr_utility.trace('translate_aliases completed alright ');
1631: END IF;
1632:
1633:
1634: EXCEPTION

Line 1636: hr_utility.trace('No Data Found in translate aliases, something wrong ');

1632:
1633:
1634: EXCEPTION
1635: WHEN NO_DATA_FOUND THEN
1636: hr_utility.trace('No Data Found in translate aliases, something wrong ');
1637:
1638: END translate_aliases;
1639:
1640:

Line 1684: hr_utility.trace('translate_cla_reasons');

1680: -- Update HXC_RPT_TC_DETAILS_ALL with the relevant lookup names
1681:
1682: IF g_debug
1683: THEN
1684: hr_utility.trace('translate_cla_reasons');
1685: END IF;
1686:
1687:
1688: OPEN get_cla_reasons;

Line 1698: hr_utility.trace('Fetched from get_cla_reasons ');

1694: CLOSE get_cla_reasons;
1695:
1696: IF g_debug
1697: THEN
1698: hr_utility.trace('Fetched from get_cla_reasons ');
1699: hr_utility.trace('Total Number of rows : '||l_meaning_tab.COUNT);
1700: END IF;
1701:
1702: IF l_meaning_tab.COUNT > 0

Line 1699: hr_utility.trace('Total Number of rows : '||l_meaning_tab.COUNT);

1695:
1696: IF g_debug
1697: THEN
1698: hr_utility.trace('Fetched from get_cla_reasons ');
1699: hr_utility.trace('Total Number of rows : '||l_meaning_tab.COUNT);
1700: END IF;
1701:
1702: IF l_meaning_tab.COUNT > 0
1703: THEN

Line 1720: hr_utility.trace('translate_cla_reasons completed alright');

1716: END IF;
1717:
1718: IF g_debug
1719: THEN
1720: hr_utility.trace('translate_cla_reasons completed alright');
1721: END IF;
1722:
1723:
1724: EXCEPTION

Line 1728: hr_utility.trace('No Data Found from translate_cla_reasons');

1724: EXCEPTION
1725: WHEN NO_DATA_FOUND THEN
1726: IF g_debug
1727: THEN
1728: hr_utility.trace('No Data Found from translate_cla_reasons');
1729: END IF;
1730:
1731: END translate_cla_reasons;
1732:

Line 1953: hr_utility.trace('update_transaction_ids');

1949:
1950:
1951: IF g_debug
1952: THEN
1953: hr_utility.trace('update_transaction_ids');
1954: END IF;
1955:
1956: OPEN get_transaction_details;
1957:

Line 1968: hr_utility.trace('Fetched from get_transaction_details ');

1964: CLOSE get_transaction_details;
1965:
1966: IF g_debug
1967: THEN
1968: hr_utility.trace('Fetched from get_transaction_details ');
1969: hr_utility.trace('Total Number of rows : '||det_trans_id_tab.COUNT);
1970: END IF;
1971:
1972: IF det_bb_id_tab.COUNT > 0

Line 1969: hr_utility.trace('Total Number of rows : '||det_trans_id_tab.COUNT);

1965:
1966: IF g_debug
1967: THEN
1968: hr_utility.trace('Fetched from get_transaction_details ');
1969: hr_utility.trace('Total Number of rows : '||det_trans_id_tab.COUNT);
1970: END IF;
1971:
1972: IF det_bb_id_tab.COUNT > 0
1973: THEN

Line 2006: hr_utility.trace('Fetched from get_transaction_details ');

2002: CLOSE get_old_transaction_details;
2003:
2004: IF g_debug
2005: THEN
2006: hr_utility.trace('Fetched from get_transaction_details ');
2007: hr_utility.trace('Total Number of rows : '||det_trans_id_tab.COUNT);
2008: END IF;
2009:
2010: IF det_bb_id_tab.COUNT > 0

Line 2007: hr_utility.trace('Total Number of rows : '||det_trans_id_tab.COUNT);

2003:
2004: IF g_debug
2005: THEN
2006: hr_utility.trace('Fetched from get_transaction_details ');
2007: hr_utility.trace('Total Number of rows : '||det_trans_id_tab.COUNT);
2008: END IF;
2009:
2010: IF det_bb_id_tab.COUNT > 0
2011: THEN

Line 2125: hr_utility.trace('update_transaction_ids completed alright');

2121:
2122:
2123: IF g_debug
2124: THEN
2125: hr_utility.trace('update_transaction_ids completed alright');
2126: END IF;
2127:
2128:
2129: EXCEPTION

Line 2133: hr_utility.trace('No Data Found from update_transaction_ids');

2129: EXCEPTION
2130: WHEN NO_DATA_FOUND THEN
2131: IF g_debug
2132: THEN
2133: hr_utility.trace('No Data Found from update_transaction_ids');
2134: END IF;
2135:
2136: END update_transaction_ids;
2137:

Line 2178: hr_utility.trace('translate_created_by');

2174: -- Update HXC_RPT_TC_DETAILS_ALL with the corresponding values.
2175:
2176: IF g_debug
2177: THEN
2178: hr_utility.trace('translate_created_by');
2179: END IF;
2180:
2181:
2182: OPEN get_created_user(g_request_id);

Line 2192: hr_utility.trace('Fetched from get_created_user ');

2188: CLOSE get_created_user;
2189:
2190: IF g_debug
2191: THEN
2192: hr_utility.trace('Fetched from get_created_user ');
2193: hr_utility.trace('Total number of rows fetched : '||l_bb_id_tab.COUNT);
2194: END IF;
2195:
2196: IF l_bb_id_tab.COUNT > 0

Line 2193: hr_utility.trace('Total number of rows fetched : '||l_bb_id_tab.COUNT);

2189:
2190: IF g_debug
2191: THEN
2192: hr_utility.trace('Fetched from get_created_user ');
2193: hr_utility.trace('Total number of rows fetched : '||l_bb_id_tab.COUNT);
2194: END IF;
2195:
2196: IF l_bb_id_tab.COUNT > 0
2197: THEN

Line 2212: hr_utility.trace('translate_created_by completed alright');

2208: END IF;
2209:
2210: IF g_debug
2211: THEN
2212: hr_utility.trace('translate_created_by completed alright');
2213: END IF;
2214:
2215:
2216: EXCEPTION

Line 2218: hr_utility.trace('No Data Found from translate_created_by, something wrong');

2214:
2215:
2216: EXCEPTION
2217: WHEN NO_DATA_FOUND THEN
2218: hr_utility.trace('No Data Found from translate_created_by, something wrong');
2219:
2220:
2221: END translate_created_by;
2222:

Line 2264: hr_utility.trace('translate_last_updated_by');

2260:
2261:
2262: IF g_debug
2263: THEN
2264: hr_utility.trace('translate_last_updated_by');
2265: END IF;
2266:
2267:
2268:

Line 2280: hr_utility.trace('Fetched from get_updated_user ');

2276:
2277:
2278: IF g_debug
2279: THEN
2280: hr_utility.trace('Fetched from get_updated_user ');
2281: hr_utility.trace('Total number of rows fetched : '||l_bb_id_tab.COUNT);
2282: END IF;
2283:
2284:

Line 2281: hr_utility.trace('Total number of rows fetched : '||l_bb_id_tab.COUNT);

2277:
2278: IF g_debug
2279: THEN
2280: hr_utility.trace('Fetched from get_updated_user ');
2281: hr_utility.trace('Total number of rows fetched : '||l_bb_id_tab.COUNT);
2282: END IF;
2283:
2284:
2285: IF l_bb_id_tab.COUNT > 0

Line 2302: hr_utility.trace('translate_last_updated_by completed alright');

2298:
2299:
2300: IF g_debug
2301: THEN
2302: hr_utility.trace('translate_last_updated_by completed alright');
2303: END IF;
2304:
2305:
2306: EXCEPTION

Line 2308: hr_utility.trace('No Data Found from translate_last_updated_by, something wrong');

2304:
2305:
2306: EXCEPTION
2307: WHEN NO_DATA_FOUND THEN
2308: hr_utility.trace('No Data Found from translate_last_updated_by, something wrong');
2309:
2310: END translate_last_updated_by;
2311:
2312:

Line 2337: hr_utility.trace('log_time_capture');

2333: -- insert a relevant record into HXC_RPT_TC_HIST_LOG.
2334:
2335: IF g_debug
2336: THEN
2337: hr_utility.trace('log_time_capture');
2338: END IF;
2339:
2340:
2341: UPDATE hxc_rpt_tc_hist_log

Line 2359: hr_utility.trace('Updated hxc_rpt_tc_hist_log ');

2355: stop_time_tab ;
2356:
2357: IF g_debug
2358: THEN
2359: hr_utility.trace('Updated hxc_rpt_tc_hist_log ');
2360: hr_utility.trace('Total Number of timecards updated here : '||resource_id_tab.COUNT);
2361: END IF;
2362:
2363: IF resource_id_tab.COUNT > 0

Line 2360: hr_utility.trace('Total Number of timecards updated here : '||resource_id_tab.COUNT);

2356:
2357: IF g_debug
2358: THEN
2359: hr_utility.trace('Updated hxc_rpt_tc_hist_log ');
2360: hr_utility.trace('Total Number of timecards updated here : '||resource_id_tab.COUNT);
2361: END IF;
2362:
2363: IF resource_id_tab.COUNT > 0
2364: THEN

Line 2397: hr_utility.trace('log_time_capture completed alright');

2393:
2394:
2395: IF g_debug
2396: THEN
2397: hr_utility.trace('log_time_capture completed alright');
2398: END IF;
2399:
2400: EXCEPTION
2401: WHEN NO_DATA_FOUND THEN

Line 2404: hr_utility.trace('No Data Found from log_time_capture ');

2400: EXCEPTION
2401: WHEN NO_DATA_FOUND THEN
2402: IF g_debug
2403: THEN
2404: hr_utility.trace('No Data Found from log_time_capture ');
2405: END IF;
2406:
2407: END log_time_capture;
2408:

Line 2472: hr_utility.trace('Load Timecard Snapshot ');

2468: g_request_id := FND_GLOBAL.CONC_PRIORITY_REQUEST;
2469:
2470: IF g_debug
2471: THEN
2472: hr_utility.trace('Load Timecard Snapshot ');
2473: hr_utility.trace('Parameters');
2474: hr_utility.trace('==========');
2475: hr_utility.trace('p_date_from '||p_date_from);
2476: hr_utility.trace('p_date_to '||p_date_to);

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

2469:
2470: IF g_debug
2471: THEN
2472: hr_utility.trace('Load Timecard Snapshot ');
2473: hr_utility.trace('Parameters');
2474: hr_utility.trace('==========');
2475: hr_utility.trace('p_date_from '||p_date_from);
2476: hr_utility.trace('p_date_to '||p_date_to);
2477: hr_utility.trace('p_data_regen '||p_data_regen);

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

2470: IF g_debug
2471: THEN
2472: hr_utility.trace('Load Timecard Snapshot ');
2473: hr_utility.trace('Parameters');
2474: hr_utility.trace('==========');
2475: hr_utility.trace('p_date_from '||p_date_from);
2476: hr_utility.trace('p_date_to '||p_date_to);
2477: hr_utility.trace('p_data_regen '||p_data_regen);
2478: hr_utility.trace('p_record_save '||p_record_save);

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

2471: THEN
2472: hr_utility.trace('Load Timecard Snapshot ');
2473: hr_utility.trace('Parameters');
2474: hr_utility.trace('==========');
2475: hr_utility.trace('p_date_from '||p_date_from);
2476: hr_utility.trace('p_date_to '||p_date_to);
2477: hr_utility.trace('p_data_regen '||p_data_regen);
2478: hr_utility.trace('p_record_save '||p_record_save);
2479: hr_utility.trace('p_org_id '||p_org_id);

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

2472: hr_utility.trace('Load Timecard Snapshot ');
2473: hr_utility.trace('Parameters');
2474: hr_utility.trace('==========');
2475: hr_utility.trace('p_date_from '||p_date_from);
2476: hr_utility.trace('p_date_to '||p_date_to);
2477: hr_utility.trace('p_data_regen '||p_data_regen);
2478: hr_utility.trace('p_record_save '||p_record_save);
2479: hr_utility.trace('p_org_id '||p_org_id);
2480: hr_utility.trace('p_locn_id '||p_locn_id);

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

2473: hr_utility.trace('Parameters');
2474: hr_utility.trace('==========');
2475: hr_utility.trace('p_date_from '||p_date_from);
2476: hr_utility.trace('p_date_to '||p_date_to);
2477: hr_utility.trace('p_data_regen '||p_data_regen);
2478: hr_utility.trace('p_record_save '||p_record_save);
2479: hr_utility.trace('p_org_id '||p_org_id);
2480: hr_utility.trace('p_locn_id '||p_locn_id);
2481: hr_utility.trace('p_payroll_id '||p_payroll_id);

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

2474: hr_utility.trace('==========');
2475: hr_utility.trace('p_date_from '||p_date_from);
2476: hr_utility.trace('p_date_to '||p_date_to);
2477: hr_utility.trace('p_data_regen '||p_data_regen);
2478: hr_utility.trace('p_record_save '||p_record_save);
2479: hr_utility.trace('p_org_id '||p_org_id);
2480: hr_utility.trace('p_locn_id '||p_locn_id);
2481: hr_utility.trace('p_payroll_id '||p_payroll_id);
2482: hr_utility.trace('p_supervisor_id '||p_supervisor_id);

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

2475: hr_utility.trace('p_date_from '||p_date_from);
2476: hr_utility.trace('p_date_to '||p_date_to);
2477: hr_utility.trace('p_data_regen '||p_data_regen);
2478: hr_utility.trace('p_record_save '||p_record_save);
2479: hr_utility.trace('p_org_id '||p_org_id);
2480: hr_utility.trace('p_locn_id '||p_locn_id);
2481: hr_utility.trace('p_payroll_id '||p_payroll_id);
2482: hr_utility.trace('p_supervisor_id '||p_supervisor_id);
2483: hr_utility.trace('p_person_id '||p_person_id);

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

2476: hr_utility.trace('p_date_to '||p_date_to);
2477: hr_utility.trace('p_data_regen '||p_data_regen);
2478: hr_utility.trace('p_record_save '||p_record_save);
2479: hr_utility.trace('p_org_id '||p_org_id);
2480: hr_utility.trace('p_locn_id '||p_locn_id);
2481: hr_utility.trace('p_payroll_id '||p_payroll_id);
2482: hr_utility.trace('p_supervisor_id '||p_supervisor_id);
2483: hr_utility.trace('p_person_id '||p_person_id);
2484: hr_utility.trace('Priority Request Id '||g_request_id);

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

2477: hr_utility.trace('p_data_regen '||p_data_regen);
2478: hr_utility.trace('p_record_save '||p_record_save);
2479: hr_utility.trace('p_org_id '||p_org_id);
2480: hr_utility.trace('p_locn_id '||p_locn_id);
2481: hr_utility.trace('p_payroll_id '||p_payroll_id);
2482: hr_utility.trace('p_supervisor_id '||p_supervisor_id);
2483: hr_utility.trace('p_person_id '||p_person_id);
2484: hr_utility.trace('Priority Request Id '||g_request_id);
2485: hr_utility.trace('Request starts execution at '||

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

2478: hr_utility.trace('p_record_save '||p_record_save);
2479: hr_utility.trace('p_org_id '||p_org_id);
2480: hr_utility.trace('p_locn_id '||p_locn_id);
2481: hr_utility.trace('p_payroll_id '||p_payroll_id);
2482: hr_utility.trace('p_supervisor_id '||p_supervisor_id);
2483: hr_utility.trace('p_person_id '||p_person_id);
2484: hr_utility.trace('Priority Request Id '||g_request_id);
2485: hr_utility.trace('Request starts execution at '||
2486: TO_CHAR(g_request_sysdate,'dd-MON-yyyy HH:MI:SS'));

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

2479: hr_utility.trace('p_org_id '||p_org_id);
2480: hr_utility.trace('p_locn_id '||p_locn_id);
2481: hr_utility.trace('p_payroll_id '||p_payroll_id);
2482: hr_utility.trace('p_supervisor_id '||p_supervisor_id);
2483: hr_utility.trace('p_person_id '||p_person_id);
2484: hr_utility.trace('Priority Request Id '||g_request_id);
2485: hr_utility.trace('Request starts execution at '||
2486: TO_CHAR(g_request_sysdate,'dd-MON-yyyy HH:MI:SS'));
2487: END IF;

Line 2484: hr_utility.trace('Priority Request Id '||g_request_id);

2480: hr_utility.trace('p_locn_id '||p_locn_id);
2481: hr_utility.trace('p_payroll_id '||p_payroll_id);
2482: hr_utility.trace('p_supervisor_id '||p_supervisor_id);
2483: hr_utility.trace('p_person_id '||p_person_id);
2484: hr_utility.trace('Priority Request Id '||g_request_id);
2485: hr_utility.trace('Request starts execution at '||
2486: TO_CHAR(g_request_sysdate,'dd-MON-yyyy HH:MI:SS'));
2487: END IF;
2488:

Line 2485: hr_utility.trace('Request starts execution at '||

2481: hr_utility.trace('p_payroll_id '||p_payroll_id);
2482: hr_utility.trace('p_supervisor_id '||p_supervisor_id);
2483: hr_utility.trace('p_person_id '||p_person_id);
2484: hr_utility.trace('Priority Request Id '||g_request_id);
2485: hr_utility.trace('Request starts execution at '||
2486: TO_CHAR(g_request_sysdate,'dd-MON-yyyy HH:MI:SS'));
2487: END IF;
2488:
2489: resource_where_clause ( p_date_from => fnd_date.canonical_to_date(p_date_from)

Line 2502: hr_utility.trace('Clearing history...');

2498: IF p_data_regen = 'Y'
2499: THEN
2500: IF g_debug
2501: THEN
2502: hr_utility.trace('Clearing history...');
2503: END IF;
2504: clear_history_data;
2505: END IF;
2506:

Line 2512: hr_utility.trace('Cleared hxc_rpt_tc_resource_temp, just in case the last run crashed');

2508: DELETE FROM hxc_rpt_tc_resource_temp;
2509:
2510: IF g_debug
2511: THEN
2512: hr_utility.trace('Cleared hxc_rpt_tc_resource_temp, just in case the last run crashed');
2513: hr_utility.trace(SQLCODE);
2514: END IF;
2515:
2516:

Line 2513: hr_utility.trace(SQLCODE);

2509:
2510: IF g_debug
2511: THEN
2512: hr_utility.trace('Cleared hxc_rpt_tc_resource_temp, just in case the last run crashed');
2513: hr_utility.trace(SQLCODE);
2514: END IF;
2515:
2516:
2517: FOR i in g_res_list_cs.FIRST..g_res_list_cs.LAST

Line 2526: hr_utility.trace('Processing resource list '||i);

2522: IF (g_res_list_cs(i) IS NOT NULL) AND (g_res_list_cs(i) <> ' ')
2523: THEN
2524: IF g_debug
2525: THEN
2526: hr_utility.trace('Processing resource list '||i);
2527: hr_utility.trace(g_res_list_cs(i));
2528: END IF;
2529: load_tc_level_info ( p_resource_list => ltrim(g_res_list_cs(i),' ,'),
2530: p_tc_from => fnd_date.canonical_to_date(p_date_from),

Line 2527: hr_utility.trace(g_res_list_cs(i));

2523: THEN
2524: IF g_debug
2525: THEN
2526: hr_utility.trace('Processing resource list '||i);
2527: hr_utility.trace(g_res_list_cs(i));
2528: END IF;
2529: load_tc_level_info ( p_resource_list => ltrim(g_res_list_cs(i),' ,'),
2530: p_tc_from => fnd_date.canonical_to_date(p_date_from),
2531: p_tc_to => fnd_date.canonical_to_date(p_date_to),

Line 2544: hr_utility.trace('No timecards exist for this resource list ');

2540: IF timecard_exists = 0
2541: THEN
2542: IF g_debug
2543: THEN
2544: hr_utility.trace('No timecards exist for this resource list ');
2545: hr_utility.trace(g_res_list_cs(i));
2546: END IF;
2547:
2548: ELSE

Line 2545: hr_utility.trace(g_res_list_cs(i));

2541: THEN
2542: IF g_debug
2543: THEN
2544: hr_utility.trace('No timecards exist for this resource list ');
2545: hr_utility.trace(g_res_list_cs(i));
2546: END IF;
2547:
2548: ELSE
2549:

Line 2556: hr_utility.trace('Using history data, so update Last Touched Dates');

2552: IF p_data_regen <> 'Y'
2553: THEN
2554: IF g_debug
2555: THEN
2556: hr_utility.trace('Using history data, so update Last Touched Dates');
2557: END IF;
2558: update_last_touched_date;
2559: END IF;
2560:

Line 2579: hr_utility.trace('Processing Layout '||l_layout_id);

2575: EXIT WHEN get_layout_ids%NOTFOUND;
2576:
2577: IF g_debug
2578: THEN
2579: hr_utility.trace('Processing Layout '||l_layout_id);
2580: END IF;
2581:
2582: populate_attributes (p_layout_id => l_layout_id,
2583: p_alias_tab => l_alias_tab);

Line 2592: hr_utility.trace('Error Stack ');

2588: p_alias_tab => l_alias_tab);
2589:
2590: EXCEPTION
2591: WHEN OTHERS THEN
2592: hr_utility.trace('Error Stack ');
2593: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2594: hr_utility.trace('Exception '||SQLERRM||' while processing layout '||l_layout_id);
2595: END;
2596:

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

2589:
2590: EXCEPTION
2591: WHEN OTHERS THEN
2592: hr_utility.trace('Error Stack ');
2593: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2594: hr_utility.trace('Exception '||SQLERRM||' while processing layout '||l_layout_id);
2595: END;
2596:
2597: END LOOP;

Line 2594: hr_utility.trace('Exception '||SQLERRM||' while processing layout '||l_layout_id);

2590: EXCEPTION
2591: WHEN OTHERS THEN
2592: hr_utility.trace('Error Stack ');
2593: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2594: hr_utility.trace('Exception '||SQLERRM||' while processing layout '||l_layout_id);
2595: END;
2596:
2597: END LOOP;
2598: CLOSE get_layout_ids;

Line 2609: hr_utility.trace('Finished processing for resource list '||i);

2605: p_request_sysdate => g_request_sysdate );
2606:
2607: IF g_debug
2608: THEN
2609: hr_utility.trace('Finished processing for resource list '||i);
2610: hr_utility.trace('Clear the resource table and COMMIT the data collection ');
2611: END IF;
2612: DELETE FROM hxc_rpt_tc_resource_temp;
2613: COMMIT;

Line 2610: hr_utility.trace('Clear the resource table and COMMIT the data collection ');

2606:
2607: IF g_debug
2608: THEN
2609: hr_utility.trace('Finished processing for resource list '||i);
2610: hr_utility.trace('Clear the resource table and COMMIT the data collection ');
2611: END IF;
2612: DELETE FROM hxc_rpt_tc_resource_temp;
2613: COMMIT;
2614: END IF;

Line 2620: hr_utility.trace('Error Stack ');

2616: END IF;
2617:
2618: EXCEPTION
2619: WHEN OTHERS THEN
2620: hr_utility.trace('Error Stack ');
2621: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2622: hr_utility.trace('Exception '||SQLERRM||' while processing the following list ');
2623: hr_utility.trace(g_res_list_cs(i));
2624: END;

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

2617:
2618: EXCEPTION
2619: WHEN OTHERS THEN
2620: hr_utility.trace('Error Stack ');
2621: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2622: hr_utility.trace('Exception '||SQLERRM||' while processing the following list ');
2623: hr_utility.trace(g_res_list_cs(i));
2624: END;
2625:

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

2618: EXCEPTION
2619: WHEN OTHERS THEN
2620: hr_utility.trace('Error Stack ');
2621: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2622: hr_utility.trace('Exception '||SQLERRM||' while processing the following list ');
2623: hr_utility.trace(g_res_list_cs(i));
2624: END;
2625:
2626:

Line 2623: hr_utility.trace(g_res_list_cs(i));

2619: WHEN OTHERS THEN
2620: hr_utility.trace('Error Stack ');
2621: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2622: hr_utility.trace('Exception '||SQLERRM||' while processing the following list ');
2623: hr_utility.trace(g_res_list_cs(i));
2624: END;
2625:
2626:
2627: END LOOP;

Line 2631: hr_utility.trace('Request Finishes execution at '||to_char(SYSDATE,'dd-MON-yyyy HH:MI:SS')

2627: END LOOP;
2628:
2629: IF g_debug
2630: THEN
2631: hr_utility.trace('Request Finishes execution at '||to_char(SYSDATE,'dd-MON-yyyy HH:MI:SS')
2632: ||' and took '||ROUND(((SYSDATE-g_request_sysdate)*24*60),2)||' minutes to complete');
2633: END IF;
2634:
2635: