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.HR_TRS_INS dependencies on HR_API

Line 85: -- Insert the row into: hr_api_transaction_steps

81: p_rec.object_version_number := 1; -- Initialise the object version
82: --
83: hr_trs_shd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Insert the row into: hr_api_transaction_steps
86: --
87: insert into hr_api_transaction_steps
88: ( transaction_step_id,
89: transaction_id,

Line 87: insert into hr_api_transaction_steps

83: hr_trs_shd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Insert the row into: hr_api_transaction_steps
86: --
87: insert into hr_api_transaction_steps
88: ( transaction_step_id,
89: transaction_id,
90: api_name,
91: api_display_name,

Line 200: When hr_api.check_integrity_violated Then

196: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
197: --
198: hr_utility.set_location(' Leaving:'||l_proc, 10);
199: Exception
200: When hr_api.check_integrity_violated Then
201: -- A check constraint has been violated
202: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
203: hr_trs_shd.constraint_error
204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

200: When hr_api.check_integrity_violated Then
201: -- A check constraint has been violated
202: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
203: hr_trs_shd.constraint_error
204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
205: When hr_api.parent_integrity_violated Then
206: -- Parent integrity has been violated
207: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
208: hr_trs_shd.constraint_error

Line 205: When hr_api.parent_integrity_violated Then

201: -- A check constraint has been violated
202: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
203: hr_trs_shd.constraint_error
204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
205: When hr_api.parent_integrity_violated Then
206: -- Parent integrity has been violated
207: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
208: hr_trs_shd.constraint_error
209: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 209: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

205: When hr_api.parent_integrity_violated Then
206: -- Parent integrity has been violated
207: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
208: hr_trs_shd.constraint_error
209: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
210: When hr_api.unique_integrity_violated Then
211: -- Unique integrity has been violated
212: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
213: hr_trs_shd.constraint_error

Line 210: When hr_api.unique_integrity_violated Then

206: -- Parent integrity has been violated
207: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
208: hr_trs_shd.constraint_error
209: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
210: When hr_api.unique_integrity_violated Then
211: -- Unique integrity has been violated
212: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
213: hr_trs_shd.constraint_error
214: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 214: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

210: When hr_api.unique_integrity_violated Then
211: -- Unique integrity has been violated
212: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
213: hr_trs_shd.constraint_error
214: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
215: When Others Then
216: hr_trs_shd.g_api_dml := false; -- Unset the api dml status
217: Raise;
218: End insert_dml;

Line 262: Cursor C_Sel1 is select hr_api_transaction_steps_s.nextval from sys.dual;

258: --
259: l_proc varchar2(72) := g_package||'pre_insert';
260: l_exists varchar2(1);
261: --
262: Cursor C_Sel1 is select hr_api_transaction_steps_s.nextval from sys.dual;
263:
264: Cursor C_Sel2 is
265: select null
266: from hr_api_transaction_steps

Line 266: from hr_api_transaction_steps

262: Cursor C_Sel1 is select hr_api_transaction_steps_s.nextval from sys.dual;
263:
264: Cursor C_Sel2 is
265: select null
266: from hr_api_transaction_steps
267: where transaction_step_id = hr_trs_ins.g_transaction_step_id_i;
268: --
269: --
270: Begin

Line 285: fnd_message.set_token('TABLE_NAME','hr_api_transaction_steps');

281: --
282: -- The primary key values are already in use.
283: --
284: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
285: fnd_message.set_token('TABLE_NAME','hr_api_transaction_steps');
286: fnd_message.raise_error;
287: end if;
288: Close C_Sel2;
289: --

Line 397: Raise HR_Api.Validate_Enabled;

393: --
394: -- If we are validating then raise the Validate_Enabled exception
395: --
396: If p_validate then
397: Raise HR_Api.Validate_Enabled;
398: End If;
399: --
400: hr_utility.set_location(' Leaving:'||l_proc, 10);
401: Exception

Line 402: When HR_Api.Validate_Enabled Then

398: End If;
399: --
400: hr_utility.set_location(' Leaving:'||l_proc, 10);
401: Exception
402: When HR_Api.Validate_Enabled Then
403: --
404: -- As the Validate_Enabled exception has been raised
405: -- we must rollback to the savepoint
406: --