DBA Data[Home] [Help]

APPS.HRDPP_DELETE_ELIG_CVRD_DPNT dependencies on HR_UTILITY

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

153: hr_data_pump.entry('call');
154: open cr;
155: fetch cr into c;
156: if cr%notfound then
157: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
158: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
159: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
160: hr_utility.set_message_token('VALUE',p_batch_line_id);
161: hr_utility.raise_error;

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

154: open cr;
155: fetch cr into c;
156: if cr%notfound then
157: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
158: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
159: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
160: hr_utility.set_message_token('VALUE',p_batch_line_id);
161: hr_utility.raise_error;
162: end if;

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

155: fetch cr into c;
156: if cr%notfound then
157: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
158: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
159: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
160: hr_utility.set_message_token('VALUE',p_batch_line_id);
161: hr_utility.raise_error;
162: end if;
163: --

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

156: if cr%notfound then
157: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
158: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
159: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
160: hr_utility.set_message_token('VALUE',p_batch_line_id);
161: hr_utility.raise_error;
162: end if;
163: --
164: if upper(c.p5) = 'TRUE' then

Line 161: hr_utility.raise_error;

157: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
158: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
159: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
160: hr_utility.set_message_token('VALUE',p_batch_line_id);
161: hr_utility.raise_error;
162: end if;
163: --
164: if upper(c.p5) = 'TRUE' then
165: L_MULTI_ROW_ACTN := true;

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

165: L_MULTI_ROW_ACTN := true;
166: elsif upper(c.p5) = 'FALSE' then
167: L_MULTI_ROW_ACTN := false;
168: elsif c.p5 is not null then
169: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
170: hr_utility.set_message_token('TYPE','BOOLEAN');
171: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
172: hr_utility.set_message_token('VALUE',c.p5);
173: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');

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

166: elsif upper(c.p5) = 'FALSE' then
167: L_MULTI_ROW_ACTN := false;
168: elsif c.p5 is not null then
169: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
170: hr_utility.set_message_token('TYPE','BOOLEAN');
171: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
172: hr_utility.set_message_token('VALUE',c.p5);
173: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
174: hr_utility.raise_error;

Line 171: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');

167: L_MULTI_ROW_ACTN := false;
168: elsif c.p5 is not null then
169: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
170: hr_utility.set_message_token('TYPE','BOOLEAN');
171: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
172: hr_utility.set_message_token('VALUE',c.p5);
173: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
174: hr_utility.raise_error;
175: end if;

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

168: elsif c.p5 is not null then
169: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
170: hr_utility.set_message_token('TYPE','BOOLEAN');
171: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
172: hr_utility.set_message_token('VALUE',c.p5);
173: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
174: hr_utility.raise_error;
175: end if;
176: --

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

169: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
170: hr_utility.set_message_token('TYPE','BOOLEAN');
171: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
172: hr_utility.set_message_token('VALUE',c.p5);
173: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
174: hr_utility.raise_error;
175: end if;
176: --
177: if c.p7 is null then

Line 174: hr_utility.raise_error;

170: hr_utility.set_message_token('TYPE','BOOLEAN');
171: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
172: hr_utility.set_message_token('VALUE',c.p5);
173: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
174: hr_utility.raise_error;
175: end if;
176: --
177: if c.p7 is null then
178: L_ELIG_CVRD_DPNT_ID:=nn;