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

Line 26: hr_utility.set_location('Entering:'|| l_proc, 10);

22: --
23:
24: BEGIN
25:
26: hr_utility.set_location('Entering:'|| l_proc, 10);
27:
28: hr_utility.set_location(l_proc, 6);
29:
30: if p_aei_information_category = 'GB_P46EXP' then

Line 28: hr_utility.set_location(l_proc, 6);

24: BEGIN
25:
26: hr_utility.set_location('Entering:'|| l_proc, 10);
27:
28: hr_utility.set_location(l_proc, 6);
29:
30: if p_aei_information_category = 'GB_P46EXP' then
31: if (p_aei_information1 = 'Y') then --if send_edi is checked
32: if (p_aei_information2 <> 'A' and p_aei_information2 <> 'B' and p_aei_information2 <> 'C') then

Line 33: hr_utility.set_message(801, 'PAY_GB_78146_INV_EXPAT_STMT');

29:
30: if p_aei_information_category = 'GB_P46EXP' then
31: if (p_aei_information1 = 'Y') then --if send_edi is checked
32: if (p_aei_information2 <> 'A' and p_aei_information2 <> 'B' and p_aei_information2 <> 'C') then
33: hr_utility.set_message(801, 'PAY_GB_78146_INV_EXPAT_STMT');
34: hr_utility.set_message_token('TYPE','P46EXPAT');
35: hr_utility.raise_error;
36: end if;
37:

Line 34: hr_utility.set_message_token('TYPE','P46EXPAT');

30: if p_aei_information_category = 'GB_P46EXP' then
31: if (p_aei_information1 = 'Y') then --if send_edi is checked
32: if (p_aei_information2 <> 'A' and p_aei_information2 <> 'B' and p_aei_information2 <> 'C') then
33: hr_utility.set_message(801, 'PAY_GB_78146_INV_EXPAT_STMT');
34: hr_utility.set_message_token('TYPE','P46EXPAT');
35: hr_utility.raise_error;
36: end if;
37:
38: if (p_aei_information4 is not null and p_aei_information4 <> 'D') then

Line 35: hr_utility.raise_error;

31: if (p_aei_information1 = 'Y') then --if send_edi is checked
32: if (p_aei_information2 <> 'A' and p_aei_information2 <> 'B' and p_aei_information2 <> 'C') then
33: hr_utility.set_message(801, 'PAY_GB_78146_INV_EXPAT_STMT');
34: hr_utility.set_message_token('TYPE','P46EXPAT');
35: hr_utility.raise_error;
36: end if;
37:
38: if (p_aei_information4 is not null and p_aei_information4 <> 'D') then
39: hr_utility.set_message(801, 'PAY_GB_78147_INV_STU_LOAN');

Line 39: hr_utility.set_message(801, 'PAY_GB_78147_INV_STU_LOAN');

35: hr_utility.raise_error;
36: end if;
37:
38: if (p_aei_information4 is not null and p_aei_information4 <> 'D') then
39: hr_utility.set_message(801, 'PAY_GB_78147_INV_STU_LOAN');
40: hr_utility.set_message_token('TYPE','P46EXPAT');
41: hr_utility.raise_error;
42: end if;
43:

Line 40: hr_utility.set_message_token('TYPE','P46EXPAT');

36: end if;
37:
38: if (p_aei_information4 is not null and p_aei_information4 <> 'D') then
39: hr_utility.set_message(801, 'PAY_GB_78147_INV_STU_LOAN');
40: hr_utility.set_message_token('TYPE','P46EXPAT');
41: hr_utility.raise_error;
42: end if;
43:
44: if (p_aei_information5 is not null) then

Line 41: hr_utility.raise_error;

37:
38: if (p_aei_information4 is not null and p_aei_information4 <> 'D') then
39: hr_utility.set_message(801, 'PAY_GB_78147_INV_STU_LOAN');
40: hr_utility.set_message_token('TYPE','P46EXPAT');
41: hr_utility.raise_error;
42: end if;
43:
44: if (p_aei_information5 is not null) then
45: hr_utility.set_message(801, 'PAY_GB_78143_WARN_EEA_CITIZEN');

Line 45: hr_utility.set_message(801, 'PAY_GB_78143_WARN_EEA_CITIZEN');

41: hr_utility.raise_error;
42: end if;
43:
44: if (p_aei_information5 is not null) then
45: hr_utility.set_message(801, 'PAY_GB_78143_WARN_EEA_CITIZEN');
46: hr_utility.set_message_token('TYPE','P46EXPAT');
47: end if;
48:
49: if (p_aei_information7 is null) then

Line 46: hr_utility.set_message_token('TYPE','P46EXPAT');

42: end if;
43:
44: if (p_aei_information5 is not null) then
45: hr_utility.set_message(801, 'PAY_GB_78143_WARN_EEA_CITIZEN');
46: hr_utility.set_message_token('TYPE','P46EXPAT');
47: end if;
48:
49: if (p_aei_information7 is null) then
50: hr_utility.set_message(801, 'PAY_GB_78148_INV_UK_EMPL_DATE');

Line 50: hr_utility.set_message(801, 'PAY_GB_78148_INV_UK_EMPL_DATE');

46: hr_utility.set_message_token('TYPE','P46EXPAT');
47: end if;
48:
49: if (p_aei_information7 is null) then
50: hr_utility.set_message(801, 'PAY_GB_78148_INV_UK_EMPL_DATE');
51: hr_utility.set_message_token('TYPE','P46EXPAT');
52: hr_utility.raise_error;
53: end if;
54:

Line 51: hr_utility.set_message_token('TYPE','P46EXPAT');

47: end if;
48:
49: if (p_aei_information7 is null) then
50: hr_utility.set_message(801, 'PAY_GB_78148_INV_UK_EMPL_DATE');
51: hr_utility.set_message_token('TYPE','P46EXPAT');
52: hr_utility.raise_error;
53: end if;
54:
55: end if;

Line 52: hr_utility.raise_error;

48:
49: if (p_aei_information7 is null) then
50: hr_utility.set_message(801, 'PAY_GB_78148_INV_UK_EMPL_DATE');
51: hr_utility.set_message_token('TYPE','P46EXPAT');
52: hr_utility.raise_error;
53: end if;
54:
55: end if;
56: end if;

Line 61: hr_utility.set_message(800, 'HR_GB_78160_INV_EXPAT_IND');

57:
58: if (p_aei_information_category = 'GB_PAY_RTI') then
59:
60: if (p_aei_information5 <> hr_api.g_varchar2 and p_aei_information5 <> 'Y' and p_aei_information5 <> 'N') then
61: hr_utility.set_message(800, 'HR_GB_78160_INV_EXPAT_IND');
62: hr_utility.set_message_token('TYPE','EAS13');
63: hr_utility.raise_error;
64: end if;
65:

Line 62: hr_utility.set_message_token('TYPE','EAS13');

58: if (p_aei_information_category = 'GB_PAY_RTI') then
59:
60: if (p_aei_information5 <> hr_api.g_varchar2 and p_aei_information5 <> 'Y' and p_aei_information5 <> 'N') then
61: hr_utility.set_message(800, 'HR_GB_78160_INV_EXPAT_IND');
62: hr_utility.set_message_token('TYPE','EAS13');
63: hr_utility.raise_error;
64: end if;
65:
66: if (p_aei_information6 <> hr_api.g_varchar2 and p_aei_information6 <> 'Y' and p_aei_information6 <> 'N') then

Line 63: hr_utility.raise_error;

59:
60: if (p_aei_information5 <> hr_api.g_varchar2 and p_aei_information5 <> 'Y' and p_aei_information5 <> 'N') then
61: hr_utility.set_message(800, 'HR_GB_78160_INV_EXPAT_IND');
62: hr_utility.set_message_token('TYPE','EAS13');
63: hr_utility.raise_error;
64: end if;
65:
66: if (p_aei_information6 <> hr_api.g_varchar2 and p_aei_information6 <> 'Y' and p_aei_information6 <> 'N') then
67: hr_utility.set_message(800, 'HR_GB_78161_INV_OCC_PENSION');

Line 67: hr_utility.set_message(800, 'HR_GB_78161_INV_OCC_PENSION');

63: hr_utility.raise_error;
64: end if;
65:
66: if (p_aei_information6 <> hr_api.g_varchar2 and p_aei_information6 <> 'Y' and p_aei_information6 <> 'N') then
67: hr_utility.set_message(800, 'HR_GB_78161_INV_OCC_PENSION');
68: hr_utility.set_message_token('TYPE','EAS13');
69: hr_utility.raise_error;
70: end if;
71:

Line 68: hr_utility.set_message_token('TYPE','EAS13');

64: end if;
65:
66: if (p_aei_information6 <> hr_api.g_varchar2 and p_aei_information6 <> 'Y' and p_aei_information6 <> 'N') then
67: hr_utility.set_message(800, 'HR_GB_78161_INV_OCC_PENSION');
68: hr_utility.set_message_token('TYPE','EAS13');
69: hr_utility.raise_error;
70: end if;
71:
72: if (p_aei_information7 <> hr_api.g_varchar2 and p_aei_information7 <> 'Y' and p_aei_information7 <> 'N') then

Line 69: hr_utility.raise_error;

65:
66: if (p_aei_information6 <> hr_api.g_varchar2 and p_aei_information6 <> 'Y' and p_aei_information6 <> 'N') then
67: hr_utility.set_message(800, 'HR_GB_78161_INV_OCC_PENSION');
68: hr_utility.set_message_token('TYPE','EAS13');
69: hr_utility.raise_error;
70: end if;
71:
72: if (p_aei_information7 <> hr_api.g_varchar2 and p_aei_information7 <> 'Y' and p_aei_information7 <> 'N') then
73: hr_utility.set_message(800, 'HR_GB_78162_INV_NON_PAY_INDIV');

Line 73: hr_utility.set_message(800, 'HR_GB_78162_INV_NON_PAY_INDIV');

69: hr_utility.raise_error;
70: end if;
71:
72: if (p_aei_information7 <> hr_api.g_varchar2 and p_aei_information7 <> 'Y' and p_aei_information7 <> 'N') then
73: hr_utility.set_message(800, 'HR_GB_78162_INV_NON_PAY_INDIV');
74: hr_utility.set_message_token('TYPE','EAS13');
75: hr_utility.raise_error;
76: end if;
77:

Line 74: hr_utility.set_message_token('TYPE','EAS13');

70: end if;
71:
72: if (p_aei_information7 <> hr_api.g_varchar2 and p_aei_information7 <> 'Y' and p_aei_information7 <> 'N') then
73: hr_utility.set_message(800, 'HR_GB_78162_INV_NON_PAY_INDIV');
74: hr_utility.set_message_token('TYPE','EAS13');
75: hr_utility.raise_error;
76: end if;
77:
78:

Line 75: hr_utility.raise_error;

71:
72: if (p_aei_information7 <> hr_api.g_varchar2 and p_aei_information7 <> 'Y' and p_aei_information7 <> 'N') then
73: hr_utility.set_message(800, 'HR_GB_78162_INV_NON_PAY_INDIV');
74: hr_utility.set_message_token('TYPE','EAS13');
75: hr_utility.raise_error;
76: end if;
77:
78:
79: end if;

Line 82: hr_utility.set_location(' Leaving:'||l_proc, 40);

78:
79: end if;
80:
81:
82: hr_utility.set_location(' Leaving:'||l_proc, 40);
83:
84: END CREATE_GB_P46EXPAT_INFO;
85:
86: PROCEDURE UPDATE_GB_P46EXPAT_INFO(P_ASSIGNMENT_EXTRA_INFO_ID NUMBER

Line 101: hr_utility.set_location('Entering:'|| l_proc, 10);

97: IS
98:
99: l_proc varchar2(72) := g_package||'UPDATE_GB_P46EXPAT_INFO';
100: BEGIN
101: hr_utility.set_location('Entering:'|| l_proc, 10);
102: --Commented out for time being in order to address rollback issue
103: /* if (p_aei_information1 = 'Y') then
104:
105: if (p_aei_information2 <> 'A' and p_aei_information2 <> 'B' and p_aei_information2 <> 'C') then

Line 106: hr_utility.set_message(801, 'PAY_GB_78146_INV_EXPAT_STMT');

102: --Commented out for time being in order to address rollback issue
103: /* if (p_aei_information1 = 'Y') then
104:
105: if (p_aei_information2 <> 'A' and p_aei_information2 <> 'B' and p_aei_information2 <> 'C') then
106: hr_utility.set_message(801, 'PAY_GB_78146_INV_EXPAT_STMT');
107: hr_utility.set_message_token('TYPE','P46EXPAT');
108: hr_utility.raise_error;
109: end if;
110:

Line 107: hr_utility.set_message_token('TYPE','P46EXPAT');

103: /* if (p_aei_information1 = 'Y') then
104:
105: if (p_aei_information2 <> 'A' and p_aei_information2 <> 'B' and p_aei_information2 <> 'C') then
106: hr_utility.set_message(801, 'PAY_GB_78146_INV_EXPAT_STMT');
107: hr_utility.set_message_token('TYPE','P46EXPAT');
108: hr_utility.raise_error;
109: end if;
110:
111: if (p_aei_information4 is not null and p_aei_information4 <> 'D') then

Line 108: hr_utility.raise_error;

104:
105: if (p_aei_information2 <> 'A' and p_aei_information2 <> 'B' and p_aei_information2 <> 'C') then
106: hr_utility.set_message(801, 'PAY_GB_78146_INV_EXPAT_STMT');
107: hr_utility.set_message_token('TYPE','P46EXPAT');
108: hr_utility.raise_error;
109: end if;
110:
111: if (p_aei_information4 is not null and p_aei_information4 <> 'D') then
112: hr_utility.set_message(801, 'PAY_GB_78147_INV_STU_LOAN');

Line 112: hr_utility.set_message(801, 'PAY_GB_78147_INV_STU_LOAN');

108: hr_utility.raise_error;
109: end if;
110:
111: if (p_aei_information4 is not null and p_aei_information4 <> 'D') then
112: hr_utility.set_message(801, 'PAY_GB_78147_INV_STU_LOAN');
113: hr_utility.set_message_token('TYPE','P46EXPAT');
114: hr_utility.raise_error;
115: end if;
116:

Line 113: hr_utility.set_message_token('TYPE','P46EXPAT');

109: end if;
110:
111: if (p_aei_information4 is not null and p_aei_information4 <> 'D') then
112: hr_utility.set_message(801, 'PAY_GB_78147_INV_STU_LOAN');
113: hr_utility.set_message_token('TYPE','P46EXPAT');
114: hr_utility.raise_error;
115: end if;
116:
117: if (p_aei_information5 is not null) then

Line 114: hr_utility.raise_error;

110:
111: if (p_aei_information4 is not null and p_aei_information4 <> 'D') then
112: hr_utility.set_message(801, 'PAY_GB_78147_INV_STU_LOAN');
113: hr_utility.set_message_token('TYPE','P46EXPAT');
114: hr_utility.raise_error;
115: end if;
116:
117: if (p_aei_information5 is not null) then
118: hr_utility.set_message(801, 'PAY_GB_78143_WARN_EEA_CITIZEN');

Line 118: hr_utility.set_message(801, 'PAY_GB_78143_WARN_EEA_CITIZEN');

114: hr_utility.raise_error;
115: end if;
116:
117: if (p_aei_information5 is not null) then
118: hr_utility.set_message(801, 'PAY_GB_78143_WARN_EEA_CITIZEN');
119: hr_utility.set_message_token('TYPE','P46EXPAT');
120: hr_utility.raise_error;
121: end if;
122:

Line 119: hr_utility.set_message_token('TYPE','P46EXPAT');

115: end if;
116:
117: if (p_aei_information5 is not null) then
118: hr_utility.set_message(801, 'PAY_GB_78143_WARN_EEA_CITIZEN');
119: hr_utility.set_message_token('TYPE','P46EXPAT');
120: hr_utility.raise_error;
121: end if;
122:
123: if (p_aei_information7 is null) then

Line 120: hr_utility.raise_error;

116:
117: if (p_aei_information5 is not null) then
118: hr_utility.set_message(801, 'PAY_GB_78143_WARN_EEA_CITIZEN');
119: hr_utility.set_message_token('TYPE','P46EXPAT');
120: hr_utility.raise_error;
121: end if;
122:
123: if (p_aei_information7 is null) then
124: hr_utility.set_message(801, 'PAY_GB_78148_INV_UK_EMPL_DATE');

Line 124: hr_utility.set_message(801, 'PAY_GB_78148_INV_UK_EMPL_DATE');

120: hr_utility.raise_error;
121: end if;
122:
123: if (p_aei_information7 is null) then
124: hr_utility.set_message(801, 'PAY_GB_78148_INV_UK_EMPL_DATE');
125: hr_utility.set_message_token('TYPE','P46EXPAT');
126: hr_utility.raise_error;
127: end if;
128:

Line 125: hr_utility.set_message_token('TYPE','P46EXPAT');

121: end if;
122:
123: if (p_aei_information7 is null) then
124: hr_utility.set_message(801, 'PAY_GB_78148_INV_UK_EMPL_DATE');
125: hr_utility.set_message_token('TYPE','P46EXPAT');
126: hr_utility.raise_error;
127: end if;
128:
129: end if;

Line 126: hr_utility.raise_error;

122:
123: if (p_aei_information7 is null) then
124: hr_utility.set_message(801, 'PAY_GB_78148_INV_UK_EMPL_DATE');
125: hr_utility.set_message_token('TYPE','P46EXPAT');
126: hr_utility.raise_error;
127: end if;
128:
129: end if;
130: */

Line 135: hr_utility.set_message(800, 'HR_GB_78160_INV_EXPAT_IND');

131:
132: if (p_aei_information_category = 'GB_PAY_RTI') then
133:
134: if (p_aei_information5 <> hr_api.g_varchar2 and p_aei_information5 <> 'Y' and p_aei_information5 <> 'N') then
135: hr_utility.set_message(800, 'HR_GB_78160_INV_EXPAT_IND');
136: hr_utility.set_message_token('TYPE','EAS13');
137: hr_utility.raise_error;
138: end if;
139:

Line 136: hr_utility.set_message_token('TYPE','EAS13');

132: if (p_aei_information_category = 'GB_PAY_RTI') then
133:
134: if (p_aei_information5 <> hr_api.g_varchar2 and p_aei_information5 <> 'Y' and p_aei_information5 <> 'N') then
135: hr_utility.set_message(800, 'HR_GB_78160_INV_EXPAT_IND');
136: hr_utility.set_message_token('TYPE','EAS13');
137: hr_utility.raise_error;
138: end if;
139:
140: if (p_aei_information6 <> hr_api.g_varchar2 and p_aei_information6 <> 'Y' and p_aei_information6 <> 'N') then

Line 137: hr_utility.raise_error;

133:
134: if (p_aei_information5 <> hr_api.g_varchar2 and p_aei_information5 <> 'Y' and p_aei_information5 <> 'N') then
135: hr_utility.set_message(800, 'HR_GB_78160_INV_EXPAT_IND');
136: hr_utility.set_message_token('TYPE','EAS13');
137: hr_utility.raise_error;
138: end if;
139:
140: if (p_aei_information6 <> hr_api.g_varchar2 and p_aei_information6 <> 'Y' and p_aei_information6 <> 'N') then
141: hr_utility.set_message(800, 'HR_GB_78161_INV_OCC_PENSION');

Line 141: hr_utility.set_message(800, 'HR_GB_78161_INV_OCC_PENSION');

137: hr_utility.raise_error;
138: end if;
139:
140: if (p_aei_information6 <> hr_api.g_varchar2 and p_aei_information6 <> 'Y' and p_aei_information6 <> 'N') then
141: hr_utility.set_message(800, 'HR_GB_78161_INV_OCC_PENSION');
142: hr_utility.set_message_token('TYPE','EAS13');
143: hr_utility.raise_error;
144: end if;
145:

Line 142: hr_utility.set_message_token('TYPE','EAS13');

138: end if;
139:
140: if (p_aei_information6 <> hr_api.g_varchar2 and p_aei_information6 <> 'Y' and p_aei_information6 <> 'N') then
141: hr_utility.set_message(800, 'HR_GB_78161_INV_OCC_PENSION');
142: hr_utility.set_message_token('TYPE','EAS13');
143: hr_utility.raise_error;
144: end if;
145:
146: if (p_aei_information7 <> hr_api.g_varchar2 and p_aei_information7 <> 'Y' and p_aei_information7 <> 'N') then

Line 143: hr_utility.raise_error;

139:
140: if (p_aei_information6 <> hr_api.g_varchar2 and p_aei_information6 <> 'Y' and p_aei_information6 <> 'N') then
141: hr_utility.set_message(800, 'HR_GB_78161_INV_OCC_PENSION');
142: hr_utility.set_message_token('TYPE','EAS13');
143: hr_utility.raise_error;
144: end if;
145:
146: if (p_aei_information7 <> hr_api.g_varchar2 and p_aei_information7 <> 'Y' and p_aei_information7 <> 'N') then
147: hr_utility.set_message(800, 'HR_GB_78162_INV_NON_PAY_INDIV');

Line 147: hr_utility.set_message(800, 'HR_GB_78162_INV_NON_PAY_INDIV');

143: hr_utility.raise_error;
144: end if;
145:
146: if (p_aei_information7 <> hr_api.g_varchar2 and p_aei_information7 <> 'Y' and p_aei_information7 <> 'N') then
147: hr_utility.set_message(800, 'HR_GB_78162_INV_NON_PAY_INDIV');
148: hr_utility.set_message_token('TYPE','EAS13');
149: hr_utility.raise_error;
150: end if;
151:

Line 148: hr_utility.set_message_token('TYPE','EAS13');

144: end if;
145:
146: if (p_aei_information7 <> hr_api.g_varchar2 and p_aei_information7 <> 'Y' and p_aei_information7 <> 'N') then
147: hr_utility.set_message(800, 'HR_GB_78162_INV_NON_PAY_INDIV');
148: hr_utility.set_message_token('TYPE','EAS13');
149: hr_utility.raise_error;
150: end if;
151:
152:

Line 149: hr_utility.raise_error;

145:
146: if (p_aei_information7 <> hr_api.g_varchar2 and p_aei_information7 <> 'Y' and p_aei_information7 <> 'N') then
147: hr_utility.set_message(800, 'HR_GB_78162_INV_NON_PAY_INDIV');
148: hr_utility.set_message_token('TYPE','EAS13');
149: hr_utility.raise_error;
150: end if;
151:
152:
153: end if;

Line 154: hr_utility.set_location(' Leaving:'||l_proc, 40);

150: end if;
151:
152:
153: end if;
154: hr_utility.set_location(' Leaving:'||l_proc, 40);
155:
156: END UPDATE_GB_P46EXPAT_INFO;
157:
158: