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

Line 191: hr_utility.set_location('--In Payee Address ',30);

187: l_payee_address_style VARCHAR2(35);
188:
189: --
190: BEGIN
191: hr_utility.set_location('--In Payee Address ',30);
192: --
193: IF p_payee_type = 'P' THEN -- Person Address
194: OPEN csr_get_per_address(p_payee_id);
195: FETCH csr_get_per_address INTO p_house_number,p_house_no_add,p_street_name,p_line1,p_line2,p_line3,p_postal_code,p_city,p_country;

Line 203: hr_utility.set_location('--Leaving Payee Address ',30);

199: FETCH csr_get_org_address INTO p_house_number,p_house_no_add,p_street_name,p_line1,p_line2,p_line3,p_postal_code,p_city,p_country;
200: CLOSE csr_get_org_address;
201: END IF;
202: --
203: hr_utility.set_location('--Leaving Payee Address ',30);
204: RETURN l_addr_ret;
205: --
206: END get_payee_address;
207:

Line 211: -- hr_utility.trace_on(null,'EFT');

207:
208: BEGIN
209: --
210: -- To be removed.
211: -- hr_utility.trace_on(null,'EFT');
212: -- hr_utility.set_location('--In Get Payee Details ',10);
213: g_payee_details_formula_name := 'NL_PAYEE_REPORTING_NAME';
214: g_org_details_formula_name := 'NL_ORG_PAYEE_REPORTING_NAME';
215: l_payee_name := ' ';

Line 212: -- hr_utility.set_location('--In Get Payee Details ',10);

208: BEGIN
209: --
210: -- To be removed.
211: -- hr_utility.trace_on(null,'EFT');
212: -- hr_utility.set_location('--In Get Payee Details ',10);
213: g_payee_details_formula_name := 'NL_PAYEE_REPORTING_NAME';
214: g_org_details_formula_name := 'NL_ORG_PAYEE_REPORTING_NAME';
215: l_payee_name := ' ';
216: OPEN csr_get_payee_type_id;

Line 280: hr_utility.set_location('--In Core PAYEE Return ',11);

276:
277: l_address_return := nvl(substr(get_payee_address(l_payee_id
278: , l_payee_type
279: , p_date_earned),1,35),' ');
280: hr_utility.set_location('--In Core PAYEE Return ',11);
281: CLOSE csr_get_payee_type_id;
282: RETURN l_payee_name;
283:
284: ELSIF l_payee_type = 'P' OR l_payee_type = 'p' THEN

Line 288: hr_utility.set_location('-- In the formula if ',111);

284: ELSIF l_payee_type = 'P' OR l_payee_type = 'p' THEN
285: --
286: IF g_payee_details_formula_exists = TRUE THEN
287:
288: hr_utility.set_location('-- In the formula if ',111);
289:
290:
291: IF g_payee_details_formula_cached = FALSE THEN
292: cache_formula('NL_PAYEE_REPORTING_NAME',p_business_group_id,p_date_earned,p_formula_id,p_formula_exists,p_formula_cached);

Line 330: -- hr_utility.set_location('--After the formula if ',115);

326: END IF;
327: END IF;
328:
329: -- Get PAYE Name
330: -- hr_utility.set_location('--After the formula if ',115);
331:
332: l_payee_name:=substr(pay_org_payment_methods_pkg.payee_type(
333: l_payee_type
334: ,l_payee_id

Line 337: -- hr_utility.set_location('--l_payee name '||l_payee_name ,117);

333: l_payee_type
334: ,l_payee_id
335: ,p_date_earned),1,35);
336:
337: -- hr_utility.set_location('--l_payee name '||l_payee_name ,117);
338:
339: -- Get PAYE Address
340: --
341: -- hr_utility.set_location('--In Formula Return ',11);

Line 341: -- hr_utility.set_location('--In Formula Return ',11);

337: -- hr_utility.set_location('--l_payee name '||l_payee_name ,117);
338:
339: -- Get PAYE Address
340: --
341: -- hr_utility.set_location('--In Formula Return ',11);
342: l_address_return := nvl(substr(get_payee_address(l_payee_id
343: , l_payee_type
344: , p_date_earned),1,35),' ');
345: -- hr_utility.set_location('--p_payee_address '||p_payee_address ,119);

Line 345: -- hr_utility.set_location('--p_payee_address '||p_payee_address ,119);

341: -- hr_utility.set_location('--In Formula Return ',11);
342: l_address_return := nvl(substr(get_payee_address(l_payee_id
343: , l_payee_type
344: , p_date_earned),1,35),' ');
345: -- hr_utility.set_location('--p_payee_address '||p_payee_address ,119);
346: CLOSE csr_get_payee_type_id;
347: RETURN l_payee_name;
348:
349:

Line 416: -- hr_utility.set_location('--l_payee name '||l_payee_name ,117);

412: l_payee_name:= ' ';
413:
414: l_payee_name:= nvl(l_payee_name,' ');
415:
416: -- hr_utility.set_location('--l_payee name '||l_payee_name ,117);
417:
418: -- Get PAYE Address
419: --
420: -- hr_utility.set_location('--In Formula Return ',11);

Line 420: -- hr_utility.set_location('--In Formula Return ',11);

416: -- hr_utility.set_location('--l_payee name '||l_payee_name ,117);
417:
418: -- Get PAYE Address
419: --
420: -- hr_utility.set_location('--In Formula Return ',11);
421: l_address_return := nvl(substr(get_payee_address(l_payee_id
422: , l_payee_type
423: , p_date_earned),1,35),' ');
424:

Line 500: hr_utility.set_location('--In Formula ',20);

496: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
497: l_inputs ff_exec.inputs_t;
498: l_outputs ff_exec.outputs_t;
499: BEGIN
500: hr_utility.set_location('--In Formula ',20);
501: --
502: -- Initialize the formula
503: --
504: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);

Line 535: hr_utility.set_location('--Leaving Formula ',21);

531: END IF;
532: END LOOP;
533: END LOOP;
534: END IF;
535: hr_utility.set_location('--Leaving Formula ',21);
536: EXCEPTION
537: WHEN hr_formula_error THEN
538: fnd_message.set_name('PER','FFX22J_FORMULA_NOT_FOUND');
539: fnd_message.set_token('1', p_formula_name);