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

Line 98: hr_utility.trace('Entering '||l_proc);

94: --
95:
96: l_proc VARCHAR2(100) := 'pay_gb_payroll_rules.validate_update';
97: BEGIN
98: hr_utility.trace('Entering '||l_proc);
99: hr_utility.trace('p_effective_date='||fnd_date.date_to_displaydate(p_effective_date));
100: hr_utility.trace('p_datetrack_mode='||p_datetrack_mode);
101: hr_utility.trace('p_payroll_id='||p_payroll_id);
102: hr_utility.trace('p_payroll_name='||p_payroll_name);

Line 99: hr_utility.trace('p_effective_date='||fnd_date.date_to_displaydate(p_effective_date));

95:
96: l_proc VARCHAR2(100) := 'pay_gb_payroll_rules.validate_update';
97: BEGIN
98: hr_utility.trace('Entering '||l_proc);
99: hr_utility.trace('p_effective_date='||fnd_date.date_to_displaydate(p_effective_date));
100: hr_utility.trace('p_datetrack_mode='||p_datetrack_mode);
101: hr_utility.trace('p_payroll_id='||p_payroll_id);
102: hr_utility.trace('p_payroll_name='||p_payroll_name);
103: hr_utility.trace('p_soft_coding_keyflex_id_in='||p_soft_coding_keyflex_id_in);

Line 100: hr_utility.trace('p_datetrack_mode='||p_datetrack_mode);

96: l_proc VARCHAR2(100) := 'pay_gb_payroll_rules.validate_update';
97: BEGIN
98: hr_utility.trace('Entering '||l_proc);
99: hr_utility.trace('p_effective_date='||fnd_date.date_to_displaydate(p_effective_date));
100: hr_utility.trace('p_datetrack_mode='||p_datetrack_mode);
101: hr_utility.trace('p_payroll_id='||p_payroll_id);
102: hr_utility.trace('p_payroll_name='||p_payroll_name);
103: hr_utility.trace('p_soft_coding_keyflex_id_in='||p_soft_coding_keyflex_id_in);
104: hr_utility.trace('Fetching PAYE Ref for new scl id='|| p_soft_coding_keyflex_id_in);

Line 101: hr_utility.trace('p_payroll_id='||p_payroll_id);

97: BEGIN
98: hr_utility.trace('Entering '||l_proc);
99: hr_utility.trace('p_effective_date='||fnd_date.date_to_displaydate(p_effective_date));
100: hr_utility.trace('p_datetrack_mode='||p_datetrack_mode);
101: hr_utility.trace('p_payroll_id='||p_payroll_id);
102: hr_utility.trace('p_payroll_name='||p_payroll_name);
103: hr_utility.trace('p_soft_coding_keyflex_id_in='||p_soft_coding_keyflex_id_in);
104: hr_utility.trace('Fetching PAYE Ref for new scl id='|| p_soft_coding_keyflex_id_in);
105: OPEN get_paye_ref(p_soft_coding_keyflex_id_in);

Line 102: hr_utility.trace('p_payroll_name='||p_payroll_name);

98: hr_utility.trace('Entering '||l_proc);
99: hr_utility.trace('p_effective_date='||fnd_date.date_to_displaydate(p_effective_date));
100: hr_utility.trace('p_datetrack_mode='||p_datetrack_mode);
101: hr_utility.trace('p_payroll_id='||p_payroll_id);
102: hr_utility.trace('p_payroll_name='||p_payroll_name);
103: hr_utility.trace('p_soft_coding_keyflex_id_in='||p_soft_coding_keyflex_id_in);
104: hr_utility.trace('Fetching PAYE Ref for new scl id='|| p_soft_coding_keyflex_id_in);
105: OPEN get_paye_ref(p_soft_coding_keyflex_id_in);
106: FETCH get_paye_ref INTO l_new_paye_ref;

Line 103: hr_utility.trace('p_soft_coding_keyflex_id_in='||p_soft_coding_keyflex_id_in);

99: hr_utility.trace('p_effective_date='||fnd_date.date_to_displaydate(p_effective_date));
100: hr_utility.trace('p_datetrack_mode='||p_datetrack_mode);
101: hr_utility.trace('p_payroll_id='||p_payroll_id);
102: hr_utility.trace('p_payroll_name='||p_payroll_name);
103: hr_utility.trace('p_soft_coding_keyflex_id_in='||p_soft_coding_keyflex_id_in);
104: hr_utility.trace('Fetching PAYE Ref for new scl id='|| p_soft_coding_keyflex_id_in);
105: OPEN get_paye_ref(p_soft_coding_keyflex_id_in);
106: FETCH get_paye_ref INTO l_new_paye_ref;
107: CLOSE get_paye_ref;

Line 104: hr_utility.trace('Fetching PAYE Ref for new scl id='|| p_soft_coding_keyflex_id_in);

100: hr_utility.trace('p_datetrack_mode='||p_datetrack_mode);
101: hr_utility.trace('p_payroll_id='||p_payroll_id);
102: hr_utility.trace('p_payroll_name='||p_payroll_name);
103: hr_utility.trace('p_soft_coding_keyflex_id_in='||p_soft_coding_keyflex_id_in);
104: hr_utility.trace('Fetching PAYE Ref for new scl id='|| p_soft_coding_keyflex_id_in);
105: OPEN get_paye_ref(p_soft_coding_keyflex_id_in);
106: FETCH get_paye_ref INTO l_new_paye_ref;
107: CLOSE get_paye_ref;
108: --

Line 109: hr_utility.trace('New Paye Ref is '||l_new_paye_ref);

105: OPEN get_paye_ref(p_soft_coding_keyflex_id_in);
106: FETCH get_paye_ref INTO l_new_paye_ref;
107: CLOSE get_paye_ref;
108: --
109: hr_utility.trace('New Paye Ref is '||l_new_paye_ref);
110: --
111: hr_utility.trace('Fetching current payroll details');
112: OPEN get_current_details;
113: FETCH get_current_details INTO l_cur_scl_id, l_cur_eff_start, l_cur_eff_end;

Line 111: hr_utility.trace('Fetching current payroll details');

107: CLOSE get_paye_ref;
108: --
109: hr_utility.trace('New Paye Ref is '||l_new_paye_ref);
110: --
111: hr_utility.trace('Fetching current payroll details');
112: OPEN get_current_details;
113: FETCH get_current_details INTO l_cur_scl_id, l_cur_eff_start, l_cur_eff_end;
114: CLOSE get_current_details;
115: --

Line 116: hr_utility.trace('Currrent l_cur_scl_id='||l_cur_scl_id);

112: OPEN get_current_details;
113: FETCH get_current_details INTO l_cur_scl_id, l_cur_eff_start, l_cur_eff_end;
114: CLOSE get_current_details;
115: --
116: hr_utility.trace('Currrent l_cur_scl_id='||l_cur_scl_id);
117: hr_utility.trace('Currrent l_cur_eff_start='||fnd_date.date_to_displaydate(l_cur_eff_start));
118: hr_utility.trace('Currrent l_cur_eff_end='||fnd_date.date_to_displaydate(l_cur_eff_end));
119: --
120: hr_utility.trace('Fetching Current PAYE Ref.');

Line 117: hr_utility.trace('Currrent l_cur_eff_start='||fnd_date.date_to_displaydate(l_cur_eff_start));

113: FETCH get_current_details INTO l_cur_scl_id, l_cur_eff_start, l_cur_eff_end;
114: CLOSE get_current_details;
115: --
116: hr_utility.trace('Currrent l_cur_scl_id='||l_cur_scl_id);
117: hr_utility.trace('Currrent l_cur_eff_start='||fnd_date.date_to_displaydate(l_cur_eff_start));
118: hr_utility.trace('Currrent l_cur_eff_end='||fnd_date.date_to_displaydate(l_cur_eff_end));
119: --
120: hr_utility.trace('Fetching Current PAYE Ref.');
121: OPEN get_paye_ref(l_cur_scl_id);

Line 118: hr_utility.trace('Currrent l_cur_eff_end='||fnd_date.date_to_displaydate(l_cur_eff_end));

114: CLOSE get_current_details;
115: --
116: hr_utility.trace('Currrent l_cur_scl_id='||l_cur_scl_id);
117: hr_utility.trace('Currrent l_cur_eff_start='||fnd_date.date_to_displaydate(l_cur_eff_start));
118: hr_utility.trace('Currrent l_cur_eff_end='||fnd_date.date_to_displaydate(l_cur_eff_end));
119: --
120: hr_utility.trace('Fetching Current PAYE Ref.');
121: OPEN get_paye_ref(l_cur_scl_id);
122: FETCH get_paye_ref INTO l_cur_paye_ref;

Line 120: hr_utility.trace('Fetching Current PAYE Ref.');

116: hr_utility.trace('Currrent l_cur_scl_id='||l_cur_scl_id);
117: hr_utility.trace('Currrent l_cur_eff_start='||fnd_date.date_to_displaydate(l_cur_eff_start));
118: hr_utility.trace('Currrent l_cur_eff_end='||fnd_date.date_to_displaydate(l_cur_eff_end));
119: --
120: hr_utility.trace('Fetching Current PAYE Ref.');
121: OPEN get_paye_ref(l_cur_scl_id);
122: FETCH get_paye_ref INTO l_cur_paye_ref;
123: CLOSE get_paye_ref;
124: hr_utility.trace('Current PAYE Ref is '||l_cur_paye_ref);

Line 124: hr_utility.trace('Current PAYE Ref is '||l_cur_paye_ref);

120: hr_utility.trace('Fetching Current PAYE Ref.');
121: OPEN get_paye_ref(l_cur_scl_id);
122: FETCH get_paye_ref INTO l_cur_paye_ref;
123: CLOSE get_paye_ref;
124: hr_utility.trace('Current PAYE Ref is '||l_cur_paye_ref);
125: --
126: hr_utility.trace('Fetching fiest start date and last end date of the payroll');
127: OPEN get_min_max_dates;
128: FETCH get_min_max_dates INTO l_first_eff_start, l_last_eff_end;

Line 126: hr_utility.trace('Fetching fiest start date and last end date of the payroll');

122: FETCH get_paye_ref INTO l_cur_paye_ref;
123: CLOSE get_paye_ref;
124: hr_utility.trace('Current PAYE Ref is '||l_cur_paye_ref);
125: --
126: hr_utility.trace('Fetching fiest start date and last end date of the payroll');
127: OPEN get_min_max_dates;
128: FETCH get_min_max_dates INTO l_first_eff_start, l_last_eff_end;
129: CLOSE get_min_max_dates;
130: hr_utility.trace('l_first_eff_start='||fnd_date.date_to_displaydate(l_first_eff_start));

Line 130: hr_utility.trace('l_first_eff_start='||fnd_date.date_to_displaydate(l_first_eff_start));

126: hr_utility.trace('Fetching fiest start date and last end date of the payroll');
127: OPEN get_min_max_dates;
128: FETCH get_min_max_dates INTO l_first_eff_start, l_last_eff_end;
129: CLOSE get_min_max_dates;
130: hr_utility.trace('l_first_eff_start='||fnd_date.date_to_displaydate(l_first_eff_start));
131: hr_utility.trace('l_last_eff_end='||fnd_date.date_to_displaydate(l_last_eff_end));
132: --
133: IF p_datetrack_mode = hr_api.g_correction THEN
134: hr_utility.trace('Datetrack Action is Correction.');

Line 131: hr_utility.trace('l_last_eff_end='||fnd_date.date_to_displaydate(l_last_eff_end));

127: OPEN get_min_max_dates;
128: FETCH get_min_max_dates INTO l_first_eff_start, l_last_eff_end;
129: CLOSE get_min_max_dates;
130: hr_utility.trace('l_first_eff_start='||fnd_date.date_to_displaydate(l_first_eff_start));
131: hr_utility.trace('l_last_eff_end='||fnd_date.date_to_displaydate(l_last_eff_end));
132: --
133: IF p_datetrack_mode = hr_api.g_correction THEN
134: hr_utility.trace('Datetrack Action is Correction.');
135: --

Line 134: hr_utility.trace('Datetrack Action is Correction.');

130: hr_utility.trace('l_first_eff_start='||fnd_date.date_to_displaydate(l_first_eff_start));
131: hr_utility.trace('l_last_eff_end='||fnd_date.date_to_displaydate(l_last_eff_end));
132: --
133: IF p_datetrack_mode = hr_api.g_correction THEN
134: hr_utility.trace('Datetrack Action is Correction.');
135: --
136: IF l_new_paye_ref <> l_cur_paye_ref THEN
137: hr_utility.trace('PAYE Refs is changing, validating the change');
138: --

Line 137: hr_utility.trace('PAYE Refs is changing, validating the change');

133: IF p_datetrack_mode = hr_api.g_correction THEN
134: hr_utility.trace('Datetrack Action is Correction.');
135: --
136: IF l_new_paye_ref <> l_cur_paye_ref THEN
137: hr_utility.trace('PAYE Refs is changing, validating the change');
138: --
139: hr_utility.trace('Fetching Previous PAYE Ref');
140: OPEN get_prev_details;
141: FETCH get_prev_details INTO l_prev_scl_id;

Line 139: hr_utility.trace('Fetching Previous PAYE Ref');

135: --
136: IF l_new_paye_ref <> l_cur_paye_ref THEN
137: hr_utility.trace('PAYE Refs is changing, validating the change');
138: --
139: hr_utility.trace('Fetching Previous PAYE Ref');
140: OPEN get_prev_details;
141: FETCH get_prev_details INTO l_prev_scl_id;
142: CLOSE get_prev_details;
143: --

Line 144: hr_utility.trace('l_prev_scl_id = '||l_prev_scl_id);

140: OPEN get_prev_details;
141: FETCH get_prev_details INTO l_prev_scl_id;
142: CLOSE get_prev_details;
143: --
144: hr_utility.trace('l_prev_scl_id = '||l_prev_scl_id);
145: OPEN get_paye_ref(l_prev_scl_id);
146: FETCH get_paye_ref INTO l_prev_paye_ref;
147: CLOSE get_paye_ref;
148: --

Line 149: hr_utility.trace('l_prev_paye_ref = '||l_prev_paye_ref);

145: OPEN get_paye_ref(l_prev_scl_id);
146: FETCH get_paye_ref INTO l_prev_paye_ref;
147: CLOSE get_paye_ref;
148: --
149: hr_utility.trace('l_prev_paye_ref = '||l_prev_paye_ref);
150: --
151: IF l_prev_paye_ref <> l_new_paye_ref AND
152: l_cur_eff_start <> l_first_eff_start AND
153: to_char(l_cur_eff_start, 'DD-MM') <> '06-04' THEN

Line 154: hr_utility.trace('New PAYE Ref does not match the previous ');

150: --
151: IF l_prev_paye_ref <> l_new_paye_ref AND
152: l_cur_eff_start <> l_first_eff_start AND
153: to_char(l_cur_eff_start, 'DD-MM') <> '06-04' THEN
154: hr_utility.trace('New PAYE Ref does not match the previous ');
155: hr_utility.trace('PAYE Ref and current effective start date ');
156: hr_utility.trace('is not the first effective start date and ');
157: hr_utility.trace('current effective date is not start of a ');
158: hr_utility.trace('tax year therefore raise an error message.');

Line 155: hr_utility.trace('PAYE Ref and current effective start date ');

151: IF l_prev_paye_ref <> l_new_paye_ref AND
152: l_cur_eff_start <> l_first_eff_start AND
153: to_char(l_cur_eff_start, 'DD-MM') <> '06-04' THEN
154: hr_utility.trace('New PAYE Ref does not match the previous ');
155: hr_utility.trace('PAYE Ref and current effective start date ');
156: hr_utility.trace('is not the first effective start date and ');
157: hr_utility.trace('current effective date is not start of a ');
158: hr_utility.trace('tax year therefore raise an error message.');
159: --

Line 156: hr_utility.trace('is not the first effective start date and ');

152: l_cur_eff_start <> l_first_eff_start AND
153: to_char(l_cur_eff_start, 'DD-MM') <> '06-04' THEN
154: hr_utility.trace('New PAYE Ref does not match the previous ');
155: hr_utility.trace('PAYE Ref and current effective start date ');
156: hr_utility.trace('is not the first effective start date and ');
157: hr_utility.trace('current effective date is not start of a ');
158: hr_utility.trace('tax year therefore raise an error message.');
159: --
160: l_span_start := hr_gbbal.span_start(l_cur_eff_start);

Line 157: hr_utility.trace('current effective date is not start of a ');

153: to_char(l_cur_eff_start, 'DD-MM') <> '06-04' THEN
154: hr_utility.trace('New PAYE Ref does not match the previous ');
155: hr_utility.trace('PAYE Ref and current effective start date ');
156: hr_utility.trace('is not the first effective start date and ');
157: hr_utility.trace('current effective date is not start of a ');
158: hr_utility.trace('tax year therefore raise an error message.');
159: --
160: l_span_start := hr_gbbal.span_start(l_cur_eff_start);
161: l_span_end := hr_gbbal.span_end(l_cur_eff_start);

Line 158: hr_utility.trace('tax year therefore raise an error message.');

154: hr_utility.trace('New PAYE Ref does not match the previous ');
155: hr_utility.trace('PAYE Ref and current effective start date ');
156: hr_utility.trace('is not the first effective start date and ');
157: hr_utility.trace('current effective date is not start of a ');
158: hr_utility.trace('tax year therefore raise an error message.');
159: --
160: l_span_start := hr_gbbal.span_start(l_cur_eff_start);
161: l_span_end := hr_gbbal.span_end(l_cur_eff_start);
162: --

Line 170: hr_utility.trace('Change as at the start date is ok, Checking end date');

166: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
167: fnd_message.raise_error;
168: END IF;
169: --
170: hr_utility.trace('Change as at the start date is ok, Checking end date');
171: --
172: hr_utility.trace('Fetching Next PAYE Ref');
173: OPEN get_next_details;
174: FETCH get_next_details INTO l_next_scl_id;

Line 172: hr_utility.trace('Fetching Next PAYE Ref');

168: END IF;
169: --
170: hr_utility.trace('Change as at the start date is ok, Checking end date');
171: --
172: hr_utility.trace('Fetching Next PAYE Ref');
173: OPEN get_next_details;
174: FETCH get_next_details INTO l_next_scl_id;
175: CLOSE get_next_details;
176: --

Line 177: hr_utility.trace('l_next_scl_id = '||l_next_scl_id);

173: OPEN get_next_details;
174: FETCH get_next_details INTO l_next_scl_id;
175: CLOSE get_next_details;
176: --
177: hr_utility.trace('l_next_scl_id = '||l_next_scl_id);
178: OPEN get_paye_ref(l_next_scl_id);
179: FETCH get_paye_ref INTO l_next_paye_ref;
180: CLOSE get_paye_ref;
181: --

Line 182: hr_utility.trace('l_next_paye_ref = '||l_next_paye_ref);

178: OPEN get_paye_ref(l_next_scl_id);
179: FETCH get_paye_ref INTO l_next_paye_ref;
180: CLOSE get_paye_ref;
181: --
182: hr_utility.trace('l_next_paye_ref = '||l_next_paye_ref);
183: --
184: IF l_next_paye_ref <> l_new_paye_ref AND
185: l_cur_eff_end <> l_last_eff_end AND
186: to_char(l_cur_eff_end, 'DD-MM') <> '05-04' THEN

Line 187: hr_utility.trace('New PAYE Ref does not match the next ');

183: --
184: IF l_next_paye_ref <> l_new_paye_ref AND
185: l_cur_eff_end <> l_last_eff_end AND
186: to_char(l_cur_eff_end, 'DD-MM') <> '05-04' THEN
187: hr_utility.trace('New PAYE Ref does not match the next ');
188: hr_utility.trace('PAYE Ref and current effective end date ');
189: hr_utility.trace('is not the last effective end date and ');
190: hr_utility.trace('current effective date is not end of a ');
191: hr_utility.trace('tax year therefore raise an error message.');

Line 188: hr_utility.trace('PAYE Ref and current effective end date ');

184: IF l_next_paye_ref <> l_new_paye_ref AND
185: l_cur_eff_end <> l_last_eff_end AND
186: to_char(l_cur_eff_end, 'DD-MM') <> '05-04' THEN
187: hr_utility.trace('New PAYE Ref does not match the next ');
188: hr_utility.trace('PAYE Ref and current effective end date ');
189: hr_utility.trace('is not the last effective end date and ');
190: hr_utility.trace('current effective date is not end of a ');
191: hr_utility.trace('tax year therefore raise an error message.');
192: --

Line 189: hr_utility.trace('is not the last effective end date and ');

185: l_cur_eff_end <> l_last_eff_end AND
186: to_char(l_cur_eff_end, 'DD-MM') <> '05-04' THEN
187: hr_utility.trace('New PAYE Ref does not match the next ');
188: hr_utility.trace('PAYE Ref and current effective end date ');
189: hr_utility.trace('is not the last effective end date and ');
190: hr_utility.trace('current effective date is not end of a ');
191: hr_utility.trace('tax year therefore raise an error message.');
192: --
193: l_span_start := hr_gbbal.span_start(l_cur_eff_end);

Line 190: hr_utility.trace('current effective date is not end of a ');

186: to_char(l_cur_eff_end, 'DD-MM') <> '05-04' THEN
187: hr_utility.trace('New PAYE Ref does not match the next ');
188: hr_utility.trace('PAYE Ref and current effective end date ');
189: hr_utility.trace('is not the last effective end date and ');
190: hr_utility.trace('current effective date is not end of a ');
191: hr_utility.trace('tax year therefore raise an error message.');
192: --
193: l_span_start := hr_gbbal.span_start(l_cur_eff_end);
194: l_span_end := hr_gbbal.span_end(l_cur_eff_end);

Line 191: hr_utility.trace('tax year therefore raise an error message.');

187: hr_utility.trace('New PAYE Ref does not match the next ');
188: hr_utility.trace('PAYE Ref and current effective end date ');
189: hr_utility.trace('is not the last effective end date and ');
190: hr_utility.trace('current effective date is not end of a ');
191: hr_utility.trace('tax year therefore raise an error message.');
192: --
193: l_span_start := hr_gbbal.span_start(l_cur_eff_end);
194: l_span_end := hr_gbbal.span_end(l_cur_eff_end);
195: --

Line 203: hr_utility.trace('Change as at the end date is ok too.');

199: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
200: fnd_message.raise_error;
201: END IF;
202: --
203: hr_utility.trace('Change as at the end date is ok too.');
204: --
205:
206: -- START CHECK - Termination Assignment exists at the Effective start date
207: IF (l_prev_paye_ref <> l_new_paye_ref AND

Line 254: hr_utility.trace('Datetrack Action is Update or Update Override.');

250: END IF; -- Date track mode is correction
251: --
252: IF p_datetrack_mode = hr_api.g_update
253: OR p_datetrack_mode = hr_api.g_update_override THEN
254: hr_utility.trace('Datetrack Action is Update or Update Override.');
255: --
256: IF l_new_paye_ref <> l_cur_paye_ref THEN
257: hr_utility.trace('PAYE Refs is changing, validating the change');
258: --

Line 257: hr_utility.trace('PAYE Refs is changing, validating the change');

253: OR p_datetrack_mode = hr_api.g_update_override THEN
254: hr_utility.trace('Datetrack Action is Update or Update Override.');
255: --
256: IF l_new_paye_ref <> l_cur_paye_ref THEN
257: hr_utility.trace('PAYE Refs is changing, validating the change');
258: --
259: IF l_cur_paye_ref <> l_new_paye_ref AND
260: p_effective_date <> l_first_eff_start AND
261: to_char(p_effective_date, 'DD-MM') <> '06-04' THEN

Line 262: hr_utility.trace('New PAYE Ref does not match the current ');

258: --
259: IF l_cur_paye_ref <> l_new_paye_ref AND
260: p_effective_date <> l_first_eff_start AND
261: to_char(p_effective_date, 'DD-MM') <> '06-04' THEN
262: hr_utility.trace('New PAYE Ref does not match the current ');
263: hr_utility.trace('PAYE Ref and new effective start date ');
264: hr_utility.trace('is not the first effective start date and ');
265: hr_utility.trace('new effective date is not start of a ');
266: hr_utility.trace('tax year therefore raise an error message.');

Line 263: hr_utility.trace('PAYE Ref and new effective start date ');

259: IF l_cur_paye_ref <> l_new_paye_ref AND
260: p_effective_date <> l_first_eff_start AND
261: to_char(p_effective_date, 'DD-MM') <> '06-04' THEN
262: hr_utility.trace('New PAYE Ref does not match the current ');
263: hr_utility.trace('PAYE Ref and new effective start date ');
264: hr_utility.trace('is not the first effective start date and ');
265: hr_utility.trace('new effective date is not start of a ');
266: hr_utility.trace('tax year therefore raise an error message.');
267: --

Line 264: hr_utility.trace('is not the first effective start date and ');

260: p_effective_date <> l_first_eff_start AND
261: to_char(p_effective_date, 'DD-MM') <> '06-04' THEN
262: hr_utility.trace('New PAYE Ref does not match the current ');
263: hr_utility.trace('PAYE Ref and new effective start date ');
264: hr_utility.trace('is not the first effective start date and ');
265: hr_utility.trace('new effective date is not start of a ');
266: hr_utility.trace('tax year therefore raise an error message.');
267: --
268: l_span_start := hr_gbbal.span_start(p_effective_date);

Line 265: hr_utility.trace('new effective date is not start of a ');

261: to_char(p_effective_date, 'DD-MM') <> '06-04' THEN
262: hr_utility.trace('New PAYE Ref does not match the current ');
263: hr_utility.trace('PAYE Ref and new effective start date ');
264: hr_utility.trace('is not the first effective start date and ');
265: hr_utility.trace('new effective date is not start of a ');
266: hr_utility.trace('tax year therefore raise an error message.');
267: --
268: l_span_start := hr_gbbal.span_start(p_effective_date);
269: l_span_end := hr_gbbal.span_end(p_effective_date);

Line 266: hr_utility.trace('tax year therefore raise an error message.');

262: hr_utility.trace('New PAYE Ref does not match the current ');
263: hr_utility.trace('PAYE Ref and new effective start date ');
264: hr_utility.trace('is not the first effective start date and ');
265: hr_utility.trace('new effective date is not start of a ');
266: hr_utility.trace('tax year therefore raise an error message.');
267: --
268: l_span_start := hr_gbbal.span_start(p_effective_date);
269: l_span_end := hr_gbbal.span_end(p_effective_date);
270: --

Line 278: hr_utility.trace('Change as at the new effective date ok, no need to check as at the effective end date');

274: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
275: fnd_message.raise_error;
276: END IF;
277: --
278: hr_utility.trace('Change as at the new effective date ok, no need to check as at the effective end date');
279: --
280:
281: -- START CHECK - Termination Assignment exists at the Effective start date
282: IF l_cur_paye_ref <> l_new_paye_ref AND

Line 308: hr_utility.trace('Datetrack Action is Update Change Insert.');

304: END IF; -- PAYE Ref Changing
305: END IF; -- Date track update or update override
306: --
307: IF p_datetrack_mode = hr_api.g_update_change_insert THEN
308: hr_utility.trace('Datetrack Action is Update Change Insert.');
309: --
310: IF l_new_paye_ref <> l_cur_paye_ref THEN
311: hr_utility.trace('PAYE Refs is changing, validating the change');
312: --

Line 311: hr_utility.trace('PAYE Refs is changing, validating the change');

307: IF p_datetrack_mode = hr_api.g_update_change_insert THEN
308: hr_utility.trace('Datetrack Action is Update Change Insert.');
309: --
310: IF l_new_paye_ref <> l_cur_paye_ref THEN
311: hr_utility.trace('PAYE Refs is changing, validating the change');
312: --
313: IF l_cur_paye_ref <> l_new_paye_ref AND
314: p_effective_date <> l_first_eff_start AND
315: to_char(p_effective_date, 'DD-MM') <> '06-04' THEN

Line 316: hr_utility.trace('New PAYE Ref does not match the current ');

312: --
313: IF l_cur_paye_ref <> l_new_paye_ref AND
314: p_effective_date <> l_first_eff_start AND
315: to_char(p_effective_date, 'DD-MM') <> '06-04' THEN
316: hr_utility.trace('New PAYE Ref does not match the current ');
317: hr_utility.trace('PAYE Ref and new effective start date ');
318: hr_utility.trace('is not the first effective start date and ');
319: hr_utility.trace('new effective date is not start of a ');
320: hr_utility.trace('tax year therefore raise an error message.');

Line 317: hr_utility.trace('PAYE Ref and new effective start date ');

313: IF l_cur_paye_ref <> l_new_paye_ref AND
314: p_effective_date <> l_first_eff_start AND
315: to_char(p_effective_date, 'DD-MM') <> '06-04' THEN
316: hr_utility.trace('New PAYE Ref does not match the current ');
317: hr_utility.trace('PAYE Ref and new effective start date ');
318: hr_utility.trace('is not the first effective start date and ');
319: hr_utility.trace('new effective date is not start of a ');
320: hr_utility.trace('tax year therefore raise an error message.');
321: --

Line 318: hr_utility.trace('is not the first effective start date and ');

314: p_effective_date <> l_first_eff_start AND
315: to_char(p_effective_date, 'DD-MM') <> '06-04' THEN
316: hr_utility.trace('New PAYE Ref does not match the current ');
317: hr_utility.trace('PAYE Ref and new effective start date ');
318: hr_utility.trace('is not the first effective start date and ');
319: hr_utility.trace('new effective date is not start of a ');
320: hr_utility.trace('tax year therefore raise an error message.');
321: --
322: l_span_start := hr_gbbal.span_start(p_effective_date);

Line 319: hr_utility.trace('new effective date is not start of a ');

315: to_char(p_effective_date, 'DD-MM') <> '06-04' THEN
316: hr_utility.trace('New PAYE Ref does not match the current ');
317: hr_utility.trace('PAYE Ref and new effective start date ');
318: hr_utility.trace('is not the first effective start date and ');
319: hr_utility.trace('new effective date is not start of a ');
320: hr_utility.trace('tax year therefore raise an error message.');
321: --
322: l_span_start := hr_gbbal.span_start(p_effective_date);
323: l_span_end := hr_gbbal.span_end(p_effective_date);

Line 320: hr_utility.trace('tax year therefore raise an error message.');

316: hr_utility.trace('New PAYE Ref does not match the current ');
317: hr_utility.trace('PAYE Ref and new effective start date ');
318: hr_utility.trace('is not the first effective start date and ');
319: hr_utility.trace('new effective date is not start of a ');
320: hr_utility.trace('tax year therefore raise an error message.');
321: --
322: l_span_start := hr_gbbal.span_start(p_effective_date);
323: l_span_end := hr_gbbal.span_end(p_effective_date);
324: --

Line 332: hr_utility.trace('Change as at the new effective date ok, Checking as at the effective end date');

328: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
329: fnd_message.raise_error;
330: END IF;
331: --
332: hr_utility.trace('Change as at the new effective date ok, Checking as at the effective end date');
333: --
334: --
335: hr_utility.trace('Fetching Next PAYE Ref');
336: OPEN get_next_details;

Line 335: hr_utility.trace('Fetching Next PAYE Ref');

331: --
332: hr_utility.trace('Change as at the new effective date ok, Checking as at the effective end date');
333: --
334: --
335: hr_utility.trace('Fetching Next PAYE Ref');
336: OPEN get_next_details;
337: FETCH get_next_details INTO l_next_scl_id;
338: CLOSE get_next_details;
339: --

Line 340: hr_utility.trace('l_next_scl_id = '||l_next_scl_id);

336: OPEN get_next_details;
337: FETCH get_next_details INTO l_next_scl_id;
338: CLOSE get_next_details;
339: --
340: hr_utility.trace('l_next_scl_id = '||l_next_scl_id);
341: OPEN get_paye_ref(l_next_scl_id);
342: FETCH get_paye_ref INTO l_next_paye_ref;
343: CLOSE get_paye_ref;
344: --

Line 345: hr_utility.trace('l_next_paye_ref = '||l_next_paye_ref);

341: OPEN get_paye_ref(l_next_scl_id);
342: FETCH get_paye_ref INTO l_next_paye_ref;
343: CLOSE get_paye_ref;
344: --
345: hr_utility.trace('l_next_paye_ref = '||l_next_paye_ref);
346: --
347: IF l_next_paye_ref <> l_new_paye_ref AND
348: l_cur_eff_end <> l_last_eff_end AND
349: to_char(l_cur_eff_end, 'DD-MM') <> '05-04' THEN

Line 350: hr_utility.trace('New PAYE Ref does not match the next ');

346: --
347: IF l_next_paye_ref <> l_new_paye_ref AND
348: l_cur_eff_end <> l_last_eff_end AND
349: to_char(l_cur_eff_end, 'DD-MM') <> '05-04' THEN
350: hr_utility.trace('New PAYE Ref does not match the next ');
351: hr_utility.trace('PAYE Ref and current effective end date ');
352: hr_utility.trace('is not the last effective end date and ');
353: hr_utility.trace('current effective date is not end of a ');
354: hr_utility.trace('tax year therefore raise an error message.');

Line 351: hr_utility.trace('PAYE Ref and current effective end date ');

347: IF l_next_paye_ref <> l_new_paye_ref AND
348: l_cur_eff_end <> l_last_eff_end AND
349: to_char(l_cur_eff_end, 'DD-MM') <> '05-04' THEN
350: hr_utility.trace('New PAYE Ref does not match the next ');
351: hr_utility.trace('PAYE Ref and current effective end date ');
352: hr_utility.trace('is not the last effective end date and ');
353: hr_utility.trace('current effective date is not end of a ');
354: hr_utility.trace('tax year therefore raise an error message.');
355: --

Line 352: hr_utility.trace('is not the last effective end date and ');

348: l_cur_eff_end <> l_last_eff_end AND
349: to_char(l_cur_eff_end, 'DD-MM') <> '05-04' THEN
350: hr_utility.trace('New PAYE Ref does not match the next ');
351: hr_utility.trace('PAYE Ref and current effective end date ');
352: hr_utility.trace('is not the last effective end date and ');
353: hr_utility.trace('current effective date is not end of a ');
354: hr_utility.trace('tax year therefore raise an error message.');
355: --
356: l_span_start := hr_gbbal.span_start(l_cur_eff_end);

Line 353: hr_utility.trace('current effective date is not end of a ');

349: to_char(l_cur_eff_end, 'DD-MM') <> '05-04' THEN
350: hr_utility.trace('New PAYE Ref does not match the next ');
351: hr_utility.trace('PAYE Ref and current effective end date ');
352: hr_utility.trace('is not the last effective end date and ');
353: hr_utility.trace('current effective date is not end of a ');
354: hr_utility.trace('tax year therefore raise an error message.');
355: --
356: l_span_start := hr_gbbal.span_start(l_cur_eff_end);
357: l_span_end := hr_gbbal.span_end(l_cur_eff_end);

Line 354: hr_utility.trace('tax year therefore raise an error message.');

350: hr_utility.trace('New PAYE Ref does not match the next ');
351: hr_utility.trace('PAYE Ref and current effective end date ');
352: hr_utility.trace('is not the last effective end date and ');
353: hr_utility.trace('current effective date is not end of a ');
354: hr_utility.trace('tax year therefore raise an error message.');
355: --
356: l_span_start := hr_gbbal.span_start(l_cur_eff_end);
357: l_span_end := hr_gbbal.span_end(l_cur_eff_end);
358: --

Line 366: hr_utility.trace('Change as at the end date is ok too.');

362: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
363: fnd_message.raise_error;
364: END IF;
365: --
366: hr_utility.trace('Change as at the end date is ok too.');
367: --
368:
369: -- START CHECK - Termination Assignment exists at the Effective start date
370: IF (l_cur_paye_ref <> l_new_paye_ref AND

Line 415: hr_utility.trace('No problem with this update/correction.');

411: END IF; -- PAYE Ref Changing
412: END IF; -- Date track update change insert
413: --
414:
415: hr_utility.trace('No problem with this update/correction.');
416: hr_utility.trace('Leaving pay_gb_payroll_rules.validate_update');
417: END validate_update;
418:
419: PROCEDURE validate_delete(p_effective_date IN DATE

Line 416: hr_utility.trace('Leaving pay_gb_payroll_rules.validate_update');

412: END IF; -- Date track update change insert
413: --
414:
415: hr_utility.trace('No problem with this update/correction.');
416: hr_utility.trace('Leaving pay_gb_payroll_rules.validate_update');
417: END validate_update;
418:
419: PROCEDURE validate_delete(p_effective_date IN DATE
420: ,p_datetrack_mode IN VARCHAR2

Line 503: hr_utility.trace('Entering '||l_proc);

499: --
500:
501: l_proc VARCHAR2(100) := 'pay_gb_payroll_rules.validate_delete';
502: BEGIN
503: hr_utility.trace('Entering '||l_proc);
504: hr_utility.trace('p_effective_date='||fnd_date.date_to_displaydate(p_effective_date));
505: hr_utility.trace('p_datetrack_mode='||p_datetrack_mode);
506: hr_utility.trace('p_payroll_id='||p_payroll_id);
507: --

Line 504: hr_utility.trace('p_effective_date='||fnd_date.date_to_displaydate(p_effective_date));

500:
501: l_proc VARCHAR2(100) := 'pay_gb_payroll_rules.validate_delete';
502: BEGIN
503: hr_utility.trace('Entering '||l_proc);
504: hr_utility.trace('p_effective_date='||fnd_date.date_to_displaydate(p_effective_date));
505: hr_utility.trace('p_datetrack_mode='||p_datetrack_mode);
506: hr_utility.trace('p_payroll_id='||p_payroll_id);
507: --
508: hr_utility.trace('Fetching current payroll details');

Line 505: hr_utility.trace('p_datetrack_mode='||p_datetrack_mode);

501: l_proc VARCHAR2(100) := 'pay_gb_payroll_rules.validate_delete';
502: BEGIN
503: hr_utility.trace('Entering '||l_proc);
504: hr_utility.trace('p_effective_date='||fnd_date.date_to_displaydate(p_effective_date));
505: hr_utility.trace('p_datetrack_mode='||p_datetrack_mode);
506: hr_utility.trace('p_payroll_id='||p_payroll_id);
507: --
508: hr_utility.trace('Fetching current payroll details');
509: OPEN get_current_details;

Line 506: hr_utility.trace('p_payroll_id='||p_payroll_id);

502: BEGIN
503: hr_utility.trace('Entering '||l_proc);
504: hr_utility.trace('p_effective_date='||fnd_date.date_to_displaydate(p_effective_date));
505: hr_utility.trace('p_datetrack_mode='||p_datetrack_mode);
506: hr_utility.trace('p_payroll_id='||p_payroll_id);
507: --
508: hr_utility.trace('Fetching current payroll details');
509: OPEN get_current_details;
510: FETCH get_current_details INTO l_cur_scl_id, l_cur_eff_end;

Line 508: hr_utility.trace('Fetching current payroll details');

504: hr_utility.trace('p_effective_date='||fnd_date.date_to_displaydate(p_effective_date));
505: hr_utility.trace('p_datetrack_mode='||p_datetrack_mode);
506: hr_utility.trace('p_payroll_id='||p_payroll_id);
507: --
508: hr_utility.trace('Fetching current payroll details');
509: OPEN get_current_details;
510: FETCH get_current_details INTO l_cur_scl_id, l_cur_eff_end;
511: CLOSE get_current_details;
512: --

Line 513: hr_utility.trace('Currrent l_cur_scl_id='||l_cur_scl_id);

509: OPEN get_current_details;
510: FETCH get_current_details INTO l_cur_scl_id, l_cur_eff_end;
511: CLOSE get_current_details;
512: --
513: hr_utility.trace('Currrent l_cur_scl_id='||l_cur_scl_id);
514: hr_utility.trace('Currrent l_cur_eff_end='||fnd_date.date_to_displaydate(l_cur_eff_end));
515: --
516: hr_utility.trace('Fetching Current PAYE Ref.');
517: OPEN get_paye_ref(l_cur_scl_id);

Line 514: hr_utility.trace('Currrent l_cur_eff_end='||fnd_date.date_to_displaydate(l_cur_eff_end));

510: FETCH get_current_details INTO l_cur_scl_id, l_cur_eff_end;
511: CLOSE get_current_details;
512: --
513: hr_utility.trace('Currrent l_cur_scl_id='||l_cur_scl_id);
514: hr_utility.trace('Currrent l_cur_eff_end='||fnd_date.date_to_displaydate(l_cur_eff_end));
515: --
516: hr_utility.trace('Fetching Current PAYE Ref.');
517: OPEN get_paye_ref(l_cur_scl_id);
518: FETCH get_paye_ref INTO l_cur_paye_ref;

Line 516: hr_utility.trace('Fetching Current PAYE Ref.');

512: --
513: hr_utility.trace('Currrent l_cur_scl_id='||l_cur_scl_id);
514: hr_utility.trace('Currrent l_cur_eff_end='||fnd_date.date_to_displaydate(l_cur_eff_end));
515: --
516: hr_utility.trace('Fetching Current PAYE Ref.');
517: OPEN get_paye_ref(l_cur_scl_id);
518: FETCH get_paye_ref INTO l_cur_paye_ref;
519: CLOSE get_paye_ref;
520: hr_utility.trace('Current PAYE Ref is '||l_cur_paye_ref);

Line 520: hr_utility.trace('Current PAYE Ref is '||l_cur_paye_ref);

516: hr_utility.trace('Fetching Current PAYE Ref.');
517: OPEN get_paye_ref(l_cur_scl_id);
518: FETCH get_paye_ref INTO l_cur_paye_ref;
519: CLOSE get_paye_ref;
520: hr_utility.trace('Current PAYE Ref is '||l_cur_paye_ref);
521: --
522: hr_utility.trace('Fetching fiest start date and last end date of the payroll');
523: OPEN get_min_max_dates;
524: FETCH get_min_max_dates INTO l_first_eff_start, l_last_eff_end;

Line 522: hr_utility.trace('Fetching fiest start date and last end date of the payroll');

518: FETCH get_paye_ref INTO l_cur_paye_ref;
519: CLOSE get_paye_ref;
520: hr_utility.trace('Current PAYE Ref is '||l_cur_paye_ref);
521: --
522: hr_utility.trace('Fetching fiest start date and last end date of the payroll');
523: OPEN get_min_max_dates;
524: FETCH get_min_max_dates INTO l_first_eff_start, l_last_eff_end;
525: CLOSE get_min_max_dates;
526: hr_utility.trace('l_first_eff_start='||fnd_date.date_to_displaydate(l_first_eff_start));

Line 526: hr_utility.trace('l_first_eff_start='||fnd_date.date_to_displaydate(l_first_eff_start));

522: hr_utility.trace('Fetching fiest start date and last end date of the payroll');
523: OPEN get_min_max_dates;
524: FETCH get_min_max_dates INTO l_first_eff_start, l_last_eff_end;
525: CLOSE get_min_max_dates;
526: hr_utility.trace('l_first_eff_start='||fnd_date.date_to_displaydate(l_first_eff_start));
527: hr_utility.trace('l_last_eff_end='||fnd_date.date_to_displaydate(l_last_eff_end));
528: --
529: IF p_datetrack_mode = hr_api.g_delete_next_change THEN
530: hr_utility.trace('Datetrack Mode is Delete next change.');

Line 527: hr_utility.trace('l_last_eff_end='||fnd_date.date_to_displaydate(l_last_eff_end));

523: OPEN get_min_max_dates;
524: FETCH get_min_max_dates INTO l_first_eff_start, l_last_eff_end;
525: CLOSE get_min_max_dates;
526: hr_utility.trace('l_first_eff_start='||fnd_date.date_to_displaydate(l_first_eff_start));
527: hr_utility.trace('l_last_eff_end='||fnd_date.date_to_displaydate(l_last_eff_end));
528: --
529: IF p_datetrack_mode = hr_api.g_delete_next_change THEN
530: hr_utility.trace('Datetrack Mode is Delete next change.');
531: hr_utility.trace('Fetching end date of next instance.');

Line 530: hr_utility.trace('Datetrack Mode is Delete next change.');

526: hr_utility.trace('l_first_eff_start='||fnd_date.date_to_displaydate(l_first_eff_start));
527: hr_utility.trace('l_last_eff_end='||fnd_date.date_to_displaydate(l_last_eff_end));
528: --
529: IF p_datetrack_mode = hr_api.g_delete_next_change THEN
530: hr_utility.trace('Datetrack Mode is Delete next change.');
531: hr_utility.trace('Fetching end date of next instance.');
532: OPEN get_next_details;
533: FETCH get_next_details INTO l_next_eff_end;
534: CLOSE get_next_details;

Line 531: hr_utility.trace('Fetching end date of next instance.');

527: hr_utility.trace('l_last_eff_end='||fnd_date.date_to_displaydate(l_last_eff_end));
528: --
529: IF p_datetrack_mode = hr_api.g_delete_next_change THEN
530: hr_utility.trace('Datetrack Mode is Delete next change.');
531: hr_utility.trace('Fetching end date of next instance.');
532: OPEN get_next_details;
533: FETCH get_next_details INTO l_next_eff_end;
534: CLOSE get_next_details;
535: --

Line 536: hr_utility.trace('l_next_eff_date='||fnd_date.date_to_displaydate(l_next_eff_end));

532: OPEN get_next_details;
533: FETCH get_next_details INTO l_next_eff_end;
534: CLOSE get_next_details;
535: --
536: hr_utility.trace('l_next_eff_date='||fnd_date.date_to_displaydate(l_next_eff_end));
537: hr_utility.trace('Fetching PAYE Ref on next to next instance.');
538: OPEN get_next_to_next_details;
539: FETCH get_next_to_next_details INTO l_next_to_next_scl_id;
540: CLOSE get_next_to_next_details;

Line 537: hr_utility.trace('Fetching PAYE Ref on next to next instance.');

533: FETCH get_next_details INTO l_next_eff_end;
534: CLOSE get_next_details;
535: --
536: hr_utility.trace('l_next_eff_date='||fnd_date.date_to_displaydate(l_next_eff_end));
537: hr_utility.trace('Fetching PAYE Ref on next to next instance.');
538: OPEN get_next_to_next_details;
539: FETCH get_next_to_next_details INTO l_next_to_next_scl_id;
540: CLOSE get_next_to_next_details;
541: hr_utility.trace('l_next_to_next_scl_id='||l_next_to_next_scl_id);

Line 541: hr_utility.trace('l_next_to_next_scl_id='||l_next_to_next_scl_id);

537: hr_utility.trace('Fetching PAYE Ref on next to next instance.');
538: OPEN get_next_to_next_details;
539: FETCH get_next_to_next_details INTO l_next_to_next_scl_id;
540: CLOSE get_next_to_next_details;
541: hr_utility.trace('l_next_to_next_scl_id='||l_next_to_next_scl_id);
542: --
543: OPEN get_paye_ref(l_next_to_next_scl_id);
544: FETCH get_paye_ref INTO l_next_to_next_paye_ref;
545: CLOSE get_paye_ref;

Line 546: hr_utility.trace('l_next_to_next_paye_ref='||l_next_to_next_paye_ref);

542: --
543: OPEN get_paye_ref(l_next_to_next_scl_id);
544: FETCH get_paye_ref INTO l_next_to_next_paye_ref;
545: CLOSE get_paye_ref;
546: hr_utility.trace('l_next_to_next_paye_ref='||l_next_to_next_paye_ref);
547: --
548: IF l_next_to_next_paye_ref <> l_cur_paye_ref AND
549: l_next_eff_end <> l_last_eff_end AND
550: to_char(l_next_eff_end, 'DD-MM') <> '05-04' THEN

Line 552: hr_utility.trace('Current PAYE Ref does not match the PAYE ');

548: IF l_next_to_next_paye_ref <> l_cur_paye_ref AND
549: l_next_eff_end <> l_last_eff_end AND
550: to_char(l_next_eff_end, 'DD-MM') <> '05-04' THEN
551: --
552: hr_utility.trace('Current PAYE Ref does not match the PAYE ');
553: hr_utility.trace('Ref on next to next instance and next effective ');
554: hr_utility.trace('end date is not the last effective end date and ');
555: hr_utility.trace('next effective end date is not end of a ');
556: hr_utility.trace('tax year therefore raise an error message.');

Line 553: hr_utility.trace('Ref on next to next instance and next effective ');

549: l_next_eff_end <> l_last_eff_end AND
550: to_char(l_next_eff_end, 'DD-MM') <> '05-04' THEN
551: --
552: hr_utility.trace('Current PAYE Ref does not match the PAYE ');
553: hr_utility.trace('Ref on next to next instance and next effective ');
554: hr_utility.trace('end date is not the last effective end date and ');
555: hr_utility.trace('next effective end date is not end of a ');
556: hr_utility.trace('tax year therefore raise an error message.');
557: --

Line 554: hr_utility.trace('end date is not the last effective end date and ');

550: to_char(l_next_eff_end, 'DD-MM') <> '05-04' THEN
551: --
552: hr_utility.trace('Current PAYE Ref does not match the PAYE ');
553: hr_utility.trace('Ref on next to next instance and next effective ');
554: hr_utility.trace('end date is not the last effective end date and ');
555: hr_utility.trace('next effective end date is not end of a ');
556: hr_utility.trace('tax year therefore raise an error message.');
557: --
558: l_span_start := hr_gbbal.span_start(l_next_eff_end);

Line 555: hr_utility.trace('next effective end date is not end of a ');

551: --
552: hr_utility.trace('Current PAYE Ref does not match the PAYE ');
553: hr_utility.trace('Ref on next to next instance and next effective ');
554: hr_utility.trace('end date is not the last effective end date and ');
555: hr_utility.trace('next effective end date is not end of a ');
556: hr_utility.trace('tax year therefore raise an error message.');
557: --
558: l_span_start := hr_gbbal.span_start(l_next_eff_end);
559: l_span_end := hr_gbbal.span_end(l_next_eff_end);

Line 556: hr_utility.trace('tax year therefore raise an error message.');

552: hr_utility.trace('Current PAYE Ref does not match the PAYE ');
553: hr_utility.trace('Ref on next to next instance and next effective ');
554: hr_utility.trace('end date is not the last effective end date and ');
555: hr_utility.trace('next effective end date is not end of a ');
556: hr_utility.trace('tax year therefore raise an error message.');
557: --
558: l_span_start := hr_gbbal.span_start(l_next_eff_end);
559: l_span_end := hr_gbbal.span_end(l_next_eff_end);
560: --

Line 594: hr_utility.trace('No problem with this delete.');

590: -- END CHECK - Termination Assignment exists at the Effective start date
591:
592: END IF; -- Datetrack mode is Remove next change
593: --
594: hr_utility.trace('No problem with this delete.');
595: hr_utility.trace('Leaving pay_gb_payroll_rules.validate_delete');
596: END validate_delete;
597:
598: END;

Line 595: hr_utility.trace('Leaving pay_gb_payroll_rules.validate_delete');

591:
592: END IF; -- Datetrack mode is Remove next change
593: --
594: hr_utility.trace('No problem with this delete.');
595: hr_utility.trace('Leaving pay_gb_payroll_rules.validate_delete');
596: END validate_delete;
597:
598: END;