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

Line 65: hr_utility.set_message(800,'PER_52701_EFC_UNDEFINED_BG_ERR');

61: FETCH csr_find_bg INTO l_bg;
62: IF csr_find_bg%NOTFOUND THEN
63: -- No current action, so cannot determine business group id
64: CLOSE csr_find_bg;
65: hr_utility.set_message(800,'PER_52701_EFC_UNDEFINED_BG_ERR');
66: hr_utility.raise_error;
67: END IF;
68: CLOSE csr_find_bg;
69: --

Line 66: hr_utility.raise_error;

62: IF csr_find_bg%NOTFOUND THEN
63: -- No current action, so cannot determine business group id
64: CLOSE csr_find_bg;
65: hr_utility.set_message(800,'PER_52701_EFC_UNDEFINED_BG_ERR');
66: hr_utility.raise_error;
67: END IF;
68: CLOSE csr_find_bg;
69: --
70: -- Return business_group_id;

Line 424: hr_utility.set_message(800,'PER_52703_EFC_INVALID_STEP');

420: BEGIN
421: -- check step parameter
422: IF ((p_step <> 'C_UPDATE') and (p_step <> 'C_RECAL')) THEN
423: -- Incorrect parameter
424: hr_utility.set_message(800,'PER_52703_EFC_INVALID_STEP');
425: hr_utility.raise_error;
426: END IF;
427: --
428: OPEN csr_check_workers(p_action_id, p_component_name);

Line 425: hr_utility.raise_error;

421: -- check step parameter
422: IF ((p_step <> 'C_UPDATE') and (p_step <> 'C_RECAL')) THEN
423: -- Incorrect parameter
424: hr_utility.set_message(800,'PER_52703_EFC_INVALID_STEP');
425: hr_utility.raise_error;
426: END IF;
427: --
428: OPEN csr_check_workers(p_action_id, p_component_name);
429: FETCH csr_check_workers INTO l_total;

Line 435: hr_utility.set_message(800,'PER_52713_EFC_INVALID_WORKERS');

431: IF ((csr_check_workers%FOUND) and
432: (l_total.total_workers <> p_total_workers)) THEN
433: -- Row exists, yet workers does not match - error
434: CLOSE csr_check_workers;
435: hr_utility.set_message(800,'PER_52713_EFC_INVALID_WORKERS');
436: hr_utility.raise_error;
437: END IF;
438: -- Close cursor.
439: CLOSE csr_check_workers;

Line 436: hr_utility.raise_error;

432: (l_total.total_workers <> p_total_workers)) THEN
433: -- Row exists, yet workers does not match - error
434: CLOSE csr_check_workers;
435: hr_utility.set_message(800,'PER_52713_EFC_INVALID_WORKERS');
436: hr_utility.raise_error;
437: END IF;
438: -- Close cursor.
439: CLOSE csr_check_workers;
440: --

Line 484: hr_utility.set_message(800,'PER_52704_EFC_PHASE_RUNNING');

480: FETCH csr_check_phases INTO l_exists;
481: IF csr_check_phases%FOUND THEN
482: -- sub-phase exists, so error
483: CLOSE csr_check_phases;
484: hr_utility.set_message(800,'PER_52704_EFC_PHASE_RUNNING');
485: hr_utility.raise_error;
486: ELSE
487: -- All rows are complete, perhaps worker entries missing?
488: IF l_expected > l_rows THEN

Line 485: hr_utility.raise_error;

481: IF csr_check_phases%FOUND THEN
482: -- sub-phase exists, so error
483: CLOSE csr_check_phases;
484: hr_utility.set_message(800,'PER_52704_EFC_PHASE_RUNNING');
485: hr_utility.raise_error;
486: ELSE
487: -- All rows are complete, perhaps worker entries missing?
488: IF l_expected > l_rows THEN
489: hr_utility.set_message(800,'PER_52714_EFC_HIST_ENTRIES_ERR');

Line 489: hr_utility.set_message(800,'PER_52714_EFC_HIST_ENTRIES_ERR');

485: hr_utility.raise_error;
486: ELSE
487: -- All rows are complete, perhaps worker entries missing?
488: IF l_expected > l_rows THEN
489: hr_utility.set_message(800,'PER_52714_EFC_HIST_ENTRIES_ERR');
490: hr_utility.raise_error;
491: ELSIF l_expected < l_rows THEN
492: hr_utility.set_message(800,'PER_52705_EFC_INCOMPLETE_HIST');
493: hr_utility.raise_error;

Line 490: hr_utility.raise_error;

486: ELSE
487: -- All rows are complete, perhaps worker entries missing?
488: IF l_expected > l_rows THEN
489: hr_utility.set_message(800,'PER_52714_EFC_HIST_ENTRIES_ERR');
490: hr_utility.raise_error;
491: ELSIF l_expected < l_rows THEN
492: hr_utility.set_message(800,'PER_52705_EFC_INCOMPLETE_HIST');
493: hr_utility.raise_error;
494: ELSE

Line 492: hr_utility.set_message(800,'PER_52705_EFC_INCOMPLETE_HIST');

488: IF l_expected > l_rows THEN
489: hr_utility.set_message(800,'PER_52714_EFC_HIST_ENTRIES_ERR');
490: hr_utility.raise_error;
491: ELSIF l_expected < l_rows THEN
492: hr_utility.set_message(800,'PER_52705_EFC_INCOMPLETE_HIST');
493: hr_utility.raise_error;
494: ELSE
495: -- Have number of rows expected, no error.
496: null;

Line 493: hr_utility.raise_error;

489: hr_utility.set_message(800,'PER_52714_EFC_HIST_ENTRIES_ERR');
490: hr_utility.raise_error;
491: ELSIF l_expected < l_rows THEN
492: hr_utility.set_message(800,'PER_52705_EFC_INCOMPLETE_HIST');
493: hr_utility.raise_error;
494: ELSE
495: -- Have number of rows expected, no error.
496: null;
497: END IF;

Line 528: hr_utility.set_message(800,'PER_52715_EFC_MULTIPLE_ACTIONS');

524: FETCH csr_fetch_details INTO p_efc_action_id, p_business_group_id;
525: IF csr_fetch_details%ROWCOUNT > 1 THEN
526: -- error, more than one action being processed
527: CLOSE csr_fetch_details;
528: hr_utility.set_message(800,'PER_52715_EFC_MULTIPLE_ACTIONS');
529: hr_utility.raise_error;
530: ELSIF csr_fetch_details%NOTFOUND THEN
531: -- error, no action tro process
532: CLOSE csr_fetch_details;

Line 529: hr_utility.raise_error;

525: IF csr_fetch_details%ROWCOUNT > 1 THEN
526: -- error, more than one action being processed
527: CLOSE csr_fetch_details;
528: hr_utility.set_message(800,'PER_52715_EFC_MULTIPLE_ACTIONS');
529: hr_utility.raise_error;
530: ELSIF csr_fetch_details%NOTFOUND THEN
531: -- error, no action tro process
532: CLOSE csr_fetch_details;
533: hr_utility.set_message(800,'PER_52721_EFC_NO_CURRNT_ACTION');

Line 533: hr_utility.set_message(800,'PER_52721_EFC_NO_CURRNT_ACTION');

529: hr_utility.raise_error;
530: ELSIF csr_fetch_details%NOTFOUND THEN
531: -- error, no action tro process
532: CLOSE csr_fetch_details;
533: hr_utility.set_message(800,'PER_52721_EFC_NO_CURRNT_ACTION');
534: hr_utility.raise_error;
535: END IF;
536: CLOSE csr_fetch_details;
537: --

Line 534: hr_utility.raise_error;

530: ELSIF csr_fetch_details%NOTFOUND THEN
531: -- error, no action tro process
532: CLOSE csr_fetch_details;
533: hr_utility.set_message(800,'PER_52721_EFC_NO_CURRNT_ACTION');
534: hr_utility.raise_error;
535: END IF;
536: CLOSE csr_fetch_details;
537: --
538: -- Get chunk size

Line 932: hr_utility.set_message(800,'PER_52716_EFC_NO_PAYMENT_MAP');

928: END IF;
929: CLOSE csr_fetch_payment_types;
930: --
931: IF l_payment_type_id IS NULL THEN
932: hr_utility.set_message(800,'PER_52716_EFC_NO_PAYMENT_MAP');
933: hr_utility.raise_error;
934: END IF;
935: --
936: -- Return value

Line 933: hr_utility.raise_error;

929: CLOSE csr_fetch_payment_types;
930: --
931: IF l_payment_type_id IS NULL THEN
932: hr_utility.set_message(800,'PER_52716_EFC_NO_PAYMENT_MAP');
933: hr_utility.raise_error;
934: END IF;
935: --
936: -- Return value
937: RETURN l_payment_type_id;

Line 1003: hr_utility.set_message(800,'PER_52717_EFC_PROC_LOCK_ERR');

999: -- Lock timed out, or deadlock
1000: dbms_lock.sleep(p_worker_id);
1001: ELSE
1002: -- Parameter error or illegal lock handle, so error
1003: hr_utility.set_message(800,'PER_52717_EFC_PROC_LOCK_ERR');
1004: hr_utility.raise_error;
1005: END IF;
1006: END LOOP;
1007: --

Line 1004: hr_utility.raise_error;

1000: dbms_lock.sleep(p_worker_id);
1001: ELSE
1002: -- Parameter error or illegal lock handle, so error
1003: hr_utility.set_message(800,'PER_52717_EFC_PROC_LOCK_ERR');
1004: hr_utility.raise_error;
1005: END IF;
1006: END LOOP;
1007: --
1008: -- Have lock, so determine if row exists

Line 1486: hr_utility.set_message(800,'PER_52718_EFC_NO_DELETE_ACTION');

1482: FETCH csr_get_action INTO l_action_id;
1483: IF csr_get_action%NOTFOUND THEN
1484: --
1485: CLOSE csr_get_action;
1486: hr_utility.set_message(800,'PER_52718_EFC_NO_DELETE_ACTION');
1487: hr_utility.raise_error;
1488: --
1489: END IF;
1490: CLOSE csr_get_action;

Line 1487: hr_utility.raise_error;

1483: IF csr_get_action%NOTFOUND THEN
1484: --
1485: CLOSE csr_get_action;
1486: hr_utility.set_message(800,'PER_52718_EFC_NO_DELETE_ACTION');
1487: hr_utility.raise_error;
1488: --
1489: END IF;
1490: CLOSE csr_get_action;
1491: --

Line 1632: hr_utility.set_message(g_efc_error_app,

1628: -- clear table of messages
1629: hr_api_user_hooks_utility.clear_hook_report;
1630:
1631: IF g_efc_error_message IS NOT NULL THEN
1632: hr_utility.set_message(g_efc_error_app,
1633: g_efc_error_message);
1634: g_efc_error_message := null;
1635: hr_utility.raise_error;
1636: END IF;

Line 1635: hr_utility.raise_error;

1631: IF g_efc_error_message IS NOT NULL THEN
1632: hr_utility.set_message(g_efc_error_app,
1633: g_efc_error_message);
1634: g_efc_error_message := null;
1635: hr_utility.raise_error;
1636: END IF;
1637:
1638: --
1639: END clear_efc_report;