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

Line 148: hr_utility.set_location('Entering ' || l_proc, 10);

144: l_proc varchar2(50) := g_package || 'get_parameters';
145:
146: begin
147:
148: hr_utility.set_location('Entering ' || l_proc, 10);
149:
150: hr_utility.set_location('Step ' || l_proc, 20);
151: hr_utility.set_location('p_token_name = ' || p_token_name, 20);
152:

Line 150: hr_utility.set_location('Step ' || l_proc, 20);

146: begin
147:
148: hr_utility.set_location('Entering ' || l_proc, 10);
149:
150: hr_utility.set_location('Step ' || l_proc, 20);
151: hr_utility.set_location('p_token_name = ' || p_token_name, 20);
152:
153: open csr_parameter_info
154: (

Line 151: hr_utility.set_location('p_token_name = ' || p_token_name, 20);

147:
148: hr_utility.set_location('Entering ' || l_proc, 10);
149:
150: hr_utility.set_location('Step ' || l_proc, 20);
151: hr_utility.set_location('p_token_name = ' || p_token_name, 20);
152:
153: open csr_parameter_info
154: (
155: p_payroll_action_id,

Line 171: hr_utility.set_location('l_token_value = ' || p_token_value, 20);

167: p_token_value := l_token_value;
168:
169: end if;
170:
171: hr_utility.set_location('l_token_value = ' || p_token_value, 20);
172: hr_utility.set_location('Leaving ' || l_proc, 30);
173: --
174: exception
175: when others then

Line 172: hr_utility.set_location('Leaving ' || l_proc, 30);

168:
169: end if;
170:
171: hr_utility.set_location('l_token_value = ' || p_token_value, 20);
172: hr_utility.set_location('Leaving ' || l_proc, 30);
173: --
174: exception
175: when others then
176: p_token_value := null;

Line 225: hr_utility.set_location('Entering '|| l_proc,10);

221: l_proc varchar2(50) := g_package || 'get_balance';
222:
223: begin
224:
225: hr_utility.set_location('Entering '|| l_proc,10);
226:
227: open csr_latest_asg_action;
228: fetch csr_latest_asg_action into l_latest_asg_action;
229: close csr_latest_asg_action;

Line 231: hr_utility.set_location(g_package||'get_balance',20);

227: open csr_latest_asg_action;
228: fetch csr_latest_asg_action into l_latest_asg_action;
229: close csr_latest_asg_action;
230:
231: hr_utility.set_location(g_package||'get_balance',20);
232:
233: -- Set the Payroll Action ID context to the last Payroll Action
234: -- that the assignment were processed in
235: pay_balance_pkg.set_context

Line 258: hr_utility.set_location('Step ' || l_proc, 30);

254: and dim.balance_dimension_id = def.balance_dimension_id
255: and def.legislation_code = 'ZA';
256:
257:
258: hr_utility.set_location('Step ' || l_proc, 30);
259: hr_utility.set_location('l_latest_asg_action = ' || l_latest_asg_action, 30);
260: hr_utility.set_location('l_balance = ' || p_balance_name, 30);
261: hr_utility.set_location('l_dimension = ' || p_dimension, 30);
262: hr_utility.set_location('l_defined_bal_id = ' || l_defined_bal_id, 30);

Line 259: hr_utility.set_location('l_latest_asg_action = ' || l_latest_asg_action, 30);

255: and def.legislation_code = 'ZA';
256:
257:
258: hr_utility.set_location('Step ' || l_proc, 30);
259: hr_utility.set_location('l_latest_asg_action = ' || l_latest_asg_action, 30);
260: hr_utility.set_location('l_balance = ' || p_balance_name, 30);
261: hr_utility.set_location('l_dimension = ' || p_dimension, 30);
262: hr_utility.set_location('l_defined_bal_id = ' || l_defined_bal_id, 30);
263:

Line 260: hr_utility.set_location('l_balance = ' || p_balance_name, 30);

256:
257:
258: hr_utility.set_location('Step ' || l_proc, 30);
259: hr_utility.set_location('l_latest_asg_action = ' || l_latest_asg_action, 30);
260: hr_utility.set_location('l_balance = ' || p_balance_name, 30);
261: hr_utility.set_location('l_dimension = ' || p_dimension, 30);
262: hr_utility.set_location('l_defined_bal_id = ' || l_defined_bal_id, 30);
263:
264: --Bug 4140343

Line 261: hr_utility.set_location('l_dimension = ' || p_dimension, 30);

257:
258: hr_utility.set_location('Step ' || l_proc, 30);
259: hr_utility.set_location('l_latest_asg_action = ' || l_latest_asg_action, 30);
260: hr_utility.set_location('l_balance = ' || p_balance_name, 30);
261: hr_utility.set_location('l_dimension = ' || p_dimension, 30);
262: hr_utility.set_location('l_defined_bal_id = ' || l_defined_bal_id, 30);
263:
264: --Bug 4140343
265: --If an active or suspended assignment is not processed in a particular month then

Line 262: hr_utility.set_location('l_defined_bal_id = ' || l_defined_bal_id, 30);

258: hr_utility.set_location('Step ' || l_proc, 30);
259: hr_utility.set_location('l_latest_asg_action = ' || l_latest_asg_action, 30);
260: hr_utility.set_location('l_balance = ' || p_balance_name, 30);
261: hr_utility.set_location('l_dimension = ' || p_dimension, 30);
262: hr_utility.set_location('l_defined_bal_id = ' || l_defined_bal_id, 30);
263:
264: --Bug 4140343
265: --If an active or suspended assignment is not processed in a particular month then
266: --the balances values (dimension = _ASG_TAX_MTD ) are set to 0 and the employee is shown on the

Line 276: hr_utility.set_location('l_balance_value = ' || l_balance_value, 40);

272: p_defined_balance_id => l_defined_bal_id,
273: p_assignment_action_id => l_latest_asg_action
274: );
275:
276: hr_utility.set_location('l_balance_value = ' || l_balance_value, 40);
277:
278: else
279: l_balance_value := 0;
280:

Line 287: hr_utility.set_location(l_proc,50);

283: return l_balance_value;
284:
285: exception
286: when others then
287: hr_utility.set_location(l_proc,50);
288: hr_utility.set_message(801,'Sql Err Code: '||to_char(sqlcode));
289: hr_utility.raise_error;
290:
291: end get_balance_value;

Line 288: hr_utility.set_message(801,'Sql Err Code: '||to_char(sqlcode));

284:
285: exception
286: when others then
287: hr_utility.set_location(l_proc,50);
288: hr_utility.set_message(801,'Sql Err Code: '||to_char(sqlcode));
289: hr_utility.raise_error;
290:
291: end get_balance_value;
292:

Line 289: hr_utility.raise_error;

285: exception
286: when others then
287: hr_utility.set_location(l_proc,50);
288: hr_utility.set_message(801,'Sql Err Code: '||to_char(sqlcode));
289: hr_utility.raise_error;
290:
291: end get_balance_value;
292:
293:

Line 359: --hr_utility.trace_on(null, 'UIF');

355: l_proc varchar2(50) := g_package || 'range_cursor';
356:
357: begin
358:
359: --hr_utility.trace_on(null, 'UIF');
360:
361: hr_utility.set_location('Entering ' || l_proc, 10);
362: hr_utility.trace('Entering ' || l_proc);
363:

Line 361: hr_utility.set_location('Entering ' || l_proc, 10);

357: begin
358:
359: --hr_utility.trace_on(null, 'UIF');
360:
361: hr_utility.set_location('Entering ' || l_proc, 10);
362: hr_utility.trace('Entering ' || l_proc);
363:
364: g_archive_pact := pactid; -- Payroll Action of the Archiver
365:

Line 362: hr_utility.trace('Entering ' || l_proc);

358:
359: --hr_utility.trace_on(null, 'UIF');
360:
361: hr_utility.set_location('Entering ' || l_proc, 10);
362: hr_utility.trace('Entering ' || l_proc);
363:
364: g_archive_pact := pactid; -- Payroll Action of the Archiver
365:
366: hr_utility.trace('g_archive_pact: ' || to_char(g_archive_pact));

Line 366: hr_utility.trace('g_archive_pact: ' || to_char(g_archive_pact));

362: hr_utility.trace('Entering ' || l_proc);
363:
364: g_archive_pact := pactid; -- Payroll Action of the Archiver
365:
366: hr_utility.trace('g_archive_pact: ' || to_char(g_archive_pact));
367:
368:
369: -- Get the effective date of the payroll action
370: open csr_archive_effective_date(pactid); -- Payroll Action of the Archiver

Line 419: hr_utility.set_location('Step ' || l_proc, 20);

415: g_canonical_end_date := to_date(l_end_date,'yyyy/mm/dd');
416:
417: g_business_group_id := l_bg_id;
418:
419: hr_utility.set_location('Step ' || l_proc, 20);
420: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);
421: hr_utility.set_location('l_start_date = ' || l_start_date, 20);
422: hr_utility.set_location('l_end_date = ' || l_end_date, 20);
423: hr_utility.set_location('g_business_group_id = ' || g_business_group_id, 20);

Line 420: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);

416:
417: g_business_group_id := l_bg_id;
418:
419: hr_utility.set_location('Step ' || l_proc, 20);
420: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);
421: hr_utility.set_location('l_start_date = ' || l_start_date, 20);
422: hr_utility.set_location('l_end_date = ' || l_end_date, 20);
423: hr_utility.set_location('g_business_group_id = ' || g_business_group_id, 20);
424: hr_utility.set_location('g_asg_set_id = ' || g_asg_set_id, 20);

Line 421: hr_utility.set_location('l_start_date = ' || l_start_date, 20);

417: g_business_group_id := l_bg_id;
418:
419: hr_utility.set_location('Step ' || l_proc, 20);
420: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);
421: hr_utility.set_location('l_start_date = ' || l_start_date, 20);
422: hr_utility.set_location('l_end_date = ' || l_end_date, 20);
423: hr_utility.set_location('g_business_group_id = ' || g_business_group_id, 20);
424: hr_utility.set_location('g_asg_set_id = ' || g_asg_set_id, 20);
425: hr_utility.set_location('g_person_id = ' || g_person_id, 20);

Line 422: hr_utility.set_location('l_end_date = ' || l_end_date, 20);

418:
419: hr_utility.set_location('Step ' || l_proc, 20);
420: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);
421: hr_utility.set_location('l_start_date = ' || l_start_date, 20);
422: hr_utility.set_location('l_end_date = ' || l_end_date, 20);
423: hr_utility.set_location('g_business_group_id = ' || g_business_group_id, 20);
424: hr_utility.set_location('g_asg_set_id = ' || g_asg_set_id, 20);
425: hr_utility.set_location('g_person_id = ' || g_person_id, 20);
426:

Line 423: hr_utility.set_location('g_business_group_id = ' || g_business_group_id, 20);

419: hr_utility.set_location('Step ' || l_proc, 20);
420: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);
421: hr_utility.set_location('l_start_date = ' || l_start_date, 20);
422: hr_utility.set_location('l_end_date = ' || l_end_date, 20);
423: hr_utility.set_location('g_business_group_id = ' || g_business_group_id, 20);
424: hr_utility.set_location('g_asg_set_id = ' || g_asg_set_id, 20);
425: hr_utility.set_location('g_person_id = ' || g_person_id, 20);
426:
427: hr_utility.set_location('g_canonical_start_date = ' || g_canonical_start_date, 20);

Line 424: hr_utility.set_location('g_asg_set_id = ' || g_asg_set_id, 20);

420: hr_utility.set_location('l_payroll_id = ' || l_payroll_id, 20);
421: hr_utility.set_location('l_start_date = ' || l_start_date, 20);
422: hr_utility.set_location('l_end_date = ' || l_end_date, 20);
423: hr_utility.set_location('g_business_group_id = ' || g_business_group_id, 20);
424: hr_utility.set_location('g_asg_set_id = ' || g_asg_set_id, 20);
425: hr_utility.set_location('g_person_id = ' || g_person_id, 20);
426:
427: hr_utility.set_location('g_canonical_start_date = ' || g_canonical_start_date, 20);
428: hr_utility.set_location('g_canonical_end_date = ' || g_canonical_end_date, 20);

Line 425: hr_utility.set_location('g_person_id = ' || g_person_id, 20);

421: hr_utility.set_location('l_start_date = ' || l_start_date, 20);
422: hr_utility.set_location('l_end_date = ' || l_end_date, 20);
423: hr_utility.set_location('g_business_group_id = ' || g_business_group_id, 20);
424: hr_utility.set_location('g_asg_set_id = ' || g_asg_set_id, 20);
425: hr_utility.set_location('g_person_id = ' || g_person_id, 20);
426:
427: hr_utility.set_location('g_canonical_start_date = ' || g_canonical_start_date, 20);
428: hr_utility.set_location('g_canonical_end_date = ' || g_canonical_end_date, 20);
429:

Line 427: hr_utility.set_location('g_canonical_start_date = ' || g_canonical_start_date, 20);

423: hr_utility.set_location('g_business_group_id = ' || g_business_group_id, 20);
424: hr_utility.set_location('g_asg_set_id = ' || g_asg_set_id, 20);
425: hr_utility.set_location('g_person_id = ' || g_person_id, 20);
426:
427: hr_utility.set_location('g_canonical_start_date = ' || g_canonical_start_date, 20);
428: hr_utility.set_location('g_canonical_end_date = ' || g_canonical_end_date, 20);
429:
430:
431: -- Archive Creator Information that have not been archived yet for the specified UIF Month

Line 428: hr_utility.set_location('g_canonical_end_date = ' || g_canonical_end_date, 20);

424: hr_utility.set_location('g_asg_set_id = ' || g_asg_set_id, 20);
425: hr_utility.set_location('g_person_id = ' || g_person_id, 20);
426:
427: hr_utility.set_location('g_canonical_start_date = ' || g_canonical_start_date, 20);
428: hr_utility.set_location('g_canonical_end_date = ' || g_canonical_end_date, 20);
429:
430:
431: -- Archive Creator Information that have not been archived yet for the specified UIF Month
432: open csr_creator_info;

Line 442: hr_utility.set_location('ZA UIF CREATOR DETAILS does not exist', 21);

438:
439: if csr_creator_info%notfound
440: then
441:
442: hr_utility.set_location('ZA UIF CREATOR DETAILS does not exist', 21);
443:
444: else
445:
446: hr_utility.set_location('Calling arch_pay_action_level_data', 25);

Line 446: hr_utility.set_location('Calling arch_pay_action_level_data', 25);

442: hr_utility.set_location('ZA UIF CREATOR DETAILS does not exist', 21);
443:
444: else
445:
446: hr_utility.set_location('Calling arch_pay_action_level_data', 25);
447:
448: hr_utility.set_location('Archiving ZA UIF CREATOR DETAILS', 30);
449:
450: hr_utility.set_location('l_creator_uif_reference '||l_creator_uif_reference, 30);

Line 448: hr_utility.set_location('Archiving ZA UIF CREATOR DETAILS', 30);

444: else
445:
446: hr_utility.set_location('Calling arch_pay_action_level_data', 25);
447:
448: hr_utility.set_location('Archiving ZA UIF CREATOR DETAILS', 30);
449:
450: hr_utility.set_location('l_creator_uif_reference '||l_creator_uif_reference, 30);
451: hr_utility.set_location('l_contact_person '||l_contact_person, 30);
452: hr_utility.set_location('l_contact_number '||l_contact_number, 30);

Line 450: hr_utility.set_location('l_creator_uif_reference '||l_creator_uif_reference, 30);

446: hr_utility.set_location('Calling arch_pay_action_level_data', 25);
447:
448: hr_utility.set_location('Archiving ZA UIF CREATOR DETAILS', 30);
449:
450: hr_utility.set_location('l_creator_uif_reference '||l_creator_uif_reference, 30);
451: hr_utility.set_location('l_contact_person '||l_contact_person, 30);
452: hr_utility.set_location('l_contact_number '||l_contact_number, 30);
453: hr_utility.set_location('l_contact_email_address '||l_contact_email_address, 30);
454:

Line 451: hr_utility.set_location('l_contact_person '||l_contact_person, 30);

447:
448: hr_utility.set_location('Archiving ZA UIF CREATOR DETAILS', 30);
449:
450: hr_utility.set_location('l_creator_uif_reference '||l_creator_uif_reference, 30);
451: hr_utility.set_location('l_contact_person '||l_contact_person, 30);
452: hr_utility.set_location('l_contact_number '||l_contact_number, 30);
453: hr_utility.set_location('l_contact_email_address '||l_contact_email_address, 30);
454:
455: --Process UIF Ref. No.

Line 452: hr_utility.set_location('l_contact_number '||l_contact_number, 30);

448: hr_utility.set_location('Archiving ZA UIF CREATOR DETAILS', 30);
449:
450: hr_utility.set_location('l_creator_uif_reference '||l_creator_uif_reference, 30);
451: hr_utility.set_location('l_contact_person '||l_contact_person, 30);
452: hr_utility.set_location('l_contact_number '||l_contact_number, 30);
453: hr_utility.set_location('l_contact_email_address '||l_contact_email_address, 30);
454:
455: --Process UIF Ref. No.
456: l_creator_uif_reference := process_uif_ref_no (l_creator_uif_reference);

Line 453: hr_utility.set_location('l_contact_email_address '||l_contact_email_address, 30);

449:
450: hr_utility.set_location('l_creator_uif_reference '||l_creator_uif_reference, 30);
451: hr_utility.set_location('l_contact_person '||l_contact_person, 30);
452: hr_utility.set_location('l_contact_number '||l_contact_number, 30);
453: hr_utility.set_location('l_contact_email_address '||l_contact_email_address, 30);
454:
455: --Process UIF Ref. No.
456: l_creator_uif_reference := process_uif_ref_no (l_creator_uif_reference);
457:

Line 458: hr_utility.set_location('l_creator_uif_reference_processed '||l_creator_uif_reference, 30);

454:
455: --Process UIF Ref. No.
456: l_creator_uif_reference := process_uif_ref_no (l_creator_uif_reference);
457:
458: hr_utility.set_location('l_creator_uif_reference_processed '||l_creator_uif_reference, 30);
459:
460: -- Archive 'ZA UIF CREATOR DETAILS'
461: pay_action_information_api.create_action_information
462: (

Line 497: hr_utility.set_location('Leaving ' || l_proc, 10);

493: order by asg.person_id';
494:
495: sqlstr := sql_range;
496:
497: hr_utility.set_location('Leaving ' || l_proc, 10);
498:
499: --hr_utility.trace_off;
500: --
501: exception

Line 499: --hr_utility.trace_off;

495: sqlstr := sql_range;
496:
497: hr_utility.set_location('Leaving ' || l_proc, 10);
498:
499: --hr_utility.trace_off;
500: --
501: exception
502: when others then
503: sqlstr := null;

Line 529: --hr_utility.trace_on(null, 'UIF');

525: l_proc varchar2(50) := g_package || 'range_cursor_mag';
526:
527: begin
528:
529: --hr_utility.trace_on(null, 'UIF');
530:
531: hr_utility.set_location('Entering ' || l_proc, 10);
532:
533: sql_range :=

Line 531: hr_utility.set_location('Entering ' || l_proc, 10);

527: begin
528:
529: --hr_utility.trace_on(null, 'UIF');
530:
531: hr_utility.set_location('Entering ' || l_proc, 10);
532:
533: sql_range :=
534: 'select distinct asg.person_id
535: from per_assignments_f asg,

Line 547: hr_utility.set_location('Leaving ' || l_proc, 10);

543: order by asg.person_id';
544:
545: sqlstr := sql_range;
546:
547: hr_utility.set_location('Leaving ' || l_proc, 10);
548:
549: --hr_utility.trace_off;
550: --
551: exception

Line 549: --hr_utility.trace_off;

545: sqlstr := sql_range;
546:
547: hr_utility.set_location('Leaving ' || l_proc, 10);
548:
549: --hr_utility.trace_off;
550: --
551: exception
552: when others then
553: sqlstr := null;

Line 730: --hr_utility.trace_on(null, 'UIF');

726: l_asgid number;
727:
728: begin
729:
730: --hr_utility.trace_on(null, 'UIF');
731:
732: hr_utility.set_location('Entering ' || l_proc, 10);
733:
734: select get_parameter('START_DATE', legislative_parameters)

Line 732: hr_utility.set_location('Entering ' || l_proc, 10);

728: begin
729:
730: --hr_utility.trace_on(null, 'UIF');
731:
732: hr_utility.set_location('Entering ' || l_proc, 10);
733:
734: select get_parameter('START_DATE', legislative_parameters)
735: into l_start_date
736: from pay_payroll_actions

Line 762: hr_utility.set_location('pactid '||to_char(pactid), 10);

758:
759: l_canonical_start_date := to_date(l_start_date,'yyyy/mm/dd');
760: l_canonical_end_date := to_date(l_end_date,'yyyy/mm/dd');
761:
762: hr_utility.set_location('pactid '||to_char(pactid), 10);
763: hr_utility.set_location('l_person_id '||to_char(l_person_id), 10);
764: hr_utility.set_location('l_asg_set_id '||to_char(l_asg_set_id), 10);
765: hr_utility.set_location('stperson '||to_char(stperson), 10);
766: hr_utility.set_location('endperson '||to_char(endperson), 10);

Line 763: hr_utility.set_location('l_person_id '||to_char(l_person_id), 10);

759: l_canonical_start_date := to_date(l_start_date,'yyyy/mm/dd');
760: l_canonical_end_date := to_date(l_end_date,'yyyy/mm/dd');
761:
762: hr_utility.set_location('pactid '||to_char(pactid), 10);
763: hr_utility.set_location('l_person_id '||to_char(l_person_id), 10);
764: hr_utility.set_location('l_asg_set_id '||to_char(l_asg_set_id), 10);
765: hr_utility.set_location('stperson '||to_char(stperson), 10);
766: hr_utility.set_location('endperson '||to_char(endperson), 10);
767: hr_utility.set_location('l_canonical_start_date '||to_char(l_canonical_start_date, 'dd/mm/yyyy'), 10);

Line 764: hr_utility.set_location('l_asg_set_id '||to_char(l_asg_set_id), 10);

760: l_canonical_end_date := to_date(l_end_date,'yyyy/mm/dd');
761:
762: hr_utility.set_location('pactid '||to_char(pactid), 10);
763: hr_utility.set_location('l_person_id '||to_char(l_person_id), 10);
764: hr_utility.set_location('l_asg_set_id '||to_char(l_asg_set_id), 10);
765: hr_utility.set_location('stperson '||to_char(stperson), 10);
766: hr_utility.set_location('endperson '||to_char(endperson), 10);
767: hr_utility.set_location('l_canonical_start_date '||to_char(l_canonical_start_date, 'dd/mm/yyyy'), 10);
768: hr_utility.set_location('l_canonical_end_date '||to_char(l_canonical_end_date, 'dd/mm/yyyy'), 10);

Line 765: hr_utility.set_location('stperson '||to_char(stperson), 10);

761:
762: hr_utility.set_location('pactid '||to_char(pactid), 10);
763: hr_utility.set_location('l_person_id '||to_char(l_person_id), 10);
764: hr_utility.set_location('l_asg_set_id '||to_char(l_asg_set_id), 10);
765: hr_utility.set_location('stperson '||to_char(stperson), 10);
766: hr_utility.set_location('endperson '||to_char(endperson), 10);
767: hr_utility.set_location('l_canonical_start_date '||to_char(l_canonical_start_date, 'dd/mm/yyyy'), 10);
768: hr_utility.set_location('l_canonical_end_date '||to_char(l_canonical_end_date, 'dd/mm/yyyy'), 10);
769:

Line 766: hr_utility.set_location('endperson '||to_char(endperson), 10);

762: hr_utility.set_location('pactid '||to_char(pactid), 10);
763: hr_utility.set_location('l_person_id '||to_char(l_person_id), 10);
764: hr_utility.set_location('l_asg_set_id '||to_char(l_asg_set_id), 10);
765: hr_utility.set_location('stperson '||to_char(stperson), 10);
766: hr_utility.set_location('endperson '||to_char(endperson), 10);
767: hr_utility.set_location('l_canonical_start_date '||to_char(l_canonical_start_date, 'dd/mm/yyyy'), 10);
768: hr_utility.set_location('l_canonical_end_date '||to_char(l_canonical_end_date, 'dd/mm/yyyy'), 10);
769:
770: if l_asg_set_id is not null then

Line 767: hr_utility.set_location('l_canonical_start_date '||to_char(l_canonical_start_date, 'dd/mm/yyyy'), 10);

763: hr_utility.set_location('l_person_id '||to_char(l_person_id), 10);
764: hr_utility.set_location('l_asg_set_id '||to_char(l_asg_set_id), 10);
765: hr_utility.set_location('stperson '||to_char(stperson), 10);
766: hr_utility.set_location('endperson '||to_char(endperson), 10);
767: hr_utility.set_location('l_canonical_start_date '||to_char(l_canonical_start_date, 'dd/mm/yyyy'), 10);
768: hr_utility.set_location('l_canonical_end_date '||to_char(l_canonical_end_date, 'dd/mm/yyyy'), 10);
769:
770: if l_asg_set_id is not null then
771: -- need to find out if assignments in assignment-set are set to Include or Exclude.

Line 768: hr_utility.set_location('l_canonical_end_date '||to_char(l_canonical_end_date, 'dd/mm/yyyy'), 10);

764: hr_utility.set_location('l_asg_set_id '||to_char(l_asg_set_id), 10);
765: hr_utility.set_location('stperson '||to_char(stperson), 10);
766: hr_utility.set_location('endperson '||to_char(endperson), 10);
767: hr_utility.set_location('l_canonical_start_date '||to_char(l_canonical_start_date, 'dd/mm/yyyy'), 10);
768: hr_utility.set_location('l_canonical_end_date '||to_char(l_canonical_end_date, 'dd/mm/yyyy'), 10);
769:
770: if l_asg_set_id is not null then
771: -- need to find out if assignments in assignment-set are set to Include or Exclude.
772: begin

Line 784: hr_utility.set_location('Before csr_get_asg', 20);

780: v_incl_sw := 'I';
781: end;
782: end if;
783:
784: hr_utility.set_location('Before csr_get_asg', 20);
785:
786: for asgrec in csr_get_asg (pactid, stperson, endperson, l_canonical_start_date, l_canonical_end_date) loop
787:
788: hr_utility.set_location('ASG: ' || to_char(asgrec.assignment_id), 30);

Line 788: hr_utility.set_location('ASG: ' || to_char(asgrec.assignment_id), 30);

784: hr_utility.set_location('Before csr_get_asg', 20);
785:
786: for asgrec in csr_get_asg (pactid, stperson, endperson, l_canonical_start_date, l_canonical_end_date) loop
787:
788: hr_utility.set_location('ASG: ' || to_char(asgrec.assignment_id), 30);
789:
790: asg_include := TRUE;
791:
792: -- Remove duplicate assignments

Line 855: hr_utility.set_location('Leaving ' || l_proc, 30);

851: end if;
852:
853: end loop;
854:
855: hr_utility.set_location('Leaving ' || l_proc, 30);
856:
857: --hr_utility.trace_off;
858:
859: end action_creation;

Line 857: --hr_utility.trace_off;

853: end loop;
854:
855: hr_utility.set_location('Leaving ' || l_proc, 30);
856:
857: --hr_utility.trace_off;
858:
859: end action_creation;
860:
861:

Line 1115: --hr_utility.trace_on(null, 'UIF');

1111: l_payroll_id number:=0; --Bug 4134166
1112:
1113: begin
1114:
1115: --hr_utility.trace_on(null, 'UIF');
1116:
1117: hr_utility.set_location('Entering ' || l_proc, 10);
1118:
1119: --get the Archive Effective Date

Line 1117: hr_utility.set_location('Entering ' || l_proc, 10);

1113: begin
1114:
1115: --hr_utility.trace_on(null, 'UIF');
1116:
1117: hr_utility.set_location('Entering ' || l_proc, 10);
1118:
1119: --get the Archive Effective Date
1120: select ppa.effective_date,
1121: ppa.payroll_action_id

Line 1369: hr_utility.set_location('l_payroll_id => '|| l_payroll_id, 100);

1365: p_token_name => 'PAYROLL_ID',
1366: p_token_value => l_payroll_id
1367: );
1368:
1369: hr_utility.set_location('l_payroll_id => '|| l_payroll_id, 100);
1370: hr_utility.set_location('l_pactid => '|| l_pactid, 100);
1371:
1372: --Added for Bug 4134166
1373: open csr_pay_periods_per_year(p_effective_date,l_payroll_id);

Line 1370: hr_utility.set_location('l_pactid => '|| l_pactid, 100);

1366: p_token_value => l_payroll_id
1367: );
1368:
1369: hr_utility.set_location('l_payroll_id => '|| l_payroll_id, 100);
1370: hr_utility.set_location('l_pactid => '|| l_pactid, 100);
1371:
1372: --Added for Bug 4134166
1373: open csr_pay_periods_per_year(p_effective_date,l_payroll_id);
1374: fetch csr_pay_periods_per_year

Line 1387: hr_utility.set_location('l_pay_periods_per_year => '|| to_char(l_pay_periods_per_year), 100);

1383: into l_pay_periods_per_month;
1384:
1385: close csr_pay_periods_per_month;
1386:
1387: hr_utility.set_location('l_pay_periods_per_year => '|| to_char(l_pay_periods_per_year), 100);
1388: hr_utility.set_location('l_pay_periods_per_month => '|| to_char(l_pay_periods_per_month), 100);
1389:
1390: open csr_uif_limit (p_effective_date);
1391:

Line 1388: hr_utility.set_location('l_pay_periods_per_month => '|| to_char(l_pay_periods_per_month), 100);

1384:
1385: close csr_pay_periods_per_month;
1386:
1387: hr_utility.set_location('l_pay_periods_per_year => '|| to_char(l_pay_periods_per_year), 100);
1388: hr_utility.set_location('l_pay_periods_per_month => '|| to_char(l_pay_periods_per_month), 100);
1389:
1390: open csr_uif_limit (p_effective_date);
1391:
1392: fetch csr_uif_limit

Line 1456: hr_utility.set_location('Archiving ZA UIF EMPLOYEE DETAILS', 50);

1452: l_reason_non_contrib := '07';
1453: end if;
1454:
1455:
1456: hr_utility.set_location('Archiving ZA UIF EMPLOYEE DETAILS', 50);
1457:
1458: -- Only archive record if the Assignment's Legal Entity and the latter's
1459: -- Employer UIF Ref No exist
1460: if (l_employer_uif_ref_no is not null and l_legal_entity is not null) then

Line 1462: hr_utility.set_location('p_action_context_id => '|| to_char(p_assactid), 60);

1458: -- Only archive record if the Assignment's Legal Entity and the latter's
1459: -- Employer UIF Ref No exist
1460: if (l_employer_uif_ref_no is not null and l_legal_entity is not null) then
1461:
1462: hr_utility.set_location('p_action_context_id => '|| to_char(p_assactid), 60);
1463: hr_utility.set_location('p_action_context_type => '|| 'AAP', 60);
1464: hr_utility.set_location('p_assignment_id => '|| to_char(l_asgid), 60);
1465: hr_utility.set_location('p_effective_date => '|| to_char(l_archive_effective_date, 'dd/mm/yyyy'), 60);
1466: hr_utility.set_location('p_action_information_category => '|| 'ZA UIF EMPLOYEE DETAILS', 60);

Line 1463: hr_utility.set_location('p_action_context_type => '|| 'AAP', 60);

1459: -- Employer UIF Ref No exist
1460: if (l_employer_uif_ref_no is not null and l_legal_entity is not null) then
1461:
1462: hr_utility.set_location('p_action_context_id => '|| to_char(p_assactid), 60);
1463: hr_utility.set_location('p_action_context_type => '|| 'AAP', 60);
1464: hr_utility.set_location('p_assignment_id => '|| to_char(l_asgid), 60);
1465: hr_utility.set_location('p_effective_date => '|| to_char(l_archive_effective_date, 'dd/mm/yyyy'), 60);
1466: hr_utility.set_location('p_action_information_category => '|| 'ZA UIF EMPLOYEE DETAILS', 60);
1467: hr_utility.set_location('p_action_information1 => '|| to_char(l_asgid), 60);

Line 1464: hr_utility.set_location('p_assignment_id => '|| to_char(l_asgid), 60);

1460: if (l_employer_uif_ref_no is not null and l_legal_entity is not null) then
1461:
1462: hr_utility.set_location('p_action_context_id => '|| to_char(p_assactid), 60);
1463: hr_utility.set_location('p_action_context_type => '|| 'AAP', 60);
1464: hr_utility.set_location('p_assignment_id => '|| to_char(l_asgid), 60);
1465: hr_utility.set_location('p_effective_date => '|| to_char(l_archive_effective_date, 'dd/mm/yyyy'), 60);
1466: hr_utility.set_location('p_action_information_category => '|| 'ZA UIF EMPLOYEE DETAILS', 60);
1467: hr_utility.set_location('p_action_information1 => '|| to_char(l_asgid), 60);
1468: hr_utility.set_location('p_action_information2 => '|| to_char(l_archive_effective_date, 'YYYYMM'), 60);

Line 1465: hr_utility.set_location('p_effective_date => '|| to_char(l_archive_effective_date, 'dd/mm/yyyy'), 60);

1461:
1462: hr_utility.set_location('p_action_context_id => '|| to_char(p_assactid), 60);
1463: hr_utility.set_location('p_action_context_type => '|| 'AAP', 60);
1464: hr_utility.set_location('p_assignment_id => '|| to_char(l_asgid), 60);
1465: hr_utility.set_location('p_effective_date => '|| to_char(l_archive_effective_date, 'dd/mm/yyyy'), 60);
1466: hr_utility.set_location('p_action_information_category => '|| 'ZA UIF EMPLOYEE DETAILS', 60);
1467: hr_utility.set_location('p_action_information1 => '|| to_char(l_asgid), 60);
1468: hr_utility.set_location('p_action_information2 => '|| to_char(l_archive_effective_date, 'YYYYMM'), 60);
1469: hr_utility.set_location('p_action_information3 => '|| l_legal_entity, 60);

Line 1466: hr_utility.set_location('p_action_information_category => '|| 'ZA UIF EMPLOYEE DETAILS', 60);

1462: hr_utility.set_location('p_action_context_id => '|| to_char(p_assactid), 60);
1463: hr_utility.set_location('p_action_context_type => '|| 'AAP', 60);
1464: hr_utility.set_location('p_assignment_id => '|| to_char(l_asgid), 60);
1465: hr_utility.set_location('p_effective_date => '|| to_char(l_archive_effective_date, 'dd/mm/yyyy'), 60);
1466: hr_utility.set_location('p_action_information_category => '|| 'ZA UIF EMPLOYEE DETAILS', 60);
1467: hr_utility.set_location('p_action_information1 => '|| to_char(l_asgid), 60);
1468: hr_utility.set_location('p_action_information2 => '|| to_char(l_archive_effective_date, 'YYYYMM'), 60);
1469: hr_utility.set_location('p_action_information3 => '|| l_legal_entity, 60);
1470: hr_utility.set_location('p_action_information4 => '|| l_employer_uif_ref_no, 60);

Line 1467: hr_utility.set_location('p_action_information1 => '|| to_char(l_asgid), 60);

1463: hr_utility.set_location('p_action_context_type => '|| 'AAP', 60);
1464: hr_utility.set_location('p_assignment_id => '|| to_char(l_asgid), 60);
1465: hr_utility.set_location('p_effective_date => '|| to_char(l_archive_effective_date, 'dd/mm/yyyy'), 60);
1466: hr_utility.set_location('p_action_information_category => '|| 'ZA UIF EMPLOYEE DETAILS', 60);
1467: hr_utility.set_location('p_action_information1 => '|| to_char(l_asgid), 60);
1468: hr_utility.set_location('p_action_information2 => '|| to_char(l_archive_effective_date, 'YYYYMM'), 60);
1469: hr_utility.set_location('p_action_information3 => '|| l_legal_entity, 60);
1470: hr_utility.set_location('p_action_information4 => '|| l_employer_uif_ref_no, 60);
1471: hr_utility.set_location('p_action_information5 => '|| l_employer_paye_number, 60);

Line 1468: hr_utility.set_location('p_action_information2 => '|| to_char(l_archive_effective_date, 'YYYYMM'), 60);

1464: hr_utility.set_location('p_assignment_id => '|| to_char(l_asgid), 60);
1465: hr_utility.set_location('p_effective_date => '|| to_char(l_archive_effective_date, 'dd/mm/yyyy'), 60);
1466: hr_utility.set_location('p_action_information_category => '|| 'ZA UIF EMPLOYEE DETAILS', 60);
1467: hr_utility.set_location('p_action_information1 => '|| to_char(l_asgid), 60);
1468: hr_utility.set_location('p_action_information2 => '|| to_char(l_archive_effective_date, 'YYYYMM'), 60);
1469: hr_utility.set_location('p_action_information3 => '|| l_legal_entity, 60);
1470: hr_utility.set_location('p_action_information4 => '|| l_employer_uif_ref_no, 60);
1471: hr_utility.set_location('p_action_information5 => '|| l_employer_paye_number, 60);
1472: hr_utility.set_location('p_action_information6 => '|| l_id_number, 60);

Line 1469: hr_utility.set_location('p_action_information3 => '|| l_legal_entity, 60);

1465: hr_utility.set_location('p_effective_date => '|| to_char(l_archive_effective_date, 'dd/mm/yyyy'), 60);
1466: hr_utility.set_location('p_action_information_category => '|| 'ZA UIF EMPLOYEE DETAILS', 60);
1467: hr_utility.set_location('p_action_information1 => '|| to_char(l_asgid), 60);
1468: hr_utility.set_location('p_action_information2 => '|| to_char(l_archive_effective_date, 'YYYYMM'), 60);
1469: hr_utility.set_location('p_action_information3 => '|| l_legal_entity, 60);
1470: hr_utility.set_location('p_action_information4 => '|| l_employer_uif_ref_no, 60);
1471: hr_utility.set_location('p_action_information5 => '|| l_employer_paye_number, 60);
1472: hr_utility.set_location('p_action_information6 => '|| l_id_number, 60);
1473: hr_utility.set_location('p_action_information7 => '|| l_other_number, 60);

Line 1470: hr_utility.set_location('p_action_information4 => '|| l_employer_uif_ref_no, 60);

1466: hr_utility.set_location('p_action_information_category => '|| 'ZA UIF EMPLOYEE DETAILS', 60);
1467: hr_utility.set_location('p_action_information1 => '|| to_char(l_asgid), 60);
1468: hr_utility.set_location('p_action_information2 => '|| to_char(l_archive_effective_date, 'YYYYMM'), 60);
1469: hr_utility.set_location('p_action_information3 => '|| l_legal_entity, 60);
1470: hr_utility.set_location('p_action_information4 => '|| l_employer_uif_ref_no, 60);
1471: hr_utility.set_location('p_action_information5 => '|| l_employer_paye_number, 60);
1472: hr_utility.set_location('p_action_information6 => '|| l_id_number, 60);
1473: hr_utility.set_location('p_action_information7 => '|| l_other_number, 60);
1474: hr_utility.set_location('p_action_information8 => '|| l_employee_number, 60);

Line 1471: hr_utility.set_location('p_action_information5 => '|| l_employer_paye_number, 60);

1467: hr_utility.set_location('p_action_information1 => '|| to_char(l_asgid), 60);
1468: hr_utility.set_location('p_action_information2 => '|| to_char(l_archive_effective_date, 'YYYYMM'), 60);
1469: hr_utility.set_location('p_action_information3 => '|| l_legal_entity, 60);
1470: hr_utility.set_location('p_action_information4 => '|| l_employer_uif_ref_no, 60);
1471: hr_utility.set_location('p_action_information5 => '|| l_employer_paye_number, 60);
1472: hr_utility.set_location('p_action_information6 => '|| l_id_number, 60);
1473: hr_utility.set_location('p_action_information7 => '|| l_other_number, 60);
1474: hr_utility.set_location('p_action_information8 => '|| l_employee_number, 60);
1475: hr_utility.set_location('p_action_information9 => '|| l_last_name, 60);

Line 1472: hr_utility.set_location('p_action_information6 => '|| l_id_number, 60);

1468: hr_utility.set_location('p_action_information2 => '|| to_char(l_archive_effective_date, 'YYYYMM'), 60);
1469: hr_utility.set_location('p_action_information3 => '|| l_legal_entity, 60);
1470: hr_utility.set_location('p_action_information4 => '|| l_employer_uif_ref_no, 60);
1471: hr_utility.set_location('p_action_information5 => '|| l_employer_paye_number, 60);
1472: hr_utility.set_location('p_action_information6 => '|| l_id_number, 60);
1473: hr_utility.set_location('p_action_information7 => '|| l_other_number, 60);
1474: hr_utility.set_location('p_action_information8 => '|| l_employee_number, 60);
1475: hr_utility.set_location('p_action_information9 => '|| l_last_name, 60);
1476: hr_utility.set_location('p_action_information10 => '|| l_first_names, 60);

Line 1473: hr_utility.set_location('p_action_information7 => '|| l_other_number, 60);

1469: hr_utility.set_location('p_action_information3 => '|| l_legal_entity, 60);
1470: hr_utility.set_location('p_action_information4 => '|| l_employer_uif_ref_no, 60);
1471: hr_utility.set_location('p_action_information5 => '|| l_employer_paye_number, 60);
1472: hr_utility.set_location('p_action_information6 => '|| l_id_number, 60);
1473: hr_utility.set_location('p_action_information7 => '|| l_other_number, 60);
1474: hr_utility.set_location('p_action_information8 => '|| l_employee_number, 60);
1475: hr_utility.set_location('p_action_information9 => '|| l_last_name, 60);
1476: hr_utility.set_location('p_action_information10 => '|| l_first_names, 60);
1477: hr_utility.set_location('p_action_information11 => '|| to_char(l_date_of_birth, 'YYYYMMDD'), 60);

Line 1474: hr_utility.set_location('p_action_information8 => '|| l_employee_number, 60);

1470: hr_utility.set_location('p_action_information4 => '|| l_employer_uif_ref_no, 60);
1471: hr_utility.set_location('p_action_information5 => '|| l_employer_paye_number, 60);
1472: hr_utility.set_location('p_action_information6 => '|| l_id_number, 60);
1473: hr_utility.set_location('p_action_information7 => '|| l_other_number, 60);
1474: hr_utility.set_location('p_action_information8 => '|| l_employee_number, 60);
1475: hr_utility.set_location('p_action_information9 => '|| l_last_name, 60);
1476: hr_utility.set_location('p_action_information10 => '|| l_first_names, 60);
1477: hr_utility.set_location('p_action_information11 => '|| to_char(l_date_of_birth, 'YYYYMMDD'), 60);
1478: hr_utility.set_location('p_action_information12 => '|| to_char(l_date_employed_from, 'YYYYMMDD'), 60);

Line 1475: hr_utility.set_location('p_action_information9 => '|| l_last_name, 60);

1471: hr_utility.set_location('p_action_information5 => '|| l_employer_paye_number, 60);
1472: hr_utility.set_location('p_action_information6 => '|| l_id_number, 60);
1473: hr_utility.set_location('p_action_information7 => '|| l_other_number, 60);
1474: hr_utility.set_location('p_action_information8 => '|| l_employee_number, 60);
1475: hr_utility.set_location('p_action_information9 => '|| l_last_name, 60);
1476: hr_utility.set_location('p_action_information10 => '|| l_first_names, 60);
1477: hr_utility.set_location('p_action_information11 => '|| to_char(l_date_of_birth, 'YYYYMMDD'), 60);
1478: hr_utility.set_location('p_action_information12 => '|| to_char(l_date_employed_from, 'YYYYMMDD'), 60);
1479: hr_utility.set_location('p_action_information13 => '|| to_char(l_date_employed_to, 'YYYYMMDD'), 60);

Line 1476: hr_utility.set_location('p_action_information10 => '|| l_first_names, 60);

1472: hr_utility.set_location('p_action_information6 => '|| l_id_number, 60);
1473: hr_utility.set_location('p_action_information7 => '|| l_other_number, 60);
1474: hr_utility.set_location('p_action_information8 => '|| l_employee_number, 60);
1475: hr_utility.set_location('p_action_information9 => '|| l_last_name, 60);
1476: hr_utility.set_location('p_action_information10 => '|| l_first_names, 60);
1477: hr_utility.set_location('p_action_information11 => '|| to_char(l_date_of_birth, 'YYYYMMDD'), 60);
1478: hr_utility.set_location('p_action_information12 => '|| to_char(l_date_employed_from, 'YYYYMMDD'), 60);
1479: hr_utility.set_location('p_action_information13 => '|| to_char(l_date_employed_to, 'YYYYMMDD'), 60);
1480: hr_utility.set_location('p_action_information14 => '|| l_empl_status, 60);

Line 1477: hr_utility.set_location('p_action_information11 => '|| to_char(l_date_of_birth, 'YYYYMMDD'), 60);

1473: hr_utility.set_location('p_action_information7 => '|| l_other_number, 60);
1474: hr_utility.set_location('p_action_information8 => '|| l_employee_number, 60);
1475: hr_utility.set_location('p_action_information9 => '|| l_last_name, 60);
1476: hr_utility.set_location('p_action_information10 => '|| l_first_names, 60);
1477: hr_utility.set_location('p_action_information11 => '|| to_char(l_date_of_birth, 'YYYYMMDD'), 60);
1478: hr_utility.set_location('p_action_information12 => '|| to_char(l_date_employed_from, 'YYYYMMDD'), 60);
1479: hr_utility.set_location('p_action_information13 => '|| to_char(l_date_employed_to, 'YYYYMMDD'), 60);
1480: hr_utility.set_location('p_action_information14 => '|| l_empl_status, 60);
1481: hr_utility.set_location('p_action_information15 => '|| l_reason_non_contrib, 60);

Line 1478: hr_utility.set_location('p_action_information12 => '|| to_char(l_date_employed_from, 'YYYYMMDD'), 60);

1474: hr_utility.set_location('p_action_information8 => '|| l_employee_number, 60);
1475: hr_utility.set_location('p_action_information9 => '|| l_last_name, 60);
1476: hr_utility.set_location('p_action_information10 => '|| l_first_names, 60);
1477: hr_utility.set_location('p_action_information11 => '|| to_char(l_date_of_birth, 'YYYYMMDD'), 60);
1478: hr_utility.set_location('p_action_information12 => '|| to_char(l_date_employed_from, 'YYYYMMDD'), 60);
1479: hr_utility.set_location('p_action_information13 => '|| to_char(l_date_employed_to, 'YYYYMMDD'), 60);
1480: hr_utility.set_location('p_action_information14 => '|| l_empl_status, 60);
1481: hr_utility.set_location('p_action_information15 => '|| l_reason_non_contrib, 60);
1482: hr_utility.set_location('p_action_information16 => '|| l_gross_taxable_remuneration, 60);

Line 1479: hr_utility.set_location('p_action_information13 => '|| to_char(l_date_employed_to, 'YYYYMMDD'), 60);

1475: hr_utility.set_location('p_action_information9 => '|| l_last_name, 60);
1476: hr_utility.set_location('p_action_information10 => '|| l_first_names, 60);
1477: hr_utility.set_location('p_action_information11 => '|| to_char(l_date_of_birth, 'YYYYMMDD'), 60);
1478: hr_utility.set_location('p_action_information12 => '|| to_char(l_date_employed_from, 'YYYYMMDD'), 60);
1479: hr_utility.set_location('p_action_information13 => '|| to_char(l_date_employed_to, 'YYYYMMDD'), 60);
1480: hr_utility.set_location('p_action_information14 => '|| l_empl_status, 60);
1481: hr_utility.set_location('p_action_information15 => '|| l_reason_non_contrib, 60);
1482: hr_utility.set_location('p_action_information16 => '|| l_gross_taxable_remuneration, 60);
1483: hr_utility.set_location('p_action_information17 => '|| l_gross_uif_remuneration, 60);

Line 1480: hr_utility.set_location('p_action_information14 => '|| l_empl_status, 60);

1476: hr_utility.set_location('p_action_information10 => '|| l_first_names, 60);
1477: hr_utility.set_location('p_action_information11 => '|| to_char(l_date_of_birth, 'YYYYMMDD'), 60);
1478: hr_utility.set_location('p_action_information12 => '|| to_char(l_date_employed_from, 'YYYYMMDD'), 60);
1479: hr_utility.set_location('p_action_information13 => '|| to_char(l_date_employed_to, 'YYYYMMDD'), 60);
1480: hr_utility.set_location('p_action_information14 => '|| l_empl_status, 60);
1481: hr_utility.set_location('p_action_information15 => '|| l_reason_non_contrib, 60);
1482: hr_utility.set_location('p_action_information16 => '|| l_gross_taxable_remuneration, 60);
1483: hr_utility.set_location('p_action_information17 => '|| l_gross_uif_remuneration, 60);
1484: hr_utility.set_location('p_action_information18 => '|| l_uif_contribution, 60);

Line 1481: hr_utility.set_location('p_action_information15 => '|| l_reason_non_contrib, 60);

1477: hr_utility.set_location('p_action_information11 => '|| to_char(l_date_of_birth, 'YYYYMMDD'), 60);
1478: hr_utility.set_location('p_action_information12 => '|| to_char(l_date_employed_from, 'YYYYMMDD'), 60);
1479: hr_utility.set_location('p_action_information13 => '|| to_char(l_date_employed_to, 'YYYYMMDD'), 60);
1480: hr_utility.set_location('p_action_information14 => '|| l_empl_status, 60);
1481: hr_utility.set_location('p_action_information15 => '|| l_reason_non_contrib, 60);
1482: hr_utility.set_location('p_action_information16 => '|| l_gross_taxable_remuneration, 60);
1483: hr_utility.set_location('p_action_information17 => '|| l_gross_uif_remuneration, 60);
1484: hr_utility.set_location('p_action_information18 => '|| l_uif_contribution, 60);
1485: hr_utility.set_location('p_action_information19 => '|| l_bank_branch_code, 60);

Line 1482: hr_utility.set_location('p_action_information16 => '|| l_gross_taxable_remuneration, 60);

1478: hr_utility.set_location('p_action_information12 => '|| to_char(l_date_employed_from, 'YYYYMMDD'), 60);
1479: hr_utility.set_location('p_action_information13 => '|| to_char(l_date_employed_to, 'YYYYMMDD'), 60);
1480: hr_utility.set_location('p_action_information14 => '|| l_empl_status, 60);
1481: hr_utility.set_location('p_action_information15 => '|| l_reason_non_contrib, 60);
1482: hr_utility.set_location('p_action_information16 => '|| l_gross_taxable_remuneration, 60);
1483: hr_utility.set_location('p_action_information17 => '|| l_gross_uif_remuneration, 60);
1484: hr_utility.set_location('p_action_information18 => '|| l_uif_contribution, 60);
1485: hr_utility.set_location('p_action_information19 => '|| l_bank_branch_code, 60);
1486: hr_utility.set_location('p_action_information20 => '|| l_bank_account_number, 60);

Line 1483: hr_utility.set_location('p_action_information17 => '|| l_gross_uif_remuneration, 60);

1479: hr_utility.set_location('p_action_information13 => '|| to_char(l_date_employed_to, 'YYYYMMDD'), 60);
1480: hr_utility.set_location('p_action_information14 => '|| l_empl_status, 60);
1481: hr_utility.set_location('p_action_information15 => '|| l_reason_non_contrib, 60);
1482: hr_utility.set_location('p_action_information16 => '|| l_gross_taxable_remuneration, 60);
1483: hr_utility.set_location('p_action_information17 => '|| l_gross_uif_remuneration, 60);
1484: hr_utility.set_location('p_action_information18 => '|| l_uif_contribution, 60);
1485: hr_utility.set_location('p_action_information19 => '|| l_bank_branch_code, 60);
1486: hr_utility.set_location('p_action_information20 => '|| l_bank_account_number, 60);
1487: hr_utility.set_location('p_action_information21 => '|| l_bank_account_type, 60);

Line 1484: hr_utility.set_location('p_action_information18 => '|| l_uif_contribution, 60);

1480: hr_utility.set_location('p_action_information14 => '|| l_empl_status, 60);
1481: hr_utility.set_location('p_action_information15 => '|| l_reason_non_contrib, 60);
1482: hr_utility.set_location('p_action_information16 => '|| l_gross_taxable_remuneration, 60);
1483: hr_utility.set_location('p_action_information17 => '|| l_gross_uif_remuneration, 60);
1484: hr_utility.set_location('p_action_information18 => '|| l_uif_contribution, 60);
1485: hr_utility.set_location('p_action_information19 => '|| l_bank_branch_code, 60);
1486: hr_utility.set_location('p_action_information20 => '|| l_bank_account_number, 60);
1487: hr_utility.set_location('p_action_information21 => '|| l_bank_account_type, 60);
1488: hr_utility.set_location('p_action_information22 => '|| l_employer_email_address, 50); /* Bug 2654703 */

Line 1485: hr_utility.set_location('p_action_information19 => '|| l_bank_branch_code, 60);

1481: hr_utility.set_location('p_action_information15 => '|| l_reason_non_contrib, 60);
1482: hr_utility.set_location('p_action_information16 => '|| l_gross_taxable_remuneration, 60);
1483: hr_utility.set_location('p_action_information17 => '|| l_gross_uif_remuneration, 60);
1484: hr_utility.set_location('p_action_information18 => '|| l_uif_contribution, 60);
1485: hr_utility.set_location('p_action_information19 => '|| l_bank_branch_code, 60);
1486: hr_utility.set_location('p_action_information20 => '|| l_bank_account_number, 60);
1487: hr_utility.set_location('p_action_information21 => '|| l_bank_account_type, 60);
1488: hr_utility.set_location('p_action_information22 => '|| l_employer_email_address, 50); /* Bug 2654703 */
1489:

Line 1486: hr_utility.set_location('p_action_information20 => '|| l_bank_account_number, 60);

1482: hr_utility.set_location('p_action_information16 => '|| l_gross_taxable_remuneration, 60);
1483: hr_utility.set_location('p_action_information17 => '|| l_gross_uif_remuneration, 60);
1484: hr_utility.set_location('p_action_information18 => '|| l_uif_contribution, 60);
1485: hr_utility.set_location('p_action_information19 => '|| l_bank_branch_code, 60);
1486: hr_utility.set_location('p_action_information20 => '|| l_bank_account_number, 60);
1487: hr_utility.set_location('p_action_information21 => '|| l_bank_account_type, 60);
1488: hr_utility.set_location('p_action_information22 => '|| l_employer_email_address, 50); /* Bug 2654703 */
1489:
1490:

Line 1487: hr_utility.set_location('p_action_information21 => '|| l_bank_account_type, 60);

1483: hr_utility.set_location('p_action_information17 => '|| l_gross_uif_remuneration, 60);
1484: hr_utility.set_location('p_action_information18 => '|| l_uif_contribution, 60);
1485: hr_utility.set_location('p_action_information19 => '|| l_bank_branch_code, 60);
1486: hr_utility.set_location('p_action_information20 => '|| l_bank_account_number, 60);
1487: hr_utility.set_location('p_action_information21 => '|| l_bank_account_type, 60);
1488: hr_utility.set_location('p_action_information22 => '|| l_employer_email_address, 50); /* Bug 2654703 */
1489:
1490:
1491: -- Archive the ZA UIF EMPLOYEE DETAILS

Line 1488: hr_utility.set_location('p_action_information22 => '|| l_employer_email_address, 50); /* Bug 2654703 */

1484: hr_utility.set_location('p_action_information18 => '|| l_uif_contribution, 60);
1485: hr_utility.set_location('p_action_information19 => '|| l_bank_branch_code, 60);
1486: hr_utility.set_location('p_action_information20 => '|| l_bank_account_number, 60);
1487: hr_utility.set_location('p_action_information21 => '|| l_bank_account_type, 60);
1488: hr_utility.set_location('p_action_information22 => '|| l_employer_email_address, 50); /* Bug 2654703 */
1489:
1490:
1491: -- Archive the ZA UIF EMPLOYEE DETAILS
1492: pay_action_information_api.create_action_information

Line 1529: hr_utility.set_location('Leaving ' || l_proc, 60);

1525: );
1526:
1527: end if;
1528:
1529: hr_utility.set_location('Leaving ' || l_proc, 60);
1530:
1531: --hr_utility.trace_off;
1532:
1533: end archive_data;

Line 1531: --hr_utility.trace_off;

1527: end if;
1528:
1529: hr_utility.set_location('Leaving ' || l_proc, 60);
1530:
1531: --hr_utility.trace_off;
1532:
1533: end archive_data;
1534:
1535:

Line 1555: hr_utility.set_location('Entering process_uif_ref_no', 10);

1551: l_temp_no varchar2(11) := '';
1552:
1553: begin
1554:
1555: hr_utility.set_location('Entering process_uif_ref_no', 10);
1556:
1557: l_employer_uif_ref_no := p_employer_uif_ref_no;
1558:
1559: hr_utility.set_location('l_employer_uif_ref_no = '|| l_employer_uif_ref_no, 20);

Line 1559: hr_utility.set_location('l_employer_uif_ref_no = '|| l_employer_uif_ref_no, 20);

1555: hr_utility.set_location('Entering process_uif_ref_no', 10);
1556:
1557: l_employer_uif_ref_no := p_employer_uif_ref_no;
1558:
1559: hr_utility.set_location('l_employer_uif_ref_no = '|| l_employer_uif_ref_no, 20);
1560:
1561: if l_employer_uif_ref_no is not null then
1562:
1563: l_employer_uif_ref_no := ltrim(rtrim(l_employer_uif_ref_no));

Line 1565: hr_utility.set_location('l_employer_uif_ref_no = '|| l_employer_uif_ref_no, 25);

1561: if l_employer_uif_ref_no is not null then
1562:
1563: l_employer_uif_ref_no := ltrim(rtrim(l_employer_uif_ref_no));
1564:
1565: hr_utility.set_location('l_employer_uif_ref_no = '|| l_employer_uif_ref_no, 25);
1566:
1567: l_length := to_number(length(l_employer_uif_ref_no));
1568:
1569: hr_utility.set_location('length_l_employer_uif_ref_no = '|| to_char(l_length), 30);

Line 1569: hr_utility.set_location('length_l_employer_uif_ref_no = '|| to_char(l_length), 30);

1565: hr_utility.set_location('l_employer_uif_ref_no = '|| l_employer_uif_ref_no, 25);
1566:
1567: l_length := to_number(length(l_employer_uif_ref_no));
1568:
1569: hr_utility.set_location('length_l_employer_uif_ref_no = '|| to_char(l_length), 30);
1570:
1571: for i in 1 .. l_length
1572:
1573: loop

Line 1581: hr_utility.set_location('l_temp_no = '|| l_temp_no, 35);

1577: then
1578:
1579: l_temp_no := l_temp_no || substr(l_employer_uif_ref_no, i, 1);
1580:
1581: hr_utility.set_location('l_temp_no = '|| l_temp_no, 35);
1582:
1583: end if;
1584:
1585: end loop;

Line 1591: hr_utility.set_location('l_employer_uif_ref_no_PROCESSED= '|| l_employer_uif_ref_no, 40);

1587: end if;
1588:
1589: l_employer_uif_ref_no := ltrim(rtrim(l_temp_no));
1590:
1591: hr_utility.set_location('l_employer_uif_ref_no_PROCESSED= '|| l_employer_uif_ref_no, 40);
1592:
1593: l_length := to_number(length(l_employer_uif_ref_no));
1594:
1595: if l_length > 9 then

Line 1603: hr_utility.set_location('l_employer_uif_ref_no_PROCESSED_zero_padded= '|| l_employer_uif_ref_no, 50);

1599: end if;
1600:
1601: l_employer_uif_ref_no := lpad(l_employer_uif_ref_no, 9, '0');
1602:
1603: hr_utility.set_location('l_employer_uif_ref_no_PROCESSED_zero_padded= '|| l_employer_uif_ref_no, 50);
1604:
1605: return l_employer_uif_ref_no;
1606:
1607: end process_uif_ref_no;

Line 1770: --hr_utility.trace_on(null, 'UIF');

1766: l_value varchar2(256);
1767:
1768: begin
1769:
1770: --hr_utility.trace_on(null, 'UIF');
1771:
1772: l_code := p_code;
1773:
1774: -- Remove any spaces

Line 1878: hr_utility.trace('DO(' || l_code || ',' || l_value || ',' || l_text || ')');

1874:
1875: end if;
1876:
1877:
1878: hr_utility.trace('DO(' || l_code || ',' || l_value || ',' || l_text || ')');
1879: --hr_utility.trace_off;
1880: return l_text;
1881:
1882: end;

Line 1879: --hr_utility.trace_off;

1875: end if;
1876:
1877:
1878: hr_utility.trace('DO(' || l_code || ',' || l_value || ',' || l_text || ')');
1879: --hr_utility.trace_off;
1880: return l_text;
1881:
1882: end;
1883: