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

Line 20: -- hr_utility.trace('>>> NOW build sql string');

16:
17: begin
18:
19: --
20: -- hr_utility.trace('>>> NOW build sql string');
21: /* Effective date will be set to sysdate for CC*/
22: sqlstr := 'select distinct asg.person_id
23: from
24: per_assignments_f asg,

Line 88: hr_utility.set_location(l_proc, 10);

84:
85: l_proc varchar2(80) := g_pkg||'action_creation';
86: --
87: begin
88: hr_utility.set_location(l_proc, 10);
89:
90: -->>> PHASE 1: Get the payroll id for this pay act id
91: --
92: open csr_act_info(p_pactid);

Line 104: hr_utility.trace('>>> Last time CC was run for payroll '||l_payroll_id

100: p_process => 'CC_ASG',
101: p_recorded_date => l_last_run_date,
102: p_attribute1 => asgrec.assignment_id
103: );
104: hr_utility.trace('>>> Last time CC was run for payroll '||l_payroll_id
105: ||' is: '||l_last_run_date);
106:
107: if (l_last_run_date < asgrec.creation_date) then
108: SELECT pay_assignment_actions_s.nextval

Line 115: hr_utility.set_location(l_proc, 900);

111: -- insert the action record.
112: hr_nonrun_asact.insact(l_lockingactid,asgrec.assignment_id,p_pactid,p_chunk, null);
113: end if;
114: end loop;
115: hr_utility.set_location(l_proc, 900);
116:
117: end action_creation;
118: --
119:

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

384: l_dp_type_out pay_interpreter_pkg.t_proration_type_table_type;
385:
386: l_proc varchar2(80) := g_pkg||'.archive_data';
387: BEGIN
388: hr_utility.set_location(' Entering: '||l_proc,10);
389:
390: -->>> PHASE 1: Get details on the p act, include the date this CC run started
391: -- held in the legis_params column, put there by range_cursor
392:

Line 399: -- hr_utility.trace('>>> p_assactid '||p_assactid);

395: select sysdate
396: into l_run_date
397: from dual;
398:
399: -- hr_utility.trace('>>> p_assactid '||p_assactid);
400: -- hr_utility.set_location(l_proc, 20);
401:
402: open csr_act_info(p_assactid);
403: fetch csr_act_info into

Line 400: -- hr_utility.set_location(l_proc, 20);

396: into l_run_date
397: from dual;
398:
399: -- hr_utility.trace('>>> p_assactid '||p_assactid);
400: -- hr_utility.set_location(l_proc, 20);
401:
402: open csr_act_info(p_assactid);
403: fetch csr_act_info into
404: l_assignment_id,l_payroll_id,

Line 431: -- hr_utility.trace('>> Get element entry ids asg act id: '||p_assactid||', since l_min_de_date: '||to_char(l_min_de_date,'DD-MM-RRRR'));

427: -- just got the min creation date were interested in, max is
428: -- this run date got from csr_act_info
429: l_max_date := l_run_date;
430:
431: -- hr_utility.trace('>> Get element entry ids asg act id: '||p_assactid||', since l_min_de_date: '||to_char(l_min_de_date,'DD-MM-RRRR'));
432: -- hr_utility.trace('>> Got date for payroll id: '||l_payroll_id||' last CC date: '||to_char(l_min_date,'DD-MM-RRRR'));
433: FOR l_ele_rec in c_ele(p_assactid,l_business_group_id
434: ,l_min_de_date,l_run_date) LOOP
435: --

Line 432: -- hr_utility.trace('>> Got date for payroll id: '||l_payroll_id||' last CC date: '||to_char(l_min_date,'DD-MM-RRRR'));

428: -- this run date got from csr_act_info
429: l_max_date := l_run_date;
430:
431: -- hr_utility.trace('>> Get element entry ids asg act id: '||p_assactid||', since l_min_de_date: '||to_char(l_min_de_date,'DD-MM-RRRR'));
432: -- hr_utility.trace('>> Got date for payroll id: '||l_payroll_id||' last CC date: '||to_char(l_min_date,'DD-MM-RRRR'));
433: FOR l_ele_rec in c_ele(p_assactid,l_business_group_id
434: ,l_min_de_date,l_run_date) LOOP
435: --
436: -- Get the tables of results from the interpreter package

Line 439: hr_utility.trace('>>> Calling interpreter for ee: '||l_ele_rec.entry);

435: --
436: -- Get the tables of results from the interpreter package
437: -- This is a construct of all the valid events that have occurred
438: --
439: hr_utility.trace('>>> Calling interpreter for ee: '||l_ele_rec.entry);
440: hr_utility.trace('>>> Events in range '||l_min_date||' to '||l_max_date);
441:
442:
443: -->>> PHASE 3a: Call Interpreter in DATE_EARNED mode

Line 440: hr_utility.trace('>>> Events in range '||l_min_date||' to '||l_max_date);

436: -- Get the tables of results from the interpreter package
437: -- This is a construct of all the valid events that have occurred
438: --
439: hr_utility.trace('>>> Calling interpreter for ee: '||l_ele_rec.entry);
440: hr_utility.trace('>>> Events in range '||l_min_date||' to '||l_max_date);
441:
442:
443: -->>> PHASE 3a: Call Interpreter in DATE_EARNED mode
444: --

Line 465: hr_utility.trace('>>> TOTAL NUMBER OF DATE_EARNED EVENTS FOR ee '

461: , t_proration_type => l_de_type_out);
462: --
463:
464: -- Need the min date for all of the modes
465: hr_utility.trace('>>> TOTAL NUMBER OF DATE_EARNED EVENTS FOR ee '
466: ||l_ele_rec.entry ||' IS '||l_de_det_tab_out.COUNT);
467:
468: if (l_de_det_tab_out.COUNT <> 0) then
469: FOR i in 1..l_de_det_tab_out.COUNT loop

Line 470: hr_utility.trace('Discovered Event: '||l_de_det_tab_out(i).datetracked_event

466: ||l_ele_rec.entry ||' IS '||l_de_det_tab_out.COUNT);
467:
468: if (l_de_det_tab_out.COUNT <> 0) then
469: FOR i in 1..l_de_det_tab_out.COUNT loop
470: hr_utility.trace('Discovered Event: '||l_de_det_tab_out(i).datetracked_event
471: ||' Change mode '||l_de_det_tab_out(i).change_mode
472: ||' - '||l_de_det_tab_out(i).effective_date );
473:
474: IF( l_de_det_tab_out(i).effective_date < l_ee_min_dedate) then

Line 501: hr_utility.trace('>>> TOTAL NUMBER OF DATE_PROCESSED EVENTS FOR ee '

497: , t_proration_change_type => l_dp_chge_out
498: , t_proration_type => l_dp_type_out);
499: --
500: -- Need the min date
501: hr_utility.trace('>>> TOTAL NUMBER OF DATE_PROCESSED EVENTS FOR ee '
502: ||l_ele_rec.entry ||' IS '||l_dp_det_tab_out.COUNT);
503:
504: if (l_dp_det_tab_out.COUNT <> 0) then
505: FOR i in 1..l_dp_det_tab_out.COUNT loop

Line 506: hr_utility.trace('Discovered Event: '||l_dp_det_tab_out(i).datetracked_event

502: ||l_ele_rec.entry ||' IS '||l_dp_det_tab_out.COUNT);
503:
504: if (l_dp_det_tab_out.COUNT <> 0) then
505: FOR i in 1..l_dp_det_tab_out.COUNT loop
506: hr_utility.trace('Discovered Event: '||l_dp_det_tab_out(i).datetracked_event
507: ||' Change mode '||l_dp_det_tab_out(i).change_mode
508: ||' - '||l_dp_det_tab_out(i).effective_date );
509:
510: IF(l_dp_det_tab_out(i).effective_date < l_ee_min_dpdate) then

Line 566: hr_utility.trace('+----- Resulting Dates from Interpreter ----+');

562: -- So Now we have finally got our three driving dates to be used for
563: -- mark for retry (yes, a lot of work for three dates)
564: -- but now we can finally move on to mark for retry, the most important bit.
565:
566: hr_utility.trace('+----- Resulting Dates from Interpreter ----+');
567: hr_utility.trace('| for asg act: '||p_assactid);
568: hr_utility.trace('| rundate: '||rundate);
569: hr_utility.trace('| cstdate: '||cstdate);
570: hr_utility.trace('| paydate: '||paydate);

Line 567: hr_utility.trace('| for asg act: '||p_assactid);

563: -- mark for retry (yes, a lot of work for three dates)
564: -- but now we can finally move on to mark for retry, the most important bit.
565:
566: hr_utility.trace('+----- Resulting Dates from Interpreter ----+');
567: hr_utility.trace('| for asg act: '||p_assactid);
568: hr_utility.trace('| rundate: '||rundate);
569: hr_utility.trace('| cstdate: '||cstdate);
570: hr_utility.trace('| paydate: '||paydate);
571: hr_utility.trace('+-------------------------------------------+');

Line 568: hr_utility.trace('| rundate: '||rundate);

564: -- but now we can finally move on to mark for retry, the most important bit.
565:
566: hr_utility.trace('+----- Resulting Dates from Interpreter ----+');
567: hr_utility.trace('| for asg act: '||p_assactid);
568: hr_utility.trace('| rundate: '||rundate);
569: hr_utility.trace('| cstdate: '||cstdate);
570: hr_utility.trace('| paydate: '||paydate);
571: hr_utility.trace('+-------------------------------------------+');
572:

Line 569: hr_utility.trace('| cstdate: '||cstdate);

565:
566: hr_utility.trace('+----- Resulting Dates from Interpreter ----+');
567: hr_utility.trace('| for asg act: '||p_assactid);
568: hr_utility.trace('| rundate: '||rundate);
569: hr_utility.trace('| cstdate: '||cstdate);
570: hr_utility.trace('| paydate: '||paydate);
571: hr_utility.trace('+-------------------------------------------+');
572:
573:

Line 570: hr_utility.trace('| paydate: '||paydate);

566: hr_utility.trace('+----- Resulting Dates from Interpreter ----+');
567: hr_utility.trace('| for asg act: '||p_assactid);
568: hr_utility.trace('| rundate: '||rundate);
569: hr_utility.trace('| cstdate: '||cstdate);
570: hr_utility.trace('| paydate: '||paydate);
571: hr_utility.trace('+-------------------------------------------+');
572:
573:
574:

Line 571: hr_utility.trace('+-------------------------------------------+');

567: hr_utility.trace('| for asg act: '||p_assactid);
568: hr_utility.trace('| rundate: '||rundate);
569: hr_utility.trace('| cstdate: '||cstdate);
570: hr_utility.trace('| paydate: '||paydate);
571: hr_utility.trace('+-------------------------------------------+');
572:
573:
574:
575: -->>> PHASE 6: Mark for retry all relevant costings

Line 578: hr_utility.trace('| Rolling Costing back '||cstrec.assignment_action_id);

574:
575: -->>> PHASE 6: Mark for retry all relevant costings
576: -- nb. Not interested in GRE dates anymore since retropay changes
577: for cstrec in get_costings(p_assactid, cstdate) loop
578: hr_utility.trace('| Rolling Costing back '||cstrec.assignment_action_id);
579: py_rollback_pkg.rollback_ass_action
580: (
581: p_assignment_action_id => cstrec.assignment_action_id,
582: p_rollback_mode => 'RETRY',

Line 589: hr_utility.trace('| Rolling Prepay back '||prerec.assignment_action_id);

585: end loop;
586:
587: -->>> PHASE 7: Mark for retry all relevant prepayments
588: for prerec in get_prepay(p_assactid, paydate) loop
589: hr_utility.trace('| Rolling Prepay back '||prerec.assignment_action_id);
590: py_rollback_pkg.rollback_ass_action
591: (
592: p_assignment_action_id => prerec.assignment_action_id,
593: p_rollback_mode => 'RETRY',

Line 601: hr_utility.trace('| Rolling locked action back '

597:
598: -->>> PHASE 8: Mark for retry all relevant runs
599: for runrec in get_run(p_assactid, rundate) loop
600: for lockrec in get_locked_actions(runrec.assignment_action_id) loop
601: hr_utility.trace('| Rolling locked action back '
602: ||lockrec.assignment_action_id);
603: py_rollback_pkg.rollback_ass_action
604: (
605: p_assignment_action_id => lockrec.assignment_action_id,

Line 610: hr_utility.trace('| Rolling Run back '||runrec.assignment_action_id);

606: p_rollback_mode => 'RETRY',
607: p_multi_thread => TRUE
608: );
609: end loop;
610: hr_utility.trace('| Rolling Run back '||runrec.assignment_action_id);
611: py_rollback_pkg.rollback_ass_action
612: (
613: p_assignment_action_id => runrec.assignment_action_id,
614: p_rollback_mode => 'RETRY',

Line 626: hr_utility.trace('+-------------------------------------------+');

622: p_recorded_date => l_run_date,
623: p_recorded_date_o => l_min_date,
624: p_attribute1 => l_assignment_id);
625:
626: hr_utility.trace('+-------------------------------------------+');
627: hr_utility.set_location(' Leaving: '||l_proc,900);
628:
629: END archive_data;
630:

Line 627: hr_utility.set_location(' Leaving: '||l_proc,900);

623: p_recorded_date_o => l_min_date,
624: p_attribute1 => l_assignment_id);
625:
626: hr_utility.trace('+-------------------------------------------+');
627: hr_utility.set_location(' Leaving: '||l_proc,900);
628:
629: END archive_data;
630:
631: /* Name : deinitialise

Line 667: -- hr_utility.trace('jf store pactid '||pactid);

663: end if;
664: --
665:
666:
667: -- hr_utility.trace('jf store pactid '||pactid);
668: -- hr_utility.trace('jf store new date '||l_new_cc_date_v);
669: -- hr_utility.trace('jf store remove act'||l_remove_act);
670: -- hr_utility.trace('jf store pay id '||l_payroll_id);
671: -- hr_utility.trace('jf store full orig '||l_orig_params);

Line 668: -- hr_utility.trace('jf store new date '||l_new_cc_date_v);

664: --
665:
666:
667: -- hr_utility.trace('jf store pactid '||pactid);
668: -- hr_utility.trace('jf store new date '||l_new_cc_date_v);
669: -- hr_utility.trace('jf store remove act'||l_remove_act);
670: -- hr_utility.trace('jf store pay id '||l_payroll_id);
671: -- hr_utility.trace('jf store full orig '||l_orig_params);
672:

Line 669: -- hr_utility.trace('jf store remove act'||l_remove_act);

665:
666:
667: -- hr_utility.trace('jf store pactid '||pactid);
668: -- hr_utility.trace('jf store new date '||l_new_cc_date_v);
669: -- hr_utility.trace('jf store remove act'||l_remove_act);
670: -- hr_utility.trace('jf store pay id '||l_payroll_id);
671: -- hr_utility.trace('jf store full orig '||l_orig_params);
672:
673:

Line 670: -- hr_utility.trace('jf store pay id '||l_payroll_id);

666:
667: -- hr_utility.trace('jf store pactid '||pactid);
668: -- hr_utility.trace('jf store new date '||l_new_cc_date_v);
669: -- hr_utility.trace('jf store remove act'||l_remove_act);
670: -- hr_utility.trace('jf store pay id '||l_payroll_id);
671: -- hr_utility.trace('jf store full orig '||l_orig_params);
672:
673:
674:

Line 671: -- hr_utility.trace('jf store full orig '||l_orig_params);

667: -- hr_utility.trace('jf store pactid '||pactid);
668: -- hr_utility.trace('jf store new date '||l_new_cc_date_v);
669: -- hr_utility.trace('jf store remove act'||l_remove_act);
670: -- hr_utility.trace('jf store pay id '||l_payroll_id);
671: -- hr_utility.trace('jf store full orig '||l_orig_params);
672:
673:
674:
675: end deinitialise;

Line 1088: hr_utility.trace_on(null, p_table_name);

1084: l_eff_end_low varchar2(40);
1085: begin
1086: --
1087: /* OK put trace on */
1088: hr_utility.trace_on(null, p_table_name);
1089: --
1090: if (p_owner is null) then
1091: g_pay_schema := paywsdyg_pkg.get_table_owner(p_table_name);
1092: l_owner := g_pay_schema;

Line 1095: hr_utility.trace('-- WARNING: owner '||p_owner||' is not valid for table '||p_table_name);

1091: g_pay_schema := paywsdyg_pkg.get_table_owner(p_table_name);
1092: l_owner := g_pay_schema;
1093: else
1094: if paywsdyg_pkg.is_table_owner_valid(p_table_name,p_owner) = 'N' then
1095: hr_utility.trace('-- WARNING: owner '||p_owner||' is not valid for table '||p_table_name);
1096: end if;
1097: l_owner := p_owner;
1098: end if;
1099: --

Line 1110: hr_utility.trace(proc);

1106: p_business_group_id in number,
1107: p_legislation_code in varchar2,
1108: p_effective_date in date';
1109: --
1110: hr_utility.trace(proc);
1111: for colrec in get_columns(p_table_name, l_eff_str_up, l_eff_end_up, l_owner) loop
1112: proc := ',
1113: ';
1114: proc := proc||'p_old_'||colrec.column_name||' in '||colrec.data_type||',

Line 1118: hr_utility.trace(proc);

1114: proc := proc||'p_old_'||colrec.column_name||' in '||colrec.data_type||',
1115: ';
1116: proc := proc||'p_new_'||colrec.column_name||' in '||colrec.data_type;
1117: --
1118: hr_utility.trace(proc);
1119: end loop;
1120: --
1121: proc := '
1122: )

Line 1135: hr_utility.trace(proc);

1131: /* If the dates havent changed it must be a correction */
1132: if (p_old_'||l_eff_end_up||' = p_new_'||l_eff_end_up||'
1133: and p_old_'||l_eff_str_up||' = p_new_'||l_eff_str_up||') then';
1134: --
1135: hr_utility.trace(proc);
1136: for colrec in get_columns(p_table_name, l_eff_str_up, l_eff_end_up, l_owner) loop
1137: --
1138: if (colrec.column_name = l_eff_end_up) then
1139: proc := proc||'

Line 1142: hr_utility.trace(proc);

1138: if (colrec.column_name = l_eff_end_up) then
1139: proc := proc||'
1140: else
1141: /* OK it must be a date track change */';
1142: hr_utility.trace(proc);
1143: end if;
1144: --
1145: proc := '--
1146: pay_continuous_calc.event_update(p_business_group_id,

Line 1171: hr_utility.trace(proc);

1167: end if;
1168: --
1169: proc := proc||'
1170: );';
1171: hr_utility.trace(proc);
1172: end loop;
1173: proc := '
1174: end if;
1175: --

Line 1204: hr_utility.trace(proc);

1200: end;
1201: --
1202: end '||p_table_name||'_aru;';
1203: --
1204: hr_utility.trace(proc);
1205: end generate_cc_procedure;
1206: --
1207:
1208: --

Line 1369: hr_utility.set_location(l_proc,10);

1365: l_return_value hr_lookups.meaning%type ;
1366: l_proc varchar2(80) := g_pkg||'.get_asg_act_status';
1367:
1368: BEGIN
1369: hr_utility.set_location(l_proc,10);
1370:
1371: --
1372: ischanged := FALSE;
1373: --

Line 1379: hr_utility.trace('-assignment_id: '||l_assignment_id);

1375: --
1376: open get_assignment_id (p_assignment_action_id);
1377: fetch get_assignment_id into l_assignment_id;
1378: close get_assignment_id;
1379: hr_utility.trace('-assignment_id: '||l_assignment_id);
1380: --Get date CC was last executed
1381: --
1382: -- As highlighted in bug 3146928
1383: -- This function is used in a view and thus no dml can occur, so call new proc

Line 1386: hr_utility.trace('-last CC run date is '||l_date);

1382: -- As highlighted in bug 3146928
1383: -- This function is used in a view and thus no dml can occur, so call new proc
1384: --
1385: PAY_RECORDED_REQUESTS_PKG.get_recorded_date_no_ins('CC_ASG',l_date,l_assignment_id);
1386: hr_utility.trace('-last CC run date is '||l_date);
1387:
1388: --
1389: -- bug 3265814
1390: --If looks like CC not in use then dont bother to look for modified

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

1396: open c_is_voided( p_assignment_action_id ) ;
1397: fetch c_is_voided into l_dummy_action_id ;
1398: if c_is_voided%found then
1399: l_return_value := hr_general.decode_lookup('ACTION_STATUS','V');
1400: hr_utility.set_location(l_proc,50);
1401: else
1402: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1403: hr_utility.set_location(l_proc,55);
1404: end if;

Line 1403: hr_utility.set_location(l_proc,55);

1399: l_return_value := hr_general.decode_lookup('ACTION_STATUS','V');
1400: hr_utility.set_location(l_proc,50);
1401: else
1402: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1403: hr_utility.set_location(l_proc,55);
1404: end if;
1405: close c_is_voided ;
1406: else
1407: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;

Line 1425: hr_utility.set_location(l_proc,20);

1421: close run_modified ;
1422: --
1423: if (ischanged) then
1424: l_return_value := hr_general.decode_lookup('ACTION_STATUS','MO');
1425: hr_utility.set_location(l_proc,20);
1426: else
1427: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1428: hr_utility.set_location(l_proc,25);
1429: end if;

Line 1428: hr_utility.set_location(l_proc,25);

1424: l_return_value := hr_general.decode_lookup('ACTION_STATUS','MO');
1425: hr_utility.set_location(l_proc,20);
1426: else
1427: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1428: hr_utility.set_location(l_proc,25);
1429: end if;
1430: --
1431: elsif ( p_action_type in ('P', 'U')) then
1432: --

Line 1445: hr_utility.set_location(l_proc,30);

1441: close prepay_modified ;
1442: --
1443: if (ischanged) then
1444: l_return_value := hr_general.decode_lookup('ACTION_STATUS','MO');
1445: hr_utility.set_location(l_proc,30);
1446: else
1447: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1448: hr_utility.set_location(l_proc,35);
1449: end if;

Line 1448: hr_utility.set_location(l_proc,35);

1444: l_return_value := hr_general.decode_lookup('ACTION_STATUS','MO');
1445: hr_utility.set_location(l_proc,30);
1446: else
1447: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1448: hr_utility.set_location(l_proc,35);
1449: end if;
1450: --
1451: elsif ( p_action_type = 'C') then
1452: --

Line 1465: hr_utility.set_location(l_proc,40);

1461: close cost_modified ;
1462: --
1463: if (ischanged) then
1464: l_return_value := hr_general.decode_lookup('ACTION_STATUS','MO');
1465: hr_utility.set_location(l_proc,40);
1466: else
1467: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1468: hr_utility.set_location(l_proc,45);
1469: end if;

Line 1468: hr_utility.set_location(l_proc,45);

1464: l_return_value := hr_general.decode_lookup('ACTION_STATUS','MO');
1465: hr_utility.set_location(l_proc,40);
1466: else
1467: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1468: hr_utility.set_location(l_proc,45);
1469: end if;
1470: --
1471: --
1472: elsif ( p_action_type = 'H' ) then

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

1473: open c_is_voided( p_assignment_action_id ) ;
1474: fetch c_is_voided into l_dummy_action_id ;
1475: if c_is_voided%found then
1476: l_return_value := hr_general.decode_lookup('ACTION_STATUS','V');
1477: hr_utility.set_location(l_proc,50);
1478: else
1479: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1480: hr_utility.set_location(l_proc,55);
1481: end if;

Line 1480: hr_utility.set_location(l_proc,55);

1476: l_return_value := hr_general.decode_lookup('ACTION_STATUS','V');
1477: hr_utility.set_location(l_proc,50);
1478: else
1479: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1480: hr_utility.set_location(l_proc,55);
1481: end if;
1482: close c_is_voided ;
1483: else
1484: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;

Line 1487: hr_utility.set_location(l_proc,900);

1483: else
1484: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1485: end if;
1486: end if;
1487: hr_utility.set_location(l_proc,900);
1488: return ( l_return_value ) ;
1489: end get_asg_act_status ;
1490:
1491:

Line 1549: hr_utility.trace_on(null, p_table_name);

1545: l_industry varchar2(1);
1546: --
1547: begin
1548: /* OK put trace on */
1549: hr_utility.trace_on(null, p_table_name);
1550: --
1551: g_pay_schema := paywsdyg_pkg.get_table_owner(p_table_name);
1552: --
1553: proc := ' pay_dyn_triggers.create_trigger_event(

Line 1565: hr_utility.trace(proc);

1561: );
1562: --
1563: ';
1564: --
1565: hr_utility.trace(proc);
1566: --
1567: proc := ' pay_dyn_triggers.create_trg_declaration(
1568: '''||p_table_name||'_ARU'',
1569: ''business_group_id'',

Line 1576: hr_utility.trace(proc);

1572: NULL
1573: );
1574: --
1575: ';
1576: hr_utility.trace(proc);
1577: --
1578: proc := ' pay_dyn_triggers.create_trg_initialisation(
1579: '''||p_table_name||'_ARU'',
1580: ''1'',

Line 1588: hr_utility.trace(proc);

1584: NULL
1585: );
1586: --
1587: ';
1588: hr_utility.trace(proc);
1589: --
1590: proc := ' pay_dyn_triggers.create_trg_parameter(
1591: '''||p_table_name||'_ARU'',
1592: 1,

Line 1606: hr_utility.trace(proc);

1602: NULL
1603: );
1604: --
1605: ';
1606: hr_utility.trace(proc);
1607: --
1608: proc := ' pay_dyn_triggers.create_trg_parameter(
1609: '''||p_table_name||'_ARU'',
1610: 1,

Line 1624: hr_utility.trace(proc);

1620: NULL
1621: );
1622: --
1623: ';
1624: hr_utility.trace(proc);
1625: --
1626: proc := ' pay_dyn_triggers.create_trg_declaration(
1627: '''||p_table_name||'_ARU'',
1628: ''legislation_code'',

Line 1635: hr_utility.trace(proc);

1631: NULL
1632: );
1633: --
1634: ';
1635: hr_utility.trace(proc);
1636: --
1637: proc := ' pay_dyn_triggers.create_trg_initialisation(
1638: '''||p_table_name||'_ARU'',
1639: ''2'',

Line 1647: hr_utility.trace(proc);

1643: NULL
1644: );
1645: --
1646: ';
1647: hr_utility.trace(proc);
1648: --
1649: proc := ' pay_dyn_triggers.create_trg_parameter(
1650: '''||p_table_name||'_ARU'',
1651: 2,

Line 1665: hr_utility.trace(proc);

1661: NULL
1662: );
1663: --
1664: ';
1665: hr_utility.trace(proc);
1666: --
1667: proc := ' pay_dyn_triggers.create_trg_parameter(
1668: '''||p_table_name||'_ARU'',
1669: 2,

Line 1683: hr_utility.trace(proc);

1679: NULL
1680: );
1681: --
1682: ';
1683: hr_utility.trace(proc);
1684: --
1685: proc := ' pay_dyn_triggers.create_trg_components(
1686: '''||p_table_name||'_ARU'',
1687: NULL,

Line 1697: hr_utility.trace(proc);

1693: NULL
1694: );
1695: --
1696: ';
1697: hr_utility.trace(proc);
1698: --
1699: proc := ' pay_dyn_triggers.create_trg_parameter(
1700: '''||p_table_name||'_ARU'',
1701: NULL,

Line 1715: hr_utility.trace(proc);

1711: NULL
1712: );
1713: --
1714: ';
1715: hr_utility.trace(proc);
1716: --
1717: proc := ' pay_dyn_triggers.create_trg_parameter(
1718: '''||p_table_name||'_ARU'',
1719: NULL,

Line 1733: hr_utility.trace(proc);

1729: NULL
1730: );
1731: --
1732: ';
1733: hr_utility.trace(proc);
1734: --
1735: proc := ' pay_dyn_triggers.create_trg_parameter(
1736: '''||p_table_name||'_ARU'',
1737: NULL,

Line 1751: hr_utility.trace(proc);

1747: NULL
1748: );
1749: --
1750: ';
1751: hr_utility.trace(proc);
1752: --
1753: for colrec in get_columns(p_table_name) loop
1754: proc := ' pay_dyn_triggers.create_trg_parameter(
1755: '''||p_table_name||'_ARU'',

Line 1770: hr_utility.trace(proc);

1766: NULL
1767: );
1768: --
1769: ';
1770: hr_utility.trace(proc);
1771: --
1772: proc := ' pay_dyn_triggers.create_trg_parameter(
1773: '''||p_table_name||'_ARU'',
1774: NULL,

Line 1788: hr_utility.trace(proc);

1784: NULL
1785: );
1786: --
1787: ';
1788: hr_utility.trace(proc);
1789: end loop;
1790: --
1791: end generate_upd_script;
1792: --

Line 2102: hr_utility.trace('Updating pay_recorded_requests, process and recorded_date : '|| p_process || ' ' || new_cc_date);

2098: if (l_update_cc_date = TRUE) then
2099:
2100: new_cc_date :=p_sysdate;
2101:
2102: hr_utility.trace('Updating pay_recorded_requests, process and recorded_date : '|| p_process || ' ' || new_cc_date);
2103:
2104: pay_recorded_requests_pkg.set_recorded_date(
2105: p_process => p_process,
2106: p_recorded_date => new_cc_date,