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

Line 20: g_debug boolean := hr_utility.debug_enabled;

16: g_bus_grp number;
17: g_leg_code varchar2(30);
18: g_att_name varchar2(30);
19: g_att_cached boolean; /*Bug 9315998*/
20: g_debug boolean := hr_utility.debug_enabled;
21: g_purge_only boolean default FALSE;
22: g_program_name fnd_concurrent_programs.concurrent_program_name%type;
23: g_generate_pact pay_payroll_actions.payroll_action_id%type;
24:

Line 176: hr_utility.trace('get CONCURRENT_PROGRAM_NAME. g_program_name:'||g_program_name);

172: from FND_CONCURRENT_REQUESTS fcr,
173: FND_CONCURRENT_PROGRAMS fcp
174: where fcr.REQUEST_ID = l_request_id
175: and fcp.CONCURRENT_PROGRAM_ID = fcr.CONCURRENT_PROGRAM_ID;
176: hr_utility.trace('get CONCURRENT_PROGRAM_NAME. g_program_name:'||g_program_name);
177:
178: if (g_proc_mode <> 'SINGLE') then
179: -- bug 11874880 fetch pregenerate load date
180: if g_program_name = 'RB_ADJD' then

Line 190: hr_utility.trace('set_run_bal_status store g_old_balance_validation_tab. '|| g_old_balance_validation_tab.count);

186: bulk collect into g_old_balance_validation_tab
187: from pay_balance_validation
188: where business_group_id = l_bus_grp;
189: if g_debug then
190: hr_utility.trace('set_run_bal_status store g_old_balance_validation_tab. '|| g_old_balance_validation_tab.count);
191: end if;
192: end if;
193:
194: for dbrec in get_all_bals(p_pactid) loop

Line 266: hr_utility.trace('set_run_bal_status g_purge_only. l_old_balance_load_date:'||

262: update pay_payroll_actions set legislative_parameters = legislative_parameters || ' PURGE_ONLY=Y'
263: where payroll_action_id = p_pactid
264: and legislative_parameters not like '%PURGE_ONLY%';
265: if g_debug then
266: hr_utility.trace('set_run_bal_status g_purge_only. l_old_balance_load_date:'||
267: l_old_balance_load_date||
268: ' g_start_date:'||g_start_date);
269: end if;
270: else g_purge_only := FALSE;

Line 405: hr_utility.set_location

401: l_rb_row_status varchar2(1);
402: --
403: begin
404: --
405: hr_utility.set_location
406: ('Entering: pay_run_balance_build.calculate_delta_asg_balnces', 10);
407: if (g_proc_mode = 'SINGLE') then
408: l_rb_row_status := 'U';
409: --

Line 487: hr_utility.set_location

483: --
484: end if;
485: end if;
486: --
487: hr_utility.set_location
488: ('Leaving: pay_run_balance_build.calculate_delta_asg_balances', 100);
489: end calculate_delta_asg_balances;
490: --
491: /* Name : calculate_full_asg_balances

Line 509: hr_utility.set_location(

505: l_rb_row_status varchar2(1);
506: begin
507: --
508: --
509: hr_utility.set_location(
510: 'Enter:pay_run_balance_build.calculate_full_asg_balances',10);
511: l_rb_row_status := 'U';
512: --
513: if (g_proc_mode = 'SINGLE') then

Line 523: hr_utility.set_location(

519: --
520: -- If we have been supplied with a start date then delete
521: -- any run balance prior to this date.
522: --
523: hr_utility.set_location(
524: 'pay_run_balance_build.calculate_full_asg_balances',20);
525: --
526: l_delete_bals := FALSE;
527: if (g_start_date is not null

Line 535: hr_utility.set_location(

531: --
532: if (l_delete_bals) then
533: --
534: --
535: hr_utility.set_location(
536: 'pay_run_balance_build.calculate_full_asg_balances',30);
537: -- bug 11874880 reduce number of deletes by checking runbal row status
538: if (l_rb_row_status in ('I','U','O')) then
539: delete /*+ INDEX(prb PAY_RUN_BALANCES_N2) */

Line 549: hr_utility.set_location(

545: end if;
546: if not(l_delete_bals) then
547: --
548: --
549: hr_utility.set_location(
550: 'pay_run_balance_build.calculate_full_asg_balances',40);
551: --
552: if l_rb_row_status in ( 'I', 'U','M' ) then
553: pay_balance_pkg.create_asg_balance(g_def_bal_id

Line 563: hr_utility.set_location(

559: end if;
560: --
561: else
562: --
563: hr_utility.set_location(
564: 'pay_run_balance_build.calculate_full_asg_balances',50);
565: --
566: -- If we have been supplied with a start date then delete
567: -- any run balance prior to this date.

Line 577: hr_utility.set_location(

573: end if;
574: --
575: if (l_delete_bals) then
576: --
577: hr_utility.set_location(
578: 'pay_run_balance_build.calculate_full_asg_balances',60);
579: null;
580: --
581: else

Line 583: hr_utility.set_location(

579: null;
580: --
581: else
582: --
583: hr_utility.set_location(
584: 'pay_run_balance_build.calculate_full_asg_balances',70);
585: --
586: pay_balance_pkg.create_all_asg_balances(p_asg_act_id,
587: g_att_name,

Line 594: hr_utility.set_location(

590: end if;
591: end if;
592: --
593: --
594: hr_utility.set_location(
595: 'Leaving:pay_run_balance_build.calculate_full_asg_balances',80);
596: --
597: end calculate_full_asg_balances;
598: --

Line 645: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',10);

641: l_rb_row_status varchar2(1);
642:
643: begin
644: --
645: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',10);
646: --
647: l_run_bal_status := 'U';
648: --
649: if (g_proc_mode <> 'SINGLE') then

Line 651: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',20);

647: l_run_bal_status := 'U';
648: --
649: if (g_proc_mode <> 'SINGLE') then
650: --
651: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',20);
652: --
653: if (g_proc_mode = 'INVALID') then
654: --
655: -- altered delete statement to use pay_balance_attributes rather than

Line 698: hr_utility.trace('process_asg_lvl_balances. Delete rbs by load date. p_asg_id:'||p_asg_id||

694: and assignment_id = p_asg_id;
695: end loop;
696:
697: if g_debug then
698: hr_utility.trace('process_asg_lvl_balances. Delete rbs by load date. p_asg_id:'||p_asg_id||
699: ' cnt:'||sql%rowcount);
700: end if;
701: else
702: -- We must be regenerating all balances

Line 709: hr_utility.trace('process_asg_lvl_balances. Delete rbs by asg . p_asg_id:'||p_asg_id||

705: delete /*+ INDEX(prb PAY_RUN_BALANCES_N1) */
706: from pay_run_balances prb
707: where prb.assignment_id = p_asg_id;
708: if g_debug then
709: hr_utility.trace('process_asg_lvl_balances. Delete rbs by asg . p_asg_id:'||p_asg_id||
710: ' cnt:'||sql%rowcount);
711: end if;
712: end if; --} not purge only
713: end if; --}

Line 740: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',20);

736: --
737: end if;
738: else
739: --
740: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',20);
741: --
742: -- No need to delete the balance, but we do need to get the status
743: --
744: begin

Line 765: hr_utility.trace('pay_run_balance_build.process_asg_lvl_balance delete rb rows before load date:' ||SQL%ROWCOUNT);

761: delete from pay_run_balances where assignment_id = p_asg_id and
762: effective_date < l_bal_load_date
763: and defined_balance_id = g_def_bal_id;
764: if g_debug then
765: hr_utility.trace('pay_run_balance_build.process_asg_lvl_balance delete rb rows before load date:' ||SQL%ROWCOUNT);
766: end if;
767:
768:
769: if not g_purge_only then -- bug 11874880 adjust balance load date

Line 781: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',30);

777: If lt_tab_getaa.count > 0 then
778:
779: for aarec in lt_tab_getaa.first..lt_tab_getaa.last loop
780: --
781: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',30);
782: --
783: if (lt_tab_getaa(aarec).run_method <> 'C') then
784: --
785: --

Line 786: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',40);

782: --
783: if (lt_tab_getaa(aarec).run_method <> 'C') then
784: --
785: --
786: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',40);
787: --
788: if (g_load_type <> 'DELTA') then
789: --
790: --

Line 791: hr_utility.set_location(

787: --
788: if (g_load_type <> 'DELTA') then
789: --
790: --
791: hr_utility.set_location(
792: 'pay_run_balance_build.process_asg_lvl_balance',50);
793: if g_def_bal_id is not null then
794: l_rb_row_status := pay_balance_pkg.run_balance_row_status(g_def_bal_id, p_asg_id,
795: lt_tab_getaa(aarec).assignment_action_id,

Line 813: hr_utility.set_location(

809: --
810: else
811: --
812: --
813: hr_utility.set_location(
814: 'pay_run_balance_build.process_asg_lvl_balance',60);
815: --
816: if (l_run_bal_status = 'V') then
817: --

Line 819: hr_utility.set_location(

815: --
816: if (l_run_bal_status = 'V') then
817: --
818: --
819: hr_utility.set_location(
820: 'pay_run_balance_build.process_asg_lvl_balance',70);
821: --
822: calculate_delta_asg_balances( p_asg_id,
823: lt_tab_getaa(aarec).assignment_action_id,

Line 842: hr_utility.set_location(

838:
839: lt_tab_getaa.delete;
840:
841: end if;
842: hr_utility.set_location(
843: 'Leaving:pay_run_balance_build.process_asg_lvl_balance',80);
844: --
845: end process_asg_lvl_balances;
846: --

Line 870: hr_utility.set_location

866: l_def_bal_id t_def_bal_id;
867: l_delta varchar2(10);
868: begin
869: --
870: hr_utility.set_location
871: ('Entering: pay_run_balance_build.calculate_delta_grp_balances', 10);
872: --
873: if (g_proc_mode = 'SINGLE') then
874: --

Line 974: hr_utility.set_location

970: );
971: end if;
972: end if;
973: end if;
974: hr_utility.set_location
975: ('Leaving: pay_run_balance_build.calculate_delta_grp_balances', 100);
976: --
977: end calculate_delta_grp_balances;
978: --

Line 993: hr_utility.set_location ('Entering: pay_run_balance_build.calculate_full_grp_balances', 10);

989: is
990: l_delete_bals boolean;
991: begin
992: if g_debug then
993: hr_utility.set_location ('Entering: pay_run_balance_build.calculate_full_grp_balances', 10);
994: hr_utility.trace('p_eff_date:'||p_eff_date||' g_start_date:'||g_start_date);
995: end if;
996: if (g_proc_mode = 'SINGLE') then
997: --

Line 994: hr_utility.trace('p_eff_date:'||p_eff_date||' g_start_date:'||g_start_date);

990: l_delete_bals boolean;
991: begin
992: if g_debug then
993: hr_utility.set_location ('Entering: pay_run_balance_build.calculate_full_grp_balances', 10);
994: hr_utility.trace('p_eff_date:'||p_eff_date||' g_start_date:'||g_start_date);
995: end if;
996: if (g_proc_mode = 'SINGLE') then
997: --
998: -- If we have been supplied with a start date then delete

Line 1012: hr_utility.trace('calculate_full_grp_balances1. Delete by pact . p_pactid:'||p_pactid|| ' cnt:'||sql%rowcount);

1008: --
1009: delete from pay_run_balances
1010: where defined_balance_id = g_def_bal_id
1011: and payroll_action_id = p_pactid;
1012: hr_utility.trace('calculate_full_grp_balances1. Delete by pact . p_pactid:'||p_pactid|| ' cnt:'||sql%rowcount);
1013: --
1014: else
1015: --
1016: if not g_purge_only then

Line 1046: hr_utility.trace('calculate_full_grp_balances2. Delete by pact . p_pactid:'||p_pactid|| ' cnt:'||sql%rowcount);

1042: from pay_balance_validation pbv
1043: where pbv.defined_balance_id = prb.defined_balance_id
1044: and pbv.run_balance_status = 'P'
1045: and pbv.business_group_id = p_bus_grp);
1046: hr_utility.trace('calculate_full_grp_balances2. Delete by pact . p_pactid:'||p_pactid|| ' cnt:'||sql%rowcount);
1047: else
1048: --
1049: -- We must be regenerating all balances
1050: --

Line 1054: hr_utility.trace('calculate_full_grp_balances3. Delete by pact . p_pactid:'||p_pactid|| ' cnt:'||sql%rowcount);

1050: --
1051: if ( g_purge_only and g_start_date > p_eff_date ) or (not g_purge_only) then
1052: delete from pay_run_balances
1053: where payroll_action_id = p_pactid;
1054: hr_utility.trace('calculate_full_grp_balances3. Delete by pact . p_pactid:'||p_pactid|| ' cnt:'||sql%rowcount);
1055: end if;
1056: end if;
1057: --
1058: else

Line 1070: hr_utility.set_location ('Leaving: pay_run_balance_build.calculate_full_grp_balances', 90);

1066: end if;
1067: end if;
1068: end if;
1069: if g_debug then
1070: hr_utility.set_location ('Leaving: pay_run_balance_build.calculate_full_grp_balances', 90);
1071: end if;
1072: --
1073: end calculate_full_grp_balances;
1074: --

Line 1092: hr_utility.set_location ('Entering: pay_run_balance_build.process_group_lvl_balances', 10);

1088: l_del_cnt number;
1089: begin
1090: --
1091: if g_debug then
1092: hr_utility.set_location ('Entering: pay_run_balance_build.process_group_lvl_balances', 10);
1093: end if;
1094: begin
1095: select ppa.effective_date,
1096: ppa.business_group_id,

Line 1129: hr_utility.trace('process_group_lvl_balances1. Delete rbs by rbstatus . p_pactid:'||p_pactid||

1125: where pbv.defined_balance_id = prb.defined_balance_id
1126: and pbv.run_balance_status = 'P'
1127: and pbv.business_group_id = l_bus_grp);
1128: if g_debug then
1129: hr_utility.trace('process_group_lvl_balances1. Delete rbs by rbstatus . p_pactid:'||p_pactid||
1130: ' cnt:'||sql%rowcount);
1131: end if;
1132: --
1133: else

Line 1152: hr_utility.trace('process_group_lvl_balances. Delete rbs by load date. p_pactid:'||p_pactid||

1148:
1149: end loop;
1150:
1151: if g_debug then
1152: hr_utility.trace('process_group_lvl_balances. Delete rbs by load date. p_pactid:'||p_pactid||
1153: ' cnt:'||l_del_cnt);
1154: end if;
1155: else
1156: --

Line 1161: hr_utility.trace('process_group_lvl_balances3. Delete rbs by pact . p_pactid:'||p_pactid||

1157: delete /*+ INDEX(prb PAY_RUN_BALANCES_N4) */
1158: from pay_run_balances prb
1159: where prb.payroll_action_id = p_pactid;
1160: if g_debug then
1161: hr_utility.trace('process_group_lvl_balances3. Delete rbs by pact . p_pactid:'||p_pactid||
1162: ' cnt:'||sql%rowcount);
1163: end if;
1164: end if;
1165: --

Line 1186: hr_utility.trace('process_group_lvl_balances4. Delete rbs date . p_pactid:'||p_pactid||

1182: )
1183: )
1184: );
1185: if g_debug then
1186: hr_utility.trace('process_group_lvl_balances4. Delete rbs date . p_pactid:'||p_pactid||
1187: ' cnt:'||sql%rowcount);
1188: end if;
1189: --
1190: end if;

Line 1235: hr_utility.set_location ('Leaving: pay_run_balance_build.process_group_lvl_balances', 90);

1231: end if;
1232: --
1233: end if;
1234: if g_debug then
1235: hr_utility.set_location ('Leaving: pay_run_balance_build.process_group_lvl_balances', 90);
1236: end if;
1237: --
1238: end process_group_lvl_balances;
1239: --

Line 1282: hr_utility.set_location(

1278: l_asg_id pay_assignment_actions.assignment_id%type;
1279: l_chunk_number pay_assignment_actions.chunk_number%type;
1280: --
1281: BEGIN
1282: hr_utility.set_location(
1283: 'Entering:pay_run_balance_build.action_archive_data',10);
1284: --
1285: select paa.payroll_action_id,
1286: paa.object_id,

Line 1299: hr_utility.set_location(

1295: --
1296: set_globals(l_payroll_action_id);
1297: --
1298: --
1299: hr_utility.set_location(
1300: 'pay_run_balance_build.action_archive_data',20);
1301: --
1302: /* Have we timed out */
1303: select sysdate

Line 1309: hr_utility.set_message(801,'PAY_289014_PUR_TIMEOUT');

1305: from sys.dual;
1306: --
1307: if (current_date > g_timeout) then
1308: /* Error, timed out process */
1309: hr_utility.set_message(801,'PAY_289014_PUR_TIMEOUT');
1310: hr_utility.raise_error;
1311: end if;
1312: --
1313: /* do we need to load assignment balances */

Line 1310: hr_utility.raise_error;

1306: --
1307: if (current_date > g_timeout) then
1308: /* Error, timed out process */
1309: hr_utility.set_message(801,'PAY_289014_PUR_TIMEOUT');
1310: hr_utility.raise_error;
1311: end if;
1312: --
1313: /* do we need to load assignment balances */
1314: load_bals := TRUE;

Line 1319: hr_utility.set_location(

1315: --
1316: if (load_bals) then
1317: --
1318: --
1319: hr_utility.set_location(
1320: 'pay_run_balance_build.action_archive_data',30);
1321: --
1322: if (g_bal_lvl = 'GRP') then
1323: --

Line 1325: hr_utility.set_location(

1321: --
1322: if (g_bal_lvl = 'GRP') then
1323: --
1324: --
1325: hr_utility.set_location(
1326: 'pay_run_balance_build.action_archive_data',40);
1327: --
1328: /* Only do something if the legislation rule is set */
1329: if (g_save_run_bals = 'Y') then

Line 1332: hr_utility.set_location(

1328: /* Only do something if the legislation rule is set */
1329: if (g_save_run_bals = 'Y') then
1330: --
1331: --
1332: hr_utility.set_location(
1333: 'pay_run_balance_build.action_archive_data',50);
1334: --
1335: process_group_lvl_balances(l_object_id);
1336: --

Line 1341: hr_utility.set_location(

1337: end if;
1338: else
1339: --
1340: --
1341: hr_utility.set_location(
1342: 'pay_run_balance_build.action_archive_data',60);
1343: --
1344: /* Only do something if the legislation rule is set */
1345: if (g_save_asg_run_bals = 'Y') then

Line 1348: hr_utility.set_location(

1344: /* Only do something if the legislation rule is set */
1345: if (g_save_asg_run_bals = 'Y') then
1346: --
1347: --
1348: hr_utility.set_location(
1349: 'pay_run_balance_build.action_archive_data',70);
1350: --
1351: process_asg_lvl_balances(l_asg_id,
1352: l_bus_grp, l_chunk_number);

Line 1358: hr_utility.set_location(

1354: end if;
1355: end if;
1356: --
1357: --
1358: hr_utility.set_location(
1359: 'pay_run_balance_build.action_archive_data',80);
1360: --
1361: end if;
1362: --

Line 1364: hr_utility.set_location(

1360: --
1361: end if;
1362: --
1363: --
1364: hr_utility.set_location(
1365: 'Leaving:pay_run_balance_build.action_archive_data',90);
1366: --
1367: END action_archive_data;
1368:

Line 1462: hr_utility.set_location( 'Enter:runbal_bld.generate_attribute. g_bal_lvl:'||g_bal_lvl||

1458: --
1459: -- Use for both DELTA and NON DELTA modes
1460: --
1461: if g_debug then
1462: hr_utility.set_location( 'Enter:runbal_bld.generate_attribute. g_bal_lvl:'||g_bal_lvl||
1463: ' g_proc_mode:'||g_proc_mode,10);
1464: end if;
1465: l_attribute_name := 'GEN_BAL_'||p_payroll_action_id;
1466: --

Line 1491: hr_utility.trace(' looping grprec g_old_balance_validation_tab.count:'||g_old_balance_validation_tab.count);

1487: g_def_bal_id) loop
1488: -- bug 11874880 don't attribute in purge only mode
1489: l_purge_only := FALSE;
1490: if ((g_program_name = 'RB_ADJD') and (g_old_balance_validation_tab.count > 0)) then
1491: hr_utility.trace(' looping grprec g_old_balance_validation_tab.count:'||g_old_balance_validation_tab.count);
1492: for old_bv in g_old_balance_validation_tab.first..g_old_balance_validation_tab.last loop
1493: if grprec.defined_balance_id = g_old_balance_validation_tab(old_bv).defined_balance_id then
1494: if g_old_balance_validation_tab(old_bv).purge_only = 'Y' then
1495: if g_debug then

Line 1496: hr_utility.trace('generate_attribute. purge only. defined_balance_id:'||grprec.defined_balance_id);

1492: for old_bv in g_old_balance_validation_tab.first..g_old_balance_validation_tab.last loop
1493: if grprec.defined_balance_id = g_old_balance_validation_tab(old_bv).defined_balance_id then
1494: if g_old_balance_validation_tab(old_bv).purge_only = 'Y' then
1495: if g_debug then
1496: hr_utility.trace('generate_attribute. purge only. defined_balance_id:'||grprec.defined_balance_id);
1497: end if;
1498: l_purge_only := TRUE;
1499: end if;
1500: exit;

Line 1507: hr_utility.trace('generate_attribute. defined_balance_id:'||grprec.defined_balance_id||

1503: end if;
1504: --
1505: if not l_purge_only then
1506: if g_debug then
1507: hr_utility.trace('generate_attribute. defined_balance_id:'||grprec.defined_balance_id||
1508: ' l_attribute_name:'||l_attribute_name);
1509: end if;
1510: insert into pay_balance_attributes
1511: (balance_attribute_id,

Line 1541: hr_utility.trace('generate_attribute. purge only. defined_balance_id:'||asgrec.defined_balance_id);

1537: for old_bv in g_old_balance_validation_tab.first..g_old_balance_validation_tab.last loop
1538: if asgrec.defined_balance_id = g_old_balance_validation_tab(old_bv).defined_balance_id then
1539: if g_old_balance_validation_tab(old_bv).purge_only = 'Y' then
1540: if g_debug then
1541: hr_utility.trace('generate_attribute. purge only. defined_balance_id:'||asgrec.defined_balance_id);
1542: end if;
1543: l_purge_only := TRUE;
1544: end if;
1545: exit;

Line 1551: hr_utility.trace('generate_attribute. defined_balance_id:'||asgrec.defined_balance_id||

1547: end loop;
1548: end if;
1549: if not l_purge_only then
1550: if g_debug then
1551: hr_utility.trace('generate_attribute. defined_balance_id:'||asgrec.defined_balance_id||
1552: ' l_attribute_name:'||l_attribute_name);
1553: end if;
1554: insert into pay_balance_attributes
1555: (balance_attribute_id,

Line 1586: hr_utility.trace('In Range cursor before building string ');

1582: IS
1583: --
1584: lv_sql_string VARCHAR2(32000);
1585: begin
1586: hr_utility.trace('In Range cursor before building string ');
1587: --
1588: set_globals(p_payroll_action_id);
1589: set_run_bal_status(p_payroll_action_id, 'P');
1590: --

Line 1627: hr_utility.trace('In Range cursor after building string ');

1623: end if;
1624: end if;
1625: --
1626: p_sqlstr := lv_sql_string;
1627: hr_utility.trace('In Range cursor after building string ');
1628: --
1629: hr_utility.trace('Build Bal Attribute Group');
1630: --
1631: generate_attribute(p_payroll_action_id);

Line 1629: hr_utility.trace('Build Bal Attribute Group');

1625: --
1626: p_sqlstr := lv_sql_string;
1627: hr_utility.trace('In Range cursor after building string ');
1628: --
1629: hr_utility.trace('Build Bal Attribute Group');
1630: --
1631: generate_attribute(p_payroll_action_id);
1632: --
1633: hr_utility.trace('Built Bal Attribute Group');

Line 1633: hr_utility.trace('Built Bal Attribute Group');

1629: hr_utility.trace('Build Bal Attribute Group');
1630: --
1631: generate_attribute(p_payroll_action_id);
1632: --
1633: hr_utility.trace('Built Bal Attribute Group');
1634:
1635: END action_range_cursor;
1636:
1637:

Line 1709: hr_utility.trace('In action Creation before getting payroll information');

1705: l_range_person BOOLEAN default FALSE; -- 8361030 Variable used to check if RANGE_PERSON_ID is enabled
1706:
1707: begin
1708: --
1709: hr_utility.trace('In action Creation before getting payroll information');
1710: --
1711: set_globals(p_payroll_action_id);
1712: --
1713: if (g_bal_lvl = 'GRP') then

Line 1746: hr_utility.trace('In action Creation range_person_id = Y ');

1742: ,p_report_category => 'PROCESS');
1743:
1744:
1745: if l_range_person then
1746: hr_utility.trace('In action Creation range_person_id = Y ');
1747: insert into pay_assignment_actions (
1748: assignment_action_id,
1749: assignment_id,
1750: payroll_action_id,

Line 1778: hr_utility.trace(' Action creation p_chunk:'||p_chunk||' SQL%ROWCOUNT:'||SQL%ROWCOUNT);

1774: and pos.business_group_id = ppa.business_group_id
1775: and ppa.payroll_action_id = p_payroll_action_id
1776: and ppa.business_group_id = paf.business_group_id
1777: order by 1 ) asg ;
1778: hr_utility.trace(' Action creation p_chunk:'||p_chunk||' SQL%ROWCOUNT:'||SQL%ROWCOUNT);
1779: else
1780: hr_utility.trace('In action Creation range_person_id = N ');
1781: insert into pay_assignment_actions (
1782: assignment_action_id,

Line 1780: hr_utility.trace('In action Creation range_person_id = N ');

1776: and ppa.business_group_id = paf.business_group_id
1777: order by 1 ) asg ;
1778: hr_utility.trace(' Action creation p_chunk:'||p_chunk||' SQL%ROWCOUNT:'||SQL%ROWCOUNT);
1779: else
1780: hr_utility.trace('In action Creation range_person_id = N ');
1781: insert into pay_assignment_actions (
1782: assignment_action_id,
1783: assignment_id,
1784: payroll_action_id,

Line 1811: hr_utility.trace(' Action creation p_start_person_id:'||p_start_person_id||

1807: and pos.business_group_id = ppa.business_group_id
1808: and ppa.payroll_action_id = p_payroll_action_id
1809: and ppa.business_group_id = paf.business_group_id
1810: order by 1 ) asg ;
1811: hr_utility.trace(' Action creation p_start_person_id:'||p_start_person_id||
1812: ' p_end_person_id:'||p_end_person_id||' SQL%ROWCOUNT:'||SQL%ROWCOUNT);
1813: end if;
1814: end if;
1815: --

Line 1884: hr_utility.trace('ACTION_ARCHINIT get CONCURRENT_PROGRAM_NAME. g_program_name:'||g_program_name||' g_proc_mode:'||g_proc_mode);

1880: FND_CONCURRENT_PROGRAMS fcp
1881: where fcr.REQUEST_ID = l_request_id
1882: and fcp.CONCURRENT_PROGRAM_ID = fcr.CONCURRENT_PROGRAM_ID;
1883: if g_debug then
1884: hr_utility.trace('ACTION_ARCHINIT get CONCURRENT_PROGRAM_NAME. g_program_name:'||g_program_name||' g_proc_mode:'||g_proc_mode);
1885: end if;
1886:
1887: if (g_proc_mode <> 'SINGLE') then --{ single
1888: -- bug 11874880 fetch pregenerate load date

Line 1906: hr_utility.trace('set_run_bal_status store g_old_balance_validation_tab. '|| g_old_balance_validation_tab.count);

1902: and ba.defined_balance_id = bv.defined_balance_id) balance_status
1903: from pay_balance_validation bv
1904: where bv.business_group_id = l_bus_grp) bv2;
1905: if g_debug then --{
1906: hr_utility.trace('set_run_bal_status store g_old_balance_validation_tab. '|| g_old_balance_validation_tab.count);
1907: end if; --}
1908: end if; --}
1909: ELSE
1910: if g_program_name = 'RB_ADJD' and l_parm_purge_only = 'Y' then --{ Single RB_ADJD Purge Only

Line 1913: hr_utility.trace('set_run_bal_status store g_purge_only from legislation_parameters. ');

1909: ELSE
1910: if g_program_name = 'RB_ADJD' and l_parm_purge_only = 'Y' then --{ Single RB_ADJD Purge Only
1911: g_purge_only := TRUE;
1912: if g_debug then --{
1913: hr_utility.trace('set_run_bal_status store g_purge_only from legislation_parameters. ');
1914: end if; --}
1915: end if; --}
1916: end if; --}
1917: end if; --}

Line 1954: hr_utility.set_location('pay_run_balance_build.deinitialise', 10);

1950: begin
1951: --
1952: set_globals(pactid);
1953: --
1954: hr_utility.set_location('pay_run_balance_build.deinitialise', 10);
1955: /* only do something if the legislation rule is set */
1956: if (g_save_run_bals = 'Y') then
1957: /* do we need to load assignment balances */
1958: hr_utility.set_location('pay_run_balance_build.deinitialise', 20);

Line 1958: hr_utility.set_location('pay_run_balance_build.deinitialise', 20);

1954: hr_utility.set_location('pay_run_balance_build.deinitialise', 10);
1955: /* only do something if the legislation rule is set */
1956: if (g_save_run_bals = 'Y') then
1957: /* do we need to load assignment balances */
1958: hr_utility.set_location('pay_run_balance_build.deinitialise', 20);
1959: load_bals := TRUE;
1960: if (g_proc_mode = 'SINGLE') then
1961: load_bals := FALSE;
1962: elsif (g_bal_lvl = 'GRP') then

Line 1969: hr_utility.set_location('pay_run_balance_build.deinitialise', 30);

1965: --
1966: cnt := 0;
1967: if (load_bals) then
1968: --
1969: hr_utility.set_location('pay_run_balance_build.deinitialise', 30);
1970: --
1971: if (g_bal_lvl = 'BOTH') then
1972: hr_utility.set_location('pay_run_balance_build.deinitialise', 40);
1973: for parec in getpa(pactid) loop

Line 1972: hr_utility.set_location('pay_run_balance_build.deinitialise', 40);

1968: --
1969: hr_utility.set_location('pay_run_balance_build.deinitialise', 30);
1970: --
1971: if (g_bal_lvl = 'BOTH') then
1972: hr_utility.set_location('pay_run_balance_build.deinitialise', 40);
1973: for parec in getpa(pactid) loop
1974: hr_utility.set_location('pay_run_balance_build.deinitialise', 50);
1975: --
1976: process_group_lvl_balances(parec.payroll_action_id);

Line 1974: hr_utility.set_location('pay_run_balance_build.deinitialise', 50);

1970: --
1971: if (g_bal_lvl = 'BOTH') then
1972: hr_utility.set_location('pay_run_balance_build.deinitialise', 40);
1973: for parec in getpa(pactid) loop
1974: hr_utility.set_location('pay_run_balance_build.deinitialise', 50);
1975: --
1976: process_group_lvl_balances(parec.payroll_action_id);
1977: --
1978: end loop;

Line 1984: hr_utility.set_location('pay_run_balance_build.deinitialise', 60);

1980: --
1981: end if;
1982: end if;
1983: --
1984: hr_utility.set_location('pay_run_balance_build.deinitialise', 60);
1985: --
1986: /* Remove the actions if needed */
1987: select count(*)
1988: into act_com

Line 2019: --hr_utility.trace_off;

2015: where attribute_name = g_att_name;
2016: end if;
2017: end if;
2018: --
2019: --hr_utility.trace_off;
2020: end deinitialise;
2021: --
2022: begin
2023: g_globals_set := FALSE;