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

Line 250: hr_utility.set_message(800, 'HR_7208_API_BUS_GRP_INVALID');

246: INTO l_legislation_code;
247: --
248: IF csr_bg%NOTFOUND THEN
249: CLOSE csr_bg;
250: hr_utility.set_message(800, 'HR_7208_API_BUS_GRP_INVALID');
251: hr_utility.raise_error;
252: END IF;
253: CLOSE csr_bg;
254: --

Line 251: hr_utility.raise_error;

247: --
248: IF csr_bg%NOTFOUND THEN
249: CLOSE csr_bg;
250: hr_utility.set_message(800, 'HR_7208_API_BUS_GRP_INVALID');
251: hr_utility.raise_error;
252: END IF;
253: CLOSE csr_bg;
254: --
255: IF l_legislation_code <> p_legislation_code THEN

Line 256: hr_utility.set_message(800, 'HR_7961_PER_BUS_GRP_INVALID');

252: END IF;
253: CLOSE csr_bg;
254: --
255: IF l_legislation_code <> p_legislation_code THEN
256: hr_utility.set_message(800, 'HR_7961_PER_BUS_GRP_INVALID');
257: hr_utility.set_message_token('LEG_CODE', p_legislation_code);
258: hr_utility.raise_error;
259: END IF;
260: EXCEPTION

Line 257: hr_utility.set_message_token('LEG_CODE', p_legislation_code);

253: CLOSE csr_bg;
254: --
255: IF l_legislation_code <> p_legislation_code THEN
256: hr_utility.set_message(800, 'HR_7961_PER_BUS_GRP_INVALID');
257: hr_utility.set_message_token('LEG_CODE', p_legislation_code);
258: hr_utility.raise_error;
259: END IF;
260: EXCEPTION
261: WHEN OTHERS THEN

Line 258: hr_utility.raise_error;

254: --
255: IF l_legislation_code <> p_legislation_code THEN
256: hr_utility.set_message(800, 'HR_7961_PER_BUS_GRP_INVALID');
257: hr_utility.set_message_token('LEG_CODE', p_legislation_code);
258: hr_utility.raise_error;
259: END IF;
260: EXCEPTION
261: WHEN OTHERS THEN
262: IF csr_bg%ISOPEN THEN

Line 303: hr_utility.set_message(801, 'HR_7971_PER_PER_IN_PERSON');

299: FETCH csr_fetch_bg INTO l_bg_id;
300:
301: IF csr_fetch_bg%NOTFOUND THEN
302: CLOSE csr_fetch_bg;
303: hr_utility.set_message(801, 'HR_7971_PER_PER_IN_PERSON');
304: hr_utility.raise_error;
305: END IF;
306: CLOSE csr_fetch_bg;
307:

Line 304: hr_utility.raise_error;

300:
301: IF csr_fetch_bg%NOTFOUND THEN
302: CLOSE csr_fetch_bg;
303: hr_utility.set_message(801, 'HR_7971_PER_PER_IN_PERSON');
304: hr_utility.raise_error;
305: END IF;
306: CLOSE csr_fetch_bg;
307:
308: RETURN (l_bg_id);

Line 343: hr_utility.set_message(801, 'HR_7348_PPM_ASSIGNMENT_INVALID');

339: FETCH csr_fetch_bg INTO l_bg_id;
340:
341: IF csr_fetch_bg%NOTFOUND THEN
342: CLOSE csr_fetch_bg;
343: hr_utility.set_message(801, 'HR_7348_PPM_ASSIGNMENT_INVALID');
344: hr_utility.raise_error;
345: END IF;
346: CLOSE csr_fetch_bg;
347:

Line 344: hr_utility.raise_error;

340:
341: IF csr_fetch_bg%NOTFOUND THEN
342: CLOSE csr_fetch_bg;
343: hr_utility.set_message(801, 'HR_7348_PPM_ASSIGNMENT_INVALID');
344: hr_utility.raise_error;
345: END IF;
346: CLOSE csr_fetch_bg;
347:
348: RETURN (l_bg_id);

Line 380: hr_utility.trace('Entering '|| lv_proc);

376: r_legal_employer_id := -1;
377:
378: IF (g_debug)
379: THEN
380: hr_utility.trace('Entering '|| lv_proc);
381: END IF;
382:
383: SELECT effective_date
384: INTO ld_effective_date

Line 390: hr_utility.set_location(lv_proc, 10);

386: WHERE session_id = USERENV('sessionid');
387:
388: IF (g_debug)
389: THEN
390: hr_utility.set_location(lv_proc, 10);
391: END IF;
392:
393: r_legal_employer_id := get_legal_employer(p_business_group_id,
394: p_tax_unit_id,

Line 399: hr_utility.trace('Leaving '|| lv_proc);

395: ld_effective_date);
396:
397: IF (g_debug)
398: THEN
399: hr_utility.trace('Leaving '|| lv_proc);
400: END IF;
401:
402: RETURN r_legal_employer_id;
403:

Line 437: hr_utility.trace('Entering '|| lv_proc);

433: r_legal_employer_id := -1;
434:
435: IF (g_debug)
436: THEN
437: hr_utility.trace('Entering '|| lv_proc);
438: END IF;
439:
440: SELECT le_node.entity_id
441: INTO r_legal_employer_id

Line 461: hr_utility.trace('Leaving '|| lv_proc);

457: AND NVL(hier_ver.date_to, hr_general.end_of_time);
458:
459: IF (g_debug)
460: THEN
461: hr_utility.trace('Leaving '|| lv_proc);
462: END IF;
463:
464: RETURN r_legal_employer_id;
465:

Line 469: hr_utility.set_message(800, 'HR_MX_INVALID_LE');

465:
466: EXCEPTION
467: WHEN OTHERS
468: THEN
469: hr_utility.set_message(800, 'HR_MX_INVALID_LE');
470: hr_utility.raise_error;
471:
472: IF (g_debug)
473: THEN

Line 470: hr_utility.raise_error;

466: EXCEPTION
467: WHEN OTHERS
468: THEN
469: hr_utility.set_message(800, 'HR_MX_INVALID_LE');
470: hr_utility.raise_error;
471:
472: IF (g_debug)
473: THEN
474: hr_utility.trace('Leaving '|| lv_proc);

Line 474: hr_utility.trace('Leaving '|| lv_proc);

470: hr_utility.raise_error;
471:
472: IF (g_debug)
473: THEN
474: hr_utility.trace('Leaving '|| lv_proc);
475: END IF;
476:
477: RETURN r_legal_employer_id;
478: --

Line 518: hr_utility.trace('Entering '|| lv_proc);

514: lv_proc := 'get_organization_name';
515:
516: IF (g_debug)
517: THEN
518: hr_utility.trace('Entering '|| lv_proc);
519: END IF;
520:
521: SELECT name
522: INTO lv_org_name

Line 528: hr_utility.trace('Leaving '|| lv_proc);

524: WHERE organization_id = p_organization_id;
525:
526: IF (g_debug)
527: THEN
528: hr_utility.trace('Leaving '|| lv_proc);
529: END IF;
530:
531: RETURN lv_org_name;
532:

Line 540: hr_utility.trace('Entering '|| lv_proc);

536: lv_proc := 'get_tbl_val_local';
537:
538: IF (g_debug)
539: THEN
540: hr_utility.trace('Entering '|| lv_proc);
541: END IF;
542:
543:
544: lv_row_name := get_organization_name(p_organization_id);

Line 550: hr_utility.trace('Getting Tax Subsidy Percent for '|| lv_row_name);

546: BEGIN
547:
548: IF (g_debug)
549: THEN
550: hr_utility.trace('Getting Tax Subsidy Percent for '|| lv_row_name);
551: END IF;
552:
553: r_tbl_val := FND_NUMBER.canonical_to_number(hruserdt.get_table_value(
554: p_bus_group_id => p_business_group_id,

Line 565: hr_utility.trace('Found Tax Subsidy Percent : '|| r_tbl_val);

561: */
562:
563: IF (g_debug)
564: THEN
565: hr_utility.trace('Found Tax Subsidy Percent : '|| r_tbl_val);
566: END IF;
567:
568: EXCEPTION
569: WHEN OTHERS

Line 574: hr_utility.trace('Exception in '|| lv_proc);

570: THEN
571:
572: IF (g_debug)
573: THEN
574: hr_utility.trace('Exception in '|| lv_proc);
575: END IF;
576:
577: RETURN NULL;
578: END;

Line 582: hr_utility.trace('Leaving '|| lv_proc);

578: END;
579:
580: IF (g_debug)
581: THEN
582: hr_utility.trace('Leaving '|| lv_proc);
583: END IF;
584:
585: RETURN r_tbl_val;
586:

Line 615: hr_utility.trace('Entering '|| lv_proc);

611: lv_proc := 'get_wrip';
612:
613: IF (g_debug)
614: THEN
615: hr_utility.trace('Entering '|| lv_proc);
616: END IF;
617:
618: IF (NOT gt_wrip.EXISTS(p_tax_unit_id))
619: THEN

Line 634: hr_utility.trace('Leaving '|| lv_proc);

630: THEN
631:
632: IF (g_debug)
633: THEN
634: hr_utility.trace('Leaving '|| lv_proc);
635: END IF;
636:
637: hr_utility.set_message(800,'HR_MX_NO_WRIP');
638: hr_utility.raise_error;

Line 637: hr_utility.set_message(800,'HR_MX_NO_WRIP');

633: THEN
634: hr_utility.trace('Leaving '|| lv_proc);
635: END IF;
636:
637: hr_utility.set_message(800,'HR_MX_NO_WRIP');
638: hr_utility.raise_error;
639:
640: RETURN r_wrip;
641:

Line 638: hr_utility.raise_error;

634: hr_utility.trace('Leaving '|| lv_proc);
635: END IF;
636:
637: hr_utility.set_message(800,'HR_MX_NO_WRIP');
638: hr_utility.raise_error;
639:
640: RETURN r_wrip;
641:
642: /* Bug 4187012 */

Line 649: hr_utility.trace('Leaving '|| lv_proc);

645: END IF;
646:
647: IF (g_debug)
648: THEN
649: hr_utility.trace('Leaving '|| lv_proc);
650: END IF;
651:
652: RETURN r_wrip;
653:

Line 688: hr_utility.trace('Entering '|| lv_proc);

684: lv_proc := 'get_tax_subsidy_percent';
685:
686: IF (g_debug)
687: THEN
688: hr_utility.trace('Entering '|| lv_proc);
689: END IF;
690:
691: ln_legal_employer_id := get_legal_employer(p_business_group_id,
692: p_tax_unit_id);

Line 734: hr_utility.trace('Leaving '|| lv_proc);

730: THEN
731:
732: IF (g_debug)
733: THEN
734: hr_utility.trace('Leaving '|| lv_proc);
735: END IF;
736:
737: hr_utility.set_message(800,'HR_MX_NO_SUBSIDY');
738: hr_utility.raise_error;

Line 737: hr_utility.set_message(800,'HR_MX_NO_SUBSIDY');

733: THEN
734: hr_utility.trace('Leaving '|| lv_proc);
735: END IF;
736:
737: hr_utility.set_message(800,'HR_MX_NO_SUBSIDY');
738: hr_utility.raise_error;
739:
740: RETURN r_tax_subsidy_percentage;
741:

Line 738: hr_utility.raise_error;

734: hr_utility.trace('Leaving '|| lv_proc);
735: END IF;
736:
737: hr_utility.set_message(800,'HR_MX_NO_SUBSIDY');
738: hr_utility.raise_error;
739:
740: RETURN r_tax_subsidy_percentage;
741:
742: END IF;

Line 746: hr_utility.trace('Leaving '|| lv_proc);

742: END IF;
743:
744: IF (g_debug)
745: THEN
746: hr_utility.trace('Leaving '|| lv_proc);
747: END IF;
748:
749: RETURN r_tax_subsidy_percentage;
750:

Line 788: hr_utility.trace('Entering '|| lv_proc);

784: lv_proc := 'get_tax_subsidy_percent';
785:
786: IF (g_debug)
787: THEN
788: hr_utility.trace('Entering '|| lv_proc);
789: END IF;
790:
791: ln_legal_employer_id := get_legal_employer(p_business_group_id,
792: p_tax_unit_id,

Line 835: hr_utility.trace('Leaving '|| lv_proc);

831: THEN
832:
833: IF (g_debug)
834: THEN
835: hr_utility.trace('Leaving '|| lv_proc);
836: END IF;
837:
838: hr_utility.set_message(800,'HR_MX_NO_SUBSIDY');
839: hr_utility.raise_error;

Line 838: hr_utility.set_message(800,'HR_MX_NO_SUBSIDY');

834: THEN
835: hr_utility.trace('Leaving '|| lv_proc);
836: END IF;
837:
838: hr_utility.set_message(800,'HR_MX_NO_SUBSIDY');
839: hr_utility.raise_error;
840:
841: RETURN r_tax_subsidy_percentage;
842:

Line 839: hr_utility.raise_error;

835: hr_utility.trace('Leaving '|| lv_proc);
836: END IF;
837:
838: hr_utility.set_message(800,'HR_MX_NO_SUBSIDY');
839: hr_utility.raise_error;
840:
841: RETURN r_tax_subsidy_percentage;
842:
843: END IF;

Line 847: hr_utility.trace('Leaving '|| lv_proc);

843: END IF;
844:
845: IF (g_debug)
846: THEN
847: hr_utility.trace('Leaving '|| lv_proc);
848: END IF;
849:
850: RETURN r_tax_subsidy_percentage;
851:

Line 901: hr_utility.trace('ld_adj_svc_date = '|| TO_CHAR(ld_adj_svc_date));

897: OPEN c_get_adj_svc_date;
898: FETCH c_get_adj_svc_date INTO ld_adj_svc_date ;
899: CLOSE c_get_adj_svc_date;
900:
901: hr_utility.trace('ld_adj_svc_date = '|| TO_CHAR(ld_adj_svc_date));
902:
903: IF ld_adj_svc_date IS NOT NULL THEN
904: ld_seniority_from := ld_adj_svc_date ;
905: ELSE

Line 911: hr_utility.trace('ld_seniority_from = '|| TO_CHAR(ld_seniority_from));

907: FETCH c_get_hire_date INTO ld_seniority_from;
908: CLOSE c_get_hire_date ;
909: END IF;
910:
911: hr_utility.trace('ld_seniority_from = '|| TO_CHAR(ld_seniority_from));
912:
913: IF ld_seniority_from IS NULL THEN
914: hr_utility.trace('Cannot determine the start of service!');
915: hr_utility.raise_error;

Line 914: hr_utility.trace('Cannot determine the start of service!');

910:
911: hr_utility.trace('ld_seniority_from = '|| TO_CHAR(ld_seniority_from));
912:
913: IF ld_seniority_from IS NULL THEN
914: hr_utility.trace('Cannot determine the start of service!');
915: hr_utility.raise_error;
916: END IF;
917:
918: RETURN (ld_seniority_from);

Line 915: hr_utility.raise_error;

911: hr_utility.trace('ld_seniority_from = '|| TO_CHAR(ld_seniority_from));
912:
913: IF ld_seniority_from IS NULL THEN
914: hr_utility.trace('Cannot determine the start of service!');
915: hr_utility.raise_error;
916: END IF;
917:
918: RETURN (ld_seniority_from);
919: END get_hire_anniversary;

Line 955: hr_utility.trace('ln_seniority_years = '|| TO_CHAR(ln_seniority_years));

951: ln_seniority_years := 0;
952:
953: END IF;
954:
955: hr_utility.trace('ln_seniority_years = '|| TO_CHAR(ln_seniority_years));
956:
957: RETURN ln_seniority_years;
958:
959: --

Line 1021: hr_utility.trace('ln_seniority_years = '|| TO_CHAR(ln_seniority_years));

1017: ln_seniority_years := 0;
1018:
1019: END IF;
1020:
1021: hr_utility.trace('ln_seniority_years = '|| TO_CHAR(ln_seniority_years));
1022:
1023: RETURN ln_seniority_years;
1024:
1025: --

Line 1057: hr_utility.trace('IANA Charset = '||lv_iana_charset);

1053: OPEN csr_get_iana_charset;
1054: FETCH csr_get_iana_charset INTO lv_iana_charset;
1055: CLOSE csr_get_iana_charset;
1056:
1057: hr_utility.trace('IANA Charset = '||lv_iana_charset);
1058: RETURN (lv_iana_charset);
1059: END get_IANA_charset;
1060:
1061: --------------------------------------------------------------------------------

Line 1262: g_debug := hr_utility.debug_enabled;

1258:
1259: --
1260: --
1261: BEGIN
1262: g_debug := hr_utility.debug_enabled;
1263: END hr_mx_utility;