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

Line 121: hr_utility.set_message(8302, 'PQH_DUPLICATE_CORPS_CAREER');

117: open csr_career_path;
118: fetch csr_career_path into l_path;
119: if csr_career_path%found then
120: close csr_career_path;
121: hr_utility.set_message(8302, 'PQH_DUPLICATE_CORPS_CAREER');
122: hr_utility.raise_error;
123: end if;
124: close csr_career_path;
125: if p_to_seniority is not null and p_to_seniority_uom is null then

Line 122: hr_utility.raise_error;

118: fetch csr_career_path into l_path;
119: if csr_career_path%found then
120: close csr_career_path;
121: hr_utility.set_message(8302, 'PQH_DUPLICATE_CORPS_CAREER');
122: hr_utility.raise_error;
123: end if;
124: close csr_career_path;
125: if p_to_seniority is not null and p_to_seniority_uom is null then
126: hr_utility.set_message(8302, 'PQH_CORPS_UOM_MISSING');

Line 126: hr_utility.set_message(8302, 'PQH_CORPS_UOM_MISSING');

122: hr_utility.raise_error;
123: end if;
124: close csr_career_path;
125: if p_to_seniority is not null and p_to_seniority_uom is null then
126: hr_utility.set_message(8302, 'PQH_CORPS_UOM_MISSING');
127: hr_utility.raise_error;
128: end if;
129: if p_from_seniority is not null and p_from_seniority_uom is null then
130: hr_utility.set_message(8302, 'PQH_CORPS_UOM_MISSING');

Line 127: hr_utility.raise_error;

123: end if;
124: close csr_career_path;
125: if p_to_seniority is not null and p_to_seniority_uom is null then
126: hr_utility.set_message(8302, 'PQH_CORPS_UOM_MISSING');
127: hr_utility.raise_error;
128: end if;
129: if p_from_seniority is not null and p_from_seniority_uom is null then
130: hr_utility.set_message(8302, 'PQH_CORPS_UOM_MISSING');
131: hr_utility.raise_error;

Line 130: hr_utility.set_message(8302, 'PQH_CORPS_UOM_MISSING');

126: hr_utility.set_message(8302, 'PQH_CORPS_UOM_MISSING');
127: hr_utility.raise_error;
128: end if;
129: if p_from_seniority is not null and p_from_seniority_uom is null then
130: hr_utility.set_message(8302, 'PQH_CORPS_UOM_MISSING');
131: hr_utility.raise_error;
132: end if;
133: if p_from_corps_definition_id = p_to_corps_definition_id and
134: p_starting_grade_step_id = p_ending_grade_step_id then

Line 131: hr_utility.raise_error;

127: hr_utility.raise_error;
128: end if;
129: if p_from_seniority is not null and p_from_seniority_uom is null then
130: hr_utility.set_message(8302, 'PQH_CORPS_UOM_MISSING');
131: hr_utility.raise_error;
132: end if;
133: if p_from_corps_definition_id = p_to_corps_definition_id and
134: p_starting_grade_step_id = p_ending_grade_step_id then
135: hr_utility.set_message(8302, 'PQH_CORPS_CAREER_INVALID');

Line 135: hr_utility.set_message(8302, 'PQH_CORPS_CAREER_INVALID');

131: hr_utility.raise_error;
132: end if;
133: if p_from_corps_definition_id = p_to_corps_definition_id and
134: p_starting_grade_step_id = p_ending_grade_step_id then
135: hr_utility.set_message(8302, 'PQH_CORPS_CAREER_INVALID');
136: hr_utility.raise_error;
137: end if;
138: per_pgn_ins.ins
139: (p_effective_date => p_effective_date

Line 136: hr_utility.raise_error;

132: end if;
133: if p_from_corps_definition_id = p_to_corps_definition_id and
134: p_starting_grade_step_id = p_ending_grade_step_id then
135: hr_utility.set_message(8302, 'PQH_CORPS_CAREER_INVALID');
136: hr_utility.raise_error;
137: end if;
138: per_pgn_ins.ins
139: (p_effective_date => p_effective_date
140: ,p_business_group_id => p_business_group_id

Line 196: hr_utility.set_message(8302, 'PQH_DUPLICATE_CORPS_CAREER');

192: open csr_career_path;
193: fetch csr_career_path into l_path;
194: if csr_career_path%found then
195: close csr_career_path;
196: hr_utility.set_message(8302, 'PQH_DUPLICATE_CORPS_CAREER');
197: hr_utility.raise_error;
198: end if;
199: close csr_career_path;
200: if p_to_seniority is not null and p_to_seniority_uom is null then

Line 197: hr_utility.raise_error;

193: fetch csr_career_path into l_path;
194: if csr_career_path%found then
195: close csr_career_path;
196: hr_utility.set_message(8302, 'PQH_DUPLICATE_CORPS_CAREER');
197: hr_utility.raise_error;
198: end if;
199: close csr_career_path;
200: if p_to_seniority is not null and p_to_seniority_uom is null then
201: hr_utility.set_message(8302, 'PQH_CORPS_UOM_MISSING');

Line 201: hr_utility.set_message(8302, 'PQH_CORPS_UOM_MISSING');

197: hr_utility.raise_error;
198: end if;
199: close csr_career_path;
200: if p_to_seniority is not null and p_to_seniority_uom is null then
201: hr_utility.set_message(8302, 'PQH_CORPS_UOM_MISSING');
202: hr_utility.raise_error;
203: end if;
204: if p_from_seniority is not null and p_from_seniority_uom is null then
205: hr_utility.set_message(8302, 'PQH_CORPS_UOM_MISSING');

Line 202: hr_utility.raise_error;

198: end if;
199: close csr_career_path;
200: if p_to_seniority is not null and p_to_seniority_uom is null then
201: hr_utility.set_message(8302, 'PQH_CORPS_UOM_MISSING');
202: hr_utility.raise_error;
203: end if;
204: if p_from_seniority is not null and p_from_seniority_uom is null then
205: hr_utility.set_message(8302, 'PQH_CORPS_UOM_MISSING');
206: hr_utility.raise_error;

Line 205: hr_utility.set_message(8302, 'PQH_CORPS_UOM_MISSING');

201: hr_utility.set_message(8302, 'PQH_CORPS_UOM_MISSING');
202: hr_utility.raise_error;
203: end if;
204: if p_from_seniority is not null and p_from_seniority_uom is null then
205: hr_utility.set_message(8302, 'PQH_CORPS_UOM_MISSING');
206: hr_utility.raise_error;
207: end if;
208: if p_from_corps_definition_id = p_to_corps_definition_id and
209: p_starting_grade_step_id = p_ending_grade_step_id then

Line 206: hr_utility.raise_error;

202: hr_utility.raise_error;
203: end if;
204: if p_from_seniority is not null and p_from_seniority_uom is null then
205: hr_utility.set_message(8302, 'PQH_CORPS_UOM_MISSING');
206: hr_utility.raise_error;
207: end if;
208: if p_from_corps_definition_id = p_to_corps_definition_id and
209: p_starting_grade_step_id = p_ending_grade_step_id then
210: hr_utility.set_message(8302, 'PQH_CORPS_CAREER_INVALID');

Line 210: hr_utility.set_message(8302, 'PQH_CORPS_CAREER_INVALID');

206: hr_utility.raise_error;
207: end if;
208: if p_from_corps_definition_id = p_to_corps_definition_id and
209: p_starting_grade_step_id = p_ending_grade_step_id then
210: hr_utility.set_message(8302, 'PQH_CORPS_CAREER_INVALID');
211: hr_utility.raise_error;
212: end if;
213: per_pgn_upd.upd
214: (p_effective_date => p_effective_date

Line 211: hr_utility.raise_error;

207: end if;
208: if p_from_corps_definition_id = p_to_corps_definition_id and
209: p_starting_grade_step_id = p_ending_grade_step_id then
210: hr_utility.set_message(8302, 'PQH_CORPS_CAREER_INVALID');
211: hr_utility.raise_error;
212: end if;
213: per_pgn_upd.upd
214: (p_effective_date => p_effective_date
215: ,p_entity_id => p_starting_grade_step_id