DBA Data[Home] [Help]

APPS.PAY_NL_PAYFILE dependencies on HR_UTILITY

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

62: --
63: BEGIN
64: --
65: -- To be removed.
66: -- hr_utility.trace_on(null,'EFT');
67: -- hr_utility.set_location('--In Get Payee Details ',10);
68: g_payee_details_formula_name := 'NL_PAYEE_REPORTING_NAME';
69: g_org_details_formula_name := 'NL_ORG_PAYEE_REPORTING_NAME';
70: l_payee_name := ' ';

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

63: BEGIN
64: --
65: -- To be removed.
66: -- hr_utility.trace_on(null,'EFT');
67: -- hr_utility.set_location('--In Get Payee Details ',10);
68: g_payee_details_formula_name := 'NL_PAYEE_REPORTING_NAME';
69: g_org_details_formula_name := 'NL_ORG_PAYEE_REPORTING_NAME';
70: l_payee_name := ' ';
71: OPEN csr_get_payee_type_id;

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

129:
130: p_payee_address := nvl(substr(get_payee_address(l_payee_id
131: , l_payee_type
132: , p_date_earned),1,35),' ');
133: hr_utility.set_location('--In Core PAYEE Return ',11);
134:
135: RETURN l_payee_name;
136: CLOSE csr_org_count;
137: CLOSE csr_get_payee_type_id;

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

139: ELSIF l_payee_type = 'P' OR l_payee_type = 'p' THEN
140: --
141: IF g_payee_details_formula_exists = TRUE THEN
142:
143: hr_utility.set_location('-- In the formula if ',111);
144:
145:
146: IF g_payee_details_formula_cached = FALSE THEN
147: cache_formula('NL_PAYEE_REPORTING_NAME',p_business_group_id,p_date_earned,p_formula_id,p_formula_exists,p_formula_cached);

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

179: END IF;
180: END IF;
181:
182: -- Get PAYE Name
183: -- hr_utility.set_location('--After the formula if ',115);
184:
185: l_payee_name:=substr(pay_org_payment_methods_pkg.payee_type(
186: l_payee_type
187: ,l_payee_id

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

186: l_payee_type
187: ,l_payee_id
188: ,p_date_earned),1,35);
189:
190: -- hr_utility.set_location('--l_payee name '||l_payee_name ,117);
191:
192: -- Get PAYE Address
193: --
194: -- hr_utility.set_location('--In Formula Return ',11);

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

190: -- hr_utility.set_location('--l_payee name '||l_payee_name ,117);
191:
192: -- Get PAYE Address
193: --
194: -- hr_utility.set_location('--In Formula Return ',11);
195: p_payee_address := nvl(substr(get_payee_address(l_payee_id
196: , l_payee_type
197: , p_date_earned),1,35),' ');
198: -- hr_utility.set_location('--p_payee_address '||p_payee_address ,119);

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

194: -- hr_utility.set_location('--In Formula Return ',11);
195: p_payee_address := nvl(substr(get_payee_address(l_payee_id
196: , l_payee_type
197: , p_date_earned),1,35),' ');
198: -- hr_utility.set_location('--p_payee_address '||p_payee_address ,119);
199:
200: RETURN l_payee_name;
201: CLOSE csr_get_payee_type_id;
202:

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

265: l_payee_name:= ' ';
266:
267: l_payee_name:= nvl(l_payee_name,' ');
268:
269: -- hr_utility.set_location('--l_payee name '||l_payee_name ,117);
270:
271: -- Get PAYE Address
272: --
273: -- hr_utility.set_location('--In Formula Return ',11);

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

269: -- hr_utility.set_location('--l_payee name '||l_payee_name ,117);
270:
271: -- Get PAYE Address
272: --
273: -- hr_utility.set_location('--In Formula Return ',11);
274: p_payee_address := nvl(substr(get_payee_address(l_payee_id
275: , l_payee_type
276: , p_date_earned),1,35),' ');
277:

Line 308: -- hr_utility.trace('FORMULA EXISTS');

304: g_trans_desc_formula_id:=p_formula_id;
305: END IF;
306: --
307: IF g_trans_desc_formula_exists = TRUE THEN
308: -- hr_utility.trace('FORMULA EXISTS');
309: --
310: l_inputs(1).name := 'ASSIGNMENT_ID';
311: l_inputs(1).value := p_assignment_id;
312: l_inputs(2).name := 'DATE_EARNED';

Line 328: -- hr_utility.trace('p_transaction_desc'||p_transaction_desc);

324: p_inputs => l_inputs,
325: p_outputs => l_outputs);
326: --
327: l_transaction_desc := substr(l_outputs(1).value,1,128);
328: -- hr_utility.trace('p_transaction_desc'||p_transaction_desc);
329: -- hr_utility.trace('l_transaction_desc'||l_transaction_desc);
330: ELSE
331: -- hr_utility.trace('FORMULA DOESNT EXISTS');
332: l_transaction_desc := p_transaction_desc;

Line 329: -- hr_utility.trace('l_transaction_desc'||l_transaction_desc);

325: p_outputs => l_outputs);
326: --
327: l_transaction_desc := substr(l_outputs(1).value,1,128);
328: -- hr_utility.trace('p_transaction_desc'||p_transaction_desc);
329: -- hr_utility.trace('l_transaction_desc'||l_transaction_desc);
330: ELSE
331: -- hr_utility.trace('FORMULA DOESNT EXISTS');
332: l_transaction_desc := p_transaction_desc;
333: -- hr_utility.trace('p_transaction_desc'||p_transaction_desc);

Line 331: -- hr_utility.trace('FORMULA DOESNT EXISTS');

327: l_transaction_desc := substr(l_outputs(1).value,1,128);
328: -- hr_utility.trace('p_transaction_desc'||p_transaction_desc);
329: -- hr_utility.trace('l_transaction_desc'||l_transaction_desc);
330: ELSE
331: -- hr_utility.trace('FORMULA DOESNT EXISTS');
332: l_transaction_desc := p_transaction_desc;
333: -- hr_utility.trace('p_transaction_desc'||p_transaction_desc);
334: -- hr_utility.trace('l_transaction_desc'||l_transaction_desc);
335: END IF;

Line 333: -- hr_utility.trace('p_transaction_desc'||p_transaction_desc);

329: -- hr_utility.trace('l_transaction_desc'||l_transaction_desc);
330: ELSE
331: -- hr_utility.trace('FORMULA DOESNT EXISTS');
332: l_transaction_desc := p_transaction_desc;
333: -- hr_utility.trace('p_transaction_desc'||p_transaction_desc);
334: -- hr_utility.trace('l_transaction_desc'||l_transaction_desc);
335: END IF;
336: ELSIF g_trans_desc_formula_exists = FALSE THEN
337: l_transaction_desc := p_transaction_desc;

Line 334: -- hr_utility.trace('l_transaction_desc'||l_transaction_desc);

330: ELSE
331: -- hr_utility.trace('FORMULA DOESNT EXISTS');
332: l_transaction_desc := p_transaction_desc;
333: -- hr_utility.trace('p_transaction_desc'||p_transaction_desc);
334: -- hr_utility.trace('l_transaction_desc'||l_transaction_desc);
335: END IF;
336: ELSIF g_trans_desc_formula_exists = FALSE THEN
337: l_transaction_desc := p_transaction_desc;
338: END IF;

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

404: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
405: l_inputs ff_exec.inputs_t;
406: l_outputs ff_exec.outputs_t;
407: BEGIN
408: hr_utility.set_location('--In Formula ',20);
409: --
410: -- Initialize the formula
411: --
412: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);

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

439: END IF;
440: END LOOP;
441: END LOOP;
442: END IF;
443: hr_utility.set_location('--Leaving Formula ',21);
444: EXCEPTION
445: WHEN hr_formula_error THEN
446: fnd_message.set_name('PER','FFX22J_FORMULA_NOT_FOUND');
447: fnd_message.set_token('1', p_formula_name);

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

488: l_payee_address VARCHAR2(35);
489: l_payee_address_style VARCHAR2(35);
490: --
491: BEGIN
492: hr_utility.set_location('--In Payee Address ',30);
493: --
494: IF p_payee_type = 'P' THEN -- Person Address
495: OPEN csr_get_per_address_style(p_payee_id);
496: FETCH csr_get_per_address_style INTO l_payee_address_style;

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

509: FETCH csr_get_org_address INTO l_payee_address;
510: CLOSE csr_get_org_address;
511: END IF;
512: --
513: hr_utility.set_location('--Leaving Payee Address ',30);
514: RETURN l_payee_address;
515: --
516: END get_payee_address;
517: