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.PAY_SG_AWCAP_ARCHIVE dependencies on HR_UTILITY

Line 82: hr_utility.set_location(l_proc_name||' Start of procedure',10);

78: order by pap.person_id ' ;
79: begin
80: l_proc_name := l_package || 'range_code';
81: if g_debug then
82: hr_utility.set_location(l_proc_name||' Start of procedure',10);
83: end if;
84: p_sql := c_range_cursor ;
85: if g_debug then
86: hr_utility.set_location(l_proc_name||' End of procedure',20);

Line 86: hr_utility.set_location(l_proc_name||' End of procedure',20);

82: hr_utility.set_location(l_proc_name||' Start of procedure',10);
83: end if;
84: p_sql := c_range_cursor ;
85: if g_debug then
86: hr_utility.set_location(l_proc_name||' End of procedure',20);
87: end if;
88: end range_code ;
89: ------------------------------------------------------------
90: -- Assignment Action Code

Line 132: hr_utility.set_location(l_proc_name || ' Start of assignment_action_code',30);

128: l_proc_name := l_package || 'assignment_action_code';
129: pay_sg_awcap_archive.initialization_code(p_payroll_action_id) ;
130: --
131: if g_debug then
132: hr_utility.set_location(l_proc_name || ' Start of assignment_action_code',30);
133: end if;
134: --
135: for i in c_assact
136: loop

Line 142: hr_utility.set_location(l_proc_name|| ' Before calling hr_nonrun_asact.insact',10);

138: fetch next_action_id into l_next_action_id;
139: close next_action_id;
140: --
141: if g_debug then
142: hr_utility.set_location(l_proc_name|| ' Before calling hr_nonrun_asact.insact',10);
143: end if;
144: --
145: hr_nonrun_asact.insact( l_next_action_id,
146: i.assignment_id,

Line 152: hr_utility.set_location(l_proc_name||' After calling hr_nonrun_asact.insact',20);

148: p_chunk,
149: g_pact.legal_entity_id);
150: --
151: if g_debug then
152: hr_utility.set_location(l_proc_name||' After calling hr_nonrun_asact.insact',20);
153: end if;
154: --
155: end loop;
156: --

Line 158: hr_utility.set_location(l_proc_name|| ' End of assignment_action_code',30);

154: --
155: end loop;
156: --
157: if g_debug then
158: hr_utility.set_location(l_proc_name|| ' End of assignment_action_code',30);
159: end if;
160: exception
161: when others then
162: if g_debug then

Line 163: hr_utility.set_location(l_proc_name||' Error raised in assignment_action_code procedure',40);

159: end if;
160: exception
161: when others then
162: if g_debug then
163: hr_utility.set_location(l_proc_name||' Error raised in assignment_action_code procedure',40);
164: end if;
165: raise;
166: end assignment_action_code ;
167: --

Line 179: g_debug := hr_utility.debug_enabled;

175: l_proc_name varchar2(100) ;
176: begin
177: l_proc_name := l_package || 'initialization_code';
178:
179: g_debug := hr_utility.debug_enabled;
180: --
181: if g_debug then
182: hr_utility.set_location(l_proc_name||' Start of procedure',10);
183: end if;

Line 182: hr_utility.set_location(l_proc_name||' Start of procedure',10);

178:
179: g_debug := hr_utility.debug_enabled;
180: --
181: if g_debug then
182: hr_utility.set_location(l_proc_name||' Start of procedure',10);
183: end if;
184: --
185: if g_pact.report_type is null then
186: select ppa.report_type,

Line 203: hr_utility.set_location(l_proc_name||' End of procedure',20);

199: where ppa.payroll_action_id = p_payroll_action_id;
200: end if ;
201: --
202: if g_debug then
203: hr_utility.set_location(l_proc_name||' End of procedure',20);
204: end if;
205: exception
206: when others then
207: if g_debug then

Line 208: hr_utility.set_location(l_proc_name||' Error in procedure',100);

204: end if;
205: exception
206: when others then
207: if g_debug then
208: hr_utility.set_location(l_proc_name||' Error in procedure',100);
209: end if;
210: raise;
211: end initialization_code;
212: ------------------------------------------------------------

Line 334: hr_utility.set_location(l_proc_name||' Start of archive_code',10);

330: l_master_block := 'Y';
331: l_over_paid_flag := 'N';
332:
333: if g_debug then
334: hr_utility.set_location(l_proc_name||' Start of archive_code',10);
335: end if;
336: open c_get_details ;
337: fetch c_get_details into l_assignment_id,l_person_id,l_date_earned;
338: close c_get_details ;

Line 553: hr_utility.set_location(l_proc_name||' End of archive_code',20);

549: end loop;
550: close month_year_action_sequence;
551: --
552: if g_debug then
553: hr_utility.set_location(l_proc_name||' End of archive_code',20);
554: end if;
555: exception
556: when others then
557: if g_debug then

Line 558: hr_utility.set_location(l_proc_name||' Error raised in procedure',100);

554: end if;
555: exception
556: when others then
557: if g_debug then
558: hr_utility.set_location(l_proc_name||' Error raised in procedure',100);
559: end if;
560: raise;
561: end archive_code ;
562: ----------------------------------------------------------------------------------

Line 650: hr_utility.set_location(l_proc_name||' start of procedure',10);

646: l_ord_mon_cap_amt_change := 'N';
647: l_ord_mon_cap_amt := 0;
648: --
649: if g_debug then
650: hr_utility.set_location(l_proc_name||' start of procedure',10);
651: end if;
652:
653: /* Bug 12639110, ORD month ceiling changed in the current year */
654: open c_globals(p_date_earned);

Line 738: hr_utility.set_location(l_proc_name||' End of procedure',20);

734: --
735: close c_month_year_action_sequence;
736: --
737: if g_debug then
738: hr_utility.set_location(l_proc_name||' End of procedure',20);
739: end if;
740: return l_cur_ord_ytd;
741: --
742: exception

Line 745: hr_utility.set_location(l_proc_name||' Error raised in procedure',100);

741: --
742: exception
743: when others then
744: if g_debug then
745: hr_utility.set_location(l_proc_name||' Error raised in procedure',100);
746: end if;
747: raise;
748:
749: end get_cur_year_ord_ytd;

Line 761: hr_utility.set_location('Start of denit_code',10);

757: begin
758: retain_archive_flag := 'N' ;
759: l_rep_req_id := 0;
760: if g_debug then
761: hr_utility.set_location('Start of denit_code',10);
762: end if;
763: ------------------------------------------------
764: -- Call to AW CPF Capping Recalculation Report
765: ------------------------------------------------

Line 777: hr_utility.set_location('End of denit_code',20);

773: ARGUMENT5 => 'P_PERSON_ID=' || g_pact.person_id ,
774: ARGUMENT6 => 'P_RETAIN_ARCHIVE_DATA='|| g_pact.retain_archive_data);
775: --
776: if g_debug then
777: hr_utility.set_location('End of denit_code',20);
778: end if;
779: end deinit_code ;
780: begin
781: