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_TRN_INS dependencies on HR_API

Line 87: -- Insert the row into: hr_api_transactions

83: --
84: --
85: hr_trn_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: hr_api_transactions
88: --
89: insert into hr_api_transactions
90: ( transaction_id,
91: creator_person_id,

Line 89: insert into hr_api_transactions

85: hr_trn_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: hr_api_transactions
88: --
89: insert into hr_api_transactions
90: ( transaction_id,
91: creator_person_id,
92: transaction_privilege,
93: product_code,

Line 156: When hr_api.check_integrity_violated Then

152: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
153: --
154: hr_utility.set_location(' Leaving:'||l_proc, 10);
155: Exception
156: When hr_api.check_integrity_violated Then
157: -- A check constraint has been violated
158: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
159: hr_trn_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

156: When hr_api.check_integrity_violated Then
157: -- A check constraint has been violated
158: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
159: hr_trn_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.parent_integrity_violated Then
162: -- Parent integrity has been violated
163: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
164: hr_trn_shd.constraint_error

Line 161: When hr_api.parent_integrity_violated Then

157: -- A check constraint has been violated
158: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
159: hr_trn_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.parent_integrity_violated Then
162: -- Parent integrity has been violated
163: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
164: hr_trn_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

161: When hr_api.parent_integrity_violated Then
162: -- Parent integrity has been violated
163: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
164: hr_trn_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
168: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
169: hr_trn_shd.constraint_error

Line 166: When hr_api.unique_integrity_violated Then

162: -- Parent integrity has been violated
163: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
164: hr_trn_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
168: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
169: hr_trn_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
168: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
169: hr_trn_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When Others Then
172: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
173: Raise;
174: End insert_dml;

Line 218: Cursor C_Sel1 is select hr_api_transactions_s.nextval from sys.dual;

214: --
215: l_proc varchar2(72) := g_package||'pre_insert';
216: l_exists varchar2(1);
217: --
218: Cursor C_Sel1 is select hr_api_transactions_s.nextval from sys.dual;
219:
220: Cursor C_Sel2 is
221: select null
222: from hr_api_transactions

Line 222: from hr_api_transactions

218: Cursor C_Sel1 is select hr_api_transactions_s.nextval from sys.dual;
219:
220: Cursor C_Sel2 is
221: select null
222: from hr_api_transactions
223: where transaction_id = hr_trn_ins.g_transaction_id_i;
224: --
225: Begin
226: hr_utility.set_location('Entering:'||l_proc, 5);

Line 351: Raise HR_Api.Validate_Enabled;

347: --
348: -- If we are validating then raise the Validate_Enabled exception
349: --
350: If p_validate then
351: Raise HR_Api.Validate_Enabled;
352: End If;
353: --
354: hr_utility.set_location(' Leaving:'||l_proc, 10);
355: Exception

Line 356: When HR_Api.Validate_Enabled Then

352: End If;
353: --
354: hr_utility.set_location(' Leaving:'||l_proc, 10);
355: Exception
356: When HR_Api.Validate_Enabled Then
357: --
358: -- As the Validate_Enabled exception has been raised
359: -- we must rollback to the savepoint
360: --