APPS.PAY_US_SQWL_UDF dependencies on HR_UTILITY

Line 212: hr_utility.set_location('Entering:'||l_proc, 10);

208: --
209:
210: BEGIN
211: --
212: hr_utility.set_location('Entering:'||l_proc, 10);
213: --
214:
215: IF p_org_information_context = 'PAY_US_STATE_WAGE_PLAN_INFO'
216: AND p_org_information1 = 'CA' THEN

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

225:
226:
227: END LOOP;
228:
229: hr_utility.set_location(l_proc, 20);
230:
231:
232: --
233: -- raise error if the count > 1 or count = 0

Line 238: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');

234: --
235:
236: IF l_count <> 1 THEN
237:
238: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
239: hr_utility.set_message_token('FORMAT',' with at least 1 and only 1 marked as default');
240:
241: hr_utility.raise_error;
242:

Line 239: hr_utility.set_message_token('FORMAT',' with at least 1 and only 1 marked as default');

235:
236: IF l_count <> 1 THEN
237:
238: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
239: hr_utility.set_message_token('FORMAT',' with at least 1 and only 1 marked as default');
240:
241: hr_utility.raise_error;
242:
243: END IF;

Line 241: hr_utility.raise_error;

237:
238: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
239: hr_utility.set_message_token('FORMAT',' with at least 1 and only 1 marked as default');
240:
241: hr_utility.raise_error;
242:
243: END IF;
244:
245:

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

251:
252:
253: END LOOP;
254:
255: hr_utility.set_location(l_proc, 20);
256:
257:
258: --
259: -- raise error if the count > 1 or count = 0

Line 264: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');

260: --
261:
262: IF l_count > 0 THEN
263:
264: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
265: hr_utility.set_message_token('FORMAT',' with unique tax type and state code');
266:
267: hr_utility.raise_error;
268:

Line 265: hr_utility.set_message_token('FORMAT',' with unique tax type and state code');

261:
262: IF l_count > 0 THEN
263:
264: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
265: hr_utility.set_message_token('FORMAT',' with unique tax type and state code');
266:
267: hr_utility.raise_error;
268:
269: END IF;

Line 267: hr_utility.raise_error;

263:
264: hr_utility.set_message(801, 'PAY_7024_USERTAB_BAD_ROW_VALUE');
265: hr_utility.set_message_token('FORMAT',' with unique tax type and state code');
266:
267: hr_utility.raise_error;
268:
269: END IF;
270:
271:

Line 275: hr_utility.set_location(' Leaving:'||l_proc, 50);

271:
272: END IF;
273:
274: --
275: hr_utility.set_location(' Leaving:'||l_proc, 50);
276: --
277: END chk_for_default_wp;
278: --
279:

Line 326: hr_utility.set_location('Entering:'||l_proc, 10);

322: --
323:
324: BEGIN
325: --
326: hr_utility.set_location('Entering:'||l_proc, 10);
327: --
328:
329: IF p_tax_unit_id IS NOT NULL THEN
330: l_tax_unit_id := p_tax_unit_id;

Line 349: hr_utility.set_location(' Leaving:'||l_proc, 50);

345: l_yes_no := FALSE;
346: END IF;
347: END LOOP;
348: --
349: hr_utility.set_location(' Leaving:'||l_proc, 50);
350: --
351:
352: RETURN l_yes_no;
353:

Line 388: hr_utility.set_location('Entering:'||l_proc, 10);

384: --
385:
386: BEGIN
387: --
388: hr_utility.set_location('Entering:'||l_proc, 10);
389: --
390:
391: IF p_ss_wh = 0 and p_medicare_wh > 0 THEN
392: l_code := 'Q';

Line 398: hr_utility.set_location(' Leaving:'||l_proc, 50);

394: l_code := 'R';
395: END IF;
396:
397: --
398: hr_utility.set_location(' Leaving:'||l_proc, 50);
399: --
400:
401: RETURN l_code;
402:

Line 451: hr_utility.set_location('Entering:'||l_proc, 10);

447: AND arch.context1 = p_assignment_action_id;
448:
449: BEGIN
450: --
451: hr_utility.set_location('Entering:'||l_proc, 10);
452: --
453:
454:
455: -- Get the user entity id for A_ASG_GRE_EMPLOYMENT_TYPE_CODE

Line 477: hr_utility.set_location(' Leaving:'||l_proc, 50);

473:
474: END LOOP;
475:
476: --
477: hr_utility.set_location(' Leaving:'||l_proc, 50);
478: --
479:
480: RETURN l_code;
481: