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.PER_CTC_SHD dependencies on HR_UTILITY

Line 19: hr_utility.set_location('Entering:'||l_proc, 5);

15: --
16: l_proc varchar2(72) := g_package||'constraint_error';
17: --
18: Begin
19: hr_utility.set_location('Entering:'||l_proc, 5);
20: --
21: If (p_constraint_name = 'PER_CONTRACTS_F_PK') Then
22:
23: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 23: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

19: hr_utility.set_location('Entering:'||l_proc, 5);
20: --
21: If (p_constraint_name = 'PER_CONTRACTS_F_PK') Then
22:
23: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27:

Line 24: hr_utility.set_message_token('PROCEDURE', l_proc);

20: --
21: If (p_constraint_name = 'PER_CONTRACTS_F_PK') Then
22:
23: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27:
28: elsif (p_constraint_name = 'PER_CONTRACTS_F_FK1') then

Line 25: hr_utility.set_message_token('STEP','5');

21: If (p_constraint_name = 'PER_CONTRACTS_F_PK') Then
22:
23: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27:
28: elsif (p_constraint_name = 'PER_CONTRACTS_F_FK1') then
29:

Line 26: hr_utility.raise_error;

22:
23: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27:
28: elsif (p_constraint_name = 'PER_CONTRACTS_F_FK1') then
29:
30: hr_utility.set_message(801, 'PER_52832_CTR_INV_BG');

Line 30: hr_utility.set_message(801, 'PER_52832_CTR_INV_BG');

26: hr_utility.raise_error;
27:
28: elsif (p_constraint_name = 'PER_CONTRACTS_F_FK1') then
29:
30: hr_utility.set_message(801, 'PER_52832_CTR_INV_BG');
31: hr_utility.set_message_token('PROCEDURE', l_proc);
32: hr_utility.set_message_token('STEP','10');
33: hr_utility.raise_error;
34:

Line 31: hr_utility.set_message_token('PROCEDURE', l_proc);

27:
28: elsif (p_constraint_name = 'PER_CONTRACTS_F_FK1') then
29:
30: hr_utility.set_message(801, 'PER_52832_CTR_INV_BG');
31: hr_utility.set_message_token('PROCEDURE', l_proc);
32: hr_utility.set_message_token('STEP','10');
33: hr_utility.raise_error;
34:
35: elsif (p_constraint_name = 'PER_CONTRACTS_F_FK2') then

Line 32: hr_utility.set_message_token('STEP','10');

28: elsif (p_constraint_name = 'PER_CONTRACTS_F_FK1') then
29:
30: hr_utility.set_message(801, 'PER_52832_CTR_INV_BG');
31: hr_utility.set_message_token('PROCEDURE', l_proc);
32: hr_utility.set_message_token('STEP','10');
33: hr_utility.raise_error;
34:
35: elsif (p_constraint_name = 'PER_CONTRACTS_F_FK2') then
36:

Line 33: hr_utility.raise_error;

29:
30: hr_utility.set_message(801, 'PER_52832_CTR_INV_BG');
31: hr_utility.set_message_token('PROCEDURE', l_proc);
32: hr_utility.set_message_token('STEP','10');
33: hr_utility.raise_error;
34:
35: elsif (p_constraint_name = 'PER_CONTRACTS_F_FK2') then
36:
37: hr_utility.set_message(801, 'PER_52845_CTR_INV_PID');

Line 37: hr_utility.set_message(801, 'PER_52845_CTR_INV_PID');

33: hr_utility.raise_error;
34:
35: elsif (p_constraint_name = 'PER_CONTRACTS_F_FK2') then
36:
37: hr_utility.set_message(801, 'PER_52845_CTR_INV_PID');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','15');
40: hr_utility.raise_error;
41:

Line 38: hr_utility.set_message_token('PROCEDURE', l_proc);

34:
35: elsif (p_constraint_name = 'PER_CONTRACTS_F_FK2') then
36:
37: hr_utility.set_message(801, 'PER_52845_CTR_INV_PID');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','15');
40: hr_utility.raise_error;
41:
42: else

Line 39: hr_utility.set_message_token('STEP','15');

35: elsif (p_constraint_name = 'PER_CONTRACTS_F_FK2') then
36:
37: hr_utility.set_message(801, 'PER_52845_CTR_INV_PID');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','15');
40: hr_utility.raise_error;
41:
42: else
43:

Line 40: hr_utility.raise_error;

36:
37: hr_utility.set_message(801, 'PER_52845_CTR_INV_PID');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','15');
40: hr_utility.raise_error;
41:
42: else
43:
44: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

Line 44: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

40: hr_utility.raise_error;
41:
42: else
43:
44: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
45: hr_utility.set_message_token('PROCEDURE', l_proc);
46: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
47: hr_utility.raise_error;
48:

Line 45: hr_utility.set_message_token('PROCEDURE', l_proc);

41:
42: else
43:
44: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
45: hr_utility.set_message_token('PROCEDURE', l_proc);
46: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
47: hr_utility.raise_error;
48:
49: End If;

Line 46: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);

42: else
43:
44: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
45: hr_utility.set_message_token('PROCEDURE', l_proc);
46: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
47: hr_utility.raise_error;
48:
49: End If;
50: --

Line 47: hr_utility.raise_error;

43:
44: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
45: hr_utility.set_message_token('PROCEDURE', l_proc);
46: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
47: hr_utility.raise_error;
48:
49: End If;
50: --
51: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 51: hr_utility.set_location(' Leaving:'||l_proc, 20);

47: hr_utility.raise_error;
48:
49: End If;
50: --
51: hr_utility.set_location(' Leaving:'||l_proc, 20);
52: End constraint_error;
53: --
54: -- ----------------------------------------------------------------------------
55: -- |-----------------------------< api_updating >-----------------------------|

Line 142: hr_utility.set_location('Entering:'||l_proc, 5);

138: l_proc varchar2(72) := g_package||'api_updating';
139: l_fct_ret boolean;
140: --
141: Begin
142: hr_utility.set_location('Entering:'||l_proc, 5);
143: --
144: If (p_effective_date is null or
145: p_contract_id is null or
146: p_object_version_number is null) Then

Line 155: hr_utility.set_location(l_proc, 10);

151: l_fct_ret := false;
152: Else
153: If (p_contract_id = g_old_rec.contract_id and
154: p_object_version_number = g_old_rec.object_version_number) Then
155: hr_utility.set_location(l_proc, 10);
156: --
157: -- The g_old_rec is current therefore we must
158: -- set the returning function to true
159: --

Line 172: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

168: Close C_Sel1;
169: --
170: -- The primary key is invalid therefore we must error
171: --
172: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
173: hr_utility.raise_error;
174: End If;
175: Close C_Sel1;
176: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 173: hr_utility.raise_error;

169: --
170: -- The primary key is invalid therefore we must error
171: --
172: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
173: hr_utility.raise_error;
174: End If;
175: Close C_Sel1;
176: If (p_object_version_number <> g_old_rec.object_version_number) Then
177: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

Line 177: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

173: hr_utility.raise_error;
174: End If;
175: Close C_Sel1;
176: If (p_object_version_number <> g_old_rec.object_version_number) Then
177: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
178: hr_utility.raise_error;
179: End If;
180: hr_utility.set_location(l_proc, 15);
181: l_fct_ret := true;

Line 178: hr_utility.raise_error;

174: End If;
175: Close C_Sel1;
176: If (p_object_version_number <> g_old_rec.object_version_number) Then
177: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
178: hr_utility.raise_error;
179: End If;
180: hr_utility.set_location(l_proc, 15);
181: l_fct_ret := true;
182: End If;

Line 180: hr_utility.set_location(l_proc, 15);

176: If (p_object_version_number <> g_old_rec.object_version_number) Then
177: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
178: hr_utility.raise_error;
179: End If;
180: hr_utility.set_location(l_proc, 15);
181: l_fct_ret := true;
182: End If;
183: End If;
184: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 184: hr_utility.set_location(' Leaving:'||l_proc, 20);

180: hr_utility.set_location(l_proc, 15);
181: l_fct_ret := true;
182: End If;
183: End If;
184: hr_utility.set_location(' Leaving:'||l_proc, 20);
185: Return (l_fct_ret);
186: --
187: End api_updating;
188: --

Line 212: hr_utility.set_location('Entering:'||l_proc, 5);

208: and p_effective_date between ctc.effective_start_date
209: and ctc.effective_end_date;
210: --
211: Begin
212: hr_utility.set_location('Entering:'||l_proc, 5);
213: --
214: Open C_Sel1;
215: Fetch C_Sel1 Into l_parent_key_value1;
216: --

Line 219: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

215: Fetch C_Sel1 Into l_parent_key_value1;
216: --
217: If C_Sel1%notfound then
218: Close C_Sel1;
219: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
220: hr_utility.set_message_token('PROCEDURE', l_proc);
221: hr_utility.set_message_token('STEP','10');
222: hr_utility.raise_error;
223: End If;

Line 220: hr_utility.set_message_token('PROCEDURE', l_proc);

216: --
217: If C_Sel1%notfound then
218: Close C_Sel1;
219: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
220: hr_utility.set_message_token('PROCEDURE', l_proc);
221: hr_utility.set_message_token('STEP','10');
222: hr_utility.raise_error;
223: End If;
224: Close C_Sel1;

Line 221: hr_utility.set_message_token('STEP','10');

217: If C_Sel1%notfound then
218: Close C_Sel1;
219: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
220: hr_utility.set_message_token('PROCEDURE', l_proc);
221: hr_utility.set_message_token('STEP','10');
222: hr_utility.raise_error;
223: End If;
224: Close C_Sel1;
225: --

Line 222: hr_utility.raise_error;

218: Close C_Sel1;
219: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
220: hr_utility.set_message_token('PROCEDURE', l_proc);
221: hr_utility.set_message_token('STEP','10');
222: hr_utility.raise_error;
223: End If;
224: Close C_Sel1;
225: --
226: -- Call the corresponding datetrack api

Line 245: hr_utility.set_location(' Leaving:'||l_proc, 10);

241: -- delete mode is never allowed for contracts
242: --
243: p_delete := False;
244: --
245: hr_utility.set_location(' Leaving:'||l_proc, 10);
246: End find_dt_del_modes;
247: --
248: -- ----------------------------------------------------------------------------
249: -- |--------------------------< find_dt_upd_modes >---------------------------|

Line 262: hr_utility.set_location('Entering:'||l_proc, 5);

258: --
259: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
260: --
261: Begin
262: hr_utility.set_location('Entering:'||l_proc, 5);
263: --
264: -- Call the corresponding datetrack api
265: --
266: dt_api.find_dt_upd_modes

Line 276: hr_utility.set_location(' Leaving:'||l_proc, 10);

272: p_update => p_update,
273: p_update_override => p_update_override,
274: p_update_change_insert => p_update_change_insert);
275: --
276: hr_utility.set_location(' Leaving:'||l_proc, 10);
277: End find_dt_upd_modes;
278: --
279: -- ----------------------------------------------------------------------------
280: -- |------------------------< upd_effective_end_date >------------------------|

Line 294: hr_utility.set_location('Entering:'||l_proc, 5);

290: l_proc varchar2(72) := g_package||'upd_effective_end_date';
291: l_object_version_number number;
292: --
293: Begin
294: hr_utility.set_location('Entering:'||l_proc, 5);
295: --
296: -- Because we are updating a row we must get the next object
297: -- version number.
298: --

Line 305: hr_utility.set_location(l_proc, 10);

301: (p_base_table_name => 'per_contracts_f',
302: p_base_key_column => 'contract_id',
303: p_base_key_value => p_base_key_value);
304: --
305: hr_utility.set_location(l_proc, 10);
306: --
307: -- Update the specified datetrack row setting the effective
308: -- end date to the specified new effective end date.
309: --

Line 318: hr_utility.set_location(' Leaving:'||l_proc, 15);

314: and p_effective_date
315: between t.effective_start_date and t.effective_end_date;
316: --
317: p_object_version_number := l_object_version_number;
318: hr_utility.set_location(' Leaving:'||l_proc, 15);
319: --
320: Exception
321: When Others Then
322: Raise;

Line 419: hr_utility.set_location('Entering:'||l_proc, 5);

415: between effective_start_date and effective_end_date
416: for update nowait;
417: --
418: Begin
419: hr_utility.set_location('Entering:'||l_proc, 5);
420: --
421: -- Ensure that all the mandatory arguments are not null
422: --
423: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 452: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

448: Close C_Sel1;
449: --
450: -- The primary key is invalid therefore we must error
451: --
452: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
453: hr_utility.raise_error;
454: End If;
455: Close C_Sel1;
456: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 453: hr_utility.raise_error;

449: --
450: -- The primary key is invalid therefore we must error
451: --
452: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
453: hr_utility.raise_error;
454: End If;
455: Close C_Sel1;
456: If (p_object_version_number <> g_old_rec.object_version_number) Then
457: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

Line 457: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

453: hr_utility.raise_error;
454: End If;
455: Close C_Sel1;
456: If (p_object_version_number <> g_old_rec.object_version_number) Then
457: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
458: hr_utility.raise_error;
459: End If;
460: hr_utility.set_location(l_proc, 15);
461: --

Line 458: hr_utility.raise_error;

454: End If;
455: Close C_Sel1;
456: If (p_object_version_number <> g_old_rec.object_version_number) Then
457: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
458: hr_utility.raise_error;
459: End If;
460: hr_utility.set_location(l_proc, 15);
461: --
462: -- Validate the datetrack mode mode getting the validation start

Line 460: hr_utility.set_location(l_proc, 15);

456: If (p_object_version_number <> g_old_rec.object_version_number) Then
457: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
458: hr_utility.raise_error;
459: End If;
460: hr_utility.set_location(l_proc, 15);
461: --
462: -- Validate the datetrack mode mode getting the validation start
463: -- and end dates for the specified datetrack operation.
464: --

Line 483: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

479: -- We are doing a datetrack 'INSERT' which is illegal within this
480: -- procedure therefore we must error (note: to lck on insert the
481: -- private procedure ins_lck should be called).
482: --
483: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
484: hr_utility.set_message_token('PROCEDURE', l_proc);
485: hr_utility.set_message_token('STEP','20');
486: hr_utility.raise_error;
487: End If;

Line 484: hr_utility.set_message_token('PROCEDURE', l_proc);

480: -- procedure therefore we must error (note: to lck on insert the
481: -- private procedure ins_lck should be called).
482: --
483: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
484: hr_utility.set_message_token('PROCEDURE', l_proc);
485: hr_utility.set_message_token('STEP','20');
486: hr_utility.raise_error;
487: End If;
488: --

Line 485: hr_utility.set_message_token('STEP','20');

481: -- private procedure ins_lck should be called).
482: --
483: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
484: hr_utility.set_message_token('PROCEDURE', l_proc);
485: hr_utility.set_message_token('STEP','20');
486: hr_utility.raise_error;
487: End If;
488: --
489: -- Set the validation start and end date OUT arguments

Line 486: hr_utility.raise_error;

482: --
483: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
484: hr_utility.set_message_token('PROCEDURE', l_proc);
485: hr_utility.set_message_token('STEP','20');
486: hr_utility.raise_error;
487: End If;
488: --
489: -- Set the validation start and end date OUT arguments
490: --

Line 494: hr_utility.set_location(' Leaving:'||l_proc, 30);

490: --
491: p_validation_start_date := l_validation_start_date;
492: p_validation_end_date := l_validation_end_date;
493: --
494: hr_utility.set_location(' Leaving:'||l_proc, 30);
495: --
496: -- We need to trap the ORA LOCK exception
497: --
498: Exception

Line 504: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');

500: --
501: -- The object is locked therefore we need to supply a meaningful
502: -- error message.
503: --
504: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
505: hr_utility.set_message_token('TABLE_NAME', 'per_contracts_f');
506: hr_utility.raise_error;
507: When l_object_invalid then
508: --

Line 505: hr_utility.set_message_token('TABLE_NAME', 'per_contracts_f');

501: -- The object is locked therefore we need to supply a meaningful
502: -- error message.
503: --
504: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
505: hr_utility.set_message_token('TABLE_NAME', 'per_contracts_f');
506: hr_utility.raise_error;
507: When l_object_invalid then
508: --
509: -- The object doesn't exist or is invalid

Line 506: hr_utility.raise_error;

502: -- error message.
503: --
504: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
505: hr_utility.set_message_token('TABLE_NAME', 'per_contracts_f');
506: hr_utility.raise_error;
507: When l_object_invalid then
508: --
509: -- The object doesn't exist or is invalid
510: --

Line 511: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

507: When l_object_invalid then
508: --
509: -- The object doesn't exist or is invalid
510: --
511: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
512: hr_utility.set_message_token('TABLE_NAME', 'per_contracts_f');
513: hr_utility.raise_error;
514: End lck;
515: --

Line 512: hr_utility.set_message_token('TABLE_NAME', 'per_contracts_f');

508: --
509: -- The object doesn't exist or is invalid
510: --
511: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
512: hr_utility.set_message_token('TABLE_NAME', 'per_contracts_f');
513: hr_utility.raise_error;
514: End lck;
515: --
516: -- ----------------------------------------------------------------------------

Line 513: hr_utility.raise_error;

509: -- The object doesn't exist or is invalid
510: --
511: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
512: hr_utility.set_message_token('TABLE_NAME', 'per_contracts_f');
513: hr_utility.raise_error;
514: End lck;
515: --
516: -- ----------------------------------------------------------------------------
517: -- |---------------------------------< lock_record >--------------------------|

Line 605: hr_utility.set_location('Entering:'||l_proc, 5);

601: --
602: l_proc varchar2(72) := g_package||'lock_record';
603: --
604: Begin
605: hr_utility.set_location('Entering:'||l_proc, 5);
606: --
607: -- mandatory argument checking
608: --
609: hr_api.mandatory_arg_error

Line 631: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

627: Close C_Sel1;
628: --
629: -- The primary key is invalid therefore we must error
630: --
631: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
632: hr_utility.raise_error;
633: End If;
634: Close C_Sel1;
635: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 632: hr_utility.raise_error;

628: --
629: -- The primary key is invalid therefore we must error
630: --
631: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
632: hr_utility.raise_error;
633: End If;
634: Close C_Sel1;
635: If (p_object_version_number <> g_old_rec.object_version_number) Then
636: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

Line 636: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

632: hr_utility.raise_error;
633: End If;
634: Close C_Sel1;
635: If (p_object_version_number <> g_old_rec.object_version_number) Then
636: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
637: hr_utility.raise_error;
638: End If;
639: --
640: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 637: hr_utility.raise_error;

633: End If;
634: Close C_Sel1;
635: If (p_object_version_number <> g_old_rec.object_version_number) Then
636: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
637: hr_utility.raise_error;
638: End If;
639: --
640: hr_utility.set_location(' Leaving:'||l_proc, 10);
641: --

Line 640: hr_utility.set_location(' Leaving:'||l_proc, 10);

636: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
637: hr_utility.raise_error;
638: End If;
639: --
640: hr_utility.set_location(' Leaving:'||l_proc, 10);
641: --
642: -- We need to trap the ORA LOCK exception
643: --
644: Exception

Line 650: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');

646: --
647: -- The object is locked therefore we need to supply a meaningful
648: -- error message.
649: --
650: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
651: hr_utility.set_message_token('TABLE_NAME', 'per_contracts_f');
652: hr_utility.raise_error;
653: End lock_record;
654: --

Line 651: hr_utility.set_message_token('TABLE_NAME', 'per_contracts_f');

647: -- The object is locked therefore we need to supply a meaningful
648: -- error message.
649: --
650: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
651: hr_utility.set_message_token('TABLE_NAME', 'per_contracts_f');
652: hr_utility.raise_error;
653: End lock_record;
654: --
655: -- ----------------------------------------------------------------------------

Line 652: hr_utility.raise_error;

648: -- error message.
649: --
650: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
651: hr_utility.set_message_token('TABLE_NAME', 'per_contracts_f');
652: hr_utility.raise_error;
653: End lock_record;
654: --
655: -- ----------------------------------------------------------------------------
656: -- |-----------------------------< convert_args >-----------------------------|

Line 733: hr_utility.set_location('Entering:'||l_proc, 5);

729: l_proc varchar2(72) := g_package||'convert_args';
730: --
731: Begin
732: --
733: hr_utility.set_location('Entering:'||l_proc, 5);
734: --
735: -- Convert arguments into local l_rec structure.
736: --
737: l_rec.contract_id := p_contract_id;

Line 805: hr_utility.set_location(' Leaving:'||l_proc, 10);

801: l_rec.attribute20 := p_attribute20;
802: --
803: -- Return the plsql record structure.
804: --
805: hr_utility.set_location(' Leaving:'||l_proc, 10);
806: Return(l_rec);
807: --
808: End convert_args;
809: --