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 1036: hr_utility.trace_on(null, p_table_name);

1032: l_eff_end_low varchar2(40);
1033: begin
1034: --
1035: /* OK put trace on */
1036: hr_utility.trace_on(null, p_table_name);
1037: --
1038: if (p_owner is null) then
1039: g_pay_schema := paywsdyg_pkg.get_table_owner(p_table_name);
1040: l_owner := g_pay_schema;

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

1039: g_pay_schema := paywsdyg_pkg.get_table_owner(p_table_name);
1040: l_owner := g_pay_schema;
1041: else
1042: if paywsdyg_pkg.is_table_owner_valid(p_table_name,p_owner) = 'N' then
1043: hr_utility.trace('-- WARNING: owner '||p_owner||' is not valid for table '||p_table_name);
1044: end if;
1045: l_owner := p_owner;
1046: end if;
1047: --

Line 1058: hr_utility.trace(proc);

1054: p_business_group_id in number,
1055: p_legislation_code in varchar2,
1056: p_effective_date in date';
1057: --
1058: hr_utility.trace(proc);
1059: for colrec in get_columns(p_table_name, l_eff_str_up, l_eff_end_up, l_owner) loop
1060: proc := ',
1061: ';
1062: proc := proc||'p_old_'||colrec.column_name||' in '||colrec.data_type||',

Line 1066: hr_utility.trace(proc);

1062: proc := proc||'p_old_'||colrec.column_name||' in '||colrec.data_type||',
1063: ';
1064: proc := proc||'p_new_'||colrec.column_name||' in '||colrec.data_type;
1065: --
1066: hr_utility.trace(proc);
1067: end loop;
1068: --
1069: proc := '
1070: )

Line 1083: hr_utility.trace(proc);

1079: /* If the dates havent changed it must be a correction */
1080: if (p_old_'||l_eff_end_up||' = p_new_'||l_eff_end_up||'
1081: and p_old_'||l_eff_str_up||' = p_new_'||l_eff_str_up||') then';
1082: --
1083: hr_utility.trace(proc);
1084: for colrec in get_columns(p_table_name, l_eff_str_up, l_eff_end_up, l_owner) loop
1085: --
1086: if (colrec.column_name = l_eff_end_up) then
1087: proc := proc||'

Line 1090: hr_utility.trace(proc);

1086: if (colrec.column_name = l_eff_end_up) then
1087: proc := proc||'
1088: else
1089: /* OK it must be a date track change */';
1090: hr_utility.trace(proc);
1091: end if;
1092: --
1093: proc := '--
1094: pay_continuous_calc.event_update(p_business_group_id,

Line 1119: hr_utility.trace(proc);

1115: end if;
1116: --
1117: proc := proc||'
1118: );';
1119: hr_utility.trace(proc);
1120: end loop;
1121: proc := '
1122: end if;
1123: --

Line 1152: hr_utility.trace(proc);

1148: end;
1149: --
1150: end '||p_table_name||'_aru;';
1151: --
1152: hr_utility.trace(proc);
1153: end generate_cc_procedure;
1154: --
1155:
1156: --

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

1313: l_return_value hr_lookups.meaning%type ;
1314: l_proc varchar2(80) := g_pkg||'.get_asg_act_status';
1315:
1316: BEGIN
1317: hr_utility.set_location(l_proc,10);
1318:
1319: --
1320: ischanged := FALSE;
1321: --

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

1323: --
1324: open get_assignment_id (p_assignment_action_id);
1325: fetch get_assignment_id into l_assignment_id;
1326: close get_assignment_id;
1327: hr_utility.trace('-assignment_id: '||l_assignment_id);
1328: --Get date CC was last executed
1329: --
1330: -- As highlighted in bug 3146928
1331: -- This function is used in a view and thus no dml can occur, so call new proc

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

1330: -- As highlighted in bug 3146928
1331: -- This function is used in a view and thus no dml can occur, so call new proc
1332: --
1333: PAY_RECORDED_REQUESTS_PKG.get_recorded_date_no_ins('CC_ASG',l_date,l_assignment_id);
1334: hr_utility.trace('-last CC run date is '||l_date);
1335:
1336: --
1337: -- bug 3265814
1338: --If looks like CC not in use then dont bother to look for modified

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

1344: open c_is_voided( p_assignment_action_id ) ;
1345: fetch c_is_voided into l_dummy_action_id ;
1346: if c_is_voided%found then
1347: l_return_value := hr_general.decode_lookup('ACTION_STATUS','V');
1348: hr_utility.set_location(l_proc,50);
1349: else
1350: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1351: hr_utility.set_location(l_proc,55);
1352: end if;

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

1347: l_return_value := hr_general.decode_lookup('ACTION_STATUS','V');
1348: hr_utility.set_location(l_proc,50);
1349: else
1350: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1351: hr_utility.set_location(l_proc,55);
1352: end if;
1353: close c_is_voided ;
1354: else
1355: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;

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

1369: close run_modified ;
1370: --
1371: if (ischanged) then
1372: l_return_value := hr_general.decode_lookup('ACTION_STATUS','MO');
1373: hr_utility.set_location(l_proc,20);
1374: else
1375: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1376: hr_utility.set_location(l_proc,25);
1377: end if;

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

1372: l_return_value := hr_general.decode_lookup('ACTION_STATUS','MO');
1373: hr_utility.set_location(l_proc,20);
1374: else
1375: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1376: hr_utility.set_location(l_proc,25);
1377: end if;
1378: --
1379: elsif ( p_action_type in ('P', 'U')) then
1380: --

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

1389: close prepay_modified ;
1390: --
1391: if (ischanged) then
1392: l_return_value := hr_general.decode_lookup('ACTION_STATUS','MO');
1393: hr_utility.set_location(l_proc,30);
1394: else
1395: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1396: hr_utility.set_location(l_proc,35);
1397: end if;

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

1392: l_return_value := hr_general.decode_lookup('ACTION_STATUS','MO');
1393: hr_utility.set_location(l_proc,30);
1394: else
1395: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1396: hr_utility.set_location(l_proc,35);
1397: end if;
1398: --
1399: elsif ( p_action_type = 'C') then
1400: --

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

1409: close cost_modified ;
1410: --
1411: if (ischanged) then
1412: l_return_value := hr_general.decode_lookup('ACTION_STATUS','MO');
1413: hr_utility.set_location(l_proc,40);
1414: else
1415: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1416: hr_utility.set_location(l_proc,45);
1417: end if;

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

1412: l_return_value := hr_general.decode_lookup('ACTION_STATUS','MO');
1413: hr_utility.set_location(l_proc,40);
1414: else
1415: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1416: hr_utility.set_location(l_proc,45);
1417: end if;
1418: --
1419: --
1420: elsif ( p_action_type = 'H' ) then

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

1421: open c_is_voided( p_assignment_action_id ) ;
1422: fetch c_is_voided into l_dummy_action_id ;
1423: if c_is_voided%found then
1424: l_return_value := hr_general.decode_lookup('ACTION_STATUS','V');
1425: hr_utility.set_location(l_proc,50);
1426: else
1427: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1428: hr_utility.set_location(l_proc,55);
1429: end if;

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

1424: l_return_value := hr_general.decode_lookup('ACTION_STATUS','V');
1425: hr_utility.set_location(l_proc,50);
1426: else
1427: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1428: hr_utility.set_location(l_proc,55);
1429: end if;
1430: close c_is_voided ;
1431: else
1432: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;

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

1431: else
1432: l_return_value := hr_general.decode_lookup('ACTION_STATUS',p_action_status ) ;
1433: end if;
1434: end if;
1435: hr_utility.set_location(l_proc,900);
1436: return ( l_return_value ) ;
1437: end get_asg_act_status ;
1438:
1439:

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

1471: l_industry varchar2(1);
1472: --
1473: begin
1474: /* OK put trace on */
1475: hr_utility.trace_on(null, p_table_name);
1476: --
1477: g_pay_schema := paywsdyg_pkg.get_table_owner(p_table_name);
1478: --
1479: proc := ' pay_dyn_triggers.create_trigger_event(

Line 1491: hr_utility.trace(proc);

1487: );
1488: --
1489: ';
1490: --
1491: hr_utility.trace(proc);
1492: --
1493: proc := ' pay_dyn_triggers.create_trg_declaration(
1494: '''||p_table_name||'_ARU'',
1495: ''business_group_id'',

Line 1502: hr_utility.trace(proc);

1498: NULL
1499: );
1500: --
1501: ';
1502: hr_utility.trace(proc);
1503: --
1504: proc := ' pay_dyn_triggers.create_trg_initialisation(
1505: '''||p_table_name||'_ARU'',
1506: ''1'',

Line 1514: hr_utility.trace(proc);

1510: NULL
1511: );
1512: --
1513: ';
1514: hr_utility.trace(proc);
1515: --
1516: proc := ' pay_dyn_triggers.create_trg_parameter(
1517: '''||p_table_name||'_ARU'',
1518: 1,

Line 1532: hr_utility.trace(proc);

1528: NULL
1529: );
1530: --
1531: ';
1532: hr_utility.trace(proc);
1533: --
1534: proc := ' pay_dyn_triggers.create_trg_parameter(
1535: '''||p_table_name||'_ARU'',
1536: 1,

Line 1550: hr_utility.trace(proc);

1546: NULL
1547: );
1548: --
1549: ';
1550: hr_utility.trace(proc);
1551: --
1552: proc := ' pay_dyn_triggers.create_trg_declaration(
1553: '''||p_table_name||'_ARU'',
1554: ''legislation_code'',

Line 1561: hr_utility.trace(proc);

1557: NULL
1558: );
1559: --
1560: ';
1561: hr_utility.trace(proc);
1562: --
1563: proc := ' pay_dyn_triggers.create_trg_initialisation(
1564: '''||p_table_name||'_ARU'',
1565: ''2'',

Line 1573: hr_utility.trace(proc);

1569: NULL
1570: );
1571: --
1572: ';
1573: hr_utility.trace(proc);
1574: --
1575: proc := ' pay_dyn_triggers.create_trg_parameter(
1576: '''||p_table_name||'_ARU'',
1577: 2,

Line 1591: hr_utility.trace(proc);

1587: NULL
1588: );
1589: --
1590: ';
1591: hr_utility.trace(proc);
1592: --
1593: proc := ' pay_dyn_triggers.create_trg_parameter(
1594: '''||p_table_name||'_ARU'',
1595: 2,

Line 1609: hr_utility.trace(proc);

1605: NULL
1606: );
1607: --
1608: ';
1609: hr_utility.trace(proc);
1610: --
1611: proc := ' pay_dyn_triggers.create_trg_components(
1612: '''||p_table_name||'_ARU'',
1613: NULL,

Line 1623: hr_utility.trace(proc);

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

Line 1641: hr_utility.trace(proc);

1637: NULL
1638: );
1639: --
1640: ';
1641: hr_utility.trace(proc);
1642: --
1643: proc := ' pay_dyn_triggers.create_trg_parameter(
1644: '''||p_table_name||'_ARU'',
1645: NULL,

Line 1659: hr_utility.trace(proc);

1655: NULL
1656: );
1657: --
1658: ';
1659: hr_utility.trace(proc);
1660: --
1661: proc := ' pay_dyn_triggers.create_trg_parameter(
1662: '''||p_table_name||'_ARU'',
1663: NULL,

Line 1677: hr_utility.trace(proc);

1673: NULL
1674: );
1675: --
1676: ';
1677: hr_utility.trace(proc);
1678: --
1679: for colrec in get_columns(p_table_name) loop
1680: proc := ' pay_dyn_triggers.create_trg_parameter(
1681: '''||p_table_name||'_ARU'',

Line 1696: hr_utility.trace(proc);

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

Line 1714: hr_utility.trace(proc);

1710: NULL
1711: );
1712: --
1713: ';
1714: hr_utility.trace(proc);
1715: end loop;
1716: --
1717: end generate_upd_script;
1718: --

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

2023: if (l_update_cc_date = TRUE) then
2024:
2025: new_cc_date :=p_sysdate;
2026:
2027: hr_utility.trace('Updating pay_recorded_requests, process and recorded_date : '|| p_process || ' ' || new_cc_date);
2028:
2029: pay_recorded_requests_pkg.set_recorded_date(
2030: p_process => p_process,
2031: p_recorded_date => new_cc_date,