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.PAYVWELE dependencies on HR_UTILITY

Line 29: hr_utility.set_location('payvwele.forms_startup', 0);

25: l_session_date DATE;
26:
27: BEGIN
28: --
29: hr_utility.set_location('payvwele.forms_startup', 0);
30: --
31: IF p_assignment_action_id = -1 THEN
32: l_session_date := get_fpd_or_atd(p_assignment_id, p_session_date);
33: IF l_session_date IS NULL THEN --current employee

Line 55: hr_utility.set_location('payvwele.forms_startup', 1);

51: P_ASG_YTD := GET_DIM_ID('_ASG_'||p_level||'_'||'YTD',p_legislation_code);
52: P_ASG_ITD := GET_DIM_ID('_ASG_'||p_level||'_'||'ITD',p_legislation_code);
53: P_ASG_GRE_ITD := GET_DIM_ID('_ASG_GRE_ITD',p_legislation_code);
54: --
55: hr_utility.set_location('payvwele.forms_startup', 1);
56: --
57: -- Commented out as the user can now select the GRE in the form,
58: -- so don't want to be restricted to the GRE of the session date.
59: --

Line 62: hr_utility.set_location('payvwele.forms_startup', 2);

58: -- so don't want to be restricted to the GRE of the session date.
59: --
60: --p_tax_unit_id := get_tax_unit_id ( p_assignment_id, l_session_date);
61: --
62: hr_utility.set_location('payvwele.forms_startup', 2);
63: --
64: p_action_date := get_action_date (p_assignment_action_id);
65: --
66: hr_utility.set_location('payvwele.forms_startup', 3);

Line 66: hr_utility.set_location('payvwele.forms_startup', 3);

62: hr_utility.set_location('payvwele.forms_startup', 2);
63: --
64: p_action_date := get_action_date (p_assignment_action_id);
65: --
66: hr_utility.set_location('payvwele.forms_startup', 3);
67: --
68: END forms_startup;
69: --
70: FUNCTION get_tax_unit_id ( p_assignment_id NUMBER,

Line 79: hr_utility.set_location('payvwele.get_tax_unit_id', 0);

75: l_tax_unit_id NUMBER(9);
76: --
77: BEGIN
78: --
79: hr_utility.set_location('payvwele.get_tax_unit_id', 0);
80: --
81: SELECT scl.segment1
82: INTO l_tax_unit_id
83: FROM hr_soft_coding_keyflex scl,

Line 90: hr_utility.set_location('payvwele.get_tax_unit_id', 1);

86: and paf.assignment_id = p_assignment_id
87: and p_session_date between paf.effective_start_date AND paf.effective_end_date;
88: --
89: --
90: hr_utility.set_location('payvwele.get_tax_unit_id', 1);
91: --
92: RETURN l_tax_unit_id;
93: --
94: exception

Line 97: hr_utility.set_message('801', 'PAY_7785_VWELE_NO_GRE');

93: --
94: exception
95: when NO_DATA_FOUND
96: then
97: hr_utility.set_message('801', 'PAY_7785_VWELE_NO_GRE');
98: hr_utility.raise_error;
99: END get_tax_unit_id;
100: --
101: --

Line 98: hr_utility.raise_error;

94: exception
95: when NO_DATA_FOUND
96: then
97: hr_utility.set_message('801', 'PAY_7785_VWELE_NO_GRE');
98: hr_utility.raise_error;
99: END get_tax_unit_id;
100: --
101: --
102: --

Line 109: hr_utility.set_location('payvwele.get_dim_id', 0);

105: v_dim_id number(9);
106: --
107: begin
108: --
109: hr_utility.set_location('payvwele.get_dim_id', 0);
110: --
111: select balance_dimension_id
112: into v_dim_id
113: from pay_balance_dimensions

Line 119: hr_utility.set_location('payvwele.get_dim_id', 1);

115: and legislation_code = p_legislation_code; /* bug372487 */
116:
117: --change for CA use decode
118: --
119: hr_utility.set_location('payvwele.get_dim_id', 1);
120: --
121: return v_dim_id;
122: --
123: exception when no_data_found

Line 125: hr_utility.set_message(801, 'PAY_7784_VWELE_NO_BAL_DIM_ID');

121: return v_dim_id;
122: --
123: exception when no_data_found
124: then
125: hr_utility.set_message(801, 'PAY_7784_VWELE_NO_BAL_DIM_ID');
126: hr_utility.set_message_token('BAL_DIM_ID', p_dim_suffix);
127: hr_utility.raise_error;
128: --
129: end get_dim_id;

Line 126: hr_utility.set_message_token('BAL_DIM_ID', p_dim_suffix);

122: --
123: exception when no_data_found
124: then
125: hr_utility.set_message(801, 'PAY_7784_VWELE_NO_BAL_DIM_ID');
126: hr_utility.set_message_token('BAL_DIM_ID', p_dim_suffix);
127: hr_utility.raise_error;
128: --
129: end get_dim_id;
130: --

Line 127: hr_utility.raise_error;

123: exception when no_data_found
124: then
125: hr_utility.set_message(801, 'PAY_7784_VWELE_NO_BAL_DIM_ID');
126: hr_utility.set_message_token('BAL_DIM_ID', p_dim_suffix);
127: hr_utility.raise_error;
128: --
129: end get_dim_id;
130: --
131: --

Line 140: hr_utility.set_location('payvwele.get_action_date', 0);

136:
137: BEGIN
138: --
139: --
140: hr_utility.set_location('payvwele.get_action_date', 0);
141:
142: IF (p_assignment_action_id = -1) THEN
143:
144: hr_utility.set_location('payvwele.get_action_date', 11);

Line 144: hr_utility.set_location('payvwele.get_action_date', 11);

140: hr_utility.set_location('payvwele.get_action_date', 0);
141:
142: IF (p_assignment_action_id = -1) THEN
143:
144: hr_utility.set_location('payvwele.get_action_date', 11);
145: v_action_date := '';
146:
147: ELSE
148:

Line 149: hr_utility.set_location('payvwele.get_action_date', 12);

145: v_action_date := '';
146:
147: ELSE
148:
149: hr_utility.set_location('payvwele.get_action_date', 12);
150: SELECT ppa.effective_date
151: INTO v_action_date
152: FROM pay_payroll_actions ppa,
153: pay_assignment_actions paa

Line 159: hr_utility.set_location('payvwele.get_action_date', 2);

155: AND ppa.payroll_action_id = paa.payroll_action_id;
156:
157: END IF;
158:
159: hr_utility.set_location('payvwele.get_action_date', 2);
160: return v_action_date;
161: --
162: END get_action_date;
163: --