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.

[Home] [Help]

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 684: hr_utility.trace('Entering extra_assignment_checks');

680: l_ind_working_hrs number;
681:
682: BEGIN
683: --
684: hr_utility.trace('Entering extra_assignment_checks');
685: --
686: -- Added for GSI Bug 5472781
687: --
688: IF hr_utility.chk_product_install('Oracle Human Resources', 'NL') THEN

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

684: hr_utility.trace('Entering extra_assignment_checks');
685: --
686: -- Added for GSI Bug 5472781
687: --
688: IF hr_utility.chk_product_install('Oracle Human Resources', 'NL') THEN
689: --
690: /*
691: hr_utility.trace('p_normal_hours '||p_normal_hours );
692: hr_utility.trace('p_frequency '||p_frequency );

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

687: --
688: IF hr_utility.chk_product_install('Oracle Human Resources', 'NL') THEN
689: --
690: /*
691: hr_utility.trace('p_normal_hours '||p_normal_hours );
692: hr_utility.trace('p_frequency '||p_frequency );
693: hr_utility.trace('p_payroll_id '||p_payroll_id );
694: hr_utility.trace('p_scl_segment1 '||p_scl_segment1 );
695: hr_utility.trace('p_scl_segment2 '||p_scl_segment2 );

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

688: IF hr_utility.chk_product_install('Oracle Human Resources', 'NL') THEN
689: --
690: /*
691: hr_utility.trace('p_normal_hours '||p_normal_hours );
692: hr_utility.trace('p_frequency '||p_frequency );
693: hr_utility.trace('p_payroll_id '||p_payroll_id );
694: hr_utility.trace('p_scl_segment1 '||p_scl_segment1 );
695: hr_utility.trace('p_scl_segment2 '||p_scl_segment2 );
696: hr_utility.trace('p_scl_segment3 '||p_scl_segment3 );

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

689: --
690: /*
691: hr_utility.trace('p_normal_hours '||p_normal_hours );
692: hr_utility.trace('p_frequency '||p_frequency );
693: hr_utility.trace('p_payroll_id '||p_payroll_id );
694: hr_utility.trace('p_scl_segment1 '||p_scl_segment1 );
695: hr_utility.trace('p_scl_segment2 '||p_scl_segment2 );
696: hr_utility.trace('p_scl_segment3 '||p_scl_segment3 );
697: hr_utility.trace('p_scl_segment4 '||p_scl_segment4 );

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

690: /*
691: hr_utility.trace('p_normal_hours '||p_normal_hours );
692: hr_utility.trace('p_frequency '||p_frequency );
693: hr_utility.trace('p_payroll_id '||p_payroll_id );
694: hr_utility.trace('p_scl_segment1 '||p_scl_segment1 );
695: hr_utility.trace('p_scl_segment2 '||p_scl_segment2 );
696: hr_utility.trace('p_scl_segment3 '||p_scl_segment3 );
697: hr_utility.trace('p_scl_segment4 '||p_scl_segment4 );
698: hr_utility.trace('p_scl_segment5 '||p_scl_segment5 );

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

691: hr_utility.trace('p_normal_hours '||p_normal_hours );
692: hr_utility.trace('p_frequency '||p_frequency );
693: hr_utility.trace('p_payroll_id '||p_payroll_id );
694: hr_utility.trace('p_scl_segment1 '||p_scl_segment1 );
695: hr_utility.trace('p_scl_segment2 '||p_scl_segment2 );
696: hr_utility.trace('p_scl_segment3 '||p_scl_segment3 );
697: hr_utility.trace('p_scl_segment4 '||p_scl_segment4 );
698: hr_utility.trace('p_scl_segment5 '||p_scl_segment5 );
699: hr_utility.trace('p_scl_segment6 '||p_scl_segment6 );

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

692: hr_utility.trace('p_frequency '||p_frequency );
693: hr_utility.trace('p_payroll_id '||p_payroll_id );
694: hr_utility.trace('p_scl_segment1 '||p_scl_segment1 );
695: hr_utility.trace('p_scl_segment2 '||p_scl_segment2 );
696: hr_utility.trace('p_scl_segment3 '||p_scl_segment3 );
697: hr_utility.trace('p_scl_segment4 '||p_scl_segment4 );
698: hr_utility.trace('p_scl_segment5 '||p_scl_segment5 );
699: hr_utility.trace('p_scl_segment6 '||p_scl_segment6 );
700: hr_utility.trace('p_scl_segment7 '||p_scl_segment7 );

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

693: hr_utility.trace('p_payroll_id '||p_payroll_id );
694: hr_utility.trace('p_scl_segment1 '||p_scl_segment1 );
695: hr_utility.trace('p_scl_segment2 '||p_scl_segment2 );
696: hr_utility.trace('p_scl_segment3 '||p_scl_segment3 );
697: hr_utility.trace('p_scl_segment4 '||p_scl_segment4 );
698: hr_utility.trace('p_scl_segment5 '||p_scl_segment5 );
699: hr_utility.trace('p_scl_segment6 '||p_scl_segment6 );
700: hr_utility.trace('p_scl_segment7 '||p_scl_segment7 );
701: hr_utility.trace('p_scl_segment8 '||p_scl_segment8 );

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

694: hr_utility.trace('p_scl_segment1 '||p_scl_segment1 );
695: hr_utility.trace('p_scl_segment2 '||p_scl_segment2 );
696: hr_utility.trace('p_scl_segment3 '||p_scl_segment3 );
697: hr_utility.trace('p_scl_segment4 '||p_scl_segment4 );
698: hr_utility.trace('p_scl_segment5 '||p_scl_segment5 );
699: hr_utility.trace('p_scl_segment6 '||p_scl_segment6 );
700: hr_utility.trace('p_scl_segment7 '||p_scl_segment7 );
701: hr_utility.trace('p_scl_segment8 '||p_scl_segment8 );
702: hr_utility.trace('p_scl_segment9 '||p_scl_segment9 );

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

695: hr_utility.trace('p_scl_segment2 '||p_scl_segment2 );
696: hr_utility.trace('p_scl_segment3 '||p_scl_segment3 );
697: hr_utility.trace('p_scl_segment4 '||p_scl_segment4 );
698: hr_utility.trace('p_scl_segment5 '||p_scl_segment5 );
699: hr_utility.trace('p_scl_segment6 '||p_scl_segment6 );
700: hr_utility.trace('p_scl_segment7 '||p_scl_segment7 );
701: hr_utility.trace('p_scl_segment8 '||p_scl_segment8 );
702: hr_utility.trace('p_scl_segment9 '||p_scl_segment9 );
703: hr_utility.trace('p_scl_segment10 '||p_scl_segment10 );

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

696: hr_utility.trace('p_scl_segment3 '||p_scl_segment3 );
697: hr_utility.trace('p_scl_segment4 '||p_scl_segment4 );
698: hr_utility.trace('p_scl_segment5 '||p_scl_segment5 );
699: hr_utility.trace('p_scl_segment6 '||p_scl_segment6 );
700: hr_utility.trace('p_scl_segment7 '||p_scl_segment7 );
701: hr_utility.trace('p_scl_segment8 '||p_scl_segment8 );
702: hr_utility.trace('p_scl_segment9 '||p_scl_segment9 );
703: hr_utility.trace('p_scl_segment10 '||p_scl_segment10 );
704: hr_utility.trace('p_scl_segment11 '||p_scl_segment11 );

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

697: hr_utility.trace('p_scl_segment4 '||p_scl_segment4 );
698: hr_utility.trace('p_scl_segment5 '||p_scl_segment5 );
699: hr_utility.trace('p_scl_segment6 '||p_scl_segment6 );
700: hr_utility.trace('p_scl_segment7 '||p_scl_segment7 );
701: hr_utility.trace('p_scl_segment8 '||p_scl_segment8 );
702: hr_utility.trace('p_scl_segment9 '||p_scl_segment9 );
703: hr_utility.trace('p_scl_segment10 '||p_scl_segment10 );
704: hr_utility.trace('p_scl_segment11 '||p_scl_segment11 );
705: hr_utility.trace('p_scl_segment12 '||p_scl_segment12 );

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

698: hr_utility.trace('p_scl_segment5 '||p_scl_segment5 );
699: hr_utility.trace('p_scl_segment6 '||p_scl_segment6 );
700: hr_utility.trace('p_scl_segment7 '||p_scl_segment7 );
701: hr_utility.trace('p_scl_segment8 '||p_scl_segment8 );
702: hr_utility.trace('p_scl_segment9 '||p_scl_segment9 );
703: hr_utility.trace('p_scl_segment10 '||p_scl_segment10 );
704: hr_utility.trace('p_scl_segment11 '||p_scl_segment11 );
705: hr_utility.trace('p_scl_segment12 '||p_scl_segment12 );
706: hr_utility.trace('p_scl_segment13 '||p_scl_segment13 );

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

699: hr_utility.trace('p_scl_segment6 '||p_scl_segment6 );
700: hr_utility.trace('p_scl_segment7 '||p_scl_segment7 );
701: hr_utility.trace('p_scl_segment8 '||p_scl_segment8 );
702: hr_utility.trace('p_scl_segment9 '||p_scl_segment9 );
703: hr_utility.trace('p_scl_segment10 '||p_scl_segment10 );
704: hr_utility.trace('p_scl_segment11 '||p_scl_segment11 );
705: hr_utility.trace('p_scl_segment12 '||p_scl_segment12 );
706: hr_utility.trace('p_scl_segment13 '||p_scl_segment13 );
707: hr_utility.trace('p_scl_segment14 '||p_scl_segment14 );

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

700: hr_utility.trace('p_scl_segment7 '||p_scl_segment7 );
701: hr_utility.trace('p_scl_segment8 '||p_scl_segment8 );
702: hr_utility.trace('p_scl_segment9 '||p_scl_segment9 );
703: hr_utility.trace('p_scl_segment10 '||p_scl_segment10 );
704: hr_utility.trace('p_scl_segment11 '||p_scl_segment11 );
705: hr_utility.trace('p_scl_segment12 '||p_scl_segment12 );
706: hr_utility.trace('p_scl_segment13 '||p_scl_segment13 );
707: hr_utility.trace('p_scl_segment14 '||p_scl_segment14 );
708: hr_utility.trace('p_scl_segment15 '||p_scl_segment15 );

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

701: hr_utility.trace('p_scl_segment8 '||p_scl_segment8 );
702: hr_utility.trace('p_scl_segment9 '||p_scl_segment9 );
703: hr_utility.trace('p_scl_segment10 '||p_scl_segment10 );
704: hr_utility.trace('p_scl_segment11 '||p_scl_segment11 );
705: hr_utility.trace('p_scl_segment12 '||p_scl_segment12 );
706: hr_utility.trace('p_scl_segment13 '||p_scl_segment13 );
707: hr_utility.trace('p_scl_segment14 '||p_scl_segment14 );
708: hr_utility.trace('p_scl_segment15 '||p_scl_segment15 );
709: hr_utility.trace('p_scl_segment16 '||p_scl_segment16 );

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

702: hr_utility.trace('p_scl_segment9 '||p_scl_segment9 );
703: hr_utility.trace('p_scl_segment10 '||p_scl_segment10 );
704: hr_utility.trace('p_scl_segment11 '||p_scl_segment11 );
705: hr_utility.trace('p_scl_segment12 '||p_scl_segment12 );
706: hr_utility.trace('p_scl_segment13 '||p_scl_segment13 );
707: hr_utility.trace('p_scl_segment14 '||p_scl_segment14 );
708: hr_utility.trace('p_scl_segment15 '||p_scl_segment15 );
709: hr_utility.trace('p_scl_segment16 '||p_scl_segment16 );
710: hr_utility.trace('p_scl_segment17 '||p_scl_segment17 );

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

703: hr_utility.trace('p_scl_segment10 '||p_scl_segment10 );
704: hr_utility.trace('p_scl_segment11 '||p_scl_segment11 );
705: hr_utility.trace('p_scl_segment12 '||p_scl_segment12 );
706: hr_utility.trace('p_scl_segment13 '||p_scl_segment13 );
707: hr_utility.trace('p_scl_segment14 '||p_scl_segment14 );
708: hr_utility.trace('p_scl_segment15 '||p_scl_segment15 );
709: hr_utility.trace('p_scl_segment16 '||p_scl_segment16 );
710: hr_utility.trace('p_scl_segment17 '||p_scl_segment17 );
711: hr_utility.trace('p_scl_segment18 '||p_scl_segment18 );

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

704: hr_utility.trace('p_scl_segment11 '||p_scl_segment11 );
705: hr_utility.trace('p_scl_segment12 '||p_scl_segment12 );
706: hr_utility.trace('p_scl_segment13 '||p_scl_segment13 );
707: hr_utility.trace('p_scl_segment14 '||p_scl_segment14 );
708: hr_utility.trace('p_scl_segment15 '||p_scl_segment15 );
709: hr_utility.trace('p_scl_segment16 '||p_scl_segment16 );
710: hr_utility.trace('p_scl_segment17 '||p_scl_segment17 );
711: hr_utility.trace('p_scl_segment18 '||p_scl_segment18 );
712: hr_utility.trace('p_scl_segment19 '||p_scl_segment19 );

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

705: hr_utility.trace('p_scl_segment12 '||p_scl_segment12 );
706: hr_utility.trace('p_scl_segment13 '||p_scl_segment13 );
707: hr_utility.trace('p_scl_segment14 '||p_scl_segment14 );
708: hr_utility.trace('p_scl_segment15 '||p_scl_segment15 );
709: hr_utility.trace('p_scl_segment16 '||p_scl_segment16 );
710: hr_utility.trace('p_scl_segment17 '||p_scl_segment17 );
711: hr_utility.trace('p_scl_segment18 '||p_scl_segment18 );
712: hr_utility.trace('p_scl_segment19 '||p_scl_segment19 );
713: hr_utility.trace('p_scl_segment20 '||p_scl_segment20 );

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

706: hr_utility.trace('p_scl_segment13 '||p_scl_segment13 );
707: hr_utility.trace('p_scl_segment14 '||p_scl_segment14 );
708: hr_utility.trace('p_scl_segment15 '||p_scl_segment15 );
709: hr_utility.trace('p_scl_segment16 '||p_scl_segment16 );
710: hr_utility.trace('p_scl_segment17 '||p_scl_segment17 );
711: hr_utility.trace('p_scl_segment18 '||p_scl_segment18 );
712: hr_utility.trace('p_scl_segment19 '||p_scl_segment19 );
713: hr_utility.trace('p_scl_segment20 '||p_scl_segment20 );
714: hr_utility.trace('p_scl_segment21 '||p_scl_segment21 );

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

707: hr_utility.trace('p_scl_segment14 '||p_scl_segment14 );
708: hr_utility.trace('p_scl_segment15 '||p_scl_segment15 );
709: hr_utility.trace('p_scl_segment16 '||p_scl_segment16 );
710: hr_utility.trace('p_scl_segment17 '||p_scl_segment17 );
711: hr_utility.trace('p_scl_segment18 '||p_scl_segment18 );
712: hr_utility.trace('p_scl_segment19 '||p_scl_segment19 );
713: hr_utility.trace('p_scl_segment20 '||p_scl_segment20 );
714: hr_utility.trace('p_scl_segment21 '||p_scl_segment21 );
715: hr_utility.trace('p_scl_segment22 '||p_scl_segment22 );

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

708: hr_utility.trace('p_scl_segment15 '||p_scl_segment15 );
709: hr_utility.trace('p_scl_segment16 '||p_scl_segment16 );
710: hr_utility.trace('p_scl_segment17 '||p_scl_segment17 );
711: hr_utility.trace('p_scl_segment18 '||p_scl_segment18 );
712: hr_utility.trace('p_scl_segment19 '||p_scl_segment19 );
713: hr_utility.trace('p_scl_segment20 '||p_scl_segment20 );
714: hr_utility.trace('p_scl_segment21 '||p_scl_segment21 );
715: hr_utility.trace('p_scl_segment22 '||p_scl_segment22 );
716: hr_utility.trace('p_scl_segment23 '||p_scl_segment23 );

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

709: hr_utility.trace('p_scl_segment16 '||p_scl_segment16 );
710: hr_utility.trace('p_scl_segment17 '||p_scl_segment17 );
711: hr_utility.trace('p_scl_segment18 '||p_scl_segment18 );
712: hr_utility.trace('p_scl_segment19 '||p_scl_segment19 );
713: hr_utility.trace('p_scl_segment20 '||p_scl_segment20 );
714: hr_utility.trace('p_scl_segment21 '||p_scl_segment21 );
715: hr_utility.trace('p_scl_segment22 '||p_scl_segment22 );
716: hr_utility.trace('p_scl_segment23 '||p_scl_segment23 );
717: hr_utility.trace('p_scl_segment24 '||p_scl_segment24 );

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

710: hr_utility.trace('p_scl_segment17 '||p_scl_segment17 );
711: hr_utility.trace('p_scl_segment18 '||p_scl_segment18 );
712: hr_utility.trace('p_scl_segment19 '||p_scl_segment19 );
713: hr_utility.trace('p_scl_segment20 '||p_scl_segment20 );
714: hr_utility.trace('p_scl_segment21 '||p_scl_segment21 );
715: hr_utility.trace('p_scl_segment22 '||p_scl_segment22 );
716: hr_utility.trace('p_scl_segment23 '||p_scl_segment23 );
717: hr_utility.trace('p_scl_segment24 '||p_scl_segment24 );
718: hr_utility.trace('p_scl_segment25 '||p_scl_segment25 );

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

711: hr_utility.trace('p_scl_segment18 '||p_scl_segment18 );
712: hr_utility.trace('p_scl_segment19 '||p_scl_segment19 );
713: hr_utility.trace('p_scl_segment20 '||p_scl_segment20 );
714: hr_utility.trace('p_scl_segment21 '||p_scl_segment21 );
715: hr_utility.trace('p_scl_segment22 '||p_scl_segment22 );
716: hr_utility.trace('p_scl_segment23 '||p_scl_segment23 );
717: hr_utility.trace('p_scl_segment24 '||p_scl_segment24 );
718: hr_utility.trace('p_scl_segment25 '||p_scl_segment25 );
719: hr_utility.trace('p_scl_segment26 '||p_scl_segment26 );

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

712: hr_utility.trace('p_scl_segment19 '||p_scl_segment19 );
713: hr_utility.trace('p_scl_segment20 '||p_scl_segment20 );
714: hr_utility.trace('p_scl_segment21 '||p_scl_segment21 );
715: hr_utility.trace('p_scl_segment22 '||p_scl_segment22 );
716: hr_utility.trace('p_scl_segment23 '||p_scl_segment23 );
717: hr_utility.trace('p_scl_segment24 '||p_scl_segment24 );
718: hr_utility.trace('p_scl_segment25 '||p_scl_segment25 );
719: hr_utility.trace('p_scl_segment26 '||p_scl_segment26 );
720: hr_utility.trace('p_scl_segment27 '||p_scl_segment27 );

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

713: hr_utility.trace('p_scl_segment20 '||p_scl_segment20 );
714: hr_utility.trace('p_scl_segment21 '||p_scl_segment21 );
715: hr_utility.trace('p_scl_segment22 '||p_scl_segment22 );
716: hr_utility.trace('p_scl_segment23 '||p_scl_segment23 );
717: hr_utility.trace('p_scl_segment24 '||p_scl_segment24 );
718: hr_utility.trace('p_scl_segment25 '||p_scl_segment25 );
719: hr_utility.trace('p_scl_segment26 '||p_scl_segment26 );
720: hr_utility.trace('p_scl_segment27 '||p_scl_segment27 );
721: hr_utility.trace('p_scl_segment28 '||p_scl_segment28 );

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

714: hr_utility.trace('p_scl_segment21 '||p_scl_segment21 );
715: hr_utility.trace('p_scl_segment22 '||p_scl_segment22 );
716: hr_utility.trace('p_scl_segment23 '||p_scl_segment23 );
717: hr_utility.trace('p_scl_segment24 '||p_scl_segment24 );
718: hr_utility.trace('p_scl_segment25 '||p_scl_segment25 );
719: hr_utility.trace('p_scl_segment26 '||p_scl_segment26 );
720: hr_utility.trace('p_scl_segment27 '||p_scl_segment27 );
721: hr_utility.trace('p_scl_segment28 '||p_scl_segment28 );
722: hr_utility.trace('p_scl_segment29 '||p_scl_segment29 );

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

715: hr_utility.trace('p_scl_segment22 '||p_scl_segment22 );
716: hr_utility.trace('p_scl_segment23 '||p_scl_segment23 );
717: hr_utility.trace('p_scl_segment24 '||p_scl_segment24 );
718: hr_utility.trace('p_scl_segment25 '||p_scl_segment25 );
719: hr_utility.trace('p_scl_segment26 '||p_scl_segment26 );
720: hr_utility.trace('p_scl_segment27 '||p_scl_segment27 );
721: hr_utility.trace('p_scl_segment28 '||p_scl_segment28 );
722: hr_utility.trace('p_scl_segment29 '||p_scl_segment29 );
723: hr_utility.trace('p_scl_segment30 '||p_scl_segment30 );

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

716: hr_utility.trace('p_scl_segment23 '||p_scl_segment23 );
717: hr_utility.trace('p_scl_segment24 '||p_scl_segment24 );
718: hr_utility.trace('p_scl_segment25 '||p_scl_segment25 );
719: hr_utility.trace('p_scl_segment26 '||p_scl_segment26 );
720: hr_utility.trace('p_scl_segment27 '||p_scl_segment27 );
721: hr_utility.trace('p_scl_segment28 '||p_scl_segment28 );
722: hr_utility.trace('p_scl_segment29 '||p_scl_segment29 );
723: hr_utility.trace('p_scl_segment30 '||p_scl_segment30 );
724: */

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

717: hr_utility.trace('p_scl_segment24 '||p_scl_segment24 );
718: hr_utility.trace('p_scl_segment25 '||p_scl_segment25 );
719: hr_utility.trace('p_scl_segment26 '||p_scl_segment26 );
720: hr_utility.trace('p_scl_segment27 '||p_scl_segment27 );
721: hr_utility.trace('p_scl_segment28 '||p_scl_segment28 );
722: hr_utility.trace('p_scl_segment29 '||p_scl_segment29 );
723: hr_utility.trace('p_scl_segment30 '||p_scl_segment30 );
724: */
725: l_frequency:=p_frequency;

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

718: hr_utility.trace('p_scl_segment25 '||p_scl_segment25 );
719: hr_utility.trace('p_scl_segment26 '||p_scl_segment26 );
720: hr_utility.trace('p_scl_segment27 '||p_scl_segment27 );
721: hr_utility.trace('p_scl_segment28 '||p_scl_segment28 );
722: hr_utility.trace('p_scl_segment29 '||p_scl_segment29 );
723: hr_utility.trace('p_scl_segment30 '||p_scl_segment30 );
724: */
725: l_frequency:=p_frequency;
726:

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

719: hr_utility.trace('p_scl_segment26 '||p_scl_segment26 );
720: hr_utility.trace('p_scl_segment27 '||p_scl_segment27 );
721: hr_utility.trace('p_scl_segment28 '||p_scl_segment28 );
722: hr_utility.trace('p_scl_segment29 '||p_scl_segment29 );
723: hr_utility.trace('p_scl_segment30 '||p_scl_segment30 );
724: */
725: l_frequency:=p_frequency;
726:
727: IF p_scl_segment28 IS NULL then

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

782: ,l_percentage ,l_frequency ,p_normal_hours);
783: --
784: END IF;
785: --
786: hr_utility.trace('Leaving extra_assignment_checks');
787: --
788: END extra_assignment_checks;
789:
790:

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

863: l_ind_working_hrs number;
864:
865: BEGIN
866: --
867: hr_utility.trace('Entering extra_assignment_checks1');
868: --
869: -- Added for GSI Bug 5472781
870: --
871: IF hr_utility.chk_product_install('Oracle Human Resources', 'NL') THEN

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

867: hr_utility.trace('Entering extra_assignment_checks1');
868: --
869: -- Added for GSI Bug 5472781
870: --
871: IF hr_utility.chk_product_install('Oracle Human Resources', 'NL') THEN
872: --
873: /*
874: hr_utility.trace('p_normal_hours '||p_normal_hours );
875: hr_utility.trace('p_frequency '||p_frequency );

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

870: --
871: IF hr_utility.chk_product_install('Oracle Human Resources', 'NL') THEN
872: --
873: /*
874: hr_utility.trace('p_normal_hours '||p_normal_hours );
875: hr_utility.trace('p_frequency '||p_frequency );
876: hr_utility.trace('p_segment1 '||p_segment1 );
877: hr_utility.trace('p_segment2 '||p_segment2 );
878: hr_utility.trace('p_segment3 '||p_segment3 );

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

871: IF hr_utility.chk_product_install('Oracle Human Resources', 'NL') THEN
872: --
873: /*
874: hr_utility.trace('p_normal_hours '||p_normal_hours );
875: hr_utility.trace('p_frequency '||p_frequency );
876: hr_utility.trace('p_segment1 '||p_segment1 );
877: hr_utility.trace('p_segment2 '||p_segment2 );
878: hr_utility.trace('p_segment3 '||p_segment3 );
879: hr_utility.trace('p_segment4 '||p_segment4 );

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

872: --
873: /*
874: hr_utility.trace('p_normal_hours '||p_normal_hours );
875: hr_utility.trace('p_frequency '||p_frequency );
876: hr_utility.trace('p_segment1 '||p_segment1 );
877: hr_utility.trace('p_segment2 '||p_segment2 );
878: hr_utility.trace('p_segment3 '||p_segment3 );
879: hr_utility.trace('p_segment4 '||p_segment4 );
880: hr_utility.trace('p_segment5 '||p_segment5 );

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

873: /*
874: hr_utility.trace('p_normal_hours '||p_normal_hours );
875: hr_utility.trace('p_frequency '||p_frequency );
876: hr_utility.trace('p_segment1 '||p_segment1 );
877: hr_utility.trace('p_segment2 '||p_segment2 );
878: hr_utility.trace('p_segment3 '||p_segment3 );
879: hr_utility.trace('p_segment4 '||p_segment4 );
880: hr_utility.trace('p_segment5 '||p_segment5 );
881: hr_utility.trace('p_segment6 '||p_segment6 );

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

874: hr_utility.trace('p_normal_hours '||p_normal_hours );
875: hr_utility.trace('p_frequency '||p_frequency );
876: hr_utility.trace('p_segment1 '||p_segment1 );
877: hr_utility.trace('p_segment2 '||p_segment2 );
878: hr_utility.trace('p_segment3 '||p_segment3 );
879: hr_utility.trace('p_segment4 '||p_segment4 );
880: hr_utility.trace('p_segment5 '||p_segment5 );
881: hr_utility.trace('p_segment6 '||p_segment6 );
882: hr_utility.trace('p_segment7 '||p_segment7 );

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

875: hr_utility.trace('p_frequency '||p_frequency );
876: hr_utility.trace('p_segment1 '||p_segment1 );
877: hr_utility.trace('p_segment2 '||p_segment2 );
878: hr_utility.trace('p_segment3 '||p_segment3 );
879: hr_utility.trace('p_segment4 '||p_segment4 );
880: hr_utility.trace('p_segment5 '||p_segment5 );
881: hr_utility.trace('p_segment6 '||p_segment6 );
882: hr_utility.trace('p_segment7 '||p_segment7 );
883: hr_utility.trace('p_segment8 '||p_segment8 );

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

876: hr_utility.trace('p_segment1 '||p_segment1 );
877: hr_utility.trace('p_segment2 '||p_segment2 );
878: hr_utility.trace('p_segment3 '||p_segment3 );
879: hr_utility.trace('p_segment4 '||p_segment4 );
880: hr_utility.trace('p_segment5 '||p_segment5 );
881: hr_utility.trace('p_segment6 '||p_segment6 );
882: hr_utility.trace('p_segment7 '||p_segment7 );
883: hr_utility.trace('p_segment8 '||p_segment8 );
884: hr_utility.trace('p_segment9 '||p_segment9 );

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

877: hr_utility.trace('p_segment2 '||p_segment2 );
878: hr_utility.trace('p_segment3 '||p_segment3 );
879: hr_utility.trace('p_segment4 '||p_segment4 );
880: hr_utility.trace('p_segment5 '||p_segment5 );
881: hr_utility.trace('p_segment6 '||p_segment6 );
882: hr_utility.trace('p_segment7 '||p_segment7 );
883: hr_utility.trace('p_segment8 '||p_segment8 );
884: hr_utility.trace('p_segment9 '||p_segment9 );
885: hr_utility.trace('p_segment10 '||p_segment10 );

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

878: hr_utility.trace('p_segment3 '||p_segment3 );
879: hr_utility.trace('p_segment4 '||p_segment4 );
880: hr_utility.trace('p_segment5 '||p_segment5 );
881: hr_utility.trace('p_segment6 '||p_segment6 );
882: hr_utility.trace('p_segment7 '||p_segment7 );
883: hr_utility.trace('p_segment8 '||p_segment8 );
884: hr_utility.trace('p_segment9 '||p_segment9 );
885: hr_utility.trace('p_segment10 '||p_segment10 );
886: hr_utility.trace('p_segment11 '||p_segment11 );

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

879: hr_utility.trace('p_segment4 '||p_segment4 );
880: hr_utility.trace('p_segment5 '||p_segment5 );
881: hr_utility.trace('p_segment6 '||p_segment6 );
882: hr_utility.trace('p_segment7 '||p_segment7 );
883: hr_utility.trace('p_segment8 '||p_segment8 );
884: hr_utility.trace('p_segment9 '||p_segment9 );
885: hr_utility.trace('p_segment10 '||p_segment10 );
886: hr_utility.trace('p_segment11 '||p_segment11 );
887: hr_utility.trace('p_segment12 '||p_segment12 );

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

880: hr_utility.trace('p_segment5 '||p_segment5 );
881: hr_utility.trace('p_segment6 '||p_segment6 );
882: hr_utility.trace('p_segment7 '||p_segment7 );
883: hr_utility.trace('p_segment8 '||p_segment8 );
884: hr_utility.trace('p_segment9 '||p_segment9 );
885: hr_utility.trace('p_segment10 '||p_segment10 );
886: hr_utility.trace('p_segment11 '||p_segment11 );
887: hr_utility.trace('p_segment12 '||p_segment12 );
888: hr_utility.trace('p_segment13 '||p_segment13 );

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

881: hr_utility.trace('p_segment6 '||p_segment6 );
882: hr_utility.trace('p_segment7 '||p_segment7 );
883: hr_utility.trace('p_segment8 '||p_segment8 );
884: hr_utility.trace('p_segment9 '||p_segment9 );
885: hr_utility.trace('p_segment10 '||p_segment10 );
886: hr_utility.trace('p_segment11 '||p_segment11 );
887: hr_utility.trace('p_segment12 '||p_segment12 );
888: hr_utility.trace('p_segment13 '||p_segment13 );
889: hr_utility.trace('p_segment14 '||p_segment14 );

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

882: hr_utility.trace('p_segment7 '||p_segment7 );
883: hr_utility.trace('p_segment8 '||p_segment8 );
884: hr_utility.trace('p_segment9 '||p_segment9 );
885: hr_utility.trace('p_segment10 '||p_segment10 );
886: hr_utility.trace('p_segment11 '||p_segment11 );
887: hr_utility.trace('p_segment12 '||p_segment12 );
888: hr_utility.trace('p_segment13 '||p_segment13 );
889: hr_utility.trace('p_segment14 '||p_segment14 );
890: hr_utility.trace('p_segment15 '||p_segment15 );

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

883: hr_utility.trace('p_segment8 '||p_segment8 );
884: hr_utility.trace('p_segment9 '||p_segment9 );
885: hr_utility.trace('p_segment10 '||p_segment10 );
886: hr_utility.trace('p_segment11 '||p_segment11 );
887: hr_utility.trace('p_segment12 '||p_segment12 );
888: hr_utility.trace('p_segment13 '||p_segment13 );
889: hr_utility.trace('p_segment14 '||p_segment14 );
890: hr_utility.trace('p_segment15 '||p_segment15 );
891: hr_utility.trace('p_segment16 '||p_segment16 );

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

884: hr_utility.trace('p_segment9 '||p_segment9 );
885: hr_utility.trace('p_segment10 '||p_segment10 );
886: hr_utility.trace('p_segment11 '||p_segment11 );
887: hr_utility.trace('p_segment12 '||p_segment12 );
888: hr_utility.trace('p_segment13 '||p_segment13 );
889: hr_utility.trace('p_segment14 '||p_segment14 );
890: hr_utility.trace('p_segment15 '||p_segment15 );
891: hr_utility.trace('p_segment16 '||p_segment16 );
892: hr_utility.trace('p_segment17 '||p_segment17 );

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

885: hr_utility.trace('p_segment10 '||p_segment10 );
886: hr_utility.trace('p_segment11 '||p_segment11 );
887: hr_utility.trace('p_segment12 '||p_segment12 );
888: hr_utility.trace('p_segment13 '||p_segment13 );
889: hr_utility.trace('p_segment14 '||p_segment14 );
890: hr_utility.trace('p_segment15 '||p_segment15 );
891: hr_utility.trace('p_segment16 '||p_segment16 );
892: hr_utility.trace('p_segment17 '||p_segment17 );
893: hr_utility.trace('p_segment18 '||p_segment18 );

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

886: hr_utility.trace('p_segment11 '||p_segment11 );
887: hr_utility.trace('p_segment12 '||p_segment12 );
888: hr_utility.trace('p_segment13 '||p_segment13 );
889: hr_utility.trace('p_segment14 '||p_segment14 );
890: hr_utility.trace('p_segment15 '||p_segment15 );
891: hr_utility.trace('p_segment16 '||p_segment16 );
892: hr_utility.trace('p_segment17 '||p_segment17 );
893: hr_utility.trace('p_segment18 '||p_segment18 );
894: hr_utility.trace('p_segment19 '||p_segment19 );

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

887: hr_utility.trace('p_segment12 '||p_segment12 );
888: hr_utility.trace('p_segment13 '||p_segment13 );
889: hr_utility.trace('p_segment14 '||p_segment14 );
890: hr_utility.trace('p_segment15 '||p_segment15 );
891: hr_utility.trace('p_segment16 '||p_segment16 );
892: hr_utility.trace('p_segment17 '||p_segment17 );
893: hr_utility.trace('p_segment18 '||p_segment18 );
894: hr_utility.trace('p_segment19 '||p_segment19 );
895: hr_utility.trace('p_segment20 '||p_segment20 );

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

888: hr_utility.trace('p_segment13 '||p_segment13 );
889: hr_utility.trace('p_segment14 '||p_segment14 );
890: hr_utility.trace('p_segment15 '||p_segment15 );
891: hr_utility.trace('p_segment16 '||p_segment16 );
892: hr_utility.trace('p_segment17 '||p_segment17 );
893: hr_utility.trace('p_segment18 '||p_segment18 );
894: hr_utility.trace('p_segment19 '||p_segment19 );
895: hr_utility.trace('p_segment20 '||p_segment20 );
896: hr_utility.trace('p_segment21 '||p_segment21 );

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

889: hr_utility.trace('p_segment14 '||p_segment14 );
890: hr_utility.trace('p_segment15 '||p_segment15 );
891: hr_utility.trace('p_segment16 '||p_segment16 );
892: hr_utility.trace('p_segment17 '||p_segment17 );
893: hr_utility.trace('p_segment18 '||p_segment18 );
894: hr_utility.trace('p_segment19 '||p_segment19 );
895: hr_utility.trace('p_segment20 '||p_segment20 );
896: hr_utility.trace('p_segment21 '||p_segment21 );
897: hr_utility.trace('p_segment22 '||p_segment22 );

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

890: hr_utility.trace('p_segment15 '||p_segment15 );
891: hr_utility.trace('p_segment16 '||p_segment16 );
892: hr_utility.trace('p_segment17 '||p_segment17 );
893: hr_utility.trace('p_segment18 '||p_segment18 );
894: hr_utility.trace('p_segment19 '||p_segment19 );
895: hr_utility.trace('p_segment20 '||p_segment20 );
896: hr_utility.trace('p_segment21 '||p_segment21 );
897: hr_utility.trace('p_segment22 '||p_segment22 );
898: hr_utility.trace('p_segment23 '||p_segment23 );

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

891: hr_utility.trace('p_segment16 '||p_segment16 );
892: hr_utility.trace('p_segment17 '||p_segment17 );
893: hr_utility.trace('p_segment18 '||p_segment18 );
894: hr_utility.trace('p_segment19 '||p_segment19 );
895: hr_utility.trace('p_segment20 '||p_segment20 );
896: hr_utility.trace('p_segment21 '||p_segment21 );
897: hr_utility.trace('p_segment22 '||p_segment22 );
898: hr_utility.trace('p_segment23 '||p_segment23 );
899: hr_utility.trace('p_segment24 '||p_segment24 );

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

892: hr_utility.trace('p_segment17 '||p_segment17 );
893: hr_utility.trace('p_segment18 '||p_segment18 );
894: hr_utility.trace('p_segment19 '||p_segment19 );
895: hr_utility.trace('p_segment20 '||p_segment20 );
896: hr_utility.trace('p_segment21 '||p_segment21 );
897: hr_utility.trace('p_segment22 '||p_segment22 );
898: hr_utility.trace('p_segment23 '||p_segment23 );
899: hr_utility.trace('p_segment24 '||p_segment24 );
900: hr_utility.trace('p_segment25 '||p_segment25 );

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

893: hr_utility.trace('p_segment18 '||p_segment18 );
894: hr_utility.trace('p_segment19 '||p_segment19 );
895: hr_utility.trace('p_segment20 '||p_segment20 );
896: hr_utility.trace('p_segment21 '||p_segment21 );
897: hr_utility.trace('p_segment22 '||p_segment22 );
898: hr_utility.trace('p_segment23 '||p_segment23 );
899: hr_utility.trace('p_segment24 '||p_segment24 );
900: hr_utility.trace('p_segment25 '||p_segment25 );
901: hr_utility.trace('p_segment26 '||p_segment26 );

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

894: hr_utility.trace('p_segment19 '||p_segment19 );
895: hr_utility.trace('p_segment20 '||p_segment20 );
896: hr_utility.trace('p_segment21 '||p_segment21 );
897: hr_utility.trace('p_segment22 '||p_segment22 );
898: hr_utility.trace('p_segment23 '||p_segment23 );
899: hr_utility.trace('p_segment24 '||p_segment24 );
900: hr_utility.trace('p_segment25 '||p_segment25 );
901: hr_utility.trace('p_segment26 '||p_segment26 );
902: hr_utility.trace('p_segment27 '||p_segment27 );

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

895: hr_utility.trace('p_segment20 '||p_segment20 );
896: hr_utility.trace('p_segment21 '||p_segment21 );
897: hr_utility.trace('p_segment22 '||p_segment22 );
898: hr_utility.trace('p_segment23 '||p_segment23 );
899: hr_utility.trace('p_segment24 '||p_segment24 );
900: hr_utility.trace('p_segment25 '||p_segment25 );
901: hr_utility.trace('p_segment26 '||p_segment26 );
902: hr_utility.trace('p_segment27 '||p_segment27 );
903: hr_utility.trace('p_segment28 '||p_segment28 );

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

896: hr_utility.trace('p_segment21 '||p_segment21 );
897: hr_utility.trace('p_segment22 '||p_segment22 );
898: hr_utility.trace('p_segment23 '||p_segment23 );
899: hr_utility.trace('p_segment24 '||p_segment24 );
900: hr_utility.trace('p_segment25 '||p_segment25 );
901: hr_utility.trace('p_segment26 '||p_segment26 );
902: hr_utility.trace('p_segment27 '||p_segment27 );
903: hr_utility.trace('p_segment28 '||p_segment28 );
904: hr_utility.trace('p_segment29 '||p_segment29 );

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

897: hr_utility.trace('p_segment22 '||p_segment22 );
898: hr_utility.trace('p_segment23 '||p_segment23 );
899: hr_utility.trace('p_segment24 '||p_segment24 );
900: hr_utility.trace('p_segment25 '||p_segment25 );
901: hr_utility.trace('p_segment26 '||p_segment26 );
902: hr_utility.trace('p_segment27 '||p_segment27 );
903: hr_utility.trace('p_segment28 '||p_segment28 );
904: hr_utility.trace('p_segment29 '||p_segment29 );
905: hr_utility.trace('p_segment30 '||p_segment30 );

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

898: hr_utility.trace('p_segment23 '||p_segment23 );
899: hr_utility.trace('p_segment24 '||p_segment24 );
900: hr_utility.trace('p_segment25 '||p_segment25 );
901: hr_utility.trace('p_segment26 '||p_segment26 );
902: hr_utility.trace('p_segment27 '||p_segment27 );
903: hr_utility.trace('p_segment28 '||p_segment28 );
904: hr_utility.trace('p_segment29 '||p_segment29 );
905: hr_utility.trace('p_segment30 '||p_segment30 );
906: */

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

899: hr_utility.trace('p_segment24 '||p_segment24 );
900: hr_utility.trace('p_segment25 '||p_segment25 );
901: hr_utility.trace('p_segment26 '||p_segment26 );
902: hr_utility.trace('p_segment27 '||p_segment27 );
903: hr_utility.trace('p_segment28 '||p_segment28 );
904: hr_utility.trace('p_segment29 '||p_segment29 );
905: hr_utility.trace('p_segment30 '||p_segment30 );
906: */
907: open csr_asg;

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

900: hr_utility.trace('p_segment25 '||p_segment25 );
901: hr_utility.trace('p_segment26 '||p_segment26 );
902: hr_utility.trace('p_segment27 '||p_segment27 );
903: hr_utility.trace('p_segment28 '||p_segment28 );
904: hr_utility.trace('p_segment29 '||p_segment29 );
905: hr_utility.trace('p_segment30 '||p_segment30 );
906: */
907: open csr_asg;
908: fetch csr_asg into v_csr_asg;

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

901: hr_utility.trace('p_segment26 '||p_segment26 );
902: hr_utility.trace('p_segment27 '||p_segment27 );
903: hr_utility.trace('p_segment28 '||p_segment28 );
904: hr_utility.trace('p_segment29 '||p_segment29 );
905: hr_utility.trace('p_segment30 '||p_segment30 );
906: */
907: open csr_asg;
908: fetch csr_asg into v_csr_asg;
909: close csr_asg;

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

927: validate_spl_indicators(p_segment10,p_assignment_id,p_effective_date);
928:
929: IF p_segment21 = hr_api.g_varchar2 THEN
930: open csr_get_date_details(p_assignment_id,p_effective_date);
931: hr_utility.trace('DATE1');
932: fetch csr_get_date_details into date_details_rec;
933: l_commencing_date := fnd_date.canonical_to_date(date_details_rec.commencing_date);
934: close csr_get_date_details;
935: ELSE

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

979: glo_payroll_id := NULL;
980: --
981: END IF;
982: --
983: hr_utility.trace('Leaving extra_assignment_checks');
984: --
985: END extra_assignment_checks1;
986:
987: END hr_nl_extra_asg_rules;