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

Line 131: hr_utility.trace('ALU : ' || l_alu_start || ' ' || l_alu_end);

127: v_previous_end_date);
128:
129: --
130: if l_alu_end >= l_alu_start then
131: hr_utility.trace('ALU : ' || l_alu_start || ' ' || l_alu_end);
132:
133: l_idx := v_asg_id_tab.count+1;
134: --
135: -- Set the ALU data to table variables.

Line 283: hr_utility.trace('l_assignment_id '||l_assignment_id);

279: dbms_sql.column_value(sql_curs,1,l_assignment_id);
280: dbms_sql.column_value(sql_curs,2,l_effective_start_date);
281: dbms_sql.column_value(sql_curs,3,l_effective_end_date);
282: --
283: hr_utility.trace('l_assignment_id '||l_assignment_id);
284: hr_utility.trace('l_effective_start_date '||l_effective_start_date);
285: hr_utility.trace('l_effective_end_date '||l_effective_end_date);
286: --
287: if row_count = 1 then -- Skip first row but set ID

Line 284: hr_utility.trace('l_effective_start_date '||l_effective_start_date);

280: dbms_sql.column_value(sql_curs,2,l_effective_start_date);
281: dbms_sql.column_value(sql_curs,3,l_effective_end_date);
282: --
283: hr_utility.trace('l_assignment_id '||l_assignment_id);
284: hr_utility.trace('l_effective_start_date '||l_effective_start_date);
285: hr_utility.trace('l_effective_end_date '||l_effective_end_date);
286: --
287: if row_count = 1 then -- Skip first row but set ID
288: --

Line 285: hr_utility.trace('l_effective_end_date '||l_effective_end_date);

281: dbms_sql.column_value(sql_curs,3,l_effective_end_date);
282: --
283: hr_utility.trace('l_assignment_id '||l_assignment_id);
284: hr_utility.trace('l_effective_start_date '||l_effective_start_date);
285: hr_utility.trace('l_effective_end_date '||l_effective_end_date);
286: --
287: if row_count = 1 then -- Skip first row but set ID
288: --
289: v_rows_were_found := TRUE;

Line 755: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');

751: when hr_api.object_locked then
752: --
753: -- Failed to lock the assignment.
754: --
755: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
756: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');
757: hr_utility.raise_error;
758: end lock_asg;
759: --

Line 756: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');

752: --
753: -- Failed to lock the assignment.
754: --
755: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
756: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');
757: hr_utility.raise_error;
758: end lock_asg;
759: --
760: begin

Line 757: hr_utility.raise_error;

753: -- Failed to lock the assignment.
754: --
755: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
756: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');
757: hr_utility.raise_error;
758: end lock_asg;
759: --
760: begin
761:

Line 762: hr_utility.set_location('Entering: '||l_proc, 5);

758: end lock_asg;
759: --
760: begin
761:
762: hr_utility.set_location('Entering: '||l_proc, 5);
763: --
764: -- Check the eligibility of the people group and
765: -- also establish the necessary cache.
766: --

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

773: -- Construct the date tables for ALU
774: --
775: if l_eligible_pg_exists then
776:
777: hr_utility.set_location(l_proc, 10);
778:
779: l_asg_locked := false;
780: --
781: -- Setup the ALU table data

Line 867: hr_utility.set_location('Leaving: '||l_proc, 100);

863: );
864: --
865: end if;
866: --
867: hr_utility.set_location('Leaving: '||l_proc, 100);
868: --
869: end create_alu_asg_pg;
870: --
871: --------------------------------------------------------------------------------

Line 909: hr_utility.set_location('Entering: '||l_proc, 5);

905: l_link_idx number;
906: --
907: begin
908: --
909: hr_utility.set_location('Entering: '||l_proc, 5);
910: --
911: -- Check to see if the specified table variable contains
912: -- any element link data.
913: --

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

914: if p_pg_link_tab.count = 0 then
915: --
916: -- No element link was specified, hence exit this procedure.
917: --
918: hr_utility.set_location(l_proc, 10);
919: return;
920: end if;
921:
922: --

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

931: --
932: -- No people group is associated with this assignment,
933: -- hence exit this procedure.
934: --
935: hr_utility.set_location(l_proc, 20);
936: return;
937: end if;
938:
939: --

Line 998: hr_utility.set_location('Leaving: '||l_proc, 100);

994: end if;
995: --
996: end loop;
997: --
998: hr_utility.set_location('Leaving: '||l_proc, 100);
999: --
1000: end create_alu_asg;
1001: --
1002: --------------------------------------------------------------------------------