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 328: hr_utility.set_location

324: l_delta varchar2(10);
325: --
326: begin
327: --
328: hr_utility.set_location
329: ('Entering: pay_run_balance_build.calculate_delta_asg_balnces', 10);
330: if (g_proc_mode = 'SINGLE') then
331: --
332: -- If we have been supplied with a start date then delete

Line 400: hr_utility.set_location

396: --
397: end if;
398: end if;
399: --
400: hr_utility.set_location
401: ('Leaving: pay_run_balance_build.calculate_delta_asg_balances', 100);
402: end calculate_delta_asg_balances;
403: --
404: /* Name : calculate_full_asg_balances

Line 418: hr_utility.set_location(

414: l_delete_bals boolean;
415: begin
416: --
417: --
418: hr_utility.set_location(
419: 'Enter:pay_run_balance_build.calculate_full_asg_balances',10);
420: --
421: if (g_proc_mode = 'SINGLE') then
422: --

Line 426: hr_utility.set_location(

422: --
423: -- If we have been supplied with a start date then delete
424: -- any run balance prior to this date.
425: --
426: hr_utility.set_location(
427: 'pay_run_balance_build.calculate_full_asg_balances',20);
428: --
429: l_delete_bals := FALSE;
430: if (g_start_date is not null

Line 438: hr_utility.set_location(

434: --
435: if (l_delete_bals) then
436: --
437: --
438: hr_utility.set_location(
439: 'pay_run_balance_build.calculate_full_asg_balances',30);
440:
441: --
442: delete /*+ INDEX(prb PAY_RUN_BALANCES_N2) */

Line 450: hr_utility.set_location(

446: --
447: else
448: --
449: --
450: hr_utility.set_location(
451: 'pay_run_balance_build.calculate_full_asg_balances',40);
452: --
453: pay_balance_pkg.create_asg_balance(g_def_bal_id
454: ,p_asg_act_id

Line 462: hr_utility.set_location(

458: end if;
459: --
460: else
461: --
462: hr_utility.set_location(
463: 'pay_run_balance_build.calculate_full_asg_balances',50);
464: --
465: -- If we have been supplied with a start date then delete
466: -- any run balance prior to this date.

Line 476: hr_utility.set_location(

472: end if;
473: --
474: if (l_delete_bals) then
475: --
476: hr_utility.set_location(
477: 'pay_run_balance_build.calculate_full_asg_balances',60);
478: null;
479: --
480: else

Line 482: hr_utility.set_location(

478: null;
479: --
480: else
481: --
482: hr_utility.set_location(
483: 'pay_run_balance_build.calculate_full_asg_balances',70);
484: --
485: pay_balance_pkg.create_all_asg_balances(p_asg_act_id,
486: g_att_name,

Line 493: hr_utility.set_location(

489: end if;
490: end if;
491: --
492: --
493: hr_utility.set_location(
494: 'Leaving:pay_run_balance_build.calculate_full_asg_balances',80);
495: --
496: end calculate_full_asg_balances;
497: --

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

531: l_run_bal_status pay_balance_validation.run_balance_status%type;
532: l_bal_load_date pay_balance_validation.balance_load_date%type;
533: begin
534: --
535: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',10);
536: --
537: l_run_bal_status := 'V';
538: --
539: if (g_proc_mode <> 'SINGLE') then

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

537: l_run_bal_status := 'V';
538: --
539: if (g_proc_mode <> 'SINGLE') then
540: --
541: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',20);
542: --
543: if (g_proc_mode = 'INVALID') then
544: --
545: -- altered delete statement to use pay_balance_attributes rather than

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

589: --
590: end if;
591: else
592: --
593: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',20);
594: --
595: -- No need to delete the balance, but we do need to get the status
596: --
597: begin

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

611: end if;
612: --
613: for aarec in getaa(p_asg_id) loop
614: --
615: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',30);
616: --
617: if (aarec.run_method <> 'C') then
618: --
619: --

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

616: --
617: if (aarec.run_method <> 'C') then
618: --
619: --
620: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',40);
621: --
622: if (g_load_type <> 'DELTA') then
623: --
624: --

Line 625: hr_utility.set_location(

621: --
622: if (g_load_type <> 'DELTA') then
623: --
624: --
625: hr_utility.set_location(
626: 'pay_run_balance_build.process_asg_lvl_balance',50);
627: --
628: calculate_full_asg_balances( aarec.assignment_action_id,
629: aarec.effective_date

Line 635: hr_utility.set_location(

631: --
632: else
633: --
634: --
635: hr_utility.set_location(
636: 'pay_run_balance_build.process_asg_lvl_balance',60);
637: --
638: if (l_run_bal_status = 'V') then
639: --

Line 641: hr_utility.set_location(

637: --
638: if (l_run_bal_status = 'V') then
639: --
640: --
641: hr_utility.set_location(
642: 'pay_run_balance_build.process_asg_lvl_balance',70);
643: --
644: calculate_delta_asg_balances( aarec.assignment_action_id,
645: aarec.effective_date,

Line 656: hr_utility.set_location(

652: end if;
653: end loop;
654: --
655: --
656: hr_utility.set_location(
657: 'Leaving:pay_run_balance_build.process_asg_lvl_balance',80);
658: --
659: end process_asg_lvl_balances;
660: --

Line 684: hr_utility.set_location

680: l_def_bal_id t_def_bal_id;
681: l_delta varchar2(10);
682: begin
683: --
684: hr_utility.set_location
685: ('Entering: pay_run_balance_build.calculate_delta_grp_balances', 10);
686: --
687: if (g_proc_mode = 'SINGLE') then
688: --

Line 786: hr_utility.set_location

782: ,p_delta => l_delta
783: );
784: end if;
785: end if;
786: hr_utility.set_location
787: ('Leaving: pay_run_balance_build.calculate_delta_grp_balances', 100);
788: --
789: end calculate_delta_grp_balances;
790: --

Line 1038: hr_utility.set_location(

1034: l_bus_grp pay_payroll_actions.business_group_id%type;
1035: l_asg_id pay_assignment_actions.assignment_id%type;
1036: --
1037: BEGIN
1038: hr_utility.set_location(
1039: 'Entering:pay_run_balance_build.action_archive_data',10);
1040: --
1041: select paa.payroll_action_id,
1042: paa.object_id,

Line 1054: hr_utility.set_location(

1050: --
1051: set_globals(l_payroll_action_id);
1052: --
1053: --
1054: hr_utility.set_location(
1055: 'pay_run_balance_build.action_archive_data',20);
1056: --
1057: /* Have we timed out */
1058: select sysdate

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

1060: from sys.dual;
1061: --
1062: if (current_date > g_timeout) then
1063: /* Error, timed out process */
1064: hr_utility.set_message(801,'PAY_289014_PUR_TIMEOUT');
1065: hr_utility.raise_error;
1066: end if;
1067: --
1068: /* do we need to load assignment balances */

Line 1065: hr_utility.raise_error;

1061: --
1062: if (current_date > g_timeout) then
1063: /* Error, timed out process */
1064: hr_utility.set_message(801,'PAY_289014_PUR_TIMEOUT');
1065: hr_utility.raise_error;
1066: end if;
1067: --
1068: /* do we need to load assignment balances */
1069: load_bals := TRUE;

Line 1074: hr_utility.set_location(

1070: --
1071: if (load_bals) then
1072: --
1073: --
1074: hr_utility.set_location(
1075: 'pay_run_balance_build.action_archive_data',30);
1076: --
1077: if (g_bal_lvl = 'GRP') then
1078: --

Line 1080: hr_utility.set_location(

1076: --
1077: if (g_bal_lvl = 'GRP') then
1078: --
1079: --
1080: hr_utility.set_location(
1081: 'pay_run_balance_build.action_archive_data',40);
1082: --
1083: /* Only do something if the legislation rule is set */
1084: if (g_save_run_bals = 'Y') then

Line 1087: hr_utility.set_location(

1083: /* Only do something if the legislation rule is set */
1084: if (g_save_run_bals = 'Y') then
1085: --
1086: --
1087: hr_utility.set_location(
1088: 'pay_run_balance_build.action_archive_data',50);
1089: --
1090: process_group_lvl_balances(l_object_id);
1091: --

Line 1096: hr_utility.set_location(

1092: end if;
1093: else
1094: --
1095: --
1096: hr_utility.set_location(
1097: 'pay_run_balance_build.action_archive_data',60);
1098: --
1099: /* Only do something if the legislation rule is set */
1100: if (g_save_asg_run_bals = 'Y') then

Line 1103: hr_utility.set_location(

1099: /* Only do something if the legislation rule is set */
1100: if (g_save_asg_run_bals = 'Y') then
1101: --
1102: --
1103: hr_utility.set_location(
1104: 'pay_run_balance_build.action_archive_data',70);
1105: --
1106: process_asg_lvl_balances(l_asg_id,
1107: l_bus_grp);

Line 1113: hr_utility.set_location(

1109: end if;
1110: end if;
1111: --
1112: --
1113: hr_utility.set_location(
1114: 'pay_run_balance_build.action_archive_data',80);
1115: --
1116: end if;
1117: --

Line 1119: hr_utility.set_location(

1115: --
1116: end if;
1117: --
1118: --
1119: hr_utility.set_location(
1120: 'Leaving:pay_run_balance_build.action_archive_data',90);
1121: --
1122: END action_archive_data;
1123:

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

1287: IS
1288: --
1289: lv_sql_string VARCHAR2(32000);
1290: begin
1291: hr_utility.trace('In Range cursor before building string ');
1292: --
1293: set_globals(p_payroll_action_id);
1294: set_run_bal_status(p_payroll_action_id, 'P');
1295: --

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

1328: end if;
1329: end if;
1330: --
1331: p_sqlstr := lv_sql_string;
1332: hr_utility.trace('In Range cursor after building string ');
1333: --
1334: hr_utility.trace('Build Bal Attribute Group');
1335: --
1336: generate_attribute(p_payroll_action_id);

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

1330: --
1331: p_sqlstr := lv_sql_string;
1332: hr_utility.trace('In Range cursor after building string ');
1333: --
1334: hr_utility.trace('Build Bal Attribute Group');
1335: --
1336: generate_attribute(p_payroll_action_id);
1337: --
1338: hr_utility.trace('Built Bal Attribute Group');

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

1334: hr_utility.trace('Build Bal Attribute Group');
1335: --
1336: generate_attribute(p_payroll_action_id);
1337: --
1338: hr_utility.trace('Built Bal Attribute Group');
1339:
1340: END action_range_cursor;
1341:
1342:

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

1388: ln_lockingactid number;
1389: --
1390: begin
1391: --
1392: hr_utility.trace('In action Creation before getting payroll information');
1393: --
1394: set_globals(p_payroll_action_id);
1395: --
1396: if (g_bal_lvl = 'GRP') then

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

1511: begin
1512: --
1513: set_globals(pactid);
1514: --
1515: hr_utility.set_location('pay_run_balance_build.deinitialise', 10);
1516: /* only do something if the legislation rule is set */
1517: if (g_save_run_bals = 'Y') then
1518: /* do we need to load assignment balances */
1519: hr_utility.set_location('pay_run_balance_build.deinitialise', 20);

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

1515: hr_utility.set_location('pay_run_balance_build.deinitialise', 10);
1516: /* only do something if the legislation rule is set */
1517: if (g_save_run_bals = 'Y') then
1518: /* do we need to load assignment balances */
1519: hr_utility.set_location('pay_run_balance_build.deinitialise', 20);
1520: load_bals := TRUE;
1521: if (g_proc_mode = 'SINGLE') then
1522: load_bals := FALSE;
1523: elsif (g_bal_lvl = 'GRP') then

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

1526: --
1527: cnt := 0;
1528: if (load_bals) then
1529: --
1530: hr_utility.set_location('pay_run_balance_build.deinitialise', 30);
1531: --
1532: if (g_bal_lvl = 'BOTH') then
1533: hr_utility.set_location('pay_run_balance_build.deinitialise', 40);
1534: for parec in getpa(pactid) loop

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

1529: --
1530: hr_utility.set_location('pay_run_balance_build.deinitialise', 30);
1531: --
1532: if (g_bal_lvl = 'BOTH') then
1533: hr_utility.set_location('pay_run_balance_build.deinitialise', 40);
1534: for parec in getpa(pactid) loop
1535: hr_utility.set_location('pay_run_balance_build.deinitialise', 50);
1536: --
1537: process_group_lvl_balances(parec.payroll_action_id);

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

1531: --
1532: if (g_bal_lvl = 'BOTH') then
1533: hr_utility.set_location('pay_run_balance_build.deinitialise', 40);
1534: for parec in getpa(pactid) loop
1535: hr_utility.set_location('pay_run_balance_build.deinitialise', 50);
1536: --
1537: process_group_lvl_balances(parec.payroll_action_id);
1538: --
1539: end loop;

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

1541: --
1542: end if;
1543: end if;
1544: --
1545: hr_utility.set_location('pay_run_balance_build.deinitialise', 60);
1546: --
1547: /* Remove the actions if needed */
1548: select count(*)
1549: into act_com

Line 1580: --hr_utility.trace_off;

1576: where attribute_name = g_att_name;
1577: end if;
1578: end if;
1579: --
1580: --hr_utility.trace_off;
1581: end deinitialise;
1582: --
1583: begin
1584: g_globals_set := FALSE;