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.

[Home] [Help]

APPS.HR_CN_API dependencies on HR_UTILITY

Line 58: hr_utility.set_location(p_message, p_step);

54: )
55: IS
56: BEGIN
57:
58: hr_utility.set_location(p_message, p_step);
59:
60: END set_location;
61:
62: ----------------------------------------------------------------------------

Line 108: hr_utility.set_message(800,'HR_374602_INVALID_VALUE');

104: FETCH csr_lookup INTO l_lookup_code;
105:
106: IF csr_lookup%NOTFOUND THEN
107: CLOSE csr_lookup;
108: hr_utility.set_message(800,'HR_374602_INVALID_VALUE');
109: hr_utility.set_message_token('VALUE',p_argument_value);
110: hr_utility.set_message_token('FIELD',p_argument);
111: hr_utility.raise_error;
112: END IF;

Line 109: hr_utility.set_message_token('VALUE',p_argument_value);

105:
106: IF csr_lookup%NOTFOUND THEN
107: CLOSE csr_lookup;
108: hr_utility.set_message(800,'HR_374602_INVALID_VALUE');
109: hr_utility.set_message_token('VALUE',p_argument_value);
110: hr_utility.set_message_token('FIELD',p_argument);
111: hr_utility.raise_error;
112: END IF;
113:

Line 110: hr_utility.set_message_token('FIELD',p_argument);

106: IF csr_lookup%NOTFOUND THEN
107: CLOSE csr_lookup;
108: hr_utility.set_message(800,'HR_374602_INVALID_VALUE');
109: hr_utility.set_message_token('VALUE',p_argument_value);
110: hr_utility.set_message_token('FIELD',p_argument);
111: hr_utility.raise_error;
112: END IF;
113:
114: CLOSE csr_lookup;

Line 111: hr_utility.raise_error;

107: CLOSE csr_lookup;
108: hr_utility.set_message(800,'HR_374602_INVALID_VALUE');
109: hr_utility.set_message_token('VALUE',p_argument_value);
110: hr_utility.set_message_token('FIELD',p_argument);
111: hr_utility.raise_error;
112: END IF;
113:
114: CLOSE csr_lookup;
115:

Line 431: hr_utility.set_message(800,'HR_374604_INVALID_ORG_CLASS');

427: OPEN csr_org_id (p_business_group_id, p_organization_id, p_effective_date);
428: FETCH csr_org_id into l_org_id;
429: IF csr_org_id%NOTFOUND THEN
430: CLOSE csr_org_id;
431: hr_utility.set_message(800,'HR_374604_INVALID_ORG_CLASS');
432: hr_utility.set_message_token('ORG',p_organization_id);
433: hr_utility.raise_error;
434: END IF;
435: CLOSE csr_org_id;

Line 432: hr_utility.set_message_token('ORG',p_organization_id);

428: FETCH csr_org_id into l_org_id;
429: IF csr_org_id%NOTFOUND THEN
430: CLOSE csr_org_id;
431: hr_utility.set_message(800,'HR_374604_INVALID_ORG_CLASS');
432: hr_utility.set_message_token('ORG',p_organization_id);
433: hr_utility.raise_error;
434: END IF;
435: CLOSE csr_org_id;
436: EXCEPTION

Line 433: hr_utility.raise_error;

429: IF csr_org_id%NOTFOUND THEN
430: CLOSE csr_org_id;
431: hr_utility.set_message(800,'HR_374604_INVALID_ORG_CLASS');
432: hr_utility.set_message_token('ORG',p_organization_id);
433: hr_utility.raise_error;
434: END IF;
435: CLOSE csr_org_id;
436: EXCEPTION
437: WHEN OTHERS THEN

Line 481: hr_utility.set_message(800,'HR_374604_INVALID_ORG_CLASS');

477: OPEN csr_org_class(p_organization_id, p_classIFication);
478: FETCH csr_org_class into l_org_info_id;
479: IF csr_org_class%NOTFOUND THEN
480: CLOSE csr_org_class;
481: hr_utility.set_message(800,'HR_374604_INVALID_ORG_CLASS');
482: hr_utility.set_message_token('ORG',p_organization_id);
483: hr_utility.raise_error;
484: END IF;
485: CLOSE csr_org_class;

Line 482: hr_utility.set_message_token('ORG',p_organization_id);

478: FETCH csr_org_class into l_org_info_id;
479: IF csr_org_class%NOTFOUND THEN
480: CLOSE csr_org_class;
481: hr_utility.set_message(800,'HR_374604_INVALID_ORG_CLASS');
482: hr_utility.set_message_token('ORG',p_organization_id);
483: hr_utility.raise_error;
484: END IF;
485: CLOSE csr_org_class;
486: EXCEPTION

Line 483: hr_utility.raise_error;

479: IF csr_org_class%NOTFOUND THEN
480: CLOSE csr_org_class;
481: hr_utility.set_message(800,'HR_374604_INVALID_ORG_CLASS');
482: hr_utility.set_message_token('ORG',p_organization_id);
483: hr_utility.raise_error;
484: END IF;
485: CLOSE csr_org_class;
486: EXCEPTION
487: WHEN OTHERS THEN

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

529: OPEN csr_org_type(p_organization_id, p_type);
530: FETCH csr_org_type into l_org_info_id;
531: IF csr_org_type%NOTFOUND THEN
532: CLOSE csr_org_type;
533: hr_utility.set_message(800,'HR_374604_INVALID_ORG_CLASS');
534: hr_utility.set_message_token('ORG',p_organization_id);
535: hr_utility.raise_error;
536: END IF;
537: CLOSE csr_org_type;

Line 534: hr_utility.set_message_token('ORG',p_organization_id);

530: FETCH csr_org_type into l_org_info_id;
531: IF csr_org_type%NOTFOUND THEN
532: CLOSE csr_org_type;
533: hr_utility.set_message(800,'HR_374604_INVALID_ORG_CLASS');
534: hr_utility.set_message_token('ORG',p_organization_id);
535: hr_utility.raise_error;
536: END IF;
537: CLOSE csr_org_type;
538: EXCEPTION

Line 535: hr_utility.raise_error;

531: IF csr_org_type%NOTFOUND THEN
532: CLOSE csr_org_type;
533: hr_utility.set_message(800,'HR_374604_INVALID_ORG_CLASS');
534: hr_utility.set_message_token('ORG',p_organization_id);
535: hr_utility.raise_error;
536: END IF;
537: CLOSE csr_org_type;
538: EXCEPTION
539: WHEN OTHERS THEN

Line 671: hr_utility.set_message(800,'HR_374605_INV_TAX_DEPENDENCE');

667: IF (p_tax_exemption_indicator IS NULL) or (p_tax_exemption_indicator = 'N') THEN
668: IF p_percentage IS NULL THEN
669: RETURN;
670: ELSE
671: hr_utility.set_message(800,'HR_374605_INV_TAX_DEPENDENCE');
672: hr_utility.raise_error;
673: END IF;
674: END IF;
675:

Line 672: hr_utility.raise_error;

668: IF p_percentage IS NULL THEN
669: RETURN;
670: ELSE
671: hr_utility.set_message(800,'HR_374605_INV_TAX_DEPENDENCE');
672: hr_utility.raise_error;
673: END IF;
674: END IF;
675:
676:

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

715: INTO l_legislation_code;
716: --
717: IF csr_bg%NOTFOUND THEN
718: CLOSE csr_bg;
719: hr_utility.set_message(800, 'HR_7208_API_BUS_GRP_INVALID');
720: hr_utility.raise_error;
721: END IF;
722: CLOSE csr_bg;
723: --

Line 720: hr_utility.raise_error;

716: --
717: IF csr_bg%NOTFOUND THEN
718: CLOSE csr_bg;
719: hr_utility.set_message(800, 'HR_7208_API_BUS_GRP_INVALID');
720: hr_utility.raise_error;
721: END IF;
722: CLOSE csr_bg;
723: --
724: IF l_legislation_code <> p_legislation_code THEN

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

721: END IF;
722: CLOSE csr_bg;
723: --
724: IF l_legislation_code <> p_legislation_code THEN
725: hr_utility.set_message(800, 'HR_7961_PER_BUS_GRP_INVALID');
726: hr_utility.set_message_token('LEG_CODE','CN');
727: hr_utility.raise_error;
728: END IF;
729: EXCEPTION

Line 726: hr_utility.set_message_token('LEG_CODE','CN');

722: CLOSE csr_bg;
723: --
724: IF l_legislation_code <> p_legislation_code THEN
725: hr_utility.set_message(800, 'HR_7961_PER_BUS_GRP_INVALID');
726: hr_utility.set_message_token('LEG_CODE','CN');
727: hr_utility.raise_error;
728: END IF;
729: EXCEPTION
730: WHEN OTHERS THEN

Line 727: hr_utility.raise_error;

723: --
724: IF l_legislation_code <> p_legislation_code THEN
725: hr_utility.set_message(800, 'HR_7961_PER_BUS_GRP_INVALID');
726: hr_utility.set_message_token('LEG_CODE','CN');
727: hr_utility.raise_error;
728: END IF;
729: EXCEPTION
730: WHEN OTHERS THEN
731: IF csr_bg%ISOPEN THEN

Line 780: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');

776: OPEN csr_emp_leg(p_person_id, trunc(p_effective_date));
777: FETCH csr_emp_leg into l_legislation_code;
778: IF csr_emp_leg%notfound THEN
779: CLOSE csr_emp_leg;
780: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
781: hr_utility.raise_error;
782: END IF;
783: CLOSE csr_emp_leg;
784:

Line 781: hr_utility.raise_error;

777: FETCH csr_emp_leg into l_legislation_code;
778: IF csr_emp_leg%notfound THEN
779: CLOSE csr_emp_leg;
780: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
781: hr_utility.raise_error;
782: END IF;
783: CLOSE csr_emp_leg;
784:
785: --

Line 789: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');

785: --
786: -- Check that the legislation of the specIFied business group is 'CN'.
787: --
788: IF l_legislation_code <> p_legislation_code THEN
789: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
790: hr_utility.set_message_token('LEG_CODE','CN');
791: hr_utility.raise_error;
792: END IF;
793:

Line 790: hr_utility.set_message_token('LEG_CODE','CN');

786: -- Check that the legislation of the specIFied business group is 'CN'.
787: --
788: IF l_legislation_code <> p_legislation_code THEN
789: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
790: hr_utility.set_message_token('LEG_CODE','CN');
791: hr_utility.raise_error;
792: END IF;
793:
794: EXCEPTION

Line 791: hr_utility.raise_error;

787: --
788: IF l_legislation_code <> p_legislation_code THEN
789: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
790: hr_utility.set_message_token('LEG_CODE','CN');
791: hr_utility.raise_error;
792: END IF;
793:
794: EXCEPTION
795: WHEN OTHERS THEN

Line 839: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');

835: INTO l_style;
836: IF csr_add_style%notfound THEN
837: CLOSE csr_add_style;
838: --
839: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');
840: hr_utility.raise_error;
841: END IF;
842: --
843: CLOSE csr_add_style;

Line 840: hr_utility.raise_error;

836: IF csr_add_style%notfound THEN
837: CLOSE csr_add_style;
838: --
839: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');
840: hr_utility.raise_error;
841: END IF;
842: --
843: CLOSE csr_add_style;
844: --

Line 846: hr_utility.set_message(801, 'HR_52505_INV_ADDRESS_STYLE');

842: --
843: CLOSE csr_add_style;
844: --
845: IF l_style <> p_address_style THEN
846: hr_utility.set_message(801, 'HR_52505_INV_ADDRESS_STYLE');
847: hr_utility.raise_error;
848: END IF;
849:
850: EXCEPTION

Line 847: hr_utility.raise_error;

843: CLOSE csr_add_style;
844: --
845: IF l_style <> p_address_style THEN
846: hr_utility.set_message(801, 'HR_52505_INV_ADDRESS_STYLE');
847: hr_utility.raise_error;
848: END IF;
849:
850: EXCEPTION
851: WHEN OTHERS THEN

Line 908: hr_utility.set_message(800, 'HR_7348_PPM_ASSIGNMENT_INVALID');

904: -- bug 2748967 modIFications END
905:
906: IF legsel%notfound THEN
907: CLOSE legsel;
908: hr_utility.set_message(800, 'HR_7348_PPM_ASSIGNMENT_INVALID');
909: hr_utility.raise_error;
910: END IF;
911:
912: IF legsel%found AND l_legislation_code <> p_legislation_code THEN

Line 909: hr_utility.raise_error;

905:
906: IF legsel%notfound THEN
907: CLOSE legsel;
908: hr_utility.set_message(800, 'HR_7348_PPM_ASSIGNMENT_INVALID');
909: hr_utility.raise_error;
910: END IF;
911:
912: IF legsel%found AND l_legislation_code <> p_legislation_code THEN
913: CLOSE legsel;

Line 914: hr_utility.set_message(801, 'HR_374601_BUS_GRP_INVALID');

910: END IF;
911:
912: IF legsel%found AND l_legislation_code <> p_legislation_code THEN
913: CLOSE legsel;
914: hr_utility.set_message(801, 'HR_374601_BUS_GRP_INVALID');
915: hr_utility.raise_error;
916: END IF;
917:
918: --

Line 915: hr_utility.raise_error;

911:
912: IF legsel%found AND l_legislation_code <> p_legislation_code THEN
913: CLOSE legsel;
914: hr_utility.set_message(801, 'HR_374601_BUS_GRP_INVALID');
915: hr_utility.raise_error;
916: END IF;
917:
918: --
919: CLOSE legsel;

Line 972: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

968: INTO l_legislation_code;
969: --
970: IF legsel%notfound THEN
971: CLOSE legsel;
972: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
973: hr_utility.raise_error;
974: END IF;
975:
976: IF legsel%found AND l_legislation_code <> p_legislation_code THEN

Line 973: hr_utility.raise_error;

969: --
970: IF legsel%notfound THEN
971: CLOSE legsel;
972: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
973: hr_utility.raise_error;
974: END IF;
975:
976: IF legsel%found AND l_legislation_code <> p_legislation_code THEN
977: CLOSE legsel;

Line 978: hr_utility.set_message(801, 'HR_374601_BUS_GRP_INVALID');

974: END IF;
975:
976: IF legsel%found AND l_legislation_code <> p_legislation_code THEN
977: CLOSE legsel;
978: hr_utility.set_message(801, 'HR_374601_BUS_GRP_INVALID');
979: hr_utility.raise_error;
980: END IF;
981: --
982: CLOSE legsel;

Line 979: hr_utility.raise_error;

975:
976: IF legsel%found AND l_legislation_code <> p_legislation_code THEN
977: CLOSE legsel;
978: hr_utility.set_message(801, 'HR_374601_BUS_GRP_INVALID');
979: hr_utility.raise_error;
980: END IF;
981: --
982: CLOSE legsel;
983: --

Line 1053: hr_utility.set_message(800,p_message_name);

1049: set_location('. Message Name: '||p_message_name,40);
1050: --
1051: -- Bug 3047273 Changed to 800 from 801
1052: --
1053: hr_utility.set_message(800,p_message_name);
1054: --
1055: -- Truncated the token value to 77 characters, bug 3198695
1056: --
1057: IF p_token1 IS NOT NULL THEN

Line 1062: hr_utility.set_message_token(l_token_name,l_token_value);

1058: /* Obtain token 1 name and value */
1059: l_colon_position := INSTR(p_token1,':');
1060: l_token_name := SUBSTR(p_token1,1,l_colon_position-1);
1061: l_token_value := SUBSTR(SUBSTR(p_token1,l_colon_position+1,LENGTH(p_token1)) ,1,77);
1062: hr_utility.set_message_token(l_token_name,l_token_value);
1063: set_location('. Token1: '||l_token_name||'. Value: '||l_token_value,50);
1064: END IF;
1065:
1066: --

Line 1074: hr_utility.set_message_token(l_token_name,l_token_value);

1070: /* Obtain token 2 name and value */
1071: l_colon_position := INSTR(p_token2,':');
1072: l_token_name := SUBSTR(p_token2,1,l_colon_position-1);
1073: l_token_value := SUBSTR(SUBSTR(p_token2,l_colon_position+1,LENGTH(p_token2)) ,1,77);
1074: hr_utility.set_message_token(l_token_name,l_token_value);
1075: set_location('. Token2: '||l_token_name||'. Value: '||l_token_value,60);
1076: END IF;
1077:
1078: --

Line 1086: hr_utility.set_message_token(l_token_name,l_token_value);

1082: /* Obtain token 3 name and value */
1083: l_colon_position := INSTR(p_token3,':');
1084: l_token_name := SUBSTR(p_token3,1,l_colon_position-1);
1085: l_token_value := SUBSTR(SUBSTR(p_token3,l_colon_position+1,LENGTH(p_token3)) ,1,77);
1086: hr_utility.set_message_token(l_token_name,l_token_value);
1087: set_location('. Token3: '||l_token_name||'. Value: '||l_token_value,70);
1088: END IF;
1089:
1090: --

Line 1104: hr_utility.set_message_token(l_token_name,l_token_value);

1100: /* Obtain token 4 name and value */
1101: l_colon_position := INSTR(p_token4,':');
1102: l_token_name := SUBSTR(p_token4,1,l_colon_position-1);
1103: l_token_value := SUBSTR(SUBSTR(p_token4,l_colon_position+1,LENGTH(p_token4)) ,1,77);
1104: hr_utility.set_message_token(l_token_name,l_token_value);
1105: set_location('. Token4: '||l_token_name||'. Value: '||l_token_value,80);
1106: END IF;
1107:
1108: --

Line 1112: l_message := SUBSTRB(hr_utility.get_message,1,250);

1108: --
1109: -- End Bug 3038642
1110: --
1111:
1112: l_message := SUBSTRB(hr_utility.get_message,1,250);
1113:
1114: set_location('leaving '||l_proc,100);
1115: RETURN l_message;
1116:

Line 1262: hr_utility.set_message(p_application_id, p_message_name);

1258: BEGIN
1259:
1260: IF p_message_name IS NOT NULL AND p_message_name <> 'SUCCESS' THEN
1261: cnt:= p_token_name.count;
1262: hr_utility.set_message(p_application_id, p_message_name);
1263: FOR i IN 1..cnt
1264: LOOP
1265: hr_utility.set_message_token(p_token_name(i),p_token_value(i));
1266: END LOOP;

Line 1265: hr_utility.set_message_token(p_token_name(i),p_token_value(i));

1261: cnt:= p_token_name.count;
1262: hr_utility.set_message(p_application_id, p_message_name);
1263: FOR i IN 1..cnt
1264: LOOP
1265: hr_utility.set_message_token(p_token_name(i),p_token_value(i));
1266: END LOOP;
1267: hr_utility.raise_error;
1268: END IF;
1269:

Line 1267: hr_utility.raise_error;

1263: FOR i IN 1..cnt
1264: LOOP
1265: hr_utility.set_message_token(p_token_name(i),p_token_value(i));
1266: END LOOP;
1267: hr_utility.raise_error;
1268: END IF;
1269:
1270: END raise_message;
1271: