DBA Data[Home] [Help]

APPS.HRDPP_DELETE_PERSON dependencies on HR_UTILITY

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

143: hr_data_pump.entry('call');
144: open cr;
145: fetch cr into c;
146: if cr%notfound then
147: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
148: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
149: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
150: hr_utility.set_message_token('VALUE',p_batch_line_id);
151: hr_utility.raise_error;

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

144: open cr;
145: fetch cr into c;
146: if cr%notfound then
147: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
148: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
149: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
150: hr_utility.set_message_token('VALUE',p_batch_line_id);
151: hr_utility.raise_error;
152: end if;

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

145: fetch cr into c;
146: if cr%notfound then
147: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
148: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
149: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
150: hr_utility.set_message_token('VALUE',p_batch_line_id);
151: hr_utility.raise_error;
152: end if;
153: --

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

146: if cr%notfound then
147: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
148: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
149: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
150: hr_utility.set_message_token('VALUE',p_batch_line_id);
151: hr_utility.raise_error;
152: end if;
153: --
154: if upper(c.p2) = 'TRUE' then

Line 151: hr_utility.raise_error;

147: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
148: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
149: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
150: hr_utility.set_message_token('VALUE',p_batch_line_id);
151: hr_utility.raise_error;
152: end if;
153: --
154: if upper(c.p2) = 'TRUE' then
155: L_PERFORM_PREDEL_VALIDATION := true;

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

155: L_PERFORM_PREDEL_VALIDATION := true;
156: elsif upper(c.p2) = 'FALSE' then
157: L_PERFORM_PREDEL_VALIDATION := false;
158: elsif c.p2 is not null then
159: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
160: hr_utility.set_message_token('TYPE','BOOLEAN');
161: hr_utility.set_message_token('PARAMETER','P_PERFORM_PREDEL_VALIDATION');
162: hr_utility.set_message_token('VALUE',c.p2);
163: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');

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

156: elsif upper(c.p2) = 'FALSE' then
157: L_PERFORM_PREDEL_VALIDATION := false;
158: elsif c.p2 is not null then
159: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
160: hr_utility.set_message_token('TYPE','BOOLEAN');
161: hr_utility.set_message_token('PARAMETER','P_PERFORM_PREDEL_VALIDATION');
162: hr_utility.set_message_token('VALUE',c.p2);
163: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
164: hr_utility.raise_error;

Line 161: hr_utility.set_message_token('PARAMETER','P_PERFORM_PREDEL_VALIDATION');

157: L_PERFORM_PREDEL_VALIDATION := false;
158: elsif c.p2 is not null then
159: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
160: hr_utility.set_message_token('TYPE','BOOLEAN');
161: hr_utility.set_message_token('PARAMETER','P_PERFORM_PREDEL_VALIDATION');
162: hr_utility.set_message_token('VALUE',c.p2);
163: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
164: hr_utility.raise_error;
165: end if;

Line 162: hr_utility.set_message_token('VALUE',c.p2);

158: elsif c.p2 is not null then
159: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
160: hr_utility.set_message_token('TYPE','BOOLEAN');
161: hr_utility.set_message_token('PARAMETER','P_PERFORM_PREDEL_VALIDATION');
162: hr_utility.set_message_token('VALUE',c.p2);
163: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
164: hr_utility.raise_error;
165: end if;
166: --

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

159: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
160: hr_utility.set_message_token('TYPE','BOOLEAN');
161: hr_utility.set_message_token('PARAMETER','P_PERFORM_PREDEL_VALIDATION');
162: hr_utility.set_message_token('VALUE',c.p2);
163: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
164: hr_utility.raise_error;
165: end if;
166: --
167: if c.p4 is null then

Line 164: hr_utility.raise_error;

160: hr_utility.set_message_token('TYPE','BOOLEAN');
161: hr_utility.set_message_token('PARAMETER','P_PERFORM_PREDEL_VALIDATION');
162: hr_utility.set_message_token('VALUE',c.p2);
163: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
164: hr_utility.raise_error;
165: end if;
166: --
167: if c.p4 is null then
168: L_PERSON_ID:=nn;