DBA Data[Home] [Help]

APPS.PAY_P45_PKG2 dependencies on HR_UTILITY

Line 102: hr_utility.trace('Set context for G_TAX_PERIOD_ITEM.');

98: --
99: pay_balance_pkg.set_context ('payroll_action_id',
100: to_char(p_payroll_action_id));
101: --
102: hr_utility.trace('Set context for G_TAX_PERIOD_ITEM.');
103: return true;
104: --
105: else
106: --

Line 121: hr_utility.trace('Set context for G_TAX_REFNO_ITEM.');

117: --
118: pay_balance_pkg.set_context ('assignment_id',
119: to_char(p_assignment_id));
120: --
121: hr_utility.trace('Set context for G_TAX_REFNO_ITEM.');
122: return true;
123: --
124: else
125: --

Line 133: hr_utility.trace('Set context for G_TAX_CODE_ITEM, payroll_action_id='||to_char(p_payroll_action_id));

129: --
130: if p_payroll_action_id is not null and
131: p_assignment_id is not null then
132: --
133: hr_utility.trace('Set context for G_TAX_CODE_ITEM, payroll_action_id='||to_char(p_payroll_action_id));
134: pay_balance_pkg.set_context ('payroll_action_id',
135: to_char(p_payroll_action_id));
136: --
137: hr_utility.trace('Set context for G_TAX_CODE_ITEM, assignment_id='||to_char(p_assignment_id));

Line 137: hr_utility.trace('Set context for G_TAX_CODE_ITEM, assignment_id='||to_char(p_assignment_id));

133: hr_utility.trace('Set context for G_TAX_CODE_ITEM, payroll_action_id='||to_char(p_payroll_action_id));
134: pay_balance_pkg.set_context ('payroll_action_id',
135: to_char(p_payroll_action_id));
136: --
137: hr_utility.trace('Set context for G_TAX_CODE_ITEM, assignment_id='||to_char(p_assignment_id));
138: pay_balance_pkg.set_context ('assignment_id',
139: to_char(p_assignment_id));
140: --
141: hr_utility.trace('Set context for G_TAX_CODE_ITEM.');

Line 141: hr_utility.trace('Set context for G_TAX_CODE_ITEM.');

137: hr_utility.trace('Set context for G_TAX_CODE_ITEM, assignment_id='||to_char(p_assignment_id));
138: pay_balance_pkg.set_context ('assignment_id',
139: to_char(p_assignment_id));
140: --
141: hr_utility.trace('Set context for G_TAX_CODE_ITEM.');
142: return true;
143: --
144: else
145: --

Line 214: hr_utility.set_location('get_ele_entry_details',10);

210: AND c_effective_date
211: BETWEEN v.effective_start_date AND v.effective_end_date;
212: --
213: BEGIN
214: hr_utility.set_location('get_ele_entry_details',10);
215: --
216: OPEN csr_paye_id(p_effective_date);
217: FETCH csr_paye_id into l_paye_id;
218: CLOSE csr_paye_id;

Line 231: hr_utility.set_location('get_ele_entry_details',20);

227: p_pay_previous,
228: p_tax_previous;
229: CLOSE csr_paye_details;
230: --
231: hr_utility.set_location('get_ele_entry_details',20);
232: --
233: EXCEPTION WHEN NO_DATA_FOUND THEN
234: p_tax_code := null;
235: p_tax_basis := null;

Line 330: hr_utility.set_location('pay_p45_pkg2.get_database_items',10);

326: AND pact3.action_type = 'V'
327: AND assact3.action_status = 'C');
328: begin
329: --
330: hr_utility.set_location('pay_p45_pkg2.get_database_items',10);
331: --
332: -- Bug 3473274. Check that the payroll action is not null or -9999, which
333: -- may have been set if there are no payroll actions found for the
334: -- assignment (new starter). If so, use el entries.

Line 338: hr_utility.trace('Payroll Action invalid, obtain El Entries');

334: -- assignment (new starter). If so, use el entries.
335: IF p_payroll_action_id is null OR
336: p_payroll_action_id = -9999 THEN
337: --
338: hr_utility.trace('Payroll Action invalid, obtain El Entries');
339: get_ele_entry_details(p_assignment_id => p_assignment_id,
340: p_effective_date => to_date(p_date_earned,'YYYY/MM/DD'),
341: p_tax_refno => p_tax_refno,
342: p_tax_code => p_tax_code,

Line 348: hr_utility.trace('Tax Ref: '||p_tax_refno);

344: p_pay_previous => p_prev_pay_details,
345: p_tax_previous => p_prev_tax_details);
346:
347: --
348: hr_utility.trace('Tax Ref: '||p_tax_refno);
349: ELSE
350: hr_utility.set_location('pay_p45_pkg2.get_database_items',20);
351: -- There is a valid Payroll Action, continue selecting information.
352: -- Set context for Tax Period database item and retrieve it

Line 350: hr_utility.set_location('pay_p45_pkg2.get_database_items',20);

346:
347: --
348: hr_utility.trace('Tax Ref: '||p_tax_refno);
349: ELSE
350: hr_utility.set_location('pay_p45_pkg2.get_database_items',20);
351: -- There is a valid Payroll Action, continue selecting information.
352: -- Set context for Tax Period database item and retrieve it
353: --
354: if set_database_context (p_database_item => G_TAX_PERIOD_ITEM,

Line 357: hr_utility.trace('Getting G_TAX_PERIOD_ITEM.');

353: --
354: if set_database_context (p_database_item => G_TAX_PERIOD_ITEM,
355: p_payroll_action_id => p_payroll_action_id) then
356: --
357: hr_utility.trace('Getting G_TAX_PERIOD_ITEM.');
358: p_tax_period := database_item (G_TAX_PERIOD_ITEM);
359: --
360: --
361: --

Line 367: hr_utility.trace('Getting G_TAX_REFNO_ITEM.');

363: if set_database_context (p_database_item => G_TAX_REFNO_ITEM,
364: p_date_earned => p_date_earned,
365: p_assignment_id => p_assignment_id) then
366: --
367: hr_utility.trace('Getting G_TAX_REFNO_ITEM.');
368: p_tax_refno := database_item (G_TAX_REFNO_ITEM);
369: --
370: -- Look for tax details in run results first and if not found then
371: -- call dbis

Line 428: hr_utility.trace('Getting G_TAX_CODE_ITEM.');

424: if set_database_context (p_database_item => G_TAX_CODE_ITEM,
425: p_payroll_action_id => p_payroll_action_id,
426: p_assignment_id => p_assignment_id) then
427: --
428: hr_utility.trace('Getting G_TAX_CODE_ITEM.');
429: p_tax_code := database_item (G_TAX_CODE_ITEM);
430: --
431: p_tax_basis := database_item (G_TAX_BASIS_ITEM);
432: --

Line 561: hr_utility.set_location('pay_p45_pkg2.get_balance_items',10);

557: l_ni_e_employee_value number;
558: --
559: BEGIN
560: --
561: hr_utility.set_location('pay_p45_pkg2.get_balance_items',10);
562: -- if the assignment action id is not specified then do nothing.
563: -- this may have been set to -9999 to denote no action found.
564: --
565: if p_assignment_action_id is null or

Line 568: hr_utility.trace('Assignment Action invalid, return');

564: --
565: if p_assignment_action_id is null or
566: p_assignment_action_id = -9999 then
567: --
568: hr_utility.trace('Assignment Action invalid, return');
569: return;
570: --
571: end if;
572: --