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_OPT_BUS dependencies on FND_MESSAGE

Line 59: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

55: IF NOT hr_opt_shd.api_updating
56: (p_option_id => p_rec.option_id
57: ,p_object_version_number => p_rec.object_version_number
58: ) THEN
59: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
60: fnd_message.set_token('PROCEDURE ', l_proc);
61: fnd_message.set_token('STEP ', '5');
62: fnd_message.raise_error;
63: END IF;

Line 60: fnd_message.set_token('PROCEDURE ', l_proc);

56: (p_option_id => p_rec.option_id
57: ,p_object_version_number => p_rec.object_version_number
58: ) THEN
59: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
60: fnd_message.set_token('PROCEDURE ', l_proc);
61: fnd_message.set_token('STEP ', '5');
62: fnd_message.raise_error;
63: END IF;
64:

Line 61: fnd_message.set_token('STEP ', '5');

57: ,p_object_version_number => p_rec.object_version_number
58: ) THEN
59: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
60: fnd_message.set_token('PROCEDURE ', l_proc);
61: fnd_message.set_token('STEP ', '5');
62: fnd_message.raise_error;
63: END IF;
64:
65: if nvl(p_rec.option_type_id, hr_api.g_number) <>

Line 62: fnd_message.raise_error;

58: ) THEN
59: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
60: fnd_message.set_token('PROCEDURE ', l_proc);
61: fnd_message.set_token('STEP ', '5');
62: fnd_message.raise_error;
63: END IF;
64:
65: if nvl(p_rec.option_type_id, hr_api.g_number) <>
66: nvl(hr_opt_shd.g_old_rec.option_type_id

Line 161: fnd_message.set_name('PER','PER_449953_OPT_OP_TY_ID_ABSENT');

157: fetch csr_name into l_key;
158: hr_utility.set_location('After fetching:'||l_proc,20);
159: if (csr_name%notfound) then
160: close csr_name;
161: fnd_message.set_name('PER','PER_449953_OPT_OP_TY_ID_ABSENT');
162: fnd_message.raise_error;
163: end if;
164:
165: close csr_name;

Line 162: fnd_message.raise_error;

158: hr_utility.set_location('After fetching:'||l_proc,20);
159: if (csr_name%notfound) then
160: close csr_name;
161: fnd_message.set_name('PER','PER_449953_OPT_OP_TY_ID_ABSENT');
162: fnd_message.raise_error;
163: end if;
164:
165: close csr_name;
166:

Line 227: fnd_message.set_name('PER', 'PER_449956_OPT_OP_LEV_INVALID');

223: (p_effective_date => p_effective_date
224: ,p_lookup_type => 'HR_KPI_OPTION_LEVEL'
225: ,p_lookup_code => p_option_level
226: ) then
227: fnd_message.set_name('PER', 'PER_449956_OPT_OP_LEV_INVALID');
228: fnd_message.raise_error;
229: end if;
230:
231: exception

Line 228: fnd_message.raise_error;

224: ,p_lookup_type => 'HR_KPI_OPTION_LEVEL'
225: ,p_lookup_code => p_option_level
226: ) then
227: fnd_message.set_name('PER', 'PER_449956_OPT_OP_LEV_INVALID');
228: fnd_message.raise_error;
229: end if;
230:
231: exception
232: when app_exception.application_exception then

Line 346: fnd_message.set_name('PER','PER_449958_OPT_OP_APP_ID_ERR');

342: open fnd_app;
343: fetch fnd_app into l_app_id;
344: if (fnd_app%notfound)then
345: close fnd_app;
346: fnd_message.set_name('PER','PER_449958_OPT_OP_APP_ID_ERR');
347: fnd_message.raise_error;
348: end if;
349: close fnd_app;
350:

Line 347: fnd_message.raise_error;

343: fetch fnd_app into l_app_id;
344: if (fnd_app%notfound)then
345: close fnd_app;
346: fnd_message.set_name('PER','PER_449958_OPT_OP_APP_ID_ERR');
347: fnd_message.raise_error;
348: end if;
349: close fnd_app;
350:
351: --if level is responsibility

Line 367: fnd_message.set_name('PER','PER_449959_OPT_OP_RESP_ID_ERR');

363: for i in 0 .. 9 loop
364: l_temp_option_level_id := replace(l_temp_option_level_id, i, '');
365: end loop;
366: if(l_temp_option_level_id is not null) then
367: fnd_message.set_name('PER','PER_449959_OPT_OP_RESP_ID_ERR');
368: fnd_message.raise_error;
369: end if;
370:
371: --throw error if No occurance of ':'

Line 368: fnd_message.raise_error;

364: l_temp_option_level_id := replace(l_temp_option_level_id, i, '');
365: end loop;
366: if(l_temp_option_level_id is not null) then
367: fnd_message.set_name('PER','PER_449959_OPT_OP_RESP_ID_ERR');
368: fnd_message.raise_error;
369: end if;
370:
371: --throw error if No occurance of ':'
372: if (instr(p_option_level_id,l_separator) = 0) then

Line 373: fnd_message.set_name('PER','PER_449959_OPT_OP_RESP_ID_ERR');

369: end if;
370:
371: --throw error if No occurance of ':'
372: if (instr(p_option_level_id,l_separator) = 0) then
373: fnd_message.set_name('PER','PER_449959_OPT_OP_RESP_ID_ERR');
374: fnd_message.raise_error;
375: end if;
376:
377: --get the values

Line 374: fnd_message.raise_error;

370:
371: --throw error if No occurance of ':'
372: if (instr(p_option_level_id,l_separator) = 0) then
373: fnd_message.set_name('PER','PER_449959_OPT_OP_RESP_ID_ERR');
374: fnd_message.raise_error;
375: end if;
376:
377: --get the values
378: l_responsibility_id:=to_number(substr(p_option_level_id,1,

Line 385: fnd_message.set_name('PER','PER_449959_OPT_OP_RESP_ID_ERR');

381: l_application_id:=to_number(substr(p_option_level_id,
382: instr(p_option_level_id,l_separator)+1));
383:
384: if l_responsibility_id is null then
385: fnd_message.set_name('PER','PER_449959_OPT_OP_RESP_ID_ERR');
386: fnd_message.raise_error;
387: end if;
388:
389: if l_application_id is null then

Line 386: fnd_message.raise_error;

382: instr(p_option_level_id,l_separator)+1));
383:
384: if l_responsibility_id is null then
385: fnd_message.set_name('PER','PER_449959_OPT_OP_RESP_ID_ERR');
386: fnd_message.raise_error;
387: end if;
388:
389: if l_application_id is null then
390: fnd_message.set_name('PER','PER_449959_OPT_OP_RESP_ID_ERR');

Line 390: fnd_message.set_name('PER','PER_449959_OPT_OP_RESP_ID_ERR');

386: fnd_message.raise_error;
387: end if;
388:
389: if l_application_id is null then
390: fnd_message.set_name('PER','PER_449959_OPT_OP_RESP_ID_ERR');
391: fnd_message.raise_error;
392: end if;
393:
394: --open cursor with extracted values

Line 391: fnd_message.raise_error;

387: end if;
388:
389: if l_application_id is null then
390: fnd_message.set_name('PER','PER_449959_OPT_OP_RESP_ID_ERR');
391: fnd_message.raise_error;
392: end if;
393:
394: --open cursor with extracted values
395: open fnd_resp(l_application_id,l_responsibility_id);

Line 399: fnd_message.set_name('PER','PER_449959_OPT_OP_RESP_ID_ERR');

395: open fnd_resp(l_application_id,l_responsibility_id);
396: fetch fnd_resp into l_resp_id;
397: if (fnd_resp%notfound)then
398: close fnd_resp;
399: fnd_message.set_name('PER','PER_449959_OPT_OP_RESP_ID_ERR');
400: fnd_message.raise_error;
401: END IF;
402: close fnd_resp;
403:

Line 400: fnd_message.raise_error;

396: fetch fnd_resp into l_resp_id;
397: if (fnd_resp%notfound)then
398: close fnd_resp;
399: fnd_message.set_name('PER','PER_449959_OPT_OP_RESP_ID_ERR');
400: fnd_message.raise_error;
401: END IF;
402: close fnd_resp;
403:
404: --if level is User

Line 412: fnd_message.set_name('PER','PER_449960_OPT_OP_US_ID_ERR');

408: open fnd_us;
409: fetch fnd_us into l_user_id;
410: if (fnd_us%notfound)then
411: close fnd_us;
412: fnd_message.set_name('PER','PER_449960_OPT_OP_US_ID_ERR');
413: fnd_message.raise_error;
414: END IF;
415: close fnd_us;
416:

Line 413: fnd_message.raise_error;

409: fetch fnd_us into l_user_id;
410: if (fnd_us%notfound)then
411: close fnd_us;
412: fnd_message.set_name('PER','PER_449960_OPT_OP_US_ID_ERR');
413: fnd_message.raise_error;
414: END IF;
415: close fnd_us;
416:
417: end if;

Line 422: fnd_message.set_name('PER','PER_449957_OPT_OP_LE_ID_INVAL');

418:
419: --IF level is SITE then option_level_id must be null
420: else
421: IF p_option_level_id is not null THEN
422: fnd_message.set_name('PER','PER_449957_OPT_OP_LE_ID_INVAL');
423: fnd_message.raise_error;
424: END IF;
425:
426: END IF;

Line 423: fnd_message.raise_error;

419: --IF level is SITE then option_level_id must be null
420: else
421: IF p_option_level_id is not null THEN
422: fnd_message.set_name('PER','PER_449957_OPT_OP_LE_ID_INVAL');
423: fnd_message.raise_error;
424: END IF;
425:
426: END IF;
427:

Line 485: fnd_message.set_name('PER', 'PER_449954_OPT_ENCRYPTED_INVAL');

481:
482: if upper(p_encrypted) ='Y' or upper(p_encrypted)='N' then
483: null;
484: else
485: fnd_message.set_name('PER', 'PER_449954_OPT_ENCRYPTED_INVAL');
486: fnd_message.raise_error;
487:
488: end if;
489:

Line 486: fnd_message.raise_error;

482: if upper(p_encrypted) ='Y' or upper(p_encrypted)='N' then
483: null;
484: else
485: fnd_message.set_name('PER', 'PER_449954_OPT_ENCRYPTED_INVAL');
486: fnd_message.raise_error;
487:
488: end if;
489:
490: exception

Line 558: fnd_message.set_name('PER','PER_449955_OPT_INT_ID_ABSENT');

554: fetch csr_int into l_key;
555: hr_utility.set_location('After fetching :'||l_proc,30);
556: if (csr_int%notfound) then
557: close csr_int;
558: fnd_message.set_name('PER','PER_449955_OPT_INT_ID_ABSENT');
559: fnd_message.raise_error;
560: end if;
561: close csr_int;
562:

Line 559: fnd_message.raise_error;

555: hr_utility.set_location('After fetching :'||l_proc,30);
556: if (csr_int%notfound) then
557: close csr_int;
558: fnd_message.set_name('PER','PER_449955_OPT_INT_ID_ABSENT');
559: fnd_message.raise_error;
560: end if;
561: close csr_int;
562:
563: hr_utility.set_location(' Leaving:'||l_proc,40);

Line 646: fnd_message.set_name('PER','PER_449952_OPT_INVALID_COMB');

642: fetch csr_int_options into l_found;
643:
644: if (csr_int_options%found) then
645: close csr_int_options;
646: fnd_message.set_name('PER','PER_449952_OPT_INVALID_COMB');
647: fnd_message.raise_error;
648: end if;
649: close csr_int_options;
650:

Line 647: fnd_message.raise_error;

643:
644: if (csr_int_options%found) then
645: close csr_int_options;
646: fnd_message.set_name('PER','PER_449952_OPT_INVALID_COMB');
647: fnd_message.raise_error;
648: end if;
649: close csr_int_options;
650:
651: end if;