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

Line 89: hr_utility.trace('Entering validate_tax_code_combinations');

85:
86: tax_details_rec csr_get_asg_tax_details%ROWTYPE;
87: --
88: BEGIN
89: hr_utility.trace('Entering validate_tax_code_combinations');
90: /*
91: hr_utility.trace('p_payroll_id '||p_payroll_id );
92: hr_utility.trace('p_effective_date '||p_effective_date );
93: hr_utility.trace('p_tax_code '||p_tax_code );

Line 91: hr_utility.trace('p_payroll_id '||p_payroll_id );

87: --
88: BEGIN
89: hr_utility.trace('Entering validate_tax_code_combinations');
90: /*
91: hr_utility.trace('p_payroll_id '||p_payroll_id );
92: hr_utility.trace('p_effective_date '||p_effective_date );
93: hr_utility.trace('p_tax_code '||p_tax_code );
94: hr_utility.trace('p_tax_red_apply '||p_tax_red_apply );
95: hr_utility.trace('p_labour_tax_apply '||p_labour_tax_apply );

Line 92: hr_utility.trace('p_effective_date '||p_effective_date );

88: BEGIN
89: hr_utility.trace('Entering validate_tax_code_combinations');
90: /*
91: hr_utility.trace('p_payroll_id '||p_payroll_id );
92: hr_utility.trace('p_effective_date '||p_effective_date );
93: hr_utility.trace('p_tax_code '||p_tax_code );
94: hr_utility.trace('p_tax_red_apply '||p_tax_red_apply );
95: hr_utility.trace('p_labour_tax_apply '||p_labour_tax_apply );
96: hr_utility.trace('p_add_sr_tax_apply '||p_add_sr_tax_apply );

Line 93: hr_utility.trace('p_tax_code '||p_tax_code );

89: hr_utility.trace('Entering validate_tax_code_combinations');
90: /*
91: hr_utility.trace('p_payroll_id '||p_payroll_id );
92: hr_utility.trace('p_effective_date '||p_effective_date );
93: hr_utility.trace('p_tax_code '||p_tax_code );
94: hr_utility.trace('p_tax_red_apply '||p_tax_red_apply );
95: hr_utility.trace('p_labour_tax_apply '||p_labour_tax_apply );
96: hr_utility.trace('p_add_sr_tax_apply '||p_add_sr_tax_apply );
97: */

Line 94: hr_utility.trace('p_tax_red_apply '||p_tax_red_apply );

90: /*
91: hr_utility.trace('p_payroll_id '||p_payroll_id );
92: hr_utility.trace('p_effective_date '||p_effective_date );
93: hr_utility.trace('p_tax_code '||p_tax_code );
94: hr_utility.trace('p_tax_red_apply '||p_tax_red_apply );
95: hr_utility.trace('p_labour_tax_apply '||p_labour_tax_apply );
96: hr_utility.trace('p_add_sr_tax_apply '||p_add_sr_tax_apply );
97: */
98: l_tax_code := NVL(p_tax_code,'940');

Line 95: hr_utility.trace('p_labour_tax_apply '||p_labour_tax_apply );

91: hr_utility.trace('p_payroll_id '||p_payroll_id );
92: hr_utility.trace('p_effective_date '||p_effective_date );
93: hr_utility.trace('p_tax_code '||p_tax_code );
94: hr_utility.trace('p_tax_red_apply '||p_tax_red_apply );
95: hr_utility.trace('p_labour_tax_apply '||p_labour_tax_apply );
96: hr_utility.trace('p_add_sr_tax_apply '||p_add_sr_tax_apply );
97: */
98: l_tax_code := NVL(p_tax_code,'940');
99: l_tax_red_apply := NVL(p_tax_red_apply,'N');

Line 96: hr_utility.trace('p_add_sr_tax_apply '||p_add_sr_tax_apply );

92: hr_utility.trace('p_effective_date '||p_effective_date );
93: hr_utility.trace('p_tax_code '||p_tax_code );
94: hr_utility.trace('p_tax_red_apply '||p_tax_red_apply );
95: hr_utility.trace('p_labour_tax_apply '||p_labour_tax_apply );
96: hr_utility.trace('p_add_sr_tax_apply '||p_add_sr_tax_apply );
97: */
98: l_tax_code := NVL(p_tax_code,'940');
99: l_tax_red_apply := NVL(p_tax_red_apply,'N');
100: l_labour_tax_apply := NVL(p_labour_tax_apply,'N');

Line 104: hr_utility.trace('l_tax_code '||l_tax_code );

100: l_labour_tax_apply := NVL(p_labour_tax_apply,'N');
101: l_add_sr_tax_apply := NVL(p_add_sr_tax_apply,'N');
102:
103: /*
104: hr_utility.trace('l_tax_code '||l_tax_code );
105: hr_utility.trace('l_tax_red_apply '||l_tax_red_apply );
106: hr_utility.trace('l_labour_tax_apply '||l_labour_tax_apply );
107: hr_utility.trace('l_add_sr_tax_apply '||l_add_sr_tax_apply );
108: */

Line 105: hr_utility.trace('l_tax_red_apply '||l_tax_red_apply );

101: l_add_sr_tax_apply := NVL(p_add_sr_tax_apply,'N');
102:
103: /*
104: hr_utility.trace('l_tax_code '||l_tax_code );
105: hr_utility.trace('l_tax_red_apply '||l_tax_red_apply );
106: hr_utility.trace('l_labour_tax_apply '||l_labour_tax_apply );
107: hr_utility.trace('l_add_sr_tax_apply '||l_add_sr_tax_apply );
108: */
109:

Line 106: hr_utility.trace('l_labour_tax_apply '||l_labour_tax_apply );

102:
103: /*
104: hr_utility.trace('l_tax_code '||l_tax_code );
105: hr_utility.trace('l_tax_red_apply '||l_tax_red_apply );
106: hr_utility.trace('l_labour_tax_apply '||l_labour_tax_apply );
107: hr_utility.trace('l_add_sr_tax_apply '||l_add_sr_tax_apply );
108: */
109:
110: IF p_assignment_id IS NOT NULL THEN

Line 107: hr_utility.trace('l_add_sr_tax_apply '||l_add_sr_tax_apply );

103: /*
104: hr_utility.trace('l_tax_code '||l_tax_code );
105: hr_utility.trace('l_tax_red_apply '||l_tax_red_apply );
106: hr_utility.trace('l_labour_tax_apply '||l_labour_tax_apply );
107: hr_utility.trace('l_add_sr_tax_apply '||l_add_sr_tax_apply );
108: */
109:
110: IF p_assignment_id IS NOT NULL THEN
111: /*Fetch the Db Values for the Assignment if Update_emp_asg

Line 117: hr_utility.trace('tax_details_rec.tax_code '||tax_details_rec.tax_code );

113:
114: OPEN csr_get_asg_tax_details(p_assignment_id,p_effective_date);
115: FETCH csr_get_asg_tax_details INTO tax_details_rec;
116: /*
117: hr_utility.trace('tax_details_rec.tax_code '||tax_details_rec.tax_code );
118: hr_utility.trace('tax_details_rec.tax_red '||tax_details_rec.tax_red );
119: hr_utility.trace('tax_details_rec.labour_tax '||tax_details_rec.labour_tax );
120: hr_utility.trace('tax_details_rec.add_sr_tax '||tax_details_rec.add_sr_tax );
121: */

Line 118: hr_utility.trace('tax_details_rec.tax_red '||tax_details_rec.tax_red );

114: OPEN csr_get_asg_tax_details(p_assignment_id,p_effective_date);
115: FETCH csr_get_asg_tax_details INTO tax_details_rec;
116: /*
117: hr_utility.trace('tax_details_rec.tax_code '||tax_details_rec.tax_code );
118: hr_utility.trace('tax_details_rec.tax_red '||tax_details_rec.tax_red );
119: hr_utility.trace('tax_details_rec.labour_tax '||tax_details_rec.labour_tax );
120: hr_utility.trace('tax_details_rec.add_sr_tax '||tax_details_rec.add_sr_tax );
121: */
122: IF p_tax_code= hr_api.g_varchar2 THEN

Line 119: hr_utility.trace('tax_details_rec.labour_tax '||tax_details_rec.labour_tax );

115: FETCH csr_get_asg_tax_details INTO tax_details_rec;
116: /*
117: hr_utility.trace('tax_details_rec.tax_code '||tax_details_rec.tax_code );
118: hr_utility.trace('tax_details_rec.tax_red '||tax_details_rec.tax_red );
119: hr_utility.trace('tax_details_rec.labour_tax '||tax_details_rec.labour_tax );
120: hr_utility.trace('tax_details_rec.add_sr_tax '||tax_details_rec.add_sr_tax );
121: */
122: IF p_tax_code= hr_api.g_varchar2 THEN
123: l_tax_code := NVL(tax_details_rec.tax_code,'940') ;

Line 120: hr_utility.trace('tax_details_rec.add_sr_tax '||tax_details_rec.add_sr_tax );

116: /*
117: hr_utility.trace('tax_details_rec.tax_code '||tax_details_rec.tax_code );
118: hr_utility.trace('tax_details_rec.tax_red '||tax_details_rec.tax_red );
119: hr_utility.trace('tax_details_rec.labour_tax '||tax_details_rec.labour_tax );
120: hr_utility.trace('tax_details_rec.add_sr_tax '||tax_details_rec.add_sr_tax );
121: */
122: IF p_tax_code= hr_api.g_varchar2 THEN
123: l_tax_code := NVL(tax_details_rec.tax_code,'940') ;
124: END IF;

Line 136: hr_utility.trace('p_payroll_id '||p_payroll_id );

132: l_add_sr_tax_apply := NVL(tax_details_rec.add_sr_tax,'N') ;
133: END IF;
134: END IF;
135: /*
136: hr_utility.trace('p_payroll_id '||p_payroll_id );
137: hr_utility.trace('l_tax_code '||l_tax_code );
138: hr_utility.trace('l_tax_red_apply '||l_tax_red_apply );
139: hr_utility.trace('l_labour_tax_apply '||l_labour_tax_apply );
140: hr_utility.trace('l_add_sr_tax_apply '||l_add_sr_tax_apply );

Line 137: hr_utility.trace('l_tax_code '||l_tax_code );

133: END IF;
134: END IF;
135: /*
136: hr_utility.trace('p_payroll_id '||p_payroll_id );
137: hr_utility.trace('l_tax_code '||l_tax_code );
138: hr_utility.trace('l_tax_red_apply '||l_tax_red_apply );
139: hr_utility.trace('l_labour_tax_apply '||l_labour_tax_apply );
140: hr_utility.trace('l_add_sr_tax_apply '||l_add_sr_tax_apply );
141: */

Line 138: hr_utility.trace('l_tax_red_apply '||l_tax_red_apply );

134: END IF;
135: /*
136: hr_utility.trace('p_payroll_id '||p_payroll_id );
137: hr_utility.trace('l_tax_code '||l_tax_code );
138: hr_utility.trace('l_tax_red_apply '||l_tax_red_apply );
139: hr_utility.trace('l_labour_tax_apply '||l_labour_tax_apply );
140: hr_utility.trace('l_add_sr_tax_apply '||l_add_sr_tax_apply );
141: */
142: IF p_payroll_id IS NULL AND l_tax_code <> '940' THEN

Line 139: hr_utility.trace('l_labour_tax_apply '||l_labour_tax_apply );

135: /*
136: hr_utility.trace('p_payroll_id '||p_payroll_id );
137: hr_utility.trace('l_tax_code '||l_tax_code );
138: hr_utility.trace('l_tax_red_apply '||l_tax_red_apply );
139: hr_utility.trace('l_labour_tax_apply '||l_labour_tax_apply );
140: hr_utility.trace('l_add_sr_tax_apply '||l_add_sr_tax_apply );
141: */
142: IF p_payroll_id IS NULL AND l_tax_code <> '940' THEN
143: -- Message Text - "You cannot enter tax information because this

Line 140: hr_utility.trace('l_add_sr_tax_apply '||l_add_sr_tax_apply );

136: hr_utility.trace('p_payroll_id '||p_payroll_id );
137: hr_utility.trace('l_tax_code '||l_tax_code );
138: hr_utility.trace('l_tax_red_apply '||l_tax_red_apply );
139: hr_utility.trace('l_labour_tax_apply '||l_labour_tax_apply );
140: hr_utility.trace('l_add_sr_tax_apply '||l_add_sr_tax_apply );
141: */
142: IF p_payroll_id IS NULL AND l_tax_code <> '940' THEN
143: -- Message Text - "You cannot enter tax information because this
144: -- assignment does not have a payroll attached to it."

Line 145: hr_utility.set_message(800, 'HR_NL_PAYROLL_IS_NULL');

141: */
142: IF p_payroll_id IS NULL AND l_tax_code <> '940' THEN
143: -- Message Text - "You cannot enter tax information because this
144: -- assignment does not have a payroll attached to it."
145: hr_utility.set_message(800, 'HR_NL_PAYROLL_IS_NULL');
146: hr_utility.raise_error;
147: --
148: ELSE
149: --

Line 146: hr_utility.raise_error;

142: IF p_payroll_id IS NULL AND l_tax_code <> '940' THEN
143: -- Message Text - "You cannot enter tax information because this
144: -- assignment does not have a payroll attached to it."
145: hr_utility.set_message(800, 'HR_NL_PAYROLL_IS_NULL');
146: hr_utility.raise_error;
147: --
148: ELSE
149: --
150: -- Tax code validations

Line 156: -- hr_utility.trace('IN');

152: IF l_labour_tax_apply = 'Y' THEN
153: IF l_tax_red_apply = 'N' THEN
154: -- Message Text- "The Labour Tax Reduction indicator is
155: -- applicable only when Tax Reduction indicator is applicable."
156: -- hr_utility.trace('IN');
157: hr_utility.set_message(800, 'HR_NL_LTR_NA_FOR_TR_NA');
158: hr_utility.raise_error;
159: END IF;
160: END IF;

Line 157: hr_utility.set_message(800, 'HR_NL_LTR_NA_FOR_TR_NA');

153: IF l_tax_red_apply = 'N' THEN
154: -- Message Text- "The Labour Tax Reduction indicator is
155: -- applicable only when Tax Reduction indicator is applicable."
156: -- hr_utility.trace('IN');
157: hr_utility.set_message(800, 'HR_NL_LTR_NA_FOR_TR_NA');
158: hr_utility.raise_error;
159: END IF;
160: END IF;
161: IF l_add_sr_tax_apply = 'Y' THEN

Line 158: hr_utility.raise_error;

154: -- Message Text- "The Labour Tax Reduction indicator is
155: -- applicable only when Tax Reduction indicator is applicable."
156: -- hr_utility.trace('IN');
157: hr_utility.set_message(800, 'HR_NL_LTR_NA_FOR_TR_NA');
158: hr_utility.raise_error;
159: END IF;
160: END IF;
161: IF l_add_sr_tax_apply = 'Y' THEN
162: IF (l_tax_red_apply = 'N') THEN

Line 166: hr_utility.set_message(800, 'HR_STR_NA_IF_LTR_AND_TR_NA');

162: IF (l_tax_red_apply = 'N') THEN
163: -- Message Text - "Additional Senior Tax indicator is applicable
164: -- only if Tax Reduction is applicable."
165:
166: hr_utility.set_message(800, 'HR_STR_NA_IF_LTR_AND_TR_NA');
167: hr_utility.raise_error;
168: END IF;
169: END IF;
170: --

Line 167: hr_utility.raise_error;

163: -- Message Text - "Additional Senior Tax indicator is applicable
164: -- only if Tax Reduction is applicable."
165:
166: hr_utility.set_message(800, 'HR_STR_NA_IF_LTR_AND_TR_NA');
167: hr_utility.raise_error;
168: END IF;
169: END IF;
170: --
171: -- hr_utility.trace('INSIDE TAX VALIDATION THREE');

Line 171: -- hr_utility.trace('INSIDE TAX VALIDATION THREE');

167: hr_utility.raise_error;
168: END IF;
169: END IF;
170: --
171: -- hr_utility.trace('INSIDE TAX VALIDATION THREE');
172:
173: -- Get Payroll Period Type
174: OPEN get_payroll_period_type(p_payroll_id,p_effective_date);
175: FETCH get_payroll_period_type INTO l_period_type;

Line 179: --hr_utility.trace('INSIDE TAX VALIDATION FOUR');

175: FETCH get_payroll_period_type INTO l_period_type;
176: CLOSE get_payroll_period_type;
177: --
178:
179: --hr_utility.trace('INSIDE TAX VALIDATION FOUR');
180:
181: -- Get Payroll Period Type Code
182: pay_nl_tax_pkg.get_period_type_code(l_period_type
183: ,p_period_type

Line 187: --hr_utility.trace('INSIDE TAX VALIDATION FIVE'||l_period_code||l_tax_code);

183: ,p_period_type
184: ,l_period_code);
185:
186: --l_tax_code :='940';
187: --hr_utility.trace('INSIDE TAX VALIDATION FIVE'||l_period_code||l_tax_code);
188:
189: -- Validate Tax Code
190: pay_nl_tax_pkg.chk_tax_code(l_tax_code
191: ,l_period_code

Line 204: hr_utility.set_message(800, 'HR_NL_LTR_NA_FOR_GREEN_TABLE');

200: -- Message Text
201: -- "The Labour Tax Reduction indicator is applicable to the
202: -- white tax table only. Please select the white tax table
203: -- if the employee is eligible for a labour tax reduction."
204: hr_utility.set_message(800, 'HR_NL_LTR_NA_FOR_GREEN_TABLE');
205: hr_utility.raise_error;
206: END IF;
207: --
208: IF l_2_digit = '1' AND l_add_sr_tax_apply = 'Y' THEN

Line 205: hr_utility.raise_error;

201: -- "The Labour Tax Reduction indicator is applicable to the
202: -- white tax table only. Please select the white tax table
203: -- if the employee is eligible for a labour tax reduction."
204: hr_utility.set_message(800, 'HR_NL_LTR_NA_FOR_GREEN_TABLE');
205: hr_utility.raise_error;
206: END IF;
207: --
208: IF l_2_digit = '1' AND l_add_sr_tax_apply = 'Y' THEN
209: -- Message Text -

Line 214: hr_utility.set_message(800, 'HR_NL_ASTR_NA_FOR_WHITE_TABLE');

210: --"The Additional Senior Tax Reduction indicator is applicable
211: -- to the green tax table only. Please select the green tax
212: -- table if the employee is eligible for an additional
213: -- senior tax reduction."
214: hr_utility.set_message(800, 'HR_NL_ASTR_NA_FOR_WHITE_TABLE');
215: hr_utility.raise_error;
216: END IF;
217: --
218: IF l_2_digit= '1' AND (l_1_digit = '6' OR l_1_digit = '7') THEN

Line 215: hr_utility.raise_error;

211: -- to the green tax table only. Please select the green tax
212: -- table if the employee is eligible for an additional
213: -- senior tax reduction."
214: hr_utility.set_message(800, 'HR_NL_ASTR_NA_FOR_WHITE_TABLE');
215: hr_utility.raise_error;
216: END IF;
217: --
218: IF l_2_digit= '1' AND (l_1_digit = '6' OR l_1_digit = '7') THEN
219: -- Message Text -

Line 223: hr_utility.set_message(800, 'HR_NL_TAXATION_TYPES_NA');

219: -- Message Text -
220: -- "The tax code is invalid, the taxation types 6 and 7 are
221: -- applicable for the green tax table only. Please enter a
222: -- valid tax code."
223: hr_utility.set_message(800, 'HR_NL_TAXATION_TYPES_NA');
224: hr_utility.raise_error;
225: END IF;
226: --
227: OPEN csr_get_marital_status(p_person_id,p_effective_date);

Line 224: hr_utility.raise_error;

220: -- "The tax code is invalid, the taxation types 6 and 7 are
221: -- applicable for the green tax table only. Please enter a
222: -- valid tax code."
223: hr_utility.set_message(800, 'HR_NL_TAXATION_TYPES_NA');
224: hr_utility.raise_error;
225: END IF;
226: --
227: OPEN csr_get_marital_status(p_person_id,p_effective_date);
228: FETCH csr_get_marital_status INTO l_mar_status;

Line 240: hr_utility.set_message(800, 'HR_NL_ASTR_APPLIES_FOR_SINGLE');

236: AND l_add_sr_tax_apply = 'Y' THEN
237: -- Message Text -
238: -- "The Additional Senior Tax Reduction indicator is only
239: -- applicable for employees who have a status of single."
240: hr_utility.set_message(800, 'HR_NL_ASTR_APPLIES_FOR_SINGLE');
241: hr_utility.raise_error;
242: END IF;
243: --
244: l_age := pay_nl_tax_pkg.check_age_payroll_period

Line 241: hr_utility.raise_error;

237: -- Message Text -
238: -- "The Additional Senior Tax Reduction indicator is only
239: -- applicable for employees who have a status of single."
240: hr_utility.set_message(800, 'HR_NL_ASTR_APPLIES_FOR_SINGLE');
241: hr_utility.raise_error;
242: END IF;
243: --
244: l_age := pay_nl_tax_pkg.check_age_payroll_period
245: (p_person_id

Line 254: hr_utility.set_message(800, 'HR_NL_TAX_CODE_227_NA');

250: -- Message Text -
251: -- "The tax code 227 is not applicable for employees who are
252: -- under 65 years old. Please enter a valid tax code
253: -- for the assignment."
254: hr_utility.set_message(800, 'HR_NL_TAX_CODE_227_NA');
255: hr_utility.set_message_token('TAX_CODE', '227');
256: hr_utility.raise_error;
257: ELSIF l_tax_code = '228' AND l_age >= 65 THEN
258: -- Message Text -

Line 255: hr_utility.set_message_token('TAX_CODE', '227');

251: -- "The tax code 227 is not applicable for employees who are
252: -- under 65 years old. Please enter a valid tax code
253: -- for the assignment."
254: hr_utility.set_message(800, 'HR_NL_TAX_CODE_227_NA');
255: hr_utility.set_message_token('TAX_CODE', '227');
256: hr_utility.raise_error;
257: ELSIF l_tax_code = '228' AND l_age >= 65 THEN
258: -- Message Text -
259: -- "The tax code 228 is not applicable for employees who are

Line 256: hr_utility.raise_error;

252: -- under 65 years old. Please enter a valid tax code
253: -- for the assignment."
254: hr_utility.set_message(800, 'HR_NL_TAX_CODE_227_NA');
255: hr_utility.set_message_token('TAX_CODE', '227');
256: hr_utility.raise_error;
257: ELSIF l_tax_code = '228' AND l_age >= 65 THEN
258: -- Message Text -
259: -- "The tax code 228 is not applicable for employees who are
260: -- 65 years old or over. Please enter a valid tax code

Line 262: hr_utility.set_message(801, 'HR_NL_TAX_CODE_228_NA');

258: -- Message Text -
259: -- "The tax code 228 is not applicable for employees who are
260: -- 65 years old or over. Please enter a valid tax code
261: -- for the assignment."
262: hr_utility.set_message(801, 'HR_NL_TAX_CODE_228_NA');
263: hr_utility.set_message_token('TAX_CODE', '228');
264: hr_utility.raise_error;
265: END IF;
266: IF l_add_sr_tax_apply = 'Y' AND l_age < 65 THEN

Line 263: hr_utility.set_message_token('TAX_CODE', '228');

259: -- "The tax code 228 is not applicable for employees who are
260: -- 65 years old or over. Please enter a valid tax code
261: -- for the assignment."
262: hr_utility.set_message(801, 'HR_NL_TAX_CODE_228_NA');
263: hr_utility.set_message_token('TAX_CODE', '228');
264: hr_utility.raise_error;
265: END IF;
266: IF l_add_sr_tax_apply = 'Y' AND l_age < 65 THEN
267: -- Message Text -

Line 264: hr_utility.raise_error;

260: -- 65 years old or over. Please enter a valid tax code
261: -- for the assignment."
262: hr_utility.set_message(801, 'HR_NL_TAX_CODE_228_NA');
263: hr_utility.set_message_token('TAX_CODE', '228');
264: hr_utility.raise_error;
265: END IF;
266: IF l_add_sr_tax_apply = 'Y' AND l_age < 65 THEN
267: -- Message Text -
268: -- "Additional Senior Tax Reduction indicator is not applicable

Line 271: hr_utility.set_message(800, 'HR_NL_ASTR_NA_FOR_AGE_LT_65');

267: -- Message Text -
268: -- "Additional Senior Tax Reduction indicator is not applicable
269: -- for employees who are under 65 years old."
270:
271: hr_utility.set_message(800, 'HR_NL_ASTR_NA_FOR_AGE_LT_65');
272: hr_utility.raise_error;
273: END IF;
274: --
275: --

Line 272: hr_utility.raise_error;

268: -- "Additional Senior Tax Reduction indicator is not applicable
269: -- for employees who are under 65 years old."
270:
271: hr_utility.set_message(800, 'HR_NL_ASTR_NA_FOR_AGE_LT_65');
272: hr_utility.raise_error;
273: END IF;
274: --
275: --
276: --

Line 280: hr_utility.set_message(800, 'HR_NL_TAX_CODE_INVALID');

276: --
277: ELSE-- Tax code invalid
278: -- Message Text -
279: -- "This is an invalid Tax Code. Please enter the correct code."
280: hr_utility.set_message(800, 'HR_NL_TAX_CODE_INVALID');
281: hr_utility.raise_error;
282: END IF;
283: --
284: END IF;

Line 281: hr_utility.raise_error;

277: ELSE-- Tax code invalid
278: -- Message Text -
279: -- "This is an invalid Tax Code. Please enter the correct code."
280: hr_utility.set_message(800, 'HR_NL_TAX_CODE_INVALID');
281: hr_utility.raise_error;
282: END IF;
283: --
284: END IF;
285:

Line 329: hr_utility.trace('Entering validate_spl_indicators');

325:
326: l_special_indicators2 csr_get_spl_indicator_details%ROWTYPE;
327:
328: BEGIN
329: hr_utility.trace('Entering validate_spl_indicators');
330: --
331: IF p_special_indicators = hr_api.g_varchar2 THEN
332: open csr_get_spl_indicator_details(p_assignment_id,p_effective_date);
333: fetch csr_get_spl_indicator_details into l_special_indicators2;

Line 346: hr_utility.set_message(800, 'HR_NL_INVALID_FIELD');

342: IF mod(length(l_special_indicators),2) <> 0 THEN
343: -- Message Text -
344: -- "A special indicator value is invalid."
345:
346: hr_utility.set_message(800, 'HR_NL_INVALID_FIELD');
347: hr_utility.set_message_token('FIELD', 'Special Indicator');
348:
349: hr_utility.raise_error;
350: --

Line 347: hr_utility.set_message_token('FIELD', 'Special Indicator');

343: -- Message Text -
344: -- "A special indicator value is invalid."
345:
346: hr_utility.set_message(800, 'HR_NL_INVALID_FIELD');
347: hr_utility.set_message_token('FIELD', 'Special Indicator');
348:
349: hr_utility.raise_error;
350: --
351: ELSE

Line 349: hr_utility.raise_error;

345:
346: hr_utility.set_message(800, 'HR_NL_INVALID_FIELD');
347: hr_utility.set_message_token('FIELD', 'Special Indicator');
348:
349: hr_utility.raise_error;
350: --
351: ELSE
352: --
353: pay_nl_tax_pkg.get_spl_inds(l_special_indicators

Line 379: hr_utility.set_message(800, 'HR_NL_INVALID_FIELD');

375: IF csr_lookup_code_exists%NOTFOUND THEN
376: CLOSE csr_lookup_code_exists;
377: -- Message Text -
378: -- "A special indicator value is invalid."
379: hr_utility.set_message(800, 'HR_NL_INVALID_FIELD');
380: hr_utility.set_message_token('FIELD', 'Special Indicator');
381: hr_utility.raise_error;
382: --
383: END IF;

Line 380: hr_utility.set_message_token('FIELD', 'Special Indicator');

376: CLOSE csr_lookup_code_exists;
377: -- Message Text -
378: -- "A special indicator value is invalid."
379: hr_utility.set_message(800, 'HR_NL_INVALID_FIELD');
380: hr_utility.set_message_token('FIELD', 'Special Indicator');
381: hr_utility.raise_error;
382: --
383: END IF;
384: CLOSE csr_lookup_code_exists;

Line 381: hr_utility.raise_error;

377: -- Message Text -
378: -- "A special indicator value is invalid."
379: hr_utility.set_message(800, 'HR_NL_INVALID_FIELD');
380: hr_utility.set_message_token('FIELD', 'Special Indicator');
381: hr_utility.raise_error;
382: --
383: END IF;
384: CLOSE csr_lookup_code_exists;
385: END IF;

Line 407: hr_utility.set_message(800, 'HR_NL_SPL_INDICATOR_SET');

403: IF l_set THEN
404: -- Message Text -
405: -- "You have already selected this special indicator for
406: -- the employee."
407: hr_utility.set_message(800, 'HR_NL_SPL_INDICATOR_SET');
408: hr_utility.raise_error;
409: END IF;
410: --
411: END IF;

Line 408: hr_utility.raise_error;

404: -- Message Text -
405: -- "You have already selected this special indicator for
406: -- the employee."
407: hr_utility.set_message(800, 'HR_NL_SPL_INDICATOR_SET');
408: hr_utility.raise_error;
409: END IF;
410: --
411: END IF;
412: --

Line 415: hr_utility.trace('Leaving validate_spl_indicators');

411: END IF;
412: --
413: END IF;
414: --
415: hr_utility.trace('Leaving validate_spl_indicators');
416:
417: END validate_spl_indicators;
418: --
419: --------------------------------------------------------------------------------

Line 471: hr_utility.trace('Entering other_validations');

467: l_date_ending date;
468: --
469:
470: BEGIN
471: hr_utility.trace('Entering other_validations');
472: /*
473: hr_utility.trace(' p_effective_date '||p_effective_date);
474: hr_utility.trace(' p_commencing_from '||p_commencing_from);
475: hr_utility.trace(' p_date_ending '||p_date_ending);

Line 473: hr_utility.trace(' p_effective_date '||p_effective_date);

469:
470: BEGIN
471: hr_utility.trace('Entering other_validations');
472: /*
473: hr_utility.trace(' p_effective_date '||p_effective_date);
474: hr_utility.trace(' p_commencing_from '||p_commencing_from);
475: hr_utility.trace(' p_date_ending '||p_date_ending);
476: hr_utility.trace(' p_employment_type '||p_employment_type);
477: hr_utility.trace(' p_employment_subtype '||p_employment_subtype);

Line 474: hr_utility.trace(' p_commencing_from '||p_commencing_from);

470: BEGIN
471: hr_utility.trace('Entering other_validations');
472: /*
473: hr_utility.trace(' p_effective_date '||p_effective_date);
474: hr_utility.trace(' p_commencing_from '||p_commencing_from);
475: hr_utility.trace(' p_date_ending '||p_date_ending);
476: hr_utility.trace(' p_employment_type '||p_employment_type);
477: hr_utility.trace(' p_employment_subtype '||p_employment_subtype);
478: hr_utility.trace(' p_ind_working_hrs '||p_ind_working_hrs);

Line 475: hr_utility.trace(' p_date_ending '||p_date_ending);

471: hr_utility.trace('Entering other_validations');
472: /*
473: hr_utility.trace(' p_effective_date '||p_effective_date);
474: hr_utility.trace(' p_commencing_from '||p_commencing_from);
475: hr_utility.trace(' p_date_ending '||p_date_ending);
476: hr_utility.trace(' p_employment_type '||p_employment_type);
477: hr_utility.trace(' p_employment_subtype '||p_employment_subtype);
478: hr_utility.trace(' p_ind_working_hrs '||p_ind_working_hrs);
479: hr_utility.trace(' p_ind_perc '||p_ind_perc);

Line 476: hr_utility.trace(' p_employment_type '||p_employment_type);

472: /*
473: hr_utility.trace(' p_effective_date '||p_effective_date);
474: hr_utility.trace(' p_commencing_from '||p_commencing_from);
475: hr_utility.trace(' p_date_ending '||p_date_ending);
476: hr_utility.trace(' p_employment_type '||p_employment_type);
477: hr_utility.trace(' p_employment_subtype '||p_employment_subtype);
478: hr_utility.trace(' p_ind_working_hrs '||p_ind_working_hrs);
479: hr_utility.trace(' p_ind_perc '||p_ind_perc);
480: hr_utility.trace(' p_percentage '||p_percentage);

Line 477: hr_utility.trace(' p_employment_subtype '||p_employment_subtype);

473: hr_utility.trace(' p_effective_date '||p_effective_date);
474: hr_utility.trace(' p_commencing_from '||p_commencing_from);
475: hr_utility.trace(' p_date_ending '||p_date_ending);
476: hr_utility.trace(' p_employment_type '||p_employment_type);
477: hr_utility.trace(' p_employment_subtype '||p_employment_subtype);
478: hr_utility.trace(' p_ind_working_hrs '||p_ind_working_hrs);
479: hr_utility.trace(' p_ind_perc '||p_ind_perc);
480: hr_utility.trace(' p_percentage '||p_percentage);
481: hr_utility.trace(' p_frequency '||p_frequency);

Line 478: hr_utility.trace(' p_ind_working_hrs '||p_ind_working_hrs);

474: hr_utility.trace(' p_commencing_from '||p_commencing_from);
475: hr_utility.trace(' p_date_ending '||p_date_ending);
476: hr_utility.trace(' p_employment_type '||p_employment_type);
477: hr_utility.trace(' p_employment_subtype '||p_employment_subtype);
478: hr_utility.trace(' p_ind_working_hrs '||p_ind_working_hrs);
479: hr_utility.trace(' p_ind_perc '||p_ind_perc);
480: hr_utility.trace(' p_percentage '||p_percentage);
481: hr_utility.trace(' p_frequency '||p_frequency);
482: hr_utility.trace(' p_normal_hours '||p_normal_hours);

Line 479: hr_utility.trace(' p_ind_perc '||p_ind_perc);

475: hr_utility.trace(' p_date_ending '||p_date_ending);
476: hr_utility.trace(' p_employment_type '||p_employment_type);
477: hr_utility.trace(' p_employment_subtype '||p_employment_subtype);
478: hr_utility.trace(' p_ind_working_hrs '||p_ind_working_hrs);
479: hr_utility.trace(' p_ind_perc '||p_ind_perc);
480: hr_utility.trace(' p_percentage '||p_percentage);
481: hr_utility.trace(' p_frequency '||p_frequency);
482: hr_utility.trace(' p_normal_hours '||p_normal_hours);
483: */

Line 480: hr_utility.trace(' p_percentage '||p_percentage);

476: hr_utility.trace(' p_employment_type '||p_employment_type);
477: hr_utility.trace(' p_employment_subtype '||p_employment_subtype);
478: hr_utility.trace(' p_ind_working_hrs '||p_ind_working_hrs);
479: hr_utility.trace(' p_ind_perc '||p_ind_perc);
480: hr_utility.trace(' p_percentage '||p_percentage);
481: hr_utility.trace(' p_frequency '||p_frequency);
482: hr_utility.trace(' p_normal_hours '||p_normal_hours);
483: */
484:

Line 481: hr_utility.trace(' p_frequency '||p_frequency);

477: hr_utility.trace(' p_employment_subtype '||p_employment_subtype);
478: hr_utility.trace(' p_ind_working_hrs '||p_ind_working_hrs);
479: hr_utility.trace(' p_ind_perc '||p_ind_perc);
480: hr_utility.trace(' p_percentage '||p_percentage);
481: hr_utility.trace(' p_frequency '||p_frequency);
482: hr_utility.trace(' p_normal_hours '||p_normal_hours);
483: */
484:
485: l_emp_type := p_employment_type;

Line 482: hr_utility.trace(' p_normal_hours '||p_normal_hours);

478: hr_utility.trace(' p_ind_working_hrs '||p_ind_working_hrs);
479: hr_utility.trace(' p_ind_perc '||p_ind_perc);
480: hr_utility.trace(' p_percentage '||p_percentage);
481: hr_utility.trace(' p_frequency '||p_frequency);
482: hr_utility.trace(' p_normal_hours '||p_normal_hours);
483: */
484:
485: l_emp_type := p_employment_type;
486: l_emp_sub_type := p_employment_subtype;

Line 540: hr_utility.set_message(800, 'HR_NL_INVALID_FIELD');

536: --CLOSE csr_lookup_code_exists;
537: -- Message Text
538: -- 'Employment Sub Type is invalid. Please enter a valid value.'
539:
540: hr_utility.set_message(800, 'HR_NL_INVALID_FIELD');
541: hr_utility.set_message_token('FIELD', 'Employment Sub Type');
542: hr_utility.raise_error;
543: --
544: END IF;

Line 541: hr_utility.set_message_token('FIELD', 'Employment Sub Type');

537: -- Message Text
538: -- 'Employment Sub Type is invalid. Please enter a valid value.'
539:
540: hr_utility.set_message(800, 'HR_NL_INVALID_FIELD');
541: hr_utility.set_message_token('FIELD', 'Employment Sub Type');
542: hr_utility.raise_error;
543: --
544: END IF;
545: CLOSE csr_lookup_code_exists;

Line 542: hr_utility.raise_error;

538: -- 'Employment Sub Type is invalid. Please enter a valid value.'
539:
540: hr_utility.set_message(800, 'HR_NL_INVALID_FIELD');
541: hr_utility.set_message_token('FIELD', 'Employment Sub Type');
542: hr_utility.raise_error;
543: --
544: END IF;
545: CLOSE csr_lookup_code_exists;
546: --

Line 551: hr_utility.set_message(800, 'HR_NL_REQUIRED_FIELD');

547: ELSIF l_emp_type IS NULL AND l_emp_sub_type IS NOT NULL THEN
548: -- Message Text -
549: -- "You are attempting to save this record without submitting all of the
550: -- mandatory information. Please enter a value in Employment Type."
551: hr_utility.set_message(800, 'HR_NL_REQUIRED_FIELD');
552: hr_utility.set_message_token('FIELD', 'Employment Type');
553: hr_utility.raise_error;
554: --
555: END IF;

Line 552: hr_utility.set_message_token('FIELD', 'Employment Type');

548: -- Message Text -
549: -- "You are attempting to save this record without submitting all of the
550: -- mandatory information. Please enter a value in Employment Type."
551: hr_utility.set_message(800, 'HR_NL_REQUIRED_FIELD');
552: hr_utility.set_message_token('FIELD', 'Employment Type');
553: hr_utility.raise_error;
554: --
555: END IF;
556: --

Line 553: hr_utility.raise_error;

549: -- "You are attempting to save this record without submitting all of the
550: -- mandatory information. Please enter a value in Employment Type."
551: hr_utility.set_message(800, 'HR_NL_REQUIRED_FIELD');
552: hr_utility.set_message_token('FIELD', 'Employment Type');
553: hr_utility.raise_error;
554: --
555: END IF;
556: --
557:

Line 566: hr_utility.set_message(800, 'HR_NL_INVALID_DATE');

562: -- Message Text -
563: -- "The Commencing From date cannot be later than the Date Ending
564: -- date. Please enter a Commencing From date earlier than the
565: -- Date Ending date."
566: hr_utility.set_message(800, 'HR_NL_INVALID_DATE');
567: hr_utility.raise_error;
568: END IF;
569: END IF;
570:

Line 567: hr_utility.raise_error;

563: -- "The Commencing From date cannot be later than the Date Ending
564: -- date. Please enter a Commencing From date earlier than the
565: -- Date Ending date."
566: hr_utility.set_message(800, 'HR_NL_INVALID_DATE');
567: hr_utility.raise_error;
568: END IF;
569: END IF;
570:
571: -- Message Text -

Line 577: hr_utility.set_message(800, 'HR_NL_REQUIRED_FIELD');

573: -- mandatory information. Please enter a value in Frequency."
574:
575: IF ((p_ind_working_hrs <> hr_api.g_number OR p_normal_hours <> hr_api.g_number)
576: AND p_frequency IS null) THEN
577: hr_utility.set_message(800, 'HR_NL_REQUIRED_FIELD');
578: hr_utility.set_message_token('FIELD', 'Frequency');
579: hr_utility.raise_error;
580: END IF;
581:

Line 578: hr_utility.set_message_token('FIELD', 'Frequency');

574:
575: IF ((p_ind_working_hrs <> hr_api.g_number OR p_normal_hours <> hr_api.g_number)
576: AND p_frequency IS null) THEN
577: hr_utility.set_message(800, 'HR_NL_REQUIRED_FIELD');
578: hr_utility.set_message_token('FIELD', 'Frequency');
579: hr_utility.raise_error;
580: END IF;
581:
582:

Line 579: hr_utility.raise_error;

575: IF ((p_ind_working_hrs <> hr_api.g_number OR p_normal_hours <> hr_api.g_number)
576: AND p_frequency IS null) THEN
577: hr_utility.set_message(800, 'HR_NL_REQUIRED_FIELD');
578: hr_utility.set_message_token('FIELD', 'Frequency');
579: hr_utility.raise_error;
580: END IF;
581:
582:
583: IF (p_frequency = 'D' AND

Line 586: hr_utility.set_message(800, 'HR_NL_INCORRECT_FREQUENCY');

582:
583: IF (p_frequency = 'D' AND
584: (p_ind_working_hrs > fnd_number.canonical_to_number('24') OR
585: p_normal_hours > fnd_number.canonical_to_number('24'))) THEN
586: hr_utility.set_message(800, 'HR_NL_INCORRECT_FREQUENCY');
587: hr_utility.raise_error;
588: END IF;
589:
590: IF (p_frequency = 'W' AND

Line 587: hr_utility.raise_error;

583: IF (p_frequency = 'D' AND
584: (p_ind_working_hrs > fnd_number.canonical_to_number('24') OR
585: p_normal_hours > fnd_number.canonical_to_number('24'))) THEN
586: hr_utility.set_message(800, 'HR_NL_INCORRECT_FREQUENCY');
587: hr_utility.raise_error;
588: END IF;
589:
590: IF (p_frequency = 'W' AND
591: (p_ind_working_hrs > fnd_number.canonical_to_number('99.99') OR

Line 593: hr_utility.set_message(800, 'HR_NL_INCORRECT_FREQUENCY');

589:
590: IF (p_frequency = 'W' AND
591: (p_ind_working_hrs > fnd_number.canonical_to_number('99.99') OR
592: p_normal_hours > fnd_number.canonical_to_number('99.99'))) THEN
593: hr_utility.set_message(800, 'HR_NL_INCORRECT_FREQUENCY');
594: hr_utility.raise_error;
595: END IF;
596:
597:

Line 594: hr_utility.raise_error;

590: IF (p_frequency = 'W' AND
591: (p_ind_working_hrs > fnd_number.canonical_to_number('99.99') OR
592: p_normal_hours > fnd_number.canonical_to_number('99.99'))) THEN
593: hr_utility.set_message(800, 'HR_NL_INCORRECT_FREQUENCY');
594: hr_utility.raise_error;
595: END IF;
596:
597:
598: IF (p_frequency = 'M' AND

Line 601: hr_utility.set_message(800, 'HR_NL_INCORRECT_FREQUENCY');

597:
598: IF (p_frequency = 'M' AND
599: (p_ind_working_hrs > fnd_number.canonical_to_number('744') OR
600: p_normal_hours > fnd_number.canonical_to_number('744'))) THEN
601: hr_utility.set_message(800, 'HR_NL_INCORRECT_FREQUENCY');
602: hr_utility.raise_error;
603: END IF;
604:
605:

Line 602: hr_utility.raise_error;

598: IF (p_frequency = 'M' AND
599: (p_ind_working_hrs > fnd_number.canonical_to_number('744') OR
600: p_normal_hours > fnd_number.canonical_to_number('744'))) THEN
601: hr_utility.set_message(800, 'HR_NL_INCORRECT_FREQUENCY');
602: hr_utility.raise_error;
603: END IF;
604:
605:
606: IF (p_frequency = 'Y' AND

Line 609: hr_utility.set_message(800, 'HR_NL_INCORRECT_FREQUENCY');

605:
606: IF (p_frequency = 'Y' AND
607: (p_ind_working_hrs > fnd_number.canonical_to_number('8784') OR
608: p_normal_hours > fnd_number.canonical_to_number('8784'))) THEN
609: hr_utility.set_message(800, 'HR_NL_INCORRECT_FREQUENCY');
610: hr_utility.raise_error;
611: END IF;
612:
613: IF (p_ind_perc <> hr_api.g_number) THEN

Line 610: hr_utility.raise_error;

606: IF (p_frequency = 'Y' AND
607: (p_ind_working_hrs > fnd_number.canonical_to_number('8784') OR
608: p_normal_hours > fnd_number.canonical_to_number('8784'))) THEN
609: hr_utility.set_message(800, 'HR_NL_INCORRECT_FREQUENCY');
610: hr_utility.raise_error;
611: END IF;
612:
613: IF (p_ind_perc <> hr_api.g_number) THEN
614: IF (p_ind_perc < fnd_number.canonical_to_number('0.00') OR

Line 616: hr_utility.set_message(800, 'HR_NL_INVALID_PERCENT');

612:
613: IF (p_ind_perc <> hr_api.g_number) THEN
614: IF (p_ind_perc < fnd_number.canonical_to_number('0.00') OR
615: p_ind_perc > fnd_number.canonical_to_number('100.00')) THEN
616: hr_utility.set_message(800, 'HR_NL_INVALID_PERCENT');
617: hr_utility.raise_error;
618: END IF;
619: END IF;
620:

Line 617: hr_utility.raise_error;

613: IF (p_ind_perc <> hr_api.g_number) THEN
614: IF (p_ind_perc < fnd_number.canonical_to_number('0.00') OR
615: p_ind_perc > fnd_number.canonical_to_number('100.00')) THEN
616: hr_utility.set_message(800, 'HR_NL_INVALID_PERCENT');
617: hr_utility.raise_error;
618: END IF;
619: END IF;
620:
621: IF (p_percentage <> hr_api.g_number) THEN

Line 624: hr_utility.set_message(800, 'HR_NL_REALNUMBER_INVALID');

620:
621: IF (p_percentage <> hr_api.g_number) THEN
622: IF (p_percentage < fnd_number.canonical_to_number('0.00') OR
623: p_percentage > fnd_number.canonical_to_number('9999.9999')) THEN
624: hr_utility.set_message(800, 'HR_NL_REALNUMBER_INVALID');
625: hr_utility.set_message_token('MINIMUM', '0.00');
626: hr_utility.set_message_token('MAXIMUM', '9999.9999');
627: hr_utility.set_message_token('PRECISION', '4');
628: hr_utility.raise_error;

Line 625: hr_utility.set_message_token('MINIMUM', '0.00');

621: IF (p_percentage <> hr_api.g_number) THEN
622: IF (p_percentage < fnd_number.canonical_to_number('0.00') OR
623: p_percentage > fnd_number.canonical_to_number('9999.9999')) THEN
624: hr_utility.set_message(800, 'HR_NL_REALNUMBER_INVALID');
625: hr_utility.set_message_token('MINIMUM', '0.00');
626: hr_utility.set_message_token('MAXIMUM', '9999.9999');
627: hr_utility.set_message_token('PRECISION', '4');
628: hr_utility.raise_error;
629: END IF;

Line 626: hr_utility.set_message_token('MAXIMUM', '9999.9999');

622: IF (p_percentage < fnd_number.canonical_to_number('0.00') OR
623: p_percentage > fnd_number.canonical_to_number('9999.9999')) THEN
624: hr_utility.set_message(800, 'HR_NL_REALNUMBER_INVALID');
625: hr_utility.set_message_token('MINIMUM', '0.00');
626: hr_utility.set_message_token('MAXIMUM', '9999.9999');
627: hr_utility.set_message_token('PRECISION', '4');
628: hr_utility.raise_error;
629: END IF;
630: END IF;

Line 627: hr_utility.set_message_token('PRECISION', '4');

623: p_percentage > fnd_number.canonical_to_number('9999.9999')) THEN
624: hr_utility.set_message(800, 'HR_NL_REALNUMBER_INVALID');
625: hr_utility.set_message_token('MINIMUM', '0.00');
626: hr_utility.set_message_token('MAXIMUM', '9999.9999');
627: hr_utility.set_message_token('PRECISION', '4');
628: hr_utility.raise_error;
629: END IF;
630: END IF;
631: hr_utility.trace('Leaving other_validations');

Line 628: hr_utility.raise_error;

624: hr_utility.set_message(800, 'HR_NL_REALNUMBER_INVALID');
625: hr_utility.set_message_token('MINIMUM', '0.00');
626: hr_utility.set_message_token('MAXIMUM', '9999.9999');
627: hr_utility.set_message_token('PRECISION', '4');
628: hr_utility.raise_error;
629: END IF;
630: END IF;
631: hr_utility.trace('Leaving other_validations');
632:

Line 631: hr_utility.trace('Leaving other_validations');

627: hr_utility.set_message_token('PRECISION', '4');
628: hr_utility.raise_error;
629: END IF;
630: END IF;
631: hr_utility.trace('Leaving other_validations');
632:
633: --
634: END other_validations;
635:

Line 683: --hr_utility.trace('Entering validate_employer_change');

679: l_new_employer per_all_assignments_f.establishment_id%TYPE;
680: l_emp_chg_flag VARCHAR2(1);
681:
682: BEGIN
683: --hr_utility.trace('Entering validate_employer_change');
684:
685: OPEN csr_get_emp_chg_flag(p_business_group_id);
686: FETCH csr_get_emp_chg_flag into l_emp_chg_flag;
687: CLOSE csr_get_emp_chg_flag;

Line 693: --hr_utility.trace('New Employer '||l_new_employer);

689: IF nvl(l_emp_chg_flag,'Y') = 'N' THEN
690:
691: l_new_employer := p_establishment_id;
692:
693: --hr_utility.trace('New Employer '||l_new_employer);
694:
695: OPEN csr_asg_action_exists(p_assignment_id);
696: FETCH csr_asg_action_exists into l_asg_action_exists;
697: CLOSE csr_asg_action_exists;

Line 705: --hr_utility.trace('Old Employer '||l_asg_details.establishment_id);

701: OPEN csr_get_asg_details(p_assignment_id,p_effective_date);
702: FETCH csr_get_asg_details INTO l_asg_details;
703: CLOSE csr_get_asg_details;
704:
705: --hr_utility.trace('Old Employer '||l_asg_details.establishment_id);
706: --hr_utility.trace('Payroll Id '||l_asg_details.payroll_id);
707:
708: IF l_asg_details.establishment_id IS NULL AND l_asg_details.payroll_id IS NOT NULL THEN
709: OPEN csr_get_payroll_employer(l_asg_details.payroll_id,p_effective_date);

Line 706: --hr_utility.trace('Payroll Id '||l_asg_details.payroll_id);

702: FETCH csr_get_asg_details INTO l_asg_details;
703: CLOSE csr_get_asg_details;
704:
705: --hr_utility.trace('Old Employer '||l_asg_details.establishment_id);
706: --hr_utility.trace('Payroll Id '||l_asg_details.payroll_id);
707:
708: IF l_asg_details.establishment_id IS NULL AND l_asg_details.payroll_id IS NOT NULL THEN
709: OPEN csr_get_payroll_employer(l_asg_details.payroll_id,p_effective_date);
710: FETCH csr_get_payroll_employer INTO l_old_employer;

Line 715: --hr_utility.trace('Old Employer '||l_old_employer);

711: CLOSE csr_get_payroll_employer;
712: ELSE
713: l_old_employer := l_asg_details.establishment_id;
714: END IF;
715: --hr_utility.trace('Old Employer '||l_old_employer);
716: IF NVL(l_old_employer,0) = NVL(l_new_employer,0) THEN
717: RETURN TRUE;
718: ELSE
719: RETURN FALSE;

Line 724: --hr_utility.trace('Leaving validate_employer_change');

720: END IF;
721: END IF;
722: END IF;
723:
724: --hr_utility.trace('Leaving validate_employer_change');
725:
726: RETURN TRUE;
727:
728: EXCEPTION

Line 730: hr_utility.set_location('Error raised in validate_employer_change ',9);

726: RETURN TRUE;
727:
728: EXCEPTION
729: WHEN OTHERS THEN
730: hr_utility.set_location('Error raised in validate_employer_change ',9);
731: hr_utility.trace('Error in validate_employer_change : '||sqlerrm);
732: RETURN NULL;
733: END validate_employer_change;
734: --14084074

Line 731: hr_utility.trace('Error in validate_employer_change : '||sqlerrm);

727:
728: EXCEPTION
729: WHEN OTHERS THEN
730: hr_utility.set_location('Error raised in validate_employer_change ',9);
731: hr_utility.trace('Error in validate_employer_change : '||sqlerrm);
732: RETURN NULL;
733: END validate_employer_change;
734: --14084074
735:

Line 784: hr_utility.trace('Entering extra_assignment_checks');

780: l_ind_working_hrs number;
781:
782: BEGIN
783: --
784: hr_utility.trace('Entering extra_assignment_checks');
785: --
786: -- Added for GSI Bug 5472781
787: --
788: IF hr_utility.chk_product_install('Oracle Human Resources', 'NL') THEN

Line 788: IF hr_utility.chk_product_install('Oracle Human Resources', 'NL') THEN

784: hr_utility.trace('Entering extra_assignment_checks');
785: --
786: -- Added for GSI Bug 5472781
787: --
788: IF hr_utility.chk_product_install('Oracle Human Resources', 'NL') THEN
789: --
790: /*
791: hr_utility.trace('p_normal_hours '||p_normal_hours );
792: hr_utility.trace('p_frequency '||p_frequency );

Line 791: hr_utility.trace('p_normal_hours '||p_normal_hours );

787: --
788: IF hr_utility.chk_product_install('Oracle Human Resources', 'NL') THEN
789: --
790: /*
791: hr_utility.trace('p_normal_hours '||p_normal_hours );
792: hr_utility.trace('p_frequency '||p_frequency );
793: hr_utility.trace('p_payroll_id '||p_payroll_id );
794: hr_utility.trace('p_scl_segment1 '||p_scl_segment1 );
795: hr_utility.trace('p_scl_segment2 '||p_scl_segment2 );

Line 792: hr_utility.trace('p_frequency '||p_frequency );

788: IF hr_utility.chk_product_install('Oracle Human Resources', 'NL') THEN
789: --
790: /*
791: hr_utility.trace('p_normal_hours '||p_normal_hours );
792: hr_utility.trace('p_frequency '||p_frequency );
793: hr_utility.trace('p_payroll_id '||p_payroll_id );
794: hr_utility.trace('p_scl_segment1 '||p_scl_segment1 );
795: hr_utility.trace('p_scl_segment2 '||p_scl_segment2 );
796: hr_utility.trace('p_scl_segment3 '||p_scl_segment3 );

Line 793: hr_utility.trace('p_payroll_id '||p_payroll_id );

789: --
790: /*
791: hr_utility.trace('p_normal_hours '||p_normal_hours );
792: hr_utility.trace('p_frequency '||p_frequency );
793: hr_utility.trace('p_payroll_id '||p_payroll_id );
794: hr_utility.trace('p_scl_segment1 '||p_scl_segment1 );
795: hr_utility.trace('p_scl_segment2 '||p_scl_segment2 );
796: hr_utility.trace('p_scl_segment3 '||p_scl_segment3 );
797: hr_utility.trace('p_scl_segment4 '||p_scl_segment4 );

Line 794: hr_utility.trace('p_scl_segment1 '||p_scl_segment1 );

790: /*
791: hr_utility.trace('p_normal_hours '||p_normal_hours );
792: hr_utility.trace('p_frequency '||p_frequency );
793: hr_utility.trace('p_payroll_id '||p_payroll_id );
794: hr_utility.trace('p_scl_segment1 '||p_scl_segment1 );
795: hr_utility.trace('p_scl_segment2 '||p_scl_segment2 );
796: hr_utility.trace('p_scl_segment3 '||p_scl_segment3 );
797: hr_utility.trace('p_scl_segment4 '||p_scl_segment4 );
798: hr_utility.trace('p_scl_segment5 '||p_scl_segment5 );

Line 795: hr_utility.trace('p_scl_segment2 '||p_scl_segment2 );

791: hr_utility.trace('p_normal_hours '||p_normal_hours );
792: hr_utility.trace('p_frequency '||p_frequency );
793: hr_utility.trace('p_payroll_id '||p_payroll_id );
794: hr_utility.trace('p_scl_segment1 '||p_scl_segment1 );
795: hr_utility.trace('p_scl_segment2 '||p_scl_segment2 );
796: hr_utility.trace('p_scl_segment3 '||p_scl_segment3 );
797: hr_utility.trace('p_scl_segment4 '||p_scl_segment4 );
798: hr_utility.trace('p_scl_segment5 '||p_scl_segment5 );
799: hr_utility.trace('p_scl_segment6 '||p_scl_segment6 );

Line 796: hr_utility.trace('p_scl_segment3 '||p_scl_segment3 );

792: hr_utility.trace('p_frequency '||p_frequency );
793: hr_utility.trace('p_payroll_id '||p_payroll_id );
794: hr_utility.trace('p_scl_segment1 '||p_scl_segment1 );
795: hr_utility.trace('p_scl_segment2 '||p_scl_segment2 );
796: hr_utility.trace('p_scl_segment3 '||p_scl_segment3 );
797: hr_utility.trace('p_scl_segment4 '||p_scl_segment4 );
798: hr_utility.trace('p_scl_segment5 '||p_scl_segment5 );
799: hr_utility.trace('p_scl_segment6 '||p_scl_segment6 );
800: hr_utility.trace('p_scl_segment7 '||p_scl_segment7 );

Line 797: hr_utility.trace('p_scl_segment4 '||p_scl_segment4 );

793: hr_utility.trace('p_payroll_id '||p_payroll_id );
794: hr_utility.trace('p_scl_segment1 '||p_scl_segment1 );
795: hr_utility.trace('p_scl_segment2 '||p_scl_segment2 );
796: hr_utility.trace('p_scl_segment3 '||p_scl_segment3 );
797: hr_utility.trace('p_scl_segment4 '||p_scl_segment4 );
798: hr_utility.trace('p_scl_segment5 '||p_scl_segment5 );
799: hr_utility.trace('p_scl_segment6 '||p_scl_segment6 );
800: hr_utility.trace('p_scl_segment7 '||p_scl_segment7 );
801: hr_utility.trace('p_scl_segment8 '||p_scl_segment8 );

Line 798: hr_utility.trace('p_scl_segment5 '||p_scl_segment5 );

794: hr_utility.trace('p_scl_segment1 '||p_scl_segment1 );
795: hr_utility.trace('p_scl_segment2 '||p_scl_segment2 );
796: hr_utility.trace('p_scl_segment3 '||p_scl_segment3 );
797: hr_utility.trace('p_scl_segment4 '||p_scl_segment4 );
798: hr_utility.trace('p_scl_segment5 '||p_scl_segment5 );
799: hr_utility.trace('p_scl_segment6 '||p_scl_segment6 );
800: hr_utility.trace('p_scl_segment7 '||p_scl_segment7 );
801: hr_utility.trace('p_scl_segment8 '||p_scl_segment8 );
802: hr_utility.trace('p_scl_segment9 '||p_scl_segment9 );

Line 799: hr_utility.trace('p_scl_segment6 '||p_scl_segment6 );

795: hr_utility.trace('p_scl_segment2 '||p_scl_segment2 );
796: hr_utility.trace('p_scl_segment3 '||p_scl_segment3 );
797: hr_utility.trace('p_scl_segment4 '||p_scl_segment4 );
798: hr_utility.trace('p_scl_segment5 '||p_scl_segment5 );
799: hr_utility.trace('p_scl_segment6 '||p_scl_segment6 );
800: hr_utility.trace('p_scl_segment7 '||p_scl_segment7 );
801: hr_utility.trace('p_scl_segment8 '||p_scl_segment8 );
802: hr_utility.trace('p_scl_segment9 '||p_scl_segment9 );
803: hr_utility.trace('p_scl_segment10 '||p_scl_segment10 );

Line 800: hr_utility.trace('p_scl_segment7 '||p_scl_segment7 );

796: hr_utility.trace('p_scl_segment3 '||p_scl_segment3 );
797: hr_utility.trace('p_scl_segment4 '||p_scl_segment4 );
798: hr_utility.trace('p_scl_segment5 '||p_scl_segment5 );
799: hr_utility.trace('p_scl_segment6 '||p_scl_segment6 );
800: hr_utility.trace('p_scl_segment7 '||p_scl_segment7 );
801: hr_utility.trace('p_scl_segment8 '||p_scl_segment8 );
802: hr_utility.trace('p_scl_segment9 '||p_scl_segment9 );
803: hr_utility.trace('p_scl_segment10 '||p_scl_segment10 );
804: hr_utility.trace('p_scl_segment11 '||p_scl_segment11 );

Line 801: hr_utility.trace('p_scl_segment8 '||p_scl_segment8 );

797: hr_utility.trace('p_scl_segment4 '||p_scl_segment4 );
798: hr_utility.trace('p_scl_segment5 '||p_scl_segment5 );
799: hr_utility.trace('p_scl_segment6 '||p_scl_segment6 );
800: hr_utility.trace('p_scl_segment7 '||p_scl_segment7 );
801: hr_utility.trace('p_scl_segment8 '||p_scl_segment8 );
802: hr_utility.trace('p_scl_segment9 '||p_scl_segment9 );
803: hr_utility.trace('p_scl_segment10 '||p_scl_segment10 );
804: hr_utility.trace('p_scl_segment11 '||p_scl_segment11 );
805: hr_utility.trace('p_scl_segment12 '||p_scl_segment12 );

Line 802: hr_utility.trace('p_scl_segment9 '||p_scl_segment9 );

798: hr_utility.trace('p_scl_segment5 '||p_scl_segment5 );
799: hr_utility.trace('p_scl_segment6 '||p_scl_segment6 );
800: hr_utility.trace('p_scl_segment7 '||p_scl_segment7 );
801: hr_utility.trace('p_scl_segment8 '||p_scl_segment8 );
802: hr_utility.trace('p_scl_segment9 '||p_scl_segment9 );
803: hr_utility.trace('p_scl_segment10 '||p_scl_segment10 );
804: hr_utility.trace('p_scl_segment11 '||p_scl_segment11 );
805: hr_utility.trace('p_scl_segment12 '||p_scl_segment12 );
806: hr_utility.trace('p_scl_segment13 '||p_scl_segment13 );

Line 803: hr_utility.trace('p_scl_segment10 '||p_scl_segment10 );

799: hr_utility.trace('p_scl_segment6 '||p_scl_segment6 );
800: hr_utility.trace('p_scl_segment7 '||p_scl_segment7 );
801: hr_utility.trace('p_scl_segment8 '||p_scl_segment8 );
802: hr_utility.trace('p_scl_segment9 '||p_scl_segment9 );
803: hr_utility.trace('p_scl_segment10 '||p_scl_segment10 );
804: hr_utility.trace('p_scl_segment11 '||p_scl_segment11 );
805: hr_utility.trace('p_scl_segment12 '||p_scl_segment12 );
806: hr_utility.trace('p_scl_segment13 '||p_scl_segment13 );
807: hr_utility.trace('p_scl_segment14 '||p_scl_segment14 );

Line 804: hr_utility.trace('p_scl_segment11 '||p_scl_segment11 );

800: hr_utility.trace('p_scl_segment7 '||p_scl_segment7 );
801: hr_utility.trace('p_scl_segment8 '||p_scl_segment8 );
802: hr_utility.trace('p_scl_segment9 '||p_scl_segment9 );
803: hr_utility.trace('p_scl_segment10 '||p_scl_segment10 );
804: hr_utility.trace('p_scl_segment11 '||p_scl_segment11 );
805: hr_utility.trace('p_scl_segment12 '||p_scl_segment12 );
806: hr_utility.trace('p_scl_segment13 '||p_scl_segment13 );
807: hr_utility.trace('p_scl_segment14 '||p_scl_segment14 );
808: hr_utility.trace('p_scl_segment15 '||p_scl_segment15 );

Line 805: hr_utility.trace('p_scl_segment12 '||p_scl_segment12 );

801: hr_utility.trace('p_scl_segment8 '||p_scl_segment8 );
802: hr_utility.trace('p_scl_segment9 '||p_scl_segment9 );
803: hr_utility.trace('p_scl_segment10 '||p_scl_segment10 );
804: hr_utility.trace('p_scl_segment11 '||p_scl_segment11 );
805: hr_utility.trace('p_scl_segment12 '||p_scl_segment12 );
806: hr_utility.trace('p_scl_segment13 '||p_scl_segment13 );
807: hr_utility.trace('p_scl_segment14 '||p_scl_segment14 );
808: hr_utility.trace('p_scl_segment15 '||p_scl_segment15 );
809: hr_utility.trace('p_scl_segment16 '||p_scl_segment16 );

Line 806: hr_utility.trace('p_scl_segment13 '||p_scl_segment13 );

802: hr_utility.trace('p_scl_segment9 '||p_scl_segment9 );
803: hr_utility.trace('p_scl_segment10 '||p_scl_segment10 );
804: hr_utility.trace('p_scl_segment11 '||p_scl_segment11 );
805: hr_utility.trace('p_scl_segment12 '||p_scl_segment12 );
806: hr_utility.trace('p_scl_segment13 '||p_scl_segment13 );
807: hr_utility.trace('p_scl_segment14 '||p_scl_segment14 );
808: hr_utility.trace('p_scl_segment15 '||p_scl_segment15 );
809: hr_utility.trace('p_scl_segment16 '||p_scl_segment16 );
810: hr_utility.trace('p_scl_segment17 '||p_scl_segment17 );

Line 807: hr_utility.trace('p_scl_segment14 '||p_scl_segment14 );

803: hr_utility.trace('p_scl_segment10 '||p_scl_segment10 );
804: hr_utility.trace('p_scl_segment11 '||p_scl_segment11 );
805: hr_utility.trace('p_scl_segment12 '||p_scl_segment12 );
806: hr_utility.trace('p_scl_segment13 '||p_scl_segment13 );
807: hr_utility.trace('p_scl_segment14 '||p_scl_segment14 );
808: hr_utility.trace('p_scl_segment15 '||p_scl_segment15 );
809: hr_utility.trace('p_scl_segment16 '||p_scl_segment16 );
810: hr_utility.trace('p_scl_segment17 '||p_scl_segment17 );
811: hr_utility.trace('p_scl_segment18 '||p_scl_segment18 );

Line 808: hr_utility.trace('p_scl_segment15 '||p_scl_segment15 );

804: hr_utility.trace('p_scl_segment11 '||p_scl_segment11 );
805: hr_utility.trace('p_scl_segment12 '||p_scl_segment12 );
806: hr_utility.trace('p_scl_segment13 '||p_scl_segment13 );
807: hr_utility.trace('p_scl_segment14 '||p_scl_segment14 );
808: hr_utility.trace('p_scl_segment15 '||p_scl_segment15 );
809: hr_utility.trace('p_scl_segment16 '||p_scl_segment16 );
810: hr_utility.trace('p_scl_segment17 '||p_scl_segment17 );
811: hr_utility.trace('p_scl_segment18 '||p_scl_segment18 );
812: hr_utility.trace('p_scl_segment19 '||p_scl_segment19 );

Line 809: hr_utility.trace('p_scl_segment16 '||p_scl_segment16 );

805: hr_utility.trace('p_scl_segment12 '||p_scl_segment12 );
806: hr_utility.trace('p_scl_segment13 '||p_scl_segment13 );
807: hr_utility.trace('p_scl_segment14 '||p_scl_segment14 );
808: hr_utility.trace('p_scl_segment15 '||p_scl_segment15 );
809: hr_utility.trace('p_scl_segment16 '||p_scl_segment16 );
810: hr_utility.trace('p_scl_segment17 '||p_scl_segment17 );
811: hr_utility.trace('p_scl_segment18 '||p_scl_segment18 );
812: hr_utility.trace('p_scl_segment19 '||p_scl_segment19 );
813: hr_utility.trace('p_scl_segment20 '||p_scl_segment20 );

Line 810: hr_utility.trace('p_scl_segment17 '||p_scl_segment17 );

806: hr_utility.trace('p_scl_segment13 '||p_scl_segment13 );
807: hr_utility.trace('p_scl_segment14 '||p_scl_segment14 );
808: hr_utility.trace('p_scl_segment15 '||p_scl_segment15 );
809: hr_utility.trace('p_scl_segment16 '||p_scl_segment16 );
810: hr_utility.trace('p_scl_segment17 '||p_scl_segment17 );
811: hr_utility.trace('p_scl_segment18 '||p_scl_segment18 );
812: hr_utility.trace('p_scl_segment19 '||p_scl_segment19 );
813: hr_utility.trace('p_scl_segment20 '||p_scl_segment20 );
814: hr_utility.trace('p_scl_segment21 '||p_scl_segment21 );

Line 811: hr_utility.trace('p_scl_segment18 '||p_scl_segment18 );

807: hr_utility.trace('p_scl_segment14 '||p_scl_segment14 );
808: hr_utility.trace('p_scl_segment15 '||p_scl_segment15 );
809: hr_utility.trace('p_scl_segment16 '||p_scl_segment16 );
810: hr_utility.trace('p_scl_segment17 '||p_scl_segment17 );
811: hr_utility.trace('p_scl_segment18 '||p_scl_segment18 );
812: hr_utility.trace('p_scl_segment19 '||p_scl_segment19 );
813: hr_utility.trace('p_scl_segment20 '||p_scl_segment20 );
814: hr_utility.trace('p_scl_segment21 '||p_scl_segment21 );
815: hr_utility.trace('p_scl_segment22 '||p_scl_segment22 );

Line 812: hr_utility.trace('p_scl_segment19 '||p_scl_segment19 );

808: hr_utility.trace('p_scl_segment15 '||p_scl_segment15 );
809: hr_utility.trace('p_scl_segment16 '||p_scl_segment16 );
810: hr_utility.trace('p_scl_segment17 '||p_scl_segment17 );
811: hr_utility.trace('p_scl_segment18 '||p_scl_segment18 );
812: hr_utility.trace('p_scl_segment19 '||p_scl_segment19 );
813: hr_utility.trace('p_scl_segment20 '||p_scl_segment20 );
814: hr_utility.trace('p_scl_segment21 '||p_scl_segment21 );
815: hr_utility.trace('p_scl_segment22 '||p_scl_segment22 );
816: hr_utility.trace('p_scl_segment23 '||p_scl_segment23 );

Line 813: hr_utility.trace('p_scl_segment20 '||p_scl_segment20 );

809: hr_utility.trace('p_scl_segment16 '||p_scl_segment16 );
810: hr_utility.trace('p_scl_segment17 '||p_scl_segment17 );
811: hr_utility.trace('p_scl_segment18 '||p_scl_segment18 );
812: hr_utility.trace('p_scl_segment19 '||p_scl_segment19 );
813: hr_utility.trace('p_scl_segment20 '||p_scl_segment20 );
814: hr_utility.trace('p_scl_segment21 '||p_scl_segment21 );
815: hr_utility.trace('p_scl_segment22 '||p_scl_segment22 );
816: hr_utility.trace('p_scl_segment23 '||p_scl_segment23 );
817: hr_utility.trace('p_scl_segment24 '||p_scl_segment24 );

Line 814: hr_utility.trace('p_scl_segment21 '||p_scl_segment21 );

810: hr_utility.trace('p_scl_segment17 '||p_scl_segment17 );
811: hr_utility.trace('p_scl_segment18 '||p_scl_segment18 );
812: hr_utility.trace('p_scl_segment19 '||p_scl_segment19 );
813: hr_utility.trace('p_scl_segment20 '||p_scl_segment20 );
814: hr_utility.trace('p_scl_segment21 '||p_scl_segment21 );
815: hr_utility.trace('p_scl_segment22 '||p_scl_segment22 );
816: hr_utility.trace('p_scl_segment23 '||p_scl_segment23 );
817: hr_utility.trace('p_scl_segment24 '||p_scl_segment24 );
818: hr_utility.trace('p_scl_segment25 '||p_scl_segment25 );

Line 815: hr_utility.trace('p_scl_segment22 '||p_scl_segment22 );

811: hr_utility.trace('p_scl_segment18 '||p_scl_segment18 );
812: hr_utility.trace('p_scl_segment19 '||p_scl_segment19 );
813: hr_utility.trace('p_scl_segment20 '||p_scl_segment20 );
814: hr_utility.trace('p_scl_segment21 '||p_scl_segment21 );
815: hr_utility.trace('p_scl_segment22 '||p_scl_segment22 );
816: hr_utility.trace('p_scl_segment23 '||p_scl_segment23 );
817: hr_utility.trace('p_scl_segment24 '||p_scl_segment24 );
818: hr_utility.trace('p_scl_segment25 '||p_scl_segment25 );
819: hr_utility.trace('p_scl_segment26 '||p_scl_segment26 );

Line 816: hr_utility.trace('p_scl_segment23 '||p_scl_segment23 );

812: hr_utility.trace('p_scl_segment19 '||p_scl_segment19 );
813: hr_utility.trace('p_scl_segment20 '||p_scl_segment20 );
814: hr_utility.trace('p_scl_segment21 '||p_scl_segment21 );
815: hr_utility.trace('p_scl_segment22 '||p_scl_segment22 );
816: hr_utility.trace('p_scl_segment23 '||p_scl_segment23 );
817: hr_utility.trace('p_scl_segment24 '||p_scl_segment24 );
818: hr_utility.trace('p_scl_segment25 '||p_scl_segment25 );
819: hr_utility.trace('p_scl_segment26 '||p_scl_segment26 );
820: hr_utility.trace('p_scl_segment27 '||p_scl_segment27 );

Line 817: hr_utility.trace('p_scl_segment24 '||p_scl_segment24 );

813: hr_utility.trace('p_scl_segment20 '||p_scl_segment20 );
814: hr_utility.trace('p_scl_segment21 '||p_scl_segment21 );
815: hr_utility.trace('p_scl_segment22 '||p_scl_segment22 );
816: hr_utility.trace('p_scl_segment23 '||p_scl_segment23 );
817: hr_utility.trace('p_scl_segment24 '||p_scl_segment24 );
818: hr_utility.trace('p_scl_segment25 '||p_scl_segment25 );
819: hr_utility.trace('p_scl_segment26 '||p_scl_segment26 );
820: hr_utility.trace('p_scl_segment27 '||p_scl_segment27 );
821: hr_utility.trace('p_scl_segment28 '||p_scl_segment28 );

Line 818: hr_utility.trace('p_scl_segment25 '||p_scl_segment25 );

814: hr_utility.trace('p_scl_segment21 '||p_scl_segment21 );
815: hr_utility.trace('p_scl_segment22 '||p_scl_segment22 );
816: hr_utility.trace('p_scl_segment23 '||p_scl_segment23 );
817: hr_utility.trace('p_scl_segment24 '||p_scl_segment24 );
818: hr_utility.trace('p_scl_segment25 '||p_scl_segment25 );
819: hr_utility.trace('p_scl_segment26 '||p_scl_segment26 );
820: hr_utility.trace('p_scl_segment27 '||p_scl_segment27 );
821: hr_utility.trace('p_scl_segment28 '||p_scl_segment28 );
822: hr_utility.trace('p_scl_segment29 '||p_scl_segment29 );

Line 819: hr_utility.trace('p_scl_segment26 '||p_scl_segment26 );

815: hr_utility.trace('p_scl_segment22 '||p_scl_segment22 );
816: hr_utility.trace('p_scl_segment23 '||p_scl_segment23 );
817: hr_utility.trace('p_scl_segment24 '||p_scl_segment24 );
818: hr_utility.trace('p_scl_segment25 '||p_scl_segment25 );
819: hr_utility.trace('p_scl_segment26 '||p_scl_segment26 );
820: hr_utility.trace('p_scl_segment27 '||p_scl_segment27 );
821: hr_utility.trace('p_scl_segment28 '||p_scl_segment28 );
822: hr_utility.trace('p_scl_segment29 '||p_scl_segment29 );
823: hr_utility.trace('p_scl_segment30 '||p_scl_segment30 );

Line 820: hr_utility.trace('p_scl_segment27 '||p_scl_segment27 );

816: hr_utility.trace('p_scl_segment23 '||p_scl_segment23 );
817: hr_utility.trace('p_scl_segment24 '||p_scl_segment24 );
818: hr_utility.trace('p_scl_segment25 '||p_scl_segment25 );
819: hr_utility.trace('p_scl_segment26 '||p_scl_segment26 );
820: hr_utility.trace('p_scl_segment27 '||p_scl_segment27 );
821: hr_utility.trace('p_scl_segment28 '||p_scl_segment28 );
822: hr_utility.trace('p_scl_segment29 '||p_scl_segment29 );
823: hr_utility.trace('p_scl_segment30 '||p_scl_segment30 );
824: */

Line 821: hr_utility.trace('p_scl_segment28 '||p_scl_segment28 );

817: hr_utility.trace('p_scl_segment24 '||p_scl_segment24 );
818: hr_utility.trace('p_scl_segment25 '||p_scl_segment25 );
819: hr_utility.trace('p_scl_segment26 '||p_scl_segment26 );
820: hr_utility.trace('p_scl_segment27 '||p_scl_segment27 );
821: hr_utility.trace('p_scl_segment28 '||p_scl_segment28 );
822: hr_utility.trace('p_scl_segment29 '||p_scl_segment29 );
823: hr_utility.trace('p_scl_segment30 '||p_scl_segment30 );
824: */
825: l_frequency:=p_frequency;

Line 822: hr_utility.trace('p_scl_segment29 '||p_scl_segment29 );

818: hr_utility.trace('p_scl_segment25 '||p_scl_segment25 );
819: hr_utility.trace('p_scl_segment26 '||p_scl_segment26 );
820: hr_utility.trace('p_scl_segment27 '||p_scl_segment27 );
821: hr_utility.trace('p_scl_segment28 '||p_scl_segment28 );
822: hr_utility.trace('p_scl_segment29 '||p_scl_segment29 );
823: hr_utility.trace('p_scl_segment30 '||p_scl_segment30 );
824: */
825: l_frequency:=p_frequency;
826:

Line 823: hr_utility.trace('p_scl_segment30 '||p_scl_segment30 );

819: hr_utility.trace('p_scl_segment26 '||p_scl_segment26 );
820: hr_utility.trace('p_scl_segment27 '||p_scl_segment27 );
821: hr_utility.trace('p_scl_segment28 '||p_scl_segment28 );
822: hr_utility.trace('p_scl_segment29 '||p_scl_segment29 );
823: hr_utility.trace('p_scl_segment30 '||p_scl_segment30 );
824: */
825: l_frequency:=p_frequency;
826:
827: IF p_scl_segment28 IS NULL then

Line 886: hr_utility.trace('Leaving extra_assignment_checks');

882: ,l_percentage ,l_frequency ,p_normal_hours);
883: --
884: END IF;
885: --
886: hr_utility.trace('Leaving extra_assignment_checks');
887: --
888: END extra_assignment_checks;
889:
890:

Line 968: hr_utility.trace('Entering extra_assignment_checks1');

964: l_ind_working_hrs number;
965:
966: BEGIN
967: --
968: hr_utility.trace('Entering extra_assignment_checks1');
969: --
970: -- Added for GSI Bug 5472781
971: --
972: IF hr_utility.chk_product_install('Oracle Human Resources', 'NL') THEN

Line 972: IF hr_utility.chk_product_install('Oracle Human Resources', 'NL') THEN

968: hr_utility.trace('Entering extra_assignment_checks1');
969: --
970: -- Added for GSI Bug 5472781
971: --
972: IF hr_utility.chk_product_install('Oracle Human Resources', 'NL') THEN
973: --
974: /*
975: hr_utility.trace('p_normal_hours '||p_normal_hours );
976: hr_utility.trace('p_frequency '||p_frequency );

Line 975: hr_utility.trace('p_normal_hours '||p_normal_hours );

971: --
972: IF hr_utility.chk_product_install('Oracle Human Resources', 'NL') THEN
973: --
974: /*
975: hr_utility.trace('p_normal_hours '||p_normal_hours );
976: hr_utility.trace('p_frequency '||p_frequency );
977: hr_utility.trace('p_segment1 '||p_segment1 );
978: hr_utility.trace('p_segment2 '||p_segment2 );
979: hr_utility.trace('p_segment3 '||p_segment3 );

Line 976: hr_utility.trace('p_frequency '||p_frequency );

972: IF hr_utility.chk_product_install('Oracle Human Resources', 'NL') THEN
973: --
974: /*
975: hr_utility.trace('p_normal_hours '||p_normal_hours );
976: hr_utility.trace('p_frequency '||p_frequency );
977: hr_utility.trace('p_segment1 '||p_segment1 );
978: hr_utility.trace('p_segment2 '||p_segment2 );
979: hr_utility.trace('p_segment3 '||p_segment3 );
980: hr_utility.trace('p_segment4 '||p_segment4 );

Line 977: hr_utility.trace('p_segment1 '||p_segment1 );

973: --
974: /*
975: hr_utility.trace('p_normal_hours '||p_normal_hours );
976: hr_utility.trace('p_frequency '||p_frequency );
977: hr_utility.trace('p_segment1 '||p_segment1 );
978: hr_utility.trace('p_segment2 '||p_segment2 );
979: hr_utility.trace('p_segment3 '||p_segment3 );
980: hr_utility.trace('p_segment4 '||p_segment4 );
981: hr_utility.trace('p_segment5 '||p_segment5 );

Line 978: hr_utility.trace('p_segment2 '||p_segment2 );

974: /*
975: hr_utility.trace('p_normal_hours '||p_normal_hours );
976: hr_utility.trace('p_frequency '||p_frequency );
977: hr_utility.trace('p_segment1 '||p_segment1 );
978: hr_utility.trace('p_segment2 '||p_segment2 );
979: hr_utility.trace('p_segment3 '||p_segment3 );
980: hr_utility.trace('p_segment4 '||p_segment4 );
981: hr_utility.trace('p_segment5 '||p_segment5 );
982: hr_utility.trace('p_segment6 '||p_segment6 );

Line 979: hr_utility.trace('p_segment3 '||p_segment3 );

975: hr_utility.trace('p_normal_hours '||p_normal_hours );
976: hr_utility.trace('p_frequency '||p_frequency );
977: hr_utility.trace('p_segment1 '||p_segment1 );
978: hr_utility.trace('p_segment2 '||p_segment2 );
979: hr_utility.trace('p_segment3 '||p_segment3 );
980: hr_utility.trace('p_segment4 '||p_segment4 );
981: hr_utility.trace('p_segment5 '||p_segment5 );
982: hr_utility.trace('p_segment6 '||p_segment6 );
983: hr_utility.trace('p_segment7 '||p_segment7 );

Line 980: hr_utility.trace('p_segment4 '||p_segment4 );

976: hr_utility.trace('p_frequency '||p_frequency );
977: hr_utility.trace('p_segment1 '||p_segment1 );
978: hr_utility.trace('p_segment2 '||p_segment2 );
979: hr_utility.trace('p_segment3 '||p_segment3 );
980: hr_utility.trace('p_segment4 '||p_segment4 );
981: hr_utility.trace('p_segment5 '||p_segment5 );
982: hr_utility.trace('p_segment6 '||p_segment6 );
983: hr_utility.trace('p_segment7 '||p_segment7 );
984: hr_utility.trace('p_segment8 '||p_segment8 );

Line 981: hr_utility.trace('p_segment5 '||p_segment5 );

977: hr_utility.trace('p_segment1 '||p_segment1 );
978: hr_utility.trace('p_segment2 '||p_segment2 );
979: hr_utility.trace('p_segment3 '||p_segment3 );
980: hr_utility.trace('p_segment4 '||p_segment4 );
981: hr_utility.trace('p_segment5 '||p_segment5 );
982: hr_utility.trace('p_segment6 '||p_segment6 );
983: hr_utility.trace('p_segment7 '||p_segment7 );
984: hr_utility.trace('p_segment8 '||p_segment8 );
985: hr_utility.trace('p_segment9 '||p_segment9 );

Line 982: hr_utility.trace('p_segment6 '||p_segment6 );

978: hr_utility.trace('p_segment2 '||p_segment2 );
979: hr_utility.trace('p_segment3 '||p_segment3 );
980: hr_utility.trace('p_segment4 '||p_segment4 );
981: hr_utility.trace('p_segment5 '||p_segment5 );
982: hr_utility.trace('p_segment6 '||p_segment6 );
983: hr_utility.trace('p_segment7 '||p_segment7 );
984: hr_utility.trace('p_segment8 '||p_segment8 );
985: hr_utility.trace('p_segment9 '||p_segment9 );
986: hr_utility.trace('p_segment10 '||p_segment10 );

Line 983: hr_utility.trace('p_segment7 '||p_segment7 );

979: hr_utility.trace('p_segment3 '||p_segment3 );
980: hr_utility.trace('p_segment4 '||p_segment4 );
981: hr_utility.trace('p_segment5 '||p_segment5 );
982: hr_utility.trace('p_segment6 '||p_segment6 );
983: hr_utility.trace('p_segment7 '||p_segment7 );
984: hr_utility.trace('p_segment8 '||p_segment8 );
985: hr_utility.trace('p_segment9 '||p_segment9 );
986: hr_utility.trace('p_segment10 '||p_segment10 );
987: hr_utility.trace('p_segment11 '||p_segment11 );

Line 984: hr_utility.trace('p_segment8 '||p_segment8 );

980: hr_utility.trace('p_segment4 '||p_segment4 );
981: hr_utility.trace('p_segment5 '||p_segment5 );
982: hr_utility.trace('p_segment6 '||p_segment6 );
983: hr_utility.trace('p_segment7 '||p_segment7 );
984: hr_utility.trace('p_segment8 '||p_segment8 );
985: hr_utility.trace('p_segment9 '||p_segment9 );
986: hr_utility.trace('p_segment10 '||p_segment10 );
987: hr_utility.trace('p_segment11 '||p_segment11 );
988: hr_utility.trace('p_segment12 '||p_segment12 );

Line 985: hr_utility.trace('p_segment9 '||p_segment9 );

981: hr_utility.trace('p_segment5 '||p_segment5 );
982: hr_utility.trace('p_segment6 '||p_segment6 );
983: hr_utility.trace('p_segment7 '||p_segment7 );
984: hr_utility.trace('p_segment8 '||p_segment8 );
985: hr_utility.trace('p_segment9 '||p_segment9 );
986: hr_utility.trace('p_segment10 '||p_segment10 );
987: hr_utility.trace('p_segment11 '||p_segment11 );
988: hr_utility.trace('p_segment12 '||p_segment12 );
989: hr_utility.trace('p_segment13 '||p_segment13 );

Line 986: hr_utility.trace('p_segment10 '||p_segment10 );

982: hr_utility.trace('p_segment6 '||p_segment6 );
983: hr_utility.trace('p_segment7 '||p_segment7 );
984: hr_utility.trace('p_segment8 '||p_segment8 );
985: hr_utility.trace('p_segment9 '||p_segment9 );
986: hr_utility.trace('p_segment10 '||p_segment10 );
987: hr_utility.trace('p_segment11 '||p_segment11 );
988: hr_utility.trace('p_segment12 '||p_segment12 );
989: hr_utility.trace('p_segment13 '||p_segment13 );
990: hr_utility.trace('p_segment14 '||p_segment14 );

Line 987: hr_utility.trace('p_segment11 '||p_segment11 );

983: hr_utility.trace('p_segment7 '||p_segment7 );
984: hr_utility.trace('p_segment8 '||p_segment8 );
985: hr_utility.trace('p_segment9 '||p_segment9 );
986: hr_utility.trace('p_segment10 '||p_segment10 );
987: hr_utility.trace('p_segment11 '||p_segment11 );
988: hr_utility.trace('p_segment12 '||p_segment12 );
989: hr_utility.trace('p_segment13 '||p_segment13 );
990: hr_utility.trace('p_segment14 '||p_segment14 );
991: hr_utility.trace('p_segment15 '||p_segment15 );

Line 988: hr_utility.trace('p_segment12 '||p_segment12 );

984: hr_utility.trace('p_segment8 '||p_segment8 );
985: hr_utility.trace('p_segment9 '||p_segment9 );
986: hr_utility.trace('p_segment10 '||p_segment10 );
987: hr_utility.trace('p_segment11 '||p_segment11 );
988: hr_utility.trace('p_segment12 '||p_segment12 );
989: hr_utility.trace('p_segment13 '||p_segment13 );
990: hr_utility.trace('p_segment14 '||p_segment14 );
991: hr_utility.trace('p_segment15 '||p_segment15 );
992: hr_utility.trace('p_segment16 '||p_segment16 );

Line 989: hr_utility.trace('p_segment13 '||p_segment13 );

985: hr_utility.trace('p_segment9 '||p_segment9 );
986: hr_utility.trace('p_segment10 '||p_segment10 );
987: hr_utility.trace('p_segment11 '||p_segment11 );
988: hr_utility.trace('p_segment12 '||p_segment12 );
989: hr_utility.trace('p_segment13 '||p_segment13 );
990: hr_utility.trace('p_segment14 '||p_segment14 );
991: hr_utility.trace('p_segment15 '||p_segment15 );
992: hr_utility.trace('p_segment16 '||p_segment16 );
993: hr_utility.trace('p_segment17 '||p_segment17 );

Line 990: hr_utility.trace('p_segment14 '||p_segment14 );

986: hr_utility.trace('p_segment10 '||p_segment10 );
987: hr_utility.trace('p_segment11 '||p_segment11 );
988: hr_utility.trace('p_segment12 '||p_segment12 );
989: hr_utility.trace('p_segment13 '||p_segment13 );
990: hr_utility.trace('p_segment14 '||p_segment14 );
991: hr_utility.trace('p_segment15 '||p_segment15 );
992: hr_utility.trace('p_segment16 '||p_segment16 );
993: hr_utility.trace('p_segment17 '||p_segment17 );
994: hr_utility.trace('p_segment18 '||p_segment18 );

Line 991: hr_utility.trace('p_segment15 '||p_segment15 );

987: hr_utility.trace('p_segment11 '||p_segment11 );
988: hr_utility.trace('p_segment12 '||p_segment12 );
989: hr_utility.trace('p_segment13 '||p_segment13 );
990: hr_utility.trace('p_segment14 '||p_segment14 );
991: hr_utility.trace('p_segment15 '||p_segment15 );
992: hr_utility.trace('p_segment16 '||p_segment16 );
993: hr_utility.trace('p_segment17 '||p_segment17 );
994: hr_utility.trace('p_segment18 '||p_segment18 );
995: hr_utility.trace('p_segment19 '||p_segment19 );

Line 992: hr_utility.trace('p_segment16 '||p_segment16 );

988: hr_utility.trace('p_segment12 '||p_segment12 );
989: hr_utility.trace('p_segment13 '||p_segment13 );
990: hr_utility.trace('p_segment14 '||p_segment14 );
991: hr_utility.trace('p_segment15 '||p_segment15 );
992: hr_utility.trace('p_segment16 '||p_segment16 );
993: hr_utility.trace('p_segment17 '||p_segment17 );
994: hr_utility.trace('p_segment18 '||p_segment18 );
995: hr_utility.trace('p_segment19 '||p_segment19 );
996: hr_utility.trace('p_segment20 '||p_segment20 );

Line 993: hr_utility.trace('p_segment17 '||p_segment17 );

989: hr_utility.trace('p_segment13 '||p_segment13 );
990: hr_utility.trace('p_segment14 '||p_segment14 );
991: hr_utility.trace('p_segment15 '||p_segment15 );
992: hr_utility.trace('p_segment16 '||p_segment16 );
993: hr_utility.trace('p_segment17 '||p_segment17 );
994: hr_utility.trace('p_segment18 '||p_segment18 );
995: hr_utility.trace('p_segment19 '||p_segment19 );
996: hr_utility.trace('p_segment20 '||p_segment20 );
997: hr_utility.trace('p_segment21 '||p_segment21 );

Line 994: hr_utility.trace('p_segment18 '||p_segment18 );

990: hr_utility.trace('p_segment14 '||p_segment14 );
991: hr_utility.trace('p_segment15 '||p_segment15 );
992: hr_utility.trace('p_segment16 '||p_segment16 );
993: hr_utility.trace('p_segment17 '||p_segment17 );
994: hr_utility.trace('p_segment18 '||p_segment18 );
995: hr_utility.trace('p_segment19 '||p_segment19 );
996: hr_utility.trace('p_segment20 '||p_segment20 );
997: hr_utility.trace('p_segment21 '||p_segment21 );
998: hr_utility.trace('p_segment22 '||p_segment22 );

Line 995: hr_utility.trace('p_segment19 '||p_segment19 );

991: hr_utility.trace('p_segment15 '||p_segment15 );
992: hr_utility.trace('p_segment16 '||p_segment16 );
993: hr_utility.trace('p_segment17 '||p_segment17 );
994: hr_utility.trace('p_segment18 '||p_segment18 );
995: hr_utility.trace('p_segment19 '||p_segment19 );
996: hr_utility.trace('p_segment20 '||p_segment20 );
997: hr_utility.trace('p_segment21 '||p_segment21 );
998: hr_utility.trace('p_segment22 '||p_segment22 );
999: hr_utility.trace('p_segment23 '||p_segment23 );

Line 996: hr_utility.trace('p_segment20 '||p_segment20 );

992: hr_utility.trace('p_segment16 '||p_segment16 );
993: hr_utility.trace('p_segment17 '||p_segment17 );
994: hr_utility.trace('p_segment18 '||p_segment18 );
995: hr_utility.trace('p_segment19 '||p_segment19 );
996: hr_utility.trace('p_segment20 '||p_segment20 );
997: hr_utility.trace('p_segment21 '||p_segment21 );
998: hr_utility.trace('p_segment22 '||p_segment22 );
999: hr_utility.trace('p_segment23 '||p_segment23 );
1000: hr_utility.trace('p_segment24 '||p_segment24 );

Line 997: hr_utility.trace('p_segment21 '||p_segment21 );

993: hr_utility.trace('p_segment17 '||p_segment17 );
994: hr_utility.trace('p_segment18 '||p_segment18 );
995: hr_utility.trace('p_segment19 '||p_segment19 );
996: hr_utility.trace('p_segment20 '||p_segment20 );
997: hr_utility.trace('p_segment21 '||p_segment21 );
998: hr_utility.trace('p_segment22 '||p_segment22 );
999: hr_utility.trace('p_segment23 '||p_segment23 );
1000: hr_utility.trace('p_segment24 '||p_segment24 );
1001: hr_utility.trace('p_segment25 '||p_segment25 );

Line 998: hr_utility.trace('p_segment22 '||p_segment22 );

994: hr_utility.trace('p_segment18 '||p_segment18 );
995: hr_utility.trace('p_segment19 '||p_segment19 );
996: hr_utility.trace('p_segment20 '||p_segment20 );
997: hr_utility.trace('p_segment21 '||p_segment21 );
998: hr_utility.trace('p_segment22 '||p_segment22 );
999: hr_utility.trace('p_segment23 '||p_segment23 );
1000: hr_utility.trace('p_segment24 '||p_segment24 );
1001: hr_utility.trace('p_segment25 '||p_segment25 );
1002: hr_utility.trace('p_segment26 '||p_segment26 );

Line 999: hr_utility.trace('p_segment23 '||p_segment23 );

995: hr_utility.trace('p_segment19 '||p_segment19 );
996: hr_utility.trace('p_segment20 '||p_segment20 );
997: hr_utility.trace('p_segment21 '||p_segment21 );
998: hr_utility.trace('p_segment22 '||p_segment22 );
999: hr_utility.trace('p_segment23 '||p_segment23 );
1000: hr_utility.trace('p_segment24 '||p_segment24 );
1001: hr_utility.trace('p_segment25 '||p_segment25 );
1002: hr_utility.trace('p_segment26 '||p_segment26 );
1003: hr_utility.trace('p_segment27 '||p_segment27 );

Line 1000: hr_utility.trace('p_segment24 '||p_segment24 );

996: hr_utility.trace('p_segment20 '||p_segment20 );
997: hr_utility.trace('p_segment21 '||p_segment21 );
998: hr_utility.trace('p_segment22 '||p_segment22 );
999: hr_utility.trace('p_segment23 '||p_segment23 );
1000: hr_utility.trace('p_segment24 '||p_segment24 );
1001: hr_utility.trace('p_segment25 '||p_segment25 );
1002: hr_utility.trace('p_segment26 '||p_segment26 );
1003: hr_utility.trace('p_segment27 '||p_segment27 );
1004: hr_utility.trace('p_segment28 '||p_segment28 );

Line 1001: hr_utility.trace('p_segment25 '||p_segment25 );

997: hr_utility.trace('p_segment21 '||p_segment21 );
998: hr_utility.trace('p_segment22 '||p_segment22 );
999: hr_utility.trace('p_segment23 '||p_segment23 );
1000: hr_utility.trace('p_segment24 '||p_segment24 );
1001: hr_utility.trace('p_segment25 '||p_segment25 );
1002: hr_utility.trace('p_segment26 '||p_segment26 );
1003: hr_utility.trace('p_segment27 '||p_segment27 );
1004: hr_utility.trace('p_segment28 '||p_segment28 );
1005: hr_utility.trace('p_segment29 '||p_segment29 );

Line 1002: hr_utility.trace('p_segment26 '||p_segment26 );

998: hr_utility.trace('p_segment22 '||p_segment22 );
999: hr_utility.trace('p_segment23 '||p_segment23 );
1000: hr_utility.trace('p_segment24 '||p_segment24 );
1001: hr_utility.trace('p_segment25 '||p_segment25 );
1002: hr_utility.trace('p_segment26 '||p_segment26 );
1003: hr_utility.trace('p_segment27 '||p_segment27 );
1004: hr_utility.trace('p_segment28 '||p_segment28 );
1005: hr_utility.trace('p_segment29 '||p_segment29 );
1006: hr_utility.trace('p_segment30 '||p_segment30 );

Line 1003: hr_utility.trace('p_segment27 '||p_segment27 );

999: hr_utility.trace('p_segment23 '||p_segment23 );
1000: hr_utility.trace('p_segment24 '||p_segment24 );
1001: hr_utility.trace('p_segment25 '||p_segment25 );
1002: hr_utility.trace('p_segment26 '||p_segment26 );
1003: hr_utility.trace('p_segment27 '||p_segment27 );
1004: hr_utility.trace('p_segment28 '||p_segment28 );
1005: hr_utility.trace('p_segment29 '||p_segment29 );
1006: hr_utility.trace('p_segment30 '||p_segment30 );
1007: */

Line 1004: hr_utility.trace('p_segment28 '||p_segment28 );

1000: hr_utility.trace('p_segment24 '||p_segment24 );
1001: hr_utility.trace('p_segment25 '||p_segment25 );
1002: hr_utility.trace('p_segment26 '||p_segment26 );
1003: hr_utility.trace('p_segment27 '||p_segment27 );
1004: hr_utility.trace('p_segment28 '||p_segment28 );
1005: hr_utility.trace('p_segment29 '||p_segment29 );
1006: hr_utility.trace('p_segment30 '||p_segment30 );
1007: */
1008: open csr_asg;

Line 1005: hr_utility.trace('p_segment29 '||p_segment29 );

1001: hr_utility.trace('p_segment25 '||p_segment25 );
1002: hr_utility.trace('p_segment26 '||p_segment26 );
1003: hr_utility.trace('p_segment27 '||p_segment27 );
1004: hr_utility.trace('p_segment28 '||p_segment28 );
1005: hr_utility.trace('p_segment29 '||p_segment29 );
1006: hr_utility.trace('p_segment30 '||p_segment30 );
1007: */
1008: open csr_asg;
1009: fetch csr_asg into v_csr_asg;

Line 1006: hr_utility.trace('p_segment30 '||p_segment30 );

1002: hr_utility.trace('p_segment26 '||p_segment26 );
1003: hr_utility.trace('p_segment27 '||p_segment27 );
1004: hr_utility.trace('p_segment28 '||p_segment28 );
1005: hr_utility.trace('p_segment29 '||p_segment29 );
1006: hr_utility.trace('p_segment30 '||p_segment30 );
1007: */
1008: open csr_asg;
1009: fetch csr_asg into v_csr_asg;
1010: close csr_asg;

Line 1032: hr_utility.trace('DATE1');

1028: validate_spl_indicators(p_segment10,p_assignment_id,p_effective_date);
1029:
1030: IF p_segment21 = hr_api.g_varchar2 THEN
1031: open csr_get_date_details(p_assignment_id,p_effective_date);
1032: hr_utility.trace('DATE1');
1033: fetch csr_get_date_details into date_details_rec;
1034: l_commencing_date := fnd_date.canonical_to_date(date_details_rec.commencing_date);
1035: close csr_get_date_details;
1036: ELSE

Line 1083: hr_utility.set_message(800, 'HR_373479_NL_EMPLOYER_CHG');

1079:
1080: --14084074
1081: IF p_establishment_id <> hr_api.g_number THEN
1082: IF NOT validate_employer_change(p_assignment_id,p_establishment_id,v_csr_asg.business_group_id,p_effective_date) THEN
1083: hr_utility.set_message(800, 'HR_373479_NL_EMPLOYER_CHG');
1084: hr_utility.raise_error;
1085: END IF;
1086: END IF;
1087: --14084074

Line 1084: hr_utility.raise_error;

1080: --14084074
1081: IF p_establishment_id <> hr_api.g_number THEN
1082: IF NOT validate_employer_change(p_assignment_id,p_establishment_id,v_csr_asg.business_group_id,p_effective_date) THEN
1083: hr_utility.set_message(800, 'HR_373479_NL_EMPLOYER_CHG');
1084: hr_utility.raise_error;
1085: END IF;
1086: END IF;
1087: --14084074
1088:

Line 1093: hr_utility.trace('Leaving extra_assignment_checks');

1089: glo_payroll_id := NULL;
1090: --
1091: END IF;
1092: --
1093: hr_utility.trace('Leaving extra_assignment_checks');
1094: --
1095: END extra_assignment_checks1;
1096:
1097: END hr_nl_extra_asg_rules;