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.PER_GB_ORG_INFO dependencies on HR_UTILITY

Line 28: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN

24: BEGIN
25: --
26: -- Added for GSI Bug 5472781
27: --
28: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN
29: --
30: IF (p_org_info_type_code = 'Tax Details References') THEN
31: open csr_org_info_exists;
32: fetch csr_org_info_exists into l_found;

Line 35: hr_utility.set_message (800, 'HR_GB_78132_EMP_PAYE_REF_EXIST');

31: open csr_org_info_exists;
32: fetch csr_org_info_exists into l_found;
33: if csr_org_info_exists%found then
34: close csr_org_info_exists;
35: hr_utility.set_message (800, 'HR_GB_78132_EMP_PAYE_REF_EXIST');
36: hr_utility.set_message_token('PAYE_REF', p_org_information1);
37: hr_utility.raise_error;
38: end if;
39: close csr_org_info_exists;

Line 36: hr_utility.set_message_token('PAYE_REF', p_org_information1);

32: fetch csr_org_info_exists into l_found;
33: if csr_org_info_exists%found then
34: close csr_org_info_exists;
35: hr_utility.set_message (800, 'HR_GB_78132_EMP_PAYE_REF_EXIST');
36: hr_utility.set_message_token('PAYE_REF', p_org_information1);
37: hr_utility.raise_error;
38: end if;
39: close csr_org_info_exists;
40: END IF;

Line 37: hr_utility.raise_error;

33: if csr_org_info_exists%found then
34: close csr_org_info_exists;
35: hr_utility.set_message (800, 'HR_GB_78132_EMP_PAYE_REF_EXIST');
36: hr_utility.set_message_token('PAYE_REF', p_org_information1);
37: hr_utility.raise_error;
38: end if;
39: close csr_org_info_exists;
40: END IF;
41: --

Line 44: hr_utility.set_message (800, 'HR_GB_78140_EMP_STAT_NAME_MAX');

40: END IF;
41: --
42: --Added for bug 7338614
43: IF length(p_org_information3)>35 THEN
44: hr_utility.set_message (800, 'HR_GB_78140_EMP_STAT_NAME_MAX');
45: hr_utility.raise_error;
46: END IF;
47: --Bug 7338614 Ends
48: IF p_org_information10 = 'UK' THEN /*Bug 5084055*/

Line 45: hr_utility.raise_error;

41: --
42: --Added for bug 7338614
43: IF length(p_org_information3)>35 THEN
44: hr_utility.set_message (800, 'HR_GB_78140_EMP_STAT_NAME_MAX');
45: hr_utility.raise_error;
46: END IF;
47: --Bug 7338614 Ends
48: IF p_org_information10 = 'UK' THEN /*Bug 5084055*/
49: IF (p_org_info_type_code = 'Tax Details References') THEN

Line 58: hr_utility.set_message (800, 'HR_GB_78049_INV_EMP_PAYE_REF');

54: IF (l_tax_district_reference is NULL OR l_tax_reference_number is NULL
55: OR length(l_tax_district_reference) <> 3
56: OR length(l_tax_reference_number) < 0 OR length(l_tax_reference_number) > 10
57: OR pay_gb_eoy_magtape.validate_input(l_tax_reference_number, 'PAYE_REF') <> 0) THEN
58: hr_utility.set_message (800, 'HR_GB_78049_INV_EMP_PAYE_REF');
59: hr_utility.raise_error;
60: END IF;
61:
62: IF( to_number(l_tax_district_reference) = to_number(l_tax_district_reference) ) THEN

Line 59: hr_utility.raise_error;

55: OR length(l_tax_district_reference) <> 3
56: OR length(l_tax_reference_number) < 0 OR length(l_tax_reference_number) > 10
57: OR pay_gb_eoy_magtape.validate_input(l_tax_reference_number, 'PAYE_REF') <> 0) THEN
58: hr_utility.set_message (800, 'HR_GB_78049_INV_EMP_PAYE_REF');
59: hr_utility.raise_error;
60: END IF;
61:
62: IF( to_number(l_tax_district_reference) = to_number(l_tax_district_reference) ) THEN
63: IF to_number(l_tax_district_reference) < 1 then

Line 64: hr_utility.set_message (800, 'HR_GB_78049_INV_EMP_PAYE_REF');

60: END IF;
61:
62: IF( to_number(l_tax_district_reference) = to_number(l_tax_district_reference) ) THEN
63: IF to_number(l_tax_district_reference) < 1 then
64: hr_utility.set_message (800, 'HR_GB_78049_INV_EMP_PAYE_REF');
65: hr_utility.raise_error;
66: ELSE
67: null;
68: END IF;

Line 65: hr_utility.raise_error;

61:
62: IF( to_number(l_tax_district_reference) = to_number(l_tax_district_reference) ) THEN
63: IF to_number(l_tax_district_reference) < 1 then
64: hr_utility.set_message (800, 'HR_GB_78049_INV_EMP_PAYE_REF');
65: hr_utility.raise_error;
66: ELSE
67: null;
68: END IF;
69: END IF;

Line 72: hr_utility.set_message (800, 'HR_GB_78049_INV_EMP_PAYE_REF');

68: END IF;
69: END IF;
70: EXCEPTION
71: WHEN OTHERS THEN
72: hr_utility.set_message (800, 'HR_GB_78049_INV_EMP_PAYE_REF');
73: hr_utility.raise_error;
74: END;
75: END IF;
76: END IF;

Line 73: hr_utility.raise_error;

69: END IF;
70: EXCEPTION
71: WHEN OTHERS THEN
72: hr_utility.set_message (800, 'HR_GB_78049_INV_EMP_PAYE_REF');
73: hr_utility.raise_error;
74: END;
75: END IF;
76: END IF;
77: END IF;

Line 110: IF hr_utility.chk_product_install('Oracle Human Resources', 'HU') THEN

106: BEGIN
107: --
108: -- Added for GSI Bug 5472781
109: --
110: IF hr_utility.chk_product_install('Oracle Human Resources', 'HU') THEN
111: --
112: IF (p_org_info_type_code = 'Tax Details References') THEN
113: IF (p_org_information1 <> hr_api.g_varchar2) THEN
114: open csr_org_info_exists;

Line 118: hr_utility.set_message (800, 'HR_GB_78132_EMP_PAYE_REF_EXIST');

114: open csr_org_info_exists;
115: fetch csr_org_info_exists into l_found;
116: if csr_org_info_exists%found then
117: close csr_org_info_exists;
118: hr_utility.set_message (800, 'HR_GB_78132_EMP_PAYE_REF_EXIST');
119: hr_utility.set_message_token('PAYE_REF', p_org_information1);
120: hr_utility.raise_error;
121: end if;
122: close csr_org_info_exists;

Line 119: hr_utility.set_message_token('PAYE_REF', p_org_information1);

115: fetch csr_org_info_exists into l_found;
116: if csr_org_info_exists%found then
117: close csr_org_info_exists;
118: hr_utility.set_message (800, 'HR_GB_78132_EMP_PAYE_REF_EXIST');
119: hr_utility.set_message_token('PAYE_REF', p_org_information1);
120: hr_utility.raise_error;
121: end if;
122: close csr_org_info_exists;
123: END IF;

Line 120: hr_utility.raise_error;

116: if csr_org_info_exists%found then
117: close csr_org_info_exists;
118: hr_utility.set_message (800, 'HR_GB_78132_EMP_PAYE_REF_EXIST');
119: hr_utility.set_message_token('PAYE_REF', p_org_information1);
120: hr_utility.raise_error;
121: end if;
122: close csr_org_info_exists;
123: END IF;
124: END IF;

Line 128: hr_utility.set_message (800, 'HR_GB_78140_EMP_STAT_NAME_MAX');

124: END IF;
125: --
126: --Added for bug 7338614
127: IF length(p_org_information3)>35 THEN
128: hr_utility.set_message (800, 'HR_GB_78140_EMP_STAT_NAME_MAX');
129: hr_utility.raise_error;
130: END IF;
131: --Bug 7338614 Ends
132: IF p_org_information10 = 'UK' then /*Bug 5084055*/

Line 129: hr_utility.raise_error;

125: --
126: --Added for bug 7338614
127: IF length(p_org_information3)>35 THEN
128: hr_utility.set_message (800, 'HR_GB_78140_EMP_STAT_NAME_MAX');
129: hr_utility.raise_error;
130: END IF;
131: --Bug 7338614 Ends
132: IF p_org_information10 = 'UK' then /*Bug 5084055*/
133: IF (p_org_info_type_code = 'Tax Details References') THEN

Line 142: hr_utility.set_message (800, 'HR_GB_78049_INV_EMP_PAYE_REF');

138: IF (l_tax_district_reference is NULL OR l_tax_reference_number is NULL
139: OR length(l_tax_district_reference) <> 3
140: OR length(l_tax_reference_number) < 0 OR length(l_tax_reference_number) > 10
141: OR pay_gb_eoy_magtape.validate_input(l_tax_reference_number, 'PAYE_REF') <> 0 ) THEN
142: hr_utility.set_message (800, 'HR_GB_78049_INV_EMP_PAYE_REF');
143: hr_utility.raise_error;
144: END IF;
145:
146: IF (to_number(l_tax_district_reference) = to_number(l_tax_district_reference) ) THEN

Line 143: hr_utility.raise_error;

139: OR length(l_tax_district_reference) <> 3
140: OR length(l_tax_reference_number) < 0 OR length(l_tax_reference_number) > 10
141: OR pay_gb_eoy_magtape.validate_input(l_tax_reference_number, 'PAYE_REF') <> 0 ) THEN
142: hr_utility.set_message (800, 'HR_GB_78049_INV_EMP_PAYE_REF');
143: hr_utility.raise_error;
144: END IF;
145:
146: IF (to_number(l_tax_district_reference) = to_number(l_tax_district_reference) ) THEN
147: IF to_number(l_tax_district_reference) < 1 then

Line 148: hr_utility.set_message (800, 'HR_GB_78049_INV_EMP_PAYE_REF');

144: END IF;
145:
146: IF (to_number(l_tax_district_reference) = to_number(l_tax_district_reference) ) THEN
147: IF to_number(l_tax_district_reference) < 1 then
148: hr_utility.set_message (800, 'HR_GB_78049_INV_EMP_PAYE_REF');
149: hr_utility.raise_error;
150: ELSE
151: null;
152: END IF;

Line 149: hr_utility.raise_error;

145:
146: IF (to_number(l_tax_district_reference) = to_number(l_tax_district_reference) ) THEN
147: IF to_number(l_tax_district_reference) < 1 then
148: hr_utility.set_message (800, 'HR_GB_78049_INV_EMP_PAYE_REF');
149: hr_utility.raise_error;
150: ELSE
151: null;
152: END IF;
153: END IF;

Line 156: hr_utility.set_message (800, 'HR_GB_78049_INV_EMP_PAYE_REF');

152: END IF;
153: END IF;
154: EXCEPTION
155: WHEN OTHERS THEN
156: hr_utility.set_message (800, 'HR_GB_78049_INV_EMP_PAYE_REF');
157: hr_utility.raise_error;
158: END;
159: END IF;
160: END IF;

Line 157: hr_utility.raise_error;

153: END IF;
154: EXCEPTION
155: WHEN OTHERS THEN
156: hr_utility.set_message (800, 'HR_GB_78049_INV_EMP_PAYE_REF');
157: hr_utility.raise_error;
158: END;
159: END IF;
160: END IF;
161: END IF;