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

Line 6: g_debug BOOLEAN := hr_utility.debug_enabled;

2: /* $Header: hxcrpttcsnpsht.pkb 120.12.12010000.5 2009/01/21 10:06:20 asrajago 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 510: hr_utility.trace('Starting update_last_touched_date');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1103: hr_utility.trace(' ');

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

Line 1104: hr_utility.trace(dynamic_header);

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

Line 1105: hr_utility.trace(dynamic_cursor_select);

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

Line 1106: hr_utility.trace(dynamic_cursor_where);

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

Line 1107: hr_utility.trace(dynamic_cursor_group_by);

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

Line 1108: hr_utility.trace(dynamic_cursor_open);

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

Line 1109: hr_utility.trace(dynamic_cursor_close);

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

Line 1110: hr_utility.trace(dynamic_update);

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

Line 1111: hr_utility.trace(dynamic_update_where);

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

Line 1112: hr_utility.trace(dynamic_footer);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1204: hr_utility.trace(l_update);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1599: hr_utility.trace(' ');

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

Line 1600: hr_utility.trace(dynamic_header);

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

Line 1601: hr_utility.trace(dynamic_cursor);

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

Line 1602: hr_utility.trace(dynamic_where);

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

Line 1603: hr_utility.trace(dynamic_cursor2_head);

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

Line 1604: hr_utility.trace(dynamic_cursor2);

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

Line 1605: hr_utility.trace(dynamic_core);

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

Line 1606: hr_utility.trace(dynamic_core2);

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

Line 1607: hr_utility.trace(dynamic_core3);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1917:
1918:
1919: IF g_debug
1920: THEN
1921: hr_utility.trace('update_transaction_ids');
1922: END IF;
1923:
1924: OPEN get_transaction_details;
1925:

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

1932: CLOSE get_transaction_details;
1933:
1934: IF g_debug
1935: THEN
1936: hr_utility.trace('Fetched from get_transaction_details ');
1937: hr_utility.trace('Total Number of rows : '||det_trans_id_tab.COUNT);
1938: END IF;
1939:
1940: IF det_bb_id_tab.COUNT > 0

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

1933:
1934: IF g_debug
1935: THEN
1936: hr_utility.trace('Fetched from get_transaction_details ');
1937: hr_utility.trace('Total Number of rows : '||det_trans_id_tab.COUNT);
1938: END IF;
1939:
1940: IF det_bb_id_tab.COUNT > 0
1941: THEN

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

2049:
2050:
2051: IF g_debug
2052: THEN
2053: hr_utility.trace('update_transaction_ids completed alright');
2054: END IF;
2055:
2056:
2057: EXCEPTION

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

2057: EXCEPTION
2058: WHEN NO_DATA_FOUND THEN
2059: IF g_debug
2060: THEN
2061: hr_utility.trace('No Data Found from update_transaction_ids');
2062: END IF;
2063:
2064: END update_transaction_ids;
2065:

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

2102: -- Update HXC_RPT_TC_DETAILS_ALL with the corresponding values.
2103:
2104: IF g_debug
2105: THEN
2106: hr_utility.trace('translate_created_by');
2107: END IF;
2108:
2109:
2110: OPEN get_created_user(g_request_id);

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

2116: CLOSE get_created_user;
2117:
2118: IF g_debug
2119: THEN
2120: hr_utility.trace('Fetched from get_created_user ');
2121: hr_utility.trace('Total number of rows fetched : '||l_bb_id_tab.COUNT);
2122: END IF;
2123:
2124: IF l_bb_id_tab.COUNT > 0

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

2117:
2118: IF g_debug
2119: THEN
2120: hr_utility.trace('Fetched from get_created_user ');
2121: hr_utility.trace('Total number of rows fetched : '||l_bb_id_tab.COUNT);
2122: END IF;
2123:
2124: IF l_bb_id_tab.COUNT > 0
2125: THEN

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

2136: END IF;
2137:
2138: IF g_debug
2139: THEN
2140: hr_utility.trace('translate_created_by completed alright');
2141: END IF;
2142:
2143:
2144: EXCEPTION

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

2142:
2143:
2144: EXCEPTION
2145: WHEN NO_DATA_FOUND THEN
2146: hr_utility.trace('No Data Found from translate_created_by, something wrong');
2147:
2148:
2149: END translate_created_by;
2150:

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

2188:
2189:
2190: IF g_debug
2191: THEN
2192: hr_utility.trace('translate_last_updated_by');
2193: END IF;
2194:
2195:
2196:

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

2204:
2205:
2206: IF g_debug
2207: THEN
2208: hr_utility.trace('Fetched from get_updated_user ');
2209: hr_utility.trace('Total number of rows fetched : '||l_bb_id_tab.COUNT);
2210: END IF;
2211:
2212:

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

2205:
2206: IF g_debug
2207: THEN
2208: hr_utility.trace('Fetched from get_updated_user ');
2209: hr_utility.trace('Total number of rows fetched : '||l_bb_id_tab.COUNT);
2210: END IF;
2211:
2212:
2213: IF l_bb_id_tab.COUNT > 0

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

2226:
2227:
2228: IF g_debug
2229: THEN
2230: hr_utility.trace('translate_last_updated_by completed alright');
2231: END IF;
2232:
2233:
2234: EXCEPTION

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

2232:
2233:
2234: EXCEPTION
2235: WHEN NO_DATA_FOUND THEN
2236: hr_utility.trace('No Data Found from translate_last_updated_by, something wrong');
2237:
2238: END translate_last_updated_by;
2239:
2240:

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

2261: -- insert a relevant record into HXC_RPT_TC_HIST_LOG.
2262:
2263: IF g_debug
2264: THEN
2265: hr_utility.trace('log_time_capture');
2266: END IF;
2267:
2268:
2269: UPDATE hxc_rpt_tc_hist_log

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

2283: stop_time_tab ;
2284:
2285: IF g_debug
2286: THEN
2287: hr_utility.trace('Updated hxc_rpt_tc_hist_log ');
2288: hr_utility.trace('Total Number of timecards updated here : '||resource_id_tab.COUNT);
2289: END IF;
2290:
2291: IF resource_id_tab.COUNT > 0

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

2284:
2285: IF g_debug
2286: THEN
2287: hr_utility.trace('Updated hxc_rpt_tc_hist_log ');
2288: hr_utility.trace('Total Number of timecards updated here : '||resource_id_tab.COUNT);
2289: END IF;
2290:
2291: IF resource_id_tab.COUNT > 0
2292: THEN

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

2321:
2322:
2323: IF g_debug
2324: THEN
2325: hr_utility.trace('log_time_capture completed alright');
2326: END IF;
2327:
2328: EXCEPTION
2329: WHEN NO_DATA_FOUND THEN

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

2328: EXCEPTION
2329: WHEN NO_DATA_FOUND THEN
2330: IF g_debug
2331: THEN
2332: hr_utility.trace('No Data Found from log_time_capture ');
2333: END IF;
2334:
2335: END log_time_capture;
2336:

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

2396: g_request_id := FND_GLOBAL.CONC_PRIORITY_REQUEST;
2397:
2398: IF g_debug
2399: THEN
2400: hr_utility.trace('Load Timecard Snapshot ');
2401: hr_utility.trace('Parameters');
2402: hr_utility.trace('==========');
2403: hr_utility.trace('p_date_from '||p_date_from);
2404: hr_utility.trace('p_date_to '||p_date_to);

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

2397:
2398: IF g_debug
2399: THEN
2400: hr_utility.trace('Load Timecard Snapshot ');
2401: hr_utility.trace('Parameters');
2402: hr_utility.trace('==========');
2403: hr_utility.trace('p_date_from '||p_date_from);
2404: hr_utility.trace('p_date_to '||p_date_to);
2405: hr_utility.trace('p_data_regen '||p_data_regen);

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

2398: IF g_debug
2399: THEN
2400: hr_utility.trace('Load Timecard Snapshot ');
2401: hr_utility.trace('Parameters');
2402: hr_utility.trace('==========');
2403: hr_utility.trace('p_date_from '||p_date_from);
2404: hr_utility.trace('p_date_to '||p_date_to);
2405: hr_utility.trace('p_data_regen '||p_data_regen);
2406: hr_utility.trace('p_record_save '||p_record_save);

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

2399: THEN
2400: hr_utility.trace('Load Timecard Snapshot ');
2401: hr_utility.trace('Parameters');
2402: hr_utility.trace('==========');
2403: hr_utility.trace('p_date_from '||p_date_from);
2404: hr_utility.trace('p_date_to '||p_date_to);
2405: hr_utility.trace('p_data_regen '||p_data_regen);
2406: hr_utility.trace('p_record_save '||p_record_save);
2407: hr_utility.trace('p_org_id '||p_org_id);

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

2400: hr_utility.trace('Load Timecard Snapshot ');
2401: hr_utility.trace('Parameters');
2402: hr_utility.trace('==========');
2403: hr_utility.trace('p_date_from '||p_date_from);
2404: hr_utility.trace('p_date_to '||p_date_to);
2405: hr_utility.trace('p_data_regen '||p_data_regen);
2406: hr_utility.trace('p_record_save '||p_record_save);
2407: hr_utility.trace('p_org_id '||p_org_id);
2408: hr_utility.trace('p_locn_id '||p_locn_id);

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

2401: hr_utility.trace('Parameters');
2402: hr_utility.trace('==========');
2403: hr_utility.trace('p_date_from '||p_date_from);
2404: hr_utility.trace('p_date_to '||p_date_to);
2405: hr_utility.trace('p_data_regen '||p_data_regen);
2406: hr_utility.trace('p_record_save '||p_record_save);
2407: hr_utility.trace('p_org_id '||p_org_id);
2408: hr_utility.trace('p_locn_id '||p_locn_id);
2409: hr_utility.trace('p_payroll_id '||p_payroll_id);

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

2402: hr_utility.trace('==========');
2403: hr_utility.trace('p_date_from '||p_date_from);
2404: hr_utility.trace('p_date_to '||p_date_to);
2405: hr_utility.trace('p_data_regen '||p_data_regen);
2406: hr_utility.trace('p_record_save '||p_record_save);
2407: hr_utility.trace('p_org_id '||p_org_id);
2408: hr_utility.trace('p_locn_id '||p_locn_id);
2409: hr_utility.trace('p_payroll_id '||p_payroll_id);
2410: hr_utility.trace('p_supervisor_id '||p_supervisor_id);

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

2403: hr_utility.trace('p_date_from '||p_date_from);
2404: hr_utility.trace('p_date_to '||p_date_to);
2405: hr_utility.trace('p_data_regen '||p_data_regen);
2406: hr_utility.trace('p_record_save '||p_record_save);
2407: hr_utility.trace('p_org_id '||p_org_id);
2408: hr_utility.trace('p_locn_id '||p_locn_id);
2409: hr_utility.trace('p_payroll_id '||p_payroll_id);
2410: hr_utility.trace('p_supervisor_id '||p_supervisor_id);
2411: hr_utility.trace('p_person_id '||p_person_id);

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

2404: hr_utility.trace('p_date_to '||p_date_to);
2405: hr_utility.trace('p_data_regen '||p_data_regen);
2406: hr_utility.trace('p_record_save '||p_record_save);
2407: hr_utility.trace('p_org_id '||p_org_id);
2408: hr_utility.trace('p_locn_id '||p_locn_id);
2409: hr_utility.trace('p_payroll_id '||p_payroll_id);
2410: hr_utility.trace('p_supervisor_id '||p_supervisor_id);
2411: hr_utility.trace('p_person_id '||p_person_id);
2412: hr_utility.trace('Priority Request Id '||g_request_id);

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

2405: hr_utility.trace('p_data_regen '||p_data_regen);
2406: hr_utility.trace('p_record_save '||p_record_save);
2407: hr_utility.trace('p_org_id '||p_org_id);
2408: hr_utility.trace('p_locn_id '||p_locn_id);
2409: hr_utility.trace('p_payroll_id '||p_payroll_id);
2410: hr_utility.trace('p_supervisor_id '||p_supervisor_id);
2411: hr_utility.trace('p_person_id '||p_person_id);
2412: hr_utility.trace('Priority Request Id '||g_request_id);
2413: hr_utility.trace('Request starts execution at '||

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

2406: hr_utility.trace('p_record_save '||p_record_save);
2407: hr_utility.trace('p_org_id '||p_org_id);
2408: hr_utility.trace('p_locn_id '||p_locn_id);
2409: hr_utility.trace('p_payroll_id '||p_payroll_id);
2410: hr_utility.trace('p_supervisor_id '||p_supervisor_id);
2411: hr_utility.trace('p_person_id '||p_person_id);
2412: hr_utility.trace('Priority Request Id '||g_request_id);
2413: hr_utility.trace('Request starts execution at '||
2414: TO_CHAR(g_request_sysdate,'dd-MON-yyyy HH:MI:SS'));

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

2407: hr_utility.trace('p_org_id '||p_org_id);
2408: hr_utility.trace('p_locn_id '||p_locn_id);
2409: hr_utility.trace('p_payroll_id '||p_payroll_id);
2410: hr_utility.trace('p_supervisor_id '||p_supervisor_id);
2411: hr_utility.trace('p_person_id '||p_person_id);
2412: hr_utility.trace('Priority Request Id '||g_request_id);
2413: hr_utility.trace('Request starts execution at '||
2414: TO_CHAR(g_request_sysdate,'dd-MON-yyyy HH:MI:SS'));
2415: END IF;

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

2408: hr_utility.trace('p_locn_id '||p_locn_id);
2409: hr_utility.trace('p_payroll_id '||p_payroll_id);
2410: hr_utility.trace('p_supervisor_id '||p_supervisor_id);
2411: hr_utility.trace('p_person_id '||p_person_id);
2412: hr_utility.trace('Priority Request Id '||g_request_id);
2413: hr_utility.trace('Request starts execution at '||
2414: TO_CHAR(g_request_sysdate,'dd-MON-yyyy HH:MI:SS'));
2415: END IF;
2416:

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

2409: hr_utility.trace('p_payroll_id '||p_payroll_id);
2410: hr_utility.trace('p_supervisor_id '||p_supervisor_id);
2411: hr_utility.trace('p_person_id '||p_person_id);
2412: hr_utility.trace('Priority Request Id '||g_request_id);
2413: hr_utility.trace('Request starts execution at '||
2414: TO_CHAR(g_request_sysdate,'dd-MON-yyyy HH:MI:SS'));
2415: END IF;
2416:
2417: resource_where_clause ( p_date_from => fnd_date.canonical_to_date(p_date_from)

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

2426: IF p_data_regen = 'Y'
2427: THEN
2428: IF g_debug
2429: THEN
2430: hr_utility.trace('Clearing history...');
2431: END IF;
2432: clear_history_data;
2433: END IF;
2434:

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

2436: DELETE FROM hxc_rpt_tc_resource_temp;
2437:
2438: IF g_debug
2439: THEN
2440: hr_utility.trace('Cleared hxc_rpt_tc_resource_temp, just in case the last run crashed');
2441: hr_utility.trace(SQLCODE);
2442: END IF;
2443:
2444:

Line 2441: hr_utility.trace(SQLCODE);

2437:
2438: IF g_debug
2439: THEN
2440: hr_utility.trace('Cleared hxc_rpt_tc_resource_temp, just in case the last run crashed');
2441: hr_utility.trace(SQLCODE);
2442: END IF;
2443:
2444:
2445: FOR i in g_res_list_cs.FIRST..g_res_list_cs.LAST

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

2447: IF (g_res_list_cs(i) IS NOT NULL) AND (g_res_list_cs(i) <> ' ')
2448: THEN
2449: IF g_debug
2450: THEN
2451: hr_utility.trace('Processing resource list '||i);
2452: hr_utility.trace(g_res_list_cs(i));
2453: END IF;
2454: load_tc_level_info ( p_resource_list => ltrim(g_res_list_cs(i),' ,'),
2455: p_tc_from => fnd_date.canonical_to_date(p_date_from),

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

2448: THEN
2449: IF g_debug
2450: THEN
2451: hr_utility.trace('Processing resource list '||i);
2452: hr_utility.trace(g_res_list_cs(i));
2453: END IF;
2454: load_tc_level_info ( p_resource_list => ltrim(g_res_list_cs(i),' ,'),
2455: p_tc_from => fnd_date.canonical_to_date(p_date_from),
2456: p_tc_to => fnd_date.canonical_to_date(p_date_to),

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

2465: IF timecard_exists = 0
2466: THEN
2467: IF g_debug
2468: THEN
2469: hr_utility.trace('No timecards exist for this resource list ');
2470: hr_utility.trace(g_res_list_cs(i));
2471: END IF;
2472:
2473: ELSE

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

2466: THEN
2467: IF g_debug
2468: THEN
2469: hr_utility.trace('No timecards exist for this resource list ');
2470: hr_utility.trace(g_res_list_cs(i));
2471: END IF;
2472:
2473: ELSE
2474:

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

2477: IF p_data_regen <> 'Y'
2478: THEN
2479: IF g_debug
2480: THEN
2481: hr_utility.trace('Using history data, so update Last Touched Dates');
2482: END IF;
2483: update_last_touched_date;
2484: END IF;
2485:

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

2496: EXIT WHEN get_layout_ids%NOTFOUND;
2497:
2498: IF g_debug
2499: THEN
2500: hr_utility.trace('Processing Layout '||l_layout_id);
2501: END IF;
2502:
2503: populate_attributes (p_layout_id => l_layout_id,
2504: p_alias_tab => l_alias_tab);

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

2519: p_request_sysdate => g_request_sysdate );
2520:
2521: IF g_debug
2522: THEN
2523: hr_utility.trace('Finished processing for resource list '||i);
2524: hr_utility.trace('Clear the resource table and COMMIT the data collection ');
2525: END IF;
2526: DELETE FROM hxc_rpt_tc_resource_temp;
2527: COMMIT;

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

2520:
2521: IF g_debug
2522: THEN
2523: hr_utility.trace('Finished processing for resource list '||i);
2524: hr_utility.trace('Clear the resource table and COMMIT the data collection ');
2525: END IF;
2526: DELETE FROM hxc_rpt_tc_resource_temp;
2527: COMMIT;
2528: END IF;

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

2532: END LOOP;
2533:
2534: IF g_debug
2535: THEN
2536: hr_utility.trace('Request Finishes execution at '||to_char(SYSDATE,'dd-MON-yyyy HH:MI:SS')
2537: ||' and took '||ROUND(((SYSDATE-g_request_sysdate)*24*60),2)||' minutes to complete');
2538: END IF;
2539:
2540: