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

Line 148: hr_utility.set_location('Entering:'||l_proc, 5);

144: decode(substr(FLV.TAG,1,1), '+', decode(sign(instr(FLV.TAG, p_legislation_code)), 1, 'Y', 'N'),
145: '-', decode(sign(instr(FLV.TAG, p_legislation_code)), 1, 'N', 'Y'), 'Y' ) ) = 'Y';
146: --
147: begin
148: hr_utility.set_location('Entering:'||l_proc, 5);
149:
150: hr_api.mandatory_arg_error
151: (p_api_name => l_proc
152: ,p_argument => 'category_code'

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

162: fetch csr_valid_category_code into l_category_code;
163:
164: if csr_valid_category_code%notfound then
165: close csr_valid_category_code;
166: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');
167: hr_utility.set_message_token('OBJECT', 'CATEGORY_CODE');
168: hr_utility.set_message_token('TABLE', 'FND_LOOKUP_VALUES');
169: hr_utility.set_message_token('CONDITION', 'lookup type "DOCUMENT CATEGORY"');
170: hr_utility.raise_error;

Line 167: hr_utility.set_message_token('OBJECT', 'CATEGORY_CODE');

163:
164: if csr_valid_category_code%notfound then
165: close csr_valid_category_code;
166: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');
167: hr_utility.set_message_token('OBJECT', 'CATEGORY_CODE');
168: hr_utility.set_message_token('TABLE', 'FND_LOOKUP_VALUES');
169: hr_utility.set_message_token('CONDITION', 'lookup type "DOCUMENT CATEGORY"');
170: hr_utility.raise_error;
171: hr_utility.set_location(l_proc, 10);

Line 168: hr_utility.set_message_token('TABLE', 'FND_LOOKUP_VALUES');

164: if csr_valid_category_code%notfound then
165: close csr_valid_category_code;
166: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');
167: hr_utility.set_message_token('OBJECT', 'CATEGORY_CODE');
168: hr_utility.set_message_token('TABLE', 'FND_LOOKUP_VALUES');
169: hr_utility.set_message_token('CONDITION', 'lookup type "DOCUMENT CATEGORY"');
170: hr_utility.raise_error;
171: hr_utility.set_location(l_proc, 10);
172: --

Line 169: hr_utility.set_message_token('CONDITION', 'lookup type "DOCUMENT CATEGORY"');

165: close csr_valid_category_code;
166: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');
167: hr_utility.set_message_token('OBJECT', 'CATEGORY_CODE');
168: hr_utility.set_message_token('TABLE', 'FND_LOOKUP_VALUES');
169: hr_utility.set_message_token('CONDITION', 'lookup type "DOCUMENT CATEGORY"');
170: hr_utility.raise_error;
171: hr_utility.set_location(l_proc, 10);
172: --
173: else

Line 170: hr_utility.raise_error;

166: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');
167: hr_utility.set_message_token('OBJECT', 'CATEGORY_CODE');
168: hr_utility.set_message_token('TABLE', 'FND_LOOKUP_VALUES');
169: hr_utility.set_message_token('CONDITION', 'lookup type "DOCUMENT CATEGORY"');
170: hr_utility.raise_error;
171: hr_utility.set_location(l_proc, 10);
172: --
173: else
174: close csr_valid_category_code;

Line 171: hr_utility.set_location(l_proc, 10);

167: hr_utility.set_message_token('OBJECT', 'CATEGORY_CODE');
168: hr_utility.set_message_token('TABLE', 'FND_LOOKUP_VALUES');
169: hr_utility.set_message_token('CONDITION', 'lookup type "DOCUMENT CATEGORY"');
170: hr_utility.raise_error;
171: hr_utility.set_location(l_proc, 10);
172: --
173: else
174: close csr_valid_category_code;
175:

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

173: else
174: close csr_valid_category_code;
175:
176: end if;
177: hr_utility.set_location(l_proc, 20);
178: --
179:
180: exception
181: when app_exception.application_exception then

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

181: when app_exception.application_exception then
182: if hr_multi_message.exception_add
183: (p_associated_column1 => 'hr_document_types.category_code'
184: ) then
185: hr_utility.set_location('Leaving:'||l_proc, 50);
186: raise;
187: end if;
188: hr_utility.set_location('Leaving:'||l_proc,60);
189: end chk_category_code;

Line 188: hr_utility.set_location('Leaving:'||l_proc,60);

184: ) then
185: hr_utility.set_location('Leaving:'||l_proc, 50);
186: raise;
187: end if;
188: hr_utility.set_location('Leaving:'||l_proc,60);
189: end chk_category_code;
190: --
191: --
192: -- ----------------------------------------------------------------------------

Line 243: hr_utility.set_location('Entering:'||l_proc, 5);

239: and pst.system_type_cd = p_category_code
240: and pst.shared_type_code = p_sub_category_cd;
241: --
242: begin
243: hr_utility.set_location('Entering:'||l_proc, 5);
244:
245:
246: --
247: -- Check that the Category Code

Line 258: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');

254:
255: if csr_valid_sub_category_code%notfound then
256: close csr_valid_sub_category_code;
257:
258: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');
259: hr_utility.set_message_token('OBJECT', 'SUB_CATEGORY_CODE');
260: hr_utility.set_message_token('TABLE', 'PER_SHARED_TYPES');
261: hr_utility.set_message_token('CONDITION', 'lookup type "DOCUMENT CATEGORY"');
262: hr_utility.raise_error;

Line 259: hr_utility.set_message_token('OBJECT', 'SUB_CATEGORY_CODE');

255: if csr_valid_sub_category_code%notfound then
256: close csr_valid_sub_category_code;
257:
258: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');
259: hr_utility.set_message_token('OBJECT', 'SUB_CATEGORY_CODE');
260: hr_utility.set_message_token('TABLE', 'PER_SHARED_TYPES');
261: hr_utility.set_message_token('CONDITION', 'lookup type "DOCUMENT CATEGORY"');
262: hr_utility.raise_error;
263: hr_utility.set_location(l_proc, 10);

Line 260: hr_utility.set_message_token('TABLE', 'PER_SHARED_TYPES');

256: close csr_valid_sub_category_code;
257:
258: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');
259: hr_utility.set_message_token('OBJECT', 'SUB_CATEGORY_CODE');
260: hr_utility.set_message_token('TABLE', 'PER_SHARED_TYPES');
261: hr_utility.set_message_token('CONDITION', 'lookup type "DOCUMENT CATEGORY"');
262: hr_utility.raise_error;
263: hr_utility.set_location(l_proc, 10);
264: --

Line 261: hr_utility.set_message_token('CONDITION', 'lookup type "DOCUMENT CATEGORY"');

257:
258: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');
259: hr_utility.set_message_token('OBJECT', 'SUB_CATEGORY_CODE');
260: hr_utility.set_message_token('TABLE', 'PER_SHARED_TYPES');
261: hr_utility.set_message_token('CONDITION', 'lookup type "DOCUMENT CATEGORY"');
262: hr_utility.raise_error;
263: hr_utility.set_location(l_proc, 10);
264: --
265: else

Line 262: hr_utility.raise_error;

258: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');
259: hr_utility.set_message_token('OBJECT', 'SUB_CATEGORY_CODE');
260: hr_utility.set_message_token('TABLE', 'PER_SHARED_TYPES');
261: hr_utility.set_message_token('CONDITION', 'lookup type "DOCUMENT CATEGORY"');
262: hr_utility.raise_error;
263: hr_utility.set_location(l_proc, 10);
264: --
265: else
266: close csr_valid_sub_category_code;

Line 263: hr_utility.set_location(l_proc, 10);

259: hr_utility.set_message_token('OBJECT', 'SUB_CATEGORY_CODE');
260: hr_utility.set_message_token('TABLE', 'PER_SHARED_TYPES');
261: hr_utility.set_message_token('CONDITION', 'lookup type "DOCUMENT CATEGORY"');
262: hr_utility.raise_error;
263: hr_utility.set_location(l_proc, 10);
264: --
265: else
266: close csr_valid_sub_category_code;
267:

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

266: close csr_valid_sub_category_code;
267:
268: end if;
269: end if;
270: hr_utility.set_location(l_proc, 20);
271: --
272:
273: exception
274: when app_exception.application_exception then

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

274: when app_exception.application_exception then
275: if hr_multi_message.exception_add
276: (p_associated_column1 => 'hr_document_types.sub_category_code'
277: ) then
278: hr_utility.set_location('Leaving:'||l_proc, 50);
279: raise;
280: end if;
281: hr_utility.set_location('Leaving:'||l_proc,60);
282: end chk_sub_category_code;

Line 281: hr_utility.set_location('Leaving:'||l_proc,60);

277: ) then
278: hr_utility.set_location('Leaving:'||l_proc, 50);
279: raise;
280: end if;
281: hr_utility.set_location('Leaving:'||l_proc,60);
282: end chk_sub_category_code;
283: --
284: -- ----------------------------------------------------------------------------
285: -- |-------------------------< chk_active_flag >------------------------|

Line 333: hr_utility.set_location('Entering:'||l_proc, 5);

329:
330:
331: --
332: begin
333: hr_utility.set_location('Entering:'||l_proc, 5);
334:
335:
336: hr_api.mandatory_arg_error
337: (p_api_name => l_proc

Line 347: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');

343: open csr_valid_active_flag(p_active_flag);
344: fetch csr_valid_active_flag into l_active_flag;
345: if csr_valid_active_flag%notfound then
346: close csr_valid_active_flag;
347: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');
348: hr_utility.set_message_token('OBJECT', 'ACTIVE_FLAG');
349: hr_utility.set_message_token('TABLE', 'HR_STANDARD_LOOKUPS');
350: hr_utility.set_message_token('CONDITION', 'lookup type "YES_NO"');
351: hr_utility.raise_error;

Line 348: hr_utility.set_message_token('OBJECT', 'ACTIVE_FLAG');

344: fetch csr_valid_active_flag into l_active_flag;
345: if csr_valid_active_flag%notfound then
346: close csr_valid_active_flag;
347: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');
348: hr_utility.set_message_token('OBJECT', 'ACTIVE_FLAG');
349: hr_utility.set_message_token('TABLE', 'HR_STANDARD_LOOKUPS');
350: hr_utility.set_message_token('CONDITION', 'lookup type "YES_NO"');
351: hr_utility.raise_error;
352: hr_utility.set_location(l_proc, 10);

Line 349: hr_utility.set_message_token('TABLE', 'HR_STANDARD_LOOKUPS');

345: if csr_valid_active_flag%notfound then
346: close csr_valid_active_flag;
347: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');
348: hr_utility.set_message_token('OBJECT', 'ACTIVE_FLAG');
349: hr_utility.set_message_token('TABLE', 'HR_STANDARD_LOOKUPS');
350: hr_utility.set_message_token('CONDITION', 'lookup type "YES_NO"');
351: hr_utility.raise_error;
352: hr_utility.set_location(l_proc, 10);
353: --

Line 350: hr_utility.set_message_token('CONDITION', 'lookup type "YES_NO"');

346: close csr_valid_active_flag;
347: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');
348: hr_utility.set_message_token('OBJECT', 'ACTIVE_FLAG');
349: hr_utility.set_message_token('TABLE', 'HR_STANDARD_LOOKUPS');
350: hr_utility.set_message_token('CONDITION', 'lookup type "YES_NO"');
351: hr_utility.raise_error;
352: hr_utility.set_location(l_proc, 10);
353: --
354: else

Line 351: hr_utility.raise_error;

347: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');
348: hr_utility.set_message_token('OBJECT', 'ACTIVE_FLAG');
349: hr_utility.set_message_token('TABLE', 'HR_STANDARD_LOOKUPS');
350: hr_utility.set_message_token('CONDITION', 'lookup type "YES_NO"');
351: hr_utility.raise_error;
352: hr_utility.set_location(l_proc, 10);
353: --
354: else
355: close csr_valid_active_flag;

Line 352: hr_utility.set_location(l_proc, 10);

348: hr_utility.set_message_token('OBJECT', 'ACTIVE_FLAG');
349: hr_utility.set_message_token('TABLE', 'HR_STANDARD_LOOKUPS');
350: hr_utility.set_message_token('CONDITION', 'lookup type "YES_NO"');
351: hr_utility.raise_error;
352: hr_utility.set_location(l_proc, 10);
353: --
354: else
355: close csr_valid_active_flag;
356: end if;

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

353: --
354: else
355: close csr_valid_active_flag;
356: end if;
357: hr_utility.set_location(l_proc, 20);
358:
359: exception
360: when app_exception.application_exception then
361: if hr_multi_message.exception_add

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

360: when app_exception.application_exception then
361: if hr_multi_message.exception_add
362: (p_same_associated_columns => 'Y'
363: ) then
364: hr_utility.set_location('Leaving:'||l_proc, 50);
365: raise;
366: end if;
367: hr_utility.set_location('Leaving:'||l_proc,60);
368: end chk_active_flag;

Line 367: hr_utility.set_location('Leaving:'||l_proc,60);

363: ) then
364: hr_utility.set_location('Leaving:'||l_proc, 50);
365: raise;
366: end if;
367: hr_utility.set_location('Leaving:'||l_proc,60);
368: end chk_active_flag;
369: --
370:
371: --

Line 421: hr_utility.set_location('Entering:'||l_proc, 5);

417: and lookup_code = p_mul_occ_flag;
418:
419: --
420: begin
421: hr_utility.set_location('Entering:'||l_proc, 5);
422:
423:
424: hr_api.mandatory_arg_error
425: (p_api_name => l_proc

Line 437: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');

433: fetch csr_valid_mul_occurence_flag into l_multiple_occurence_flag;
434: if csr_valid_mul_occurence_flag%notfound then
435: close csr_valid_mul_occurence_flag;
436:
437: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');
438: hr_utility.set_message_token('OBJECT', 'MULTIPLE_OCCURENCES_FLAG');
439: hr_utility.set_message_token('TABLE', 'HR_STANDARD_LOOKUPS');
440: hr_utility.set_message_token('CONDITION', 'lookup type "YES_NO"');
441: hr_utility.raise_error;

Line 438: hr_utility.set_message_token('OBJECT', 'MULTIPLE_OCCURENCES_FLAG');

434: if csr_valid_mul_occurence_flag%notfound then
435: close csr_valid_mul_occurence_flag;
436:
437: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');
438: hr_utility.set_message_token('OBJECT', 'MULTIPLE_OCCURENCES_FLAG');
439: hr_utility.set_message_token('TABLE', 'HR_STANDARD_LOOKUPS');
440: hr_utility.set_message_token('CONDITION', 'lookup type "YES_NO"');
441: hr_utility.raise_error;
442: hr_utility.set_location(l_proc, 10);

Line 439: hr_utility.set_message_token('TABLE', 'HR_STANDARD_LOOKUPS');

435: close csr_valid_mul_occurence_flag;
436:
437: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');
438: hr_utility.set_message_token('OBJECT', 'MULTIPLE_OCCURENCES_FLAG');
439: hr_utility.set_message_token('TABLE', 'HR_STANDARD_LOOKUPS');
440: hr_utility.set_message_token('CONDITION', 'lookup type "YES_NO"');
441: hr_utility.raise_error;
442: hr_utility.set_location(l_proc, 10);
443: --

Line 440: hr_utility.set_message_token('CONDITION', 'lookup type "YES_NO"');

436:
437: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');
438: hr_utility.set_message_token('OBJECT', 'MULTIPLE_OCCURENCES_FLAG');
439: hr_utility.set_message_token('TABLE', 'HR_STANDARD_LOOKUPS');
440: hr_utility.set_message_token('CONDITION', 'lookup type "YES_NO"');
441: hr_utility.raise_error;
442: hr_utility.set_location(l_proc, 10);
443: --
444: else

Line 441: hr_utility.raise_error;

437: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');
438: hr_utility.set_message_token('OBJECT', 'MULTIPLE_OCCURENCES_FLAG');
439: hr_utility.set_message_token('TABLE', 'HR_STANDARD_LOOKUPS');
440: hr_utility.set_message_token('CONDITION', 'lookup type "YES_NO"');
441: hr_utility.raise_error;
442: hr_utility.set_location(l_proc, 10);
443: --
444: else
445: close csr_valid_mul_occurence_flag;

Line 442: hr_utility.set_location(l_proc, 10);

438: hr_utility.set_message_token('OBJECT', 'MULTIPLE_OCCURENCES_FLAG');
439: hr_utility.set_message_token('TABLE', 'HR_STANDARD_LOOKUPS');
440: hr_utility.set_message_token('CONDITION', 'lookup type "YES_NO"');
441: hr_utility.raise_error;
442: hr_utility.set_location(l_proc, 10);
443: --
444: else
445: close csr_valid_mul_occurence_flag;
446:

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

444: else
445: close csr_valid_mul_occurence_flag;
446:
447: end if;
448: hr_utility.set_location(l_proc, 20);
449: --
450:
451: exception
452: when app_exception.application_exception then

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

452: when app_exception.application_exception then
453: if hr_multi_message.exception_add
454: (p_same_associated_columns => 'Y'
455: ) then
456: hr_utility.set_location('Leaving:'||l_proc, 50);
457: raise;
458: end if;
459: hr_utility.set_location('Leaving:'||l_proc,60);
460: end chk_multiple_occurence_flag;

Line 459: hr_utility.set_location('Leaving:'||l_proc,60);

455: ) then
456: hr_utility.set_location('Leaving:'||l_proc, 50);
457: raise;
458: end if;
459: hr_utility.set_location('Leaving:'||l_proc,60);
460: end chk_multiple_occurence_flag;
461: --
462: --
463: -- ----------------------------------------------------------------------------

Line 510: hr_utility.set_location('Entering:'||l_proc, 5);

506: where TERRITORY_CODE = p_legislation_code;
507:
508: --
509: begin
510: hr_utility.set_location('Entering:'||l_proc, 5);
511:
512: --
513: if(p_legislation_code is NOT NULL) then
514: open csr_valid_leg_code;

Line 518: hr_utility.set_message(800, 'HR_449710_DOR_INVL_VAL');

514: open csr_valid_leg_code;
515: fetch csr_valid_leg_code into l_legislation_code;
516: if csr_valid_leg_code%notfound then
517: close csr_valid_leg_code;
518: hr_utility.set_message(800, 'HR_449710_DOR_INVL_VAL');
519: hr_utility.set_message_token('OBJECT', 'LEGISLATION_CODE');
520: hr_utility.set_message_token('TABLE', 'FND_TERRITORIES');
521: hr_utility.raise_error;
522: hr_utility.set_location(l_proc, 10);

Line 519: hr_utility.set_message_token('OBJECT', 'LEGISLATION_CODE');

515: fetch csr_valid_leg_code into l_legislation_code;
516: if csr_valid_leg_code%notfound then
517: close csr_valid_leg_code;
518: hr_utility.set_message(800, 'HR_449710_DOR_INVL_VAL');
519: hr_utility.set_message_token('OBJECT', 'LEGISLATION_CODE');
520: hr_utility.set_message_token('TABLE', 'FND_TERRITORIES');
521: hr_utility.raise_error;
522: hr_utility.set_location(l_proc, 10);
523: --

Line 520: hr_utility.set_message_token('TABLE', 'FND_TERRITORIES');

516: if csr_valid_leg_code%notfound then
517: close csr_valid_leg_code;
518: hr_utility.set_message(800, 'HR_449710_DOR_INVL_VAL');
519: hr_utility.set_message_token('OBJECT', 'LEGISLATION_CODE');
520: hr_utility.set_message_token('TABLE', 'FND_TERRITORIES');
521: hr_utility.raise_error;
522: hr_utility.set_location(l_proc, 10);
523: --
524: else

Line 521: hr_utility.raise_error;

517: close csr_valid_leg_code;
518: hr_utility.set_message(800, 'HR_449710_DOR_INVL_VAL');
519: hr_utility.set_message_token('OBJECT', 'LEGISLATION_CODE');
520: hr_utility.set_message_token('TABLE', 'FND_TERRITORIES');
521: hr_utility.raise_error;
522: hr_utility.set_location(l_proc, 10);
523: --
524: else
525: close csr_valid_leg_code;

Line 522: hr_utility.set_location(l_proc, 10);

518: hr_utility.set_message(800, 'HR_449710_DOR_INVL_VAL');
519: hr_utility.set_message_token('OBJECT', 'LEGISLATION_CODE');
520: hr_utility.set_message_token('TABLE', 'FND_TERRITORIES');
521: hr_utility.raise_error;
522: hr_utility.set_location(l_proc, 10);
523: --
524: else
525: close csr_valid_leg_code;
526:

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

525: close csr_valid_leg_code;
526:
527: end if;
528: end if;
529: hr_utility.set_location(l_proc, 20);
530: --
531:
532: exception
533: when app_exception.application_exception then

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

533: when app_exception.application_exception then
534: if hr_multi_message.exception_add
535: (p_same_associated_columns => 'Y'
536: ) then
537: hr_utility.set_location('Leaving:'||l_proc, 50);
538: raise;
539: end if;
540: hr_utility.set_location('Leaving:'||l_proc,60);
541: end chk_legislation_code;

Line 540: hr_utility.set_location('Leaving:'||l_proc,60);

536: ) then
537: hr_utility.set_location('Leaving:'||l_proc, 50);
538: raise;
539: end if;
540: hr_utility.set_location('Leaving:'||l_proc,60);
541: end chk_legislation_code;
542: --
543: --
544: -- ----------------------------------------------------------------------------

Line 593: hr_utility.set_location('Entering:'||l_proc, 5);

589: and lookup_code = p_auth_code;
590:
591: --
592: begin
593: hr_utility.set_location('Entering:'||l_proc, 5);
594:
595:
596: hr_api.mandatory_arg_error
597: (p_api_name => l_proc

Line 608: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');

604: open csr_valid_auth_code(p_authorization_required);
605: fetch csr_valid_auth_code into l_auth_code;
606: if csr_valid_auth_code%notfound then
607: close csr_valid_auth_code;
608: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');
609: hr_utility.set_message_token('OBJECT', 'AUTHORIZATION_REQUIRED');
610: hr_utility.set_message_token('TABLE', 'HR_STANDARD_LOOKUPS');
611: hr_utility.set_message_token('CONDITION', 'lookup type "YES_NO"');
612: hr_utility.raise_error;

Line 609: hr_utility.set_message_token('OBJECT', 'AUTHORIZATION_REQUIRED');

605: fetch csr_valid_auth_code into l_auth_code;
606: if csr_valid_auth_code%notfound then
607: close csr_valid_auth_code;
608: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');
609: hr_utility.set_message_token('OBJECT', 'AUTHORIZATION_REQUIRED');
610: hr_utility.set_message_token('TABLE', 'HR_STANDARD_LOOKUPS');
611: hr_utility.set_message_token('CONDITION', 'lookup type "YES_NO"');
612: hr_utility.raise_error;
613: hr_utility.set_location(l_proc, 10);

Line 610: hr_utility.set_message_token('TABLE', 'HR_STANDARD_LOOKUPS');

606: if csr_valid_auth_code%notfound then
607: close csr_valid_auth_code;
608: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');
609: hr_utility.set_message_token('OBJECT', 'AUTHORIZATION_REQUIRED');
610: hr_utility.set_message_token('TABLE', 'HR_STANDARD_LOOKUPS');
611: hr_utility.set_message_token('CONDITION', 'lookup type "YES_NO"');
612: hr_utility.raise_error;
613: hr_utility.set_location(l_proc, 10);
614: --

Line 611: hr_utility.set_message_token('CONDITION', 'lookup type "YES_NO"');

607: close csr_valid_auth_code;
608: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');
609: hr_utility.set_message_token('OBJECT', 'AUTHORIZATION_REQUIRED');
610: hr_utility.set_message_token('TABLE', 'HR_STANDARD_LOOKUPS');
611: hr_utility.set_message_token('CONDITION', 'lookup type "YES_NO"');
612: hr_utility.raise_error;
613: hr_utility.set_location(l_proc, 10);
614: --
615: else

Line 612: hr_utility.raise_error;

608: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');
609: hr_utility.set_message_token('OBJECT', 'AUTHORIZATION_REQUIRED');
610: hr_utility.set_message_token('TABLE', 'HR_STANDARD_LOOKUPS');
611: hr_utility.set_message_token('CONDITION', 'lookup type "YES_NO"');
612: hr_utility.raise_error;
613: hr_utility.set_location(l_proc, 10);
614: --
615: else
616: close csr_valid_auth_code;

Line 613: hr_utility.set_location(l_proc, 10);

609: hr_utility.set_message_token('OBJECT', 'AUTHORIZATION_REQUIRED');
610: hr_utility.set_message_token('TABLE', 'HR_STANDARD_LOOKUPS');
611: hr_utility.set_message_token('CONDITION', 'lookup type "YES_NO"');
612: hr_utility.raise_error;
613: hr_utility.set_location(l_proc, 10);
614: --
615: else
616: close csr_valid_auth_code;
617:

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

615: else
616: close csr_valid_auth_code;
617:
618: end if;
619: hr_utility.set_location(l_proc, 20);
620: --
621:
622: exception
623: when app_exception.application_exception then

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

623: when app_exception.application_exception then
624: if hr_multi_message.exception_add
625: (p_same_associated_columns => 'Y'
626: ) then
627: hr_utility.set_location('Leaving:'||l_proc, 50);
628: raise;
629: end if;
630: hr_utility.set_location('Leaving:'||l_proc,60);
631: end chk_authorization_required;

Line 630: hr_utility.set_location('Leaving:'||l_proc,60);

626: ) then
627: hr_utility.set_location('Leaving:'||l_proc, 50);
628: raise;
629: end if;
630: hr_utility.set_location('Leaving:'||l_proc,60);
631: end chk_authorization_required;
632: --
633: -- ----------------------------------------------------------------------------
634: -- |-------------------------< chk_document_type_delete >------------------------|

Line 689: hr_utility.set_location('Entering:'||l_proc, 5);

685: where hdei.document_type_id = p_document_type;
686:
687: --
688: begin
689: hr_utility.set_location('Entering:'||l_proc, 5);
690:
691: --
692: open get_document_type(p_document_type_id =>p_document_type);
693: fetch get_document_type into l_document_type;

Line 701: hr_utility.set_message(800, 'HR_449715_DOR_DOC_TYP_DEL_VAL');

697: fetch csr_doc_type_delete into l_doc_type;
698: if csr_doc_type_delete%found then
699: close csr_doc_type_delete;
700:
701: hr_utility.set_message(800, 'HR_449715_DOR_DOC_TYP_DEL_VAL');
702: hr_utility.set_message_token('TYPE', l_document_type);
703: hr_utility.set_message_token('TABLE', 'HR_DOCUMENT_EXTRA_INFO');
704: hr_utility.raise_error;
705: hr_utility.set_location(l_proc, 10);

Line 702: hr_utility.set_message_token('TYPE', l_document_type);

698: if csr_doc_type_delete%found then
699: close csr_doc_type_delete;
700:
701: hr_utility.set_message(800, 'HR_449715_DOR_DOC_TYP_DEL_VAL');
702: hr_utility.set_message_token('TYPE', l_document_type);
703: hr_utility.set_message_token('TABLE', 'HR_DOCUMENT_EXTRA_INFO');
704: hr_utility.raise_error;
705: hr_utility.set_location(l_proc, 10);
706: --

Line 703: hr_utility.set_message_token('TABLE', 'HR_DOCUMENT_EXTRA_INFO');

699: close csr_doc_type_delete;
700:
701: hr_utility.set_message(800, 'HR_449715_DOR_DOC_TYP_DEL_VAL');
702: hr_utility.set_message_token('TYPE', l_document_type);
703: hr_utility.set_message_token('TABLE', 'HR_DOCUMENT_EXTRA_INFO');
704: hr_utility.raise_error;
705: hr_utility.set_location(l_proc, 10);
706: --
707: else

Line 704: hr_utility.raise_error;

700:
701: hr_utility.set_message(800, 'HR_449715_DOR_DOC_TYP_DEL_VAL');
702: hr_utility.set_message_token('TYPE', l_document_type);
703: hr_utility.set_message_token('TABLE', 'HR_DOCUMENT_EXTRA_INFO');
704: hr_utility.raise_error;
705: hr_utility.set_location(l_proc, 10);
706: --
707: else
708: close csr_doc_type_delete;

Line 705: hr_utility.set_location(l_proc, 10);

701: hr_utility.set_message(800, 'HR_449715_DOR_DOC_TYP_DEL_VAL');
702: hr_utility.set_message_token('TYPE', l_document_type);
703: hr_utility.set_message_token('TABLE', 'HR_DOCUMENT_EXTRA_INFO');
704: hr_utility.raise_error;
705: hr_utility.set_location(l_proc, 10);
706: --
707: else
708: close csr_doc_type_delete;
709:

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

707: else
708: close csr_doc_type_delete;
709:
710: end if;
711: hr_utility.set_location(l_proc, 20);
712: --
713:
714: exception
715: when app_exception.application_exception then

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

715: when app_exception.application_exception then
716: if hr_multi_message.exception_add
717: (p_same_associated_columns => 'Y'
718: ) then
719: hr_utility.set_location('Leaving:'||l_proc, 50);
720: raise;
721: end if;
722: hr_utility.set_location('Leaving:'||l_proc,60);
723: end chk_document_type_delete;

Line 722: hr_utility.set_location('Leaving:'||l_proc,60);

718: ) then
719: hr_utility.set_location('Leaving:'||l_proc, 50);
720: raise;
721: end if;
722: hr_utility.set_location('Leaving:'||l_proc,60);
723: end chk_document_type_delete;
724: --
725: -- ----------------------------------------------------------------------------
726: -- |---------------------------< insert_validate >----------------------------|

Line 736: hr_utility.set_location('Entering:'||l_proc, 5);

732: --
733: l_proc varchar2(72) := g_package||'insert_validate';
734: --
735: Begin
736: hr_utility.set_location('Entering:'||l_proc, 5);
737: --
738: -- Call all supporting business operations
739: --
740: --

Line 781: hr_utility.set_location(' Leaving:'||l_proc, 10);

777: (
778: p_authorization_required => p_rec.authorization_required
779: );
780:
781: hr_utility.set_location(' Leaving:'||l_proc, 10);
782: End insert_validate;
783: --
784: -- ----------------------------------------------------------------------------
785: -- |---------------------------< update_validate >----------------------------|

Line 795: hr_utility.set_location('Entering:'||l_proc, 5);

791: --
792: l_proc varchar2(72) := g_package||'update_validate';
793: --
794: Begin
795: hr_utility.set_location('Entering:'||l_proc, 5);
796: --
797: -- Call all supporting business operations
798: --
799: -- "-- No business group context. HR_STANDARD_LOOKUPS used for validation."

Line 832: hr_utility.set_location(' Leaving:'||l_proc, 10);

828: chk_authorization_required
829: (
830: p_authorization_required => p_rec.authorization_required
831: );
832: hr_utility.set_location(' Leaving:'||l_proc, 10);
833: End update_validate;
834: --
835: -- ----------------------------------------------------------------------------
836: -- |---------------------------< delete_validate >----------------------------|

Line 845: hr_utility.set_location('Entering:'||l_proc, 5);

841: --
842: l_proc varchar2(72) := g_package||'delete_validate';
843: --
844: Begin
845: hr_utility.set_location('Entering:'||l_proc, 5);
846: --
847: -- Call all supporting business operations
848: chk_document_type_delete
849: (

Line 853: hr_utility.set_location(' Leaving:'||l_proc, 10);

849: (
850: p_document_type => p_rec.document_type_id
851: );
852: --
853: hr_utility.set_location(' Leaving:'||l_proc, 10);
854: End delete_validate;
855: --
856: end hr_dty_bus;
857: