DBA Data[Home] [Help]

APPS.HRDPP_DELETE_PRTT_ENRT_RESULT dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

Line 157: hr_utility.raise_error;

153: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
154: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
155: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
156: hr_utility.set_message_token('VALUE',p_batch_line_id);
157: hr_utility.raise_error;
158: end if;
159: --
160: if upper(c.p5) = 'TRUE' then
161: L_MULTI_ROW_VALIDATE := true;

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

161: L_MULTI_ROW_VALIDATE := true;
162: elsif upper(c.p5) = 'FALSE' then
163: L_MULTI_ROW_VALIDATE := false;
164: elsif c.p5 is not null then
165: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
166: hr_utility.set_message_token('TYPE','BOOLEAN');
167: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_VALIDATE');
168: hr_utility.set_message_token('VALUE',c.p5);
169: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');

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

162: elsif upper(c.p5) = 'FALSE' then
163: L_MULTI_ROW_VALIDATE := false;
164: elsif c.p5 is not null then
165: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
166: hr_utility.set_message_token('TYPE','BOOLEAN');
167: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_VALIDATE');
168: hr_utility.set_message_token('VALUE',c.p5);
169: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
170: hr_utility.raise_error;

Line 167: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_VALIDATE');

163: L_MULTI_ROW_VALIDATE := false;
164: elsif c.p5 is not null then
165: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
166: hr_utility.set_message_token('TYPE','BOOLEAN');
167: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_VALIDATE');
168: hr_utility.set_message_token('VALUE',c.p5);
169: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
170: hr_utility.raise_error;
171: end if;

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

164: elsif c.p5 is not null then
165: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
166: hr_utility.set_message_token('TYPE','BOOLEAN');
167: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_VALIDATE');
168: hr_utility.set_message_token('VALUE',c.p5);
169: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
170: hr_utility.raise_error;
171: end if;
172: --

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

165: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
166: hr_utility.set_message_token('TYPE','BOOLEAN');
167: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_VALIDATE');
168: hr_utility.set_message_token('VALUE',c.p5);
169: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
170: hr_utility.raise_error;
171: end if;
172: --
173: if c.p6 is null then

Line 170: hr_utility.raise_error;

166: hr_utility.set_message_token('TYPE','BOOLEAN');
167: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_VALIDATE');
168: hr_utility.set_message_token('VALUE',c.p5);
169: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
170: hr_utility.raise_error;
171: end if;
172: --
173: if c.p6 is null then
174: L_PRTT_ENRT_RSLT_ID:=nn;