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

Line 99: hr_utility.set_location('Entering: ' || c_proc, 10);

95: l_start_date_code pay_balance_dimensions.start_date_code%type;
96: l_dim_start_date date;
97: l_expiry_date date;
98: begin
99: hr_utility.set_location('Entering: ' || c_proc, 10);
100: hr_utility.trace('dimension_name: ' || p_dimension_name);
101: hr_utility.trace('upload_date : ' || p_upload_date);
102: --
103: select business_group_id,

Line 100: hr_utility.trace('dimension_name: ' || p_dimension_name);

96: l_dim_start_date date;
97: l_expiry_date date;
98: begin
99: hr_utility.set_location('Entering: ' || c_proc, 10);
100: hr_utility.trace('dimension_name: ' || p_dimension_name);
101: hr_utility.trace('upload_date : ' || p_upload_date);
102: --
103: select business_group_id,
104: payroll_id

Line 101: hr_utility.trace('upload_date : ' || p_upload_date);

97: l_expiry_date date;
98: begin
99: hr_utility.set_location('Entering: ' || c_proc, 10);
100: hr_utility.trace('dimension_name: ' || p_dimension_name);
101: hr_utility.trace('upload_date : ' || p_upload_date);
102: --
103: select business_group_id,
104: payroll_id
105: into l_business_group_id,

Line 121: hr_utility.set_location(c_proc, 20);

117: --
118: -- Returns 1st Period Start Date.
119: -- Also check whether payroll period exists as of p_upload_date.
120: --
121: hr_utility.set_location(c_proc, 20);
122: --
123: select nvl(min(ptp2.start_date), END_OF_TIME)
124: into l_ptp_start_date
125: from per_time_periods ptp,

Line 137: hr_utility.set_location(c_proc, 30);

133: -- Returns the date on which the assignment transferred payroll prior to
134: -- the upload date NB. the payroll is the one the assignment is assigned to
135: -- on the upload date.
136: --
137: hr_utility.set_location(c_proc, 30);
138: --
139: select max(asg.effective_end_date) + 1
140: into l_asg_start_date
141: from per_all_assignments_f asg

Line 147: hr_utility.set_location(c_proc, 35);

143: and asg.effective_end_date < p_upload_date
144: and nvl(asg.payroll_id, -1) <> l_payroll_id;
145: --
146: if l_asg_start_date is null then
147: hr_utility.set_location(c_proc, 35);
148: --
149: select min(asg.effective_start_date)
150: into l_asg_start_date
151: from per_all_assignments_f asg

Line 158: hr_utility.set_location(c_proc, 41);

154: --
155: -- In case of element level dimension
156: --
157: if p_original_entry_id is not null then
158: hr_utility.set_location(c_proc, 41);
159: --
160: select nvl(min(ee.effective_start_date), END_OF_TIME)
161: into l_ee_start_date
162: from pay_element_entries_f ee

Line 169: hr_utility.set_location(c_proc, 42);

165: and ee.assignment_id = p_assignment_id
166: and ee.entry_type = 'E'
167: and ee.effective_start_date <= p_upload_date;
168: else
169: hr_utility.set_location(c_proc, 42);
170: --
171: l_ee_start_date := START_OF_TIME;
172: end if;
173: --

Line 178: hr_utility.set_location(c_proc, 50);

174: -- Returns the start date of balance dimension.
175: --
176: l_legislation_code := hr_api.return_legislation_code(l_business_group_id);
177: --
178: hr_utility.set_location(c_proc, 50);
179: --
180: select period_type,
181: start_date_code
182: into l_period_type,

Line 189: hr_utility.set_location(c_proc, 51);

185: where dimension_name = p_dimension_name
186: and nvl(business_group_id, l_business_group_id) = l_business_group_id
187: and nvl(legislation_code, l_legislation_code) = l_legislation_code;
188: --
189: hr_utility.set_location(c_proc, 51);
190: --
191: pay_balance_pkg.get_period_type_start(
192: P_PERIOD_TYPE => l_period_type,
193: P_EFFECTIVE_DATE => p_upload_date,

Line 199: hr_utility.set_location(c_proc, 60);

195: P_START_DATE_CODE => l_start_date_code,
196: P_PAYROLL_ID => l_payroll_id,
197: P_BUS_GRP => l_business_group_id);
198: --
199: hr_utility.set_location(c_proc, 60);
200: --
201: l_expiry_date := greatest(l_ptp_start_date, l_asg_start_date, l_ee_start_date, l_dim_start_date);
202: --
203: hr_utility.trace('PTP_START_DATE: ' || l_ptp_start_date);

Line 203: hr_utility.trace('PTP_START_DATE: ' || l_ptp_start_date);

199: hr_utility.set_location(c_proc, 60);
200: --
201: l_expiry_date := greatest(l_ptp_start_date, l_asg_start_date, l_ee_start_date, l_dim_start_date);
202: --
203: hr_utility.trace('PTP_START_DATE: ' || l_ptp_start_date);
204: hr_utility.trace('ASG_START_DATE: ' || l_asg_start_date);
205: hr_utility.trace('EE_START_DATE : ' || l_ee_start_date);
206: hr_utility.trace('DIM_START_DATE: ' || l_dim_start_date);
207: hr_utility.trace('EXPIRY_DATE : ' || l_expiry_date);

Line 204: hr_utility.trace('ASG_START_DATE: ' || l_asg_start_date);

200: --
201: l_expiry_date := greatest(l_ptp_start_date, l_asg_start_date, l_ee_start_date, l_dim_start_date);
202: --
203: hr_utility.trace('PTP_START_DATE: ' || l_ptp_start_date);
204: hr_utility.trace('ASG_START_DATE: ' || l_asg_start_date);
205: hr_utility.trace('EE_START_DATE : ' || l_ee_start_date);
206: hr_utility.trace('DIM_START_DATE: ' || l_dim_start_date);
207: hr_utility.trace('EXPIRY_DATE : ' || l_expiry_date);
208: --

Line 205: hr_utility.trace('EE_START_DATE : ' || l_ee_start_date);

201: l_expiry_date := greatest(l_ptp_start_date, l_asg_start_date, l_ee_start_date, l_dim_start_date);
202: --
203: hr_utility.trace('PTP_START_DATE: ' || l_ptp_start_date);
204: hr_utility.trace('ASG_START_DATE: ' || l_asg_start_date);
205: hr_utility.trace('EE_START_DATE : ' || l_ee_start_date);
206: hr_utility.trace('DIM_START_DATE: ' || l_dim_start_date);
207: hr_utility.trace('EXPIRY_DATE : ' || l_expiry_date);
208: --
209: hr_utility.set_location('Leaving: ' || c_proc, 100);

Line 206: hr_utility.trace('DIM_START_DATE: ' || l_dim_start_date);

202: --
203: hr_utility.trace('PTP_START_DATE: ' || l_ptp_start_date);
204: hr_utility.trace('ASG_START_DATE: ' || l_asg_start_date);
205: hr_utility.trace('EE_START_DATE : ' || l_ee_start_date);
206: hr_utility.trace('DIM_START_DATE: ' || l_dim_start_date);
207: hr_utility.trace('EXPIRY_DATE : ' || l_expiry_date);
208: --
209: hr_utility.set_location('Leaving: ' || c_proc, 100);
210: return (l_expiry_date);

Line 207: hr_utility.trace('EXPIRY_DATE : ' || l_expiry_date);

203: hr_utility.trace('PTP_START_DATE: ' || l_ptp_start_date);
204: hr_utility.trace('ASG_START_DATE: ' || l_asg_start_date);
205: hr_utility.trace('EE_START_DATE : ' || l_ee_start_date);
206: hr_utility.trace('DIM_START_DATE: ' || l_dim_start_date);
207: hr_utility.trace('EXPIRY_DATE : ' || l_expiry_date);
208: --
209: hr_utility.set_location('Leaving: ' || c_proc, 100);
210: return (l_expiry_date);
211: end expiry_date;

Line 209: hr_utility.set_location('Leaving: ' || c_proc, 100);

205: hr_utility.trace('EE_START_DATE : ' || l_ee_start_date);
206: hr_utility.trace('DIM_START_DATE: ' || l_dim_start_date);
207: hr_utility.trace('EXPIRY_DATE : ' || l_expiry_date);
208: --
209: hr_utility.set_location('Leaving: ' || c_proc, 100);
210: return (l_expiry_date);
211: end expiry_date;
212: --
213: -----------------------------------------------------------------------------

Line 238: hr_utility.set_location('Entering: ' || c_proc, 10);

234: l_description pay_balance_dimensions.description%type;
235: l_dimension_level pay_balance_dimensions.dimension_level%type;
236: l_period_type pay_balance_dimensions.period_type%type;
237: begin
238: hr_utility.set_location('Entering: ' || c_proc, 10);
239: --
240: -- This SQL can possiblly raise TOO_MANY_ROWS exception
241: -- when the same dimension name exists over multiple business groups.
242: -- Current temporary workaround is to use distinct.

Line 272: hr_utility.set_location('Leaving: ' || c_proc, 100);

268: else
269: l_is_supported := false;
270: end if;
271: --
272: hr_utility.set_location('Leaving: ' || c_proc, 100);
273: return (l_is_supported);
274: exception
275: when no_data_found then
276: return false;

Line 310: hr_utility.set_location('Entering: ' || c_proc, 10);

306: is
307: c_proc constant varchar2(61) := c_package || 'include_adjustment';
308: ret_val boolean;
309: begin
310: hr_utility.set_location('Entering: ' || c_proc, 10);
311: --
312: if (p_original_entry_id = p_bal_adjustment_rec.original_entry_id)
313: or (p_original_entry_id is null) then
314: -- or (p_original_entry_id is null

Line 321: hr_utility.set_location('Leaving: ' || c_proc, 100);

317: else
318: ret_val := FALSE;
319: end if;
320: --
321: hr_utility.set_location('Leaving: ' || c_proc, 100);
322: return (ret_val);
323: end include_adjustment;
324: --
325: -----------------------------------------------------------------------------

Line 344: hr_utility.set_location('Entering: ' || c_proc, 10);

340: )
341: is
342: c_proc constant varchar2(61) := c_package || 'validate_batch_lines';
343: begin
344: hr_utility.set_location('Entering: ' || c_proc, 10);
345: --
346: hr_utility.set_location('Leaving: ' || c_proc, 100);
347: end validate_batch_lines;
348: --

Line 346: hr_utility.set_location('Leaving: ' || c_proc, 100);

342: c_proc constant varchar2(61) := c_package || 'validate_batch_lines';
343: begin
344: hr_utility.set_location('Entering: ' || c_proc, 10);
345: --
346: hr_utility.set_location('Leaving: ' || c_proc, 100);
347: end validate_batch_lines;
348: --
349: end pay_jp_bal_upload;