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 550: hr_utility.set_location(l_proc_name||' End of archive_code',20);

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

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

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

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

637: l_proc_name := l_package || 'get_cur_year_ord_ytd';
638: l_cur_ord_ytd := 0;
639: --
640: if g_debug then
641: hr_utility.set_location(l_proc_name||' start of procedure',10);
642: end if;
643:
644: open c_globals(p_date_earned);
645: fetch c_globals into l_ord_mon_cap_amt;

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

708: --
709: close c_month_year_action_sequence;
710: --
711: if g_debug then
712: hr_utility.set_location(l_proc_name||' End of procedure',20);
713: end if;
714: return l_cur_ord_ytd;
715: --
716: exception

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

715: --
716: exception
717: when others then
718: if g_debug then
719: hr_utility.set_location(l_proc_name||' Error raised in procedure',100);
720: end if;
721: raise;
722:
723: end get_cur_year_ord_ytd;

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

731: begin
732: retain_archive_flag := 'N' ;
733: l_rep_req_id := 0;
734: if g_debug then
735: hr_utility.set_location('Start of denit_code',10);
736: end if;
737: ------------------------------------------------
738: -- Call to AW CPF Capping Recalculation Report
739: ------------------------------------------------

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

747: ARGUMENT5 => 'P_PERSON_ID=' || g_pact.person_id ,
748: ARGUMENT6 => 'P_RETAIN_ARCHIVE_DATA='|| g_pact.retain_archive_data);
749: --
750: if g_debug then
751: hr_utility.set_location('End of denit_code',20);
752: end if;
753: end deinit_code ;
754: begin
755: