DBA Data[Home] [Help]

APPS.HRDPP_CREATE_USER_ROW dependencies on HR_UTILITY

Line 190: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');

186: hr_data_pump.entry('call');
187: open cr;
188: fetch cr into c;
189: if cr%notfound then
190: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
191: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
192: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
193: hr_utility.set_message_token('VALUE',p_batch_line_id);
194: hr_utility.raise_error;

Line 191: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');

187: open cr;
188: fetch cr into c;
189: if cr%notfound then
190: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
191: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
192: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
193: hr_utility.set_message_token('VALUE',p_batch_line_id);
194: hr_utility.raise_error;
195: end if;

Line 192: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');

188: fetch cr into c;
189: if cr%notfound then
190: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
191: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
192: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
193: hr_utility.set_message_token('VALUE',p_batch_line_id);
194: hr_utility.raise_error;
195: end if;
196: --

Line 193: hr_utility.set_message_token('VALUE',p_batch_line_id);

189: if cr%notfound then
190: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
191: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
192: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
193: hr_utility.set_message_token('VALUE',p_batch_line_id);
194: hr_utility.raise_error;
195: end if;
196: --
197: if upper(c.p5) = 'TRUE' then

Line 194: hr_utility.raise_error;

190: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
191: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
192: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
193: hr_utility.set_message_token('VALUE',p_batch_line_id);
194: hr_utility.raise_error;
195: end if;
196: --
197: if upper(c.p5) = 'TRUE' then
198: L_DISABLE_RANGE_OVERLAP_CHECK := true;

Line 202: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');

198: L_DISABLE_RANGE_OVERLAP_CHECK := true;
199: elsif upper(c.p5) = 'FALSE' then
200: L_DISABLE_RANGE_OVERLAP_CHECK := false;
201: elsif c.d5 is not null then
202: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
203: hr_utility.set_message_token('TYPE','BOOLEAN');
204: hr_utility.set_message_token('PARAMETER','P_DISABLE_RANGE_OVERLAP_CHECK');
205: hr_utility.set_message_token('VALUE',c.p5);
206: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');

Line 203: hr_utility.set_message_token('TYPE','BOOLEAN');

199: elsif upper(c.p5) = 'FALSE' then
200: L_DISABLE_RANGE_OVERLAP_CHECK := false;
201: elsif c.d5 is not null then
202: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
203: hr_utility.set_message_token('TYPE','BOOLEAN');
204: hr_utility.set_message_token('PARAMETER','P_DISABLE_RANGE_OVERLAP_CHECK');
205: hr_utility.set_message_token('VALUE',c.p5);
206: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
207: hr_utility.raise_error;

Line 204: hr_utility.set_message_token('PARAMETER','P_DISABLE_RANGE_OVERLAP_CHECK');

200: L_DISABLE_RANGE_OVERLAP_CHECK := false;
201: elsif c.d5 is not null then
202: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
203: hr_utility.set_message_token('TYPE','BOOLEAN');
204: hr_utility.set_message_token('PARAMETER','P_DISABLE_RANGE_OVERLAP_CHECK');
205: hr_utility.set_message_token('VALUE',c.p5);
206: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
207: hr_utility.raise_error;
208: end if;

Line 205: hr_utility.set_message_token('VALUE',c.p5);

201: elsif c.d5 is not null then
202: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
203: hr_utility.set_message_token('TYPE','BOOLEAN');
204: hr_utility.set_message_token('PARAMETER','P_DISABLE_RANGE_OVERLAP_CHECK');
205: hr_utility.set_message_token('VALUE',c.p5);
206: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
207: hr_utility.raise_error;
208: end if;
209: --

Line 206: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');

202: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
203: hr_utility.set_message_token('TYPE','BOOLEAN');
204: hr_utility.set_message_token('PARAMETER','P_DISABLE_RANGE_OVERLAP_CHECK');
205: hr_utility.set_message_token('VALUE',c.p5);
206: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
207: hr_utility.raise_error;
208: end if;
209: --
210: if upper(c.p6) = 'TRUE' then

Line 207: hr_utility.raise_error;

203: hr_utility.set_message_token('TYPE','BOOLEAN');
204: hr_utility.set_message_token('PARAMETER','P_DISABLE_RANGE_OVERLAP_CHECK');
205: hr_utility.set_message_token('VALUE',c.p5);
206: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
207: hr_utility.raise_error;
208: end if;
209: --
210: if upper(c.p6) = 'TRUE' then
211: L_DISABLE_UNITS_CHECK := true;

Line 215: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');

211: L_DISABLE_UNITS_CHECK := true;
212: elsif upper(c.p6) = 'FALSE' then
213: L_DISABLE_UNITS_CHECK := false;
214: elsif c.d6 is not null then
215: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
216: hr_utility.set_message_token('TYPE','BOOLEAN');
217: hr_utility.set_message_token('PARAMETER','P_DISABLE_UNITS_CHECK');
218: hr_utility.set_message_token('VALUE',c.p6);
219: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');

Line 216: hr_utility.set_message_token('TYPE','BOOLEAN');

212: elsif upper(c.p6) = 'FALSE' then
213: L_DISABLE_UNITS_CHECK := false;
214: elsif c.d6 is not null then
215: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
216: hr_utility.set_message_token('TYPE','BOOLEAN');
217: hr_utility.set_message_token('PARAMETER','P_DISABLE_UNITS_CHECK');
218: hr_utility.set_message_token('VALUE',c.p6);
219: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
220: hr_utility.raise_error;

Line 217: hr_utility.set_message_token('PARAMETER','P_DISABLE_UNITS_CHECK');

213: L_DISABLE_UNITS_CHECK := false;
214: elsif c.d6 is not null then
215: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
216: hr_utility.set_message_token('TYPE','BOOLEAN');
217: hr_utility.set_message_token('PARAMETER','P_DISABLE_UNITS_CHECK');
218: hr_utility.set_message_token('VALUE',c.p6);
219: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
220: hr_utility.raise_error;
221: end if;

Line 218: hr_utility.set_message_token('VALUE',c.p6);

214: elsif c.d6 is not null then
215: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
216: hr_utility.set_message_token('TYPE','BOOLEAN');
217: hr_utility.set_message_token('PARAMETER','P_DISABLE_UNITS_CHECK');
218: hr_utility.set_message_token('VALUE',c.p6);
219: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
220: hr_utility.raise_error;
221: end if;
222: --

Line 219: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');

215: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
216: hr_utility.set_message_token('TYPE','BOOLEAN');
217: hr_utility.set_message_token('PARAMETER','P_DISABLE_UNITS_CHECK');
218: hr_utility.set_message_token('VALUE',c.p6);
219: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
220: hr_utility.raise_error;
221: end if;
222: --
223: if c.p13 is null then

Line 220: hr_utility.raise_error;

216: hr_utility.set_message_token('TYPE','BOOLEAN');
217: hr_utility.set_message_token('PARAMETER','P_DISABLE_UNITS_CHECK');
218: hr_utility.set_message_token('VALUE',c.p6);
219: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
220: hr_utility.raise_error;
221: end if;
222: --
223: if c.p13 is null then
224: L_USER_TABLE_ID:=nn;