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_PDS_SHD dependencies on HR_UTILITY

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

14: --
15: l_proc varchar2(72) := g_package||'return_api_dml_status';
16: --
17: Begin
18: hr_utility.set_location('Entering:'||l_proc, 5);
19: --
20: Return (nvl(g_api_dml, false));
21: --
22: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

18: hr_utility.set_location('Entering:'||l_proc, 5);
19: --
20: Return (nvl(g_api_dml, false));
21: --
22: hr_utility.set_location(' Leaving:'||l_proc, 10);
23: End return_api_dml_status;
24: --
25: -- ----------------------------------------------------------------------------
26: -- |---------------------------< constraint_error >---------------------------|

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

30: --
31: l_proc varchar2(72) := g_package||'constraint_error';
32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'PER_PERIODS_OF_SERVICE_FK1') Then
37: --
38: -- The business_group_id is invalid

Line 40: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');

36: If (p_constraint_name = 'PER_PERIODS_OF_SERVICE_FK1') Then
37: --
38: -- The business_group_id is invalid
39: --
40: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
41: --
42: ElsIf (p_constraint_name = 'PER_PERIODS_OF_SERVICE_PK') Then
43: --
44: -- The primary key is not unique

Line 46: hr_utility.set_message(801, 'HR_7391_ASG_INV_PERIOD_OF_SERV');

42: ElsIf (p_constraint_name = 'PER_PERIODS_OF_SERVICE_PK') Then
43: --
44: -- The primary key is not unique
45: --
46: hr_utility.set_message(801, 'HR_7391_ASG_INV_PERIOD_OF_SERV');
47: --
48: elsif (p_constraint_name = 'SSP_PDS_SSP_WEEKS_NATURAL_NUM') then
49: --
50: -- Prior_employment_SSP_weeks must be an integer greater than zero

Line 52: hr_utility.set_message (801,'HR_51100_PDS_SSP_WEEKS_NATURAL');

48: elsif (p_constraint_name = 'SSP_PDS_SSP_WEEKS_NATURAL_NUM') then
49: --
50: -- Prior_employment_SSP_weeks must be an integer greater than zero
51: --
52: hr_utility.set_message (801,'HR_51100_PDS_SSP_WEEKS_NATURAL');
53: --
54: elsif (p_constraint_name = 'SSP_PDS_SSP_PAID_TO_PRE_HIRE') then
55: --
56: -- Prior_employment_SSP_paid_to must be before date_start

Line 58: hr_utility.set_message (801,'HR_51102_PDS_SSP_PAID_PRE_HIRE');

54: elsif (p_constraint_name = 'SSP_PDS_SSP_PAID_TO_PRE_HIRE') then
55: --
56: -- Prior_employment_SSP_paid_to must be before date_start
57: --
58: hr_utility.set_message (801,'HR_51102_PDS_SSP_PAID_PRE_HIRE');
59: --
60: elsif (p_constraint_name = 'SSP_PDS_SSP1L_DETAILS') then
61: --
62: -- Prior_employment... fields are mutually inclusive

Line 64: hr_utility.set_message (801,'HR_51101_PDS_SSP1L_DETAILS');

60: elsif (p_constraint_name = 'SSP_PDS_SSP1L_DETAILS') then
61: --
62: -- Prior_employment... fields are mutually inclusive
63: --
64: hr_utility.set_message (801,'HR_51101_PDS_SSP1L_DETAILS');
65: --
66: elsif (p_constraint_name = 'PER_ASSIGNMENTS_F_FK51') then
67: --
68: -- Assignment rows must be deleted before period of service

Line 70: hr_utility.set_message (801,'HR_51392_PDS_DEL_ASG_FIRST');

66: elsif (p_constraint_name = 'PER_ASSIGNMENTS_F_FK51') then
67: --
68: -- Assignment rows must be deleted before period of service
69: --
70: hr_utility.set_message (801,'HR_51392_PDS_DEL_ASG_FIRST');
71: --
72: Else
73: --
74: -- A constraint was added after this code was delivered and is not

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

73: --
74: -- A constraint was added after this code was delivered and is not
75: -- handled by this procedure.
76: --
77: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
78: hr_utility.set_message_token('PROCEDURE', l_proc);
79: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
80: --
81: End If;

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

74: -- A constraint was added after this code was delivered and is not
75: -- handled by this procedure.
76: --
77: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
78: hr_utility.set_message_token('PROCEDURE', l_proc);
79: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
80: --
81: End If;
82: --

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

75: -- handled by this procedure.
76: --
77: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
78: hr_utility.set_message_token('PROCEDURE', l_proc);
79: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
80: --
81: End If;
82: --
83: hr_utility.raise_error;

Line 83: hr_utility.raise_error;

79: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
80: --
81: End If;
82: --
83: hr_utility.raise_error;
84: --
85: hr_utility.set_location(' Leaving:'||l_proc, 10);
86: End constraint_error;
87: --

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

81: End If;
82: --
83: hr_utility.raise_error;
84: --
85: hr_utility.set_location(' Leaving:'||l_proc, 10);
86: End constraint_error;
87: --
88: -- ----------------------------------------------------------------------------
89: -- |-----------------------------< api_updating >-----------------------------|

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

178: l_proc varchar2(72) := g_package||'api_updating';
179: l_fct_ret boolean;
180: --
181: Begin
182: hr_utility.set_location('Entering:'||l_proc, 5);
183: --
184: If (
185: p_period_of_service_id is null and
186: p_object_version_number is null

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

194: If (
195: p_period_of_service_id = g_old_rec.period_of_service_id and
196: p_object_version_number = g_old_rec.object_version_number
197: ) Then
198: hr_utility.set_location(l_proc, 10);
199: --
200: -- The g_old_rec is current therefore we must
201: -- set the returning function to true
202: --

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

211: Close C_Sel1;
212: --
213: -- The primary key is invalid therefore we must error
214: --
215: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
216: hr_utility.raise_error;
217: End If;
218: Close C_Sel1;
219: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 216: hr_utility.raise_error;

212: --
213: -- The primary key is invalid therefore we must error
214: --
215: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
216: hr_utility.raise_error;
217: End If;
218: Close C_Sel1;
219: If (p_object_version_number <> g_old_rec.object_version_number) Then
220: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

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

216: hr_utility.raise_error;
217: End If;
218: Close C_Sel1;
219: If (p_object_version_number <> g_old_rec.object_version_number) Then
220: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
221: hr_utility.raise_error;
222: End If;
223: hr_utility.set_location(l_proc, 15);
224: l_fct_ret := true;

Line 221: hr_utility.raise_error;

217: End If;
218: Close C_Sel1;
219: If (p_object_version_number <> g_old_rec.object_version_number) Then
220: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
221: hr_utility.raise_error;
222: End If;
223: hr_utility.set_location(l_proc, 15);
224: l_fct_ret := true;
225: End If;

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

219: If (p_object_version_number <> g_old_rec.object_version_number) Then
220: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
221: hr_utility.raise_error;
222: End If;
223: hr_utility.set_location(l_proc, 15);
224: l_fct_ret := true;
225: End If;
226: End If;
227: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

223: hr_utility.set_location(l_proc, 15);
224: l_fct_ret := true;
225: End If;
226: End If;
227: hr_utility.set_location(' Leaving:'||l_proc, 20);
228: Return (l_fct_ret);
229: --
230: End api_updating;
231: --

Line 325: hr_utility.set_location('Entering:'||l_proc, 1);

321: --
322: l_proc varchar2(72) := g_package||'lck';
323: --
324: Begin
325: hr_utility.set_location('Entering:'||l_proc, 1);
326: --
327: hr_api.mandatory_arg_error
328: (p_api_name => l_proc,
329: p_argument => 'period_of_service_id',

Line 332: hr_utility.set_location(l_proc, 3);

328: (p_api_name => l_proc,
329: p_argument => 'period_of_service_id',
330: p_argument_value => p_period_of_service_id);
331: --
332: hr_utility.set_location(l_proc, 3);
333: --
334: hr_api.mandatory_arg_error
335: (p_api_name => l_proc,
336: p_argument => 'object_version_number',

Line 339: hr_utility.set_location(l_proc, 7);

335: (p_api_name => l_proc,
336: p_argument => 'object_version_number',
337: p_argument_value => p_object_version_number);
338: --
339: hr_utility.set_location(l_proc, 7);
340: --
341: Open C_Sel1;
342: --
343: hr_utility.set_location(l_proc, 10);

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

339: hr_utility.set_location(l_proc, 7);
340: --
341: Open C_Sel1;
342: --
343: hr_utility.set_location(l_proc, 10);
344: --
345: Fetch C_Sel1 Into g_old_rec;
346: --
347: hr_utility.set_location(l_proc, 15);

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

343: hr_utility.set_location(l_proc, 10);
344: --
345: Fetch C_Sel1 Into g_old_rec;
346: --
347: hr_utility.set_location(l_proc, 15);
348: --
349: If C_Sel1%notfound then
350: --
351: hr_utility.set_location(l_proc, 20);

Line 351: hr_utility.set_location(l_proc, 20);

347: hr_utility.set_location(l_proc, 15);
348: --
349: If C_Sel1%notfound then
350: --
351: hr_utility.set_location(l_proc, 20);
352: --
353: Close C_Sel1;
354: --
355: -- The primary key is invalid therefore we must error

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

353: Close C_Sel1;
354: --
355: -- The primary key is invalid therefore we must error
356: --
357: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
358: hr_utility.raise_error;
359: End If;
360: --
361: hr_utility.set_location(l_proc, 25);

Line 358: hr_utility.raise_error;

354: --
355: -- The primary key is invalid therefore we must error
356: --
357: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
358: hr_utility.raise_error;
359: End If;
360: --
361: hr_utility.set_location(l_proc, 25);
362: --

Line 361: hr_utility.set_location(l_proc, 25);

357: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
358: hr_utility.raise_error;
359: End If;
360: --
361: hr_utility.set_location(l_proc, 25);
362: --
363: Close C_Sel1;
364: --
365: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 366: hr_utility.set_location(l_proc, 30);

362: --
363: Close C_Sel1;
364: --
365: If (p_object_version_number <> g_old_rec.object_version_number) Then
366: hr_utility.set_location(l_proc, 30);
367: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
368: hr_utility.raise_error;
369: End If;
370: --

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

363: Close C_Sel1;
364: --
365: If (p_object_version_number <> g_old_rec.object_version_number) Then
366: hr_utility.set_location(l_proc, 30);
367: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
368: hr_utility.raise_error;
369: End If;
370: --
371: hr_utility.set_location(' Leaving:'||l_proc, 35);

Line 368: hr_utility.raise_error;

364: --
365: If (p_object_version_number <> g_old_rec.object_version_number) Then
366: hr_utility.set_location(l_proc, 30);
367: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
368: hr_utility.raise_error;
369: End If;
370: --
371: hr_utility.set_location(' Leaving:'||l_proc, 35);
372: --

Line 371: hr_utility.set_location(' Leaving:'||l_proc, 35);

367: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
368: hr_utility.raise_error;
369: End If;
370: --
371: hr_utility.set_location(' Leaving:'||l_proc, 35);
372: --
373: -- We need to trap the ORA LOCK exception
374: --
375: Exception

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

377: --
378: -- The object is locked therefore we need to supply a meaningful
379: -- error message.
380: --
381: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
382: hr_utility.set_message_token('TABLE_NAME', 'per_periods_of_service');
383: hr_utility.raise_error;
384: End lck;
385: --

Line 382: hr_utility.set_message_token('TABLE_NAME', 'per_periods_of_service');

378: -- The object is locked therefore we need to supply a meaningful
379: -- error message.
380: --
381: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
382: hr_utility.set_message_token('TABLE_NAME', 'per_periods_of_service');
383: hr_utility.raise_error;
384: End lck;
385: --
386: -- ----------------------------------------------------------------------------

Line 383: hr_utility.raise_error;

379: -- error message.
380: --
381: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
382: hr_utility.set_message_token('TABLE_NAME', 'per_periods_of_service');
383: hr_utility.raise_error;
384: End lck;
385: --
386: -- ----------------------------------------------------------------------------
387: -- |-----------------------------< convert_args >-----------------------------|

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

468: l_proc varchar2(72) := g_package||'convert_args';
469: --
470: Begin
471: --
472: hr_utility.set_location('Entering:'||l_proc, 5);
473: --
474: -- Convert arguments into local l_rec structure.
475: --
476: l_rec.period_of_service_id := p_period_of_service_id;

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

548: l_rec.pds_information30 := p_pds_information30;
549: --
550: -- Return the plsql record structure.
551: --
552: hr_utility.set_location(' Leaving:'||l_proc, 10);
553: Return(l_rec);
554: --
555: End convert_args;
556: --