DBA Data[Home] [Help]

APPS.BEN_BFT_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 = 'BEN_BENEFIT_ACTIONS_PK') Then
37: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);

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

33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_BENEFIT_ACTIONS_PK') Then
37: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','5');
40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'BEN_BENEFIT_ACTIONS_DT9') then

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

34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_BENEFIT_ACTIONS_PK') Then
37: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','5');
40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'BEN_BENEFIT_ACTIONS_DT9') then
42: ben_utility.child_exists_error(p_table_name => 'BEN_BENEFIT_ACTIONS');

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

35: --
36: If (p_constraint_name = 'BEN_BENEFIT_ACTIONS_PK') Then
37: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','5');
40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'BEN_BENEFIT_ACTIONS_DT9') then
42: ben_utility.child_exists_error(p_table_name => 'BEN_BENEFIT_ACTIONS');
43: Else

Line 40: hr_utility.raise_error;

36: If (p_constraint_name = 'BEN_BENEFIT_ACTIONS_PK') Then
37: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','5');
40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'BEN_BENEFIT_ACTIONS_DT9') then
42: ben_utility.child_exists_error(p_table_name => 'BEN_BENEFIT_ACTIONS');
43: Else
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: ElsIf (p_constraint_name = 'BEN_BENEFIT_ACTIONS_DT9') then
42: ben_utility.child_exists_error(p_table_name => 'BEN_BENEFIT_ACTIONS');
43: Else
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: End If;

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

41: ElsIf (p_constraint_name = 'BEN_BENEFIT_ACTIONS_DT9') then
42: ben_utility.child_exists_error(p_table_name => 'BEN_BENEFIT_ACTIONS');
43: Else
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: End If;
49: --

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

42: ben_utility.child_exists_error(p_table_name => 'BEN_BENEFIT_ACTIONS');
43: Else
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: End If;
49: --
50: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 47: hr_utility.raise_error;

43: Else
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: End If;
49: --
50: hr_utility.set_location(' Leaving:'||l_proc, 10);
51: End constraint_error;

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

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

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

173: l_proc varchar2(72) := g_package||'api_updating';
174: l_fct_ret boolean;
175: --
176: Begin
177: hr_utility.set_location('Entering:'||l_proc, 5);
178: --
179: If (
180: p_benefit_action_id is null and
181: p_object_version_number is null

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

189: If (
190: p_benefit_action_id = g_old_rec.benefit_action_id and
191: p_object_version_number = g_old_rec.object_version_number
192: ) Then
193: hr_utility.set_location(l_proc, 10);
194: --
195: -- The g_old_rec is current therefore we must
196: -- set the returning function to true
197: --

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

206: Close C_Sel1;
207: --
208: -- The primary key is invalid therefore we must error
209: --
210: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
211: hr_utility.raise_error;
212: End If;
213: Close C_Sel1;
214: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 211: hr_utility.raise_error;

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

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

211: hr_utility.raise_error;
212: End If;
213: Close C_Sel1;
214: If (p_object_version_number <> g_old_rec.object_version_number) Then
215: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
216: hr_utility.raise_error;
217: End If;
218: hr_utility.set_location(l_proc, 15);
219: l_fct_ret := true;

Line 216: hr_utility.raise_error;

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

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

214: If (p_object_version_number <> g_old_rec.object_version_number) Then
215: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
216: hr_utility.raise_error;
217: End If;
218: hr_utility.set_location(l_proc, 15);
219: l_fct_ret := true;
220: End If;
221: End If;
222: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

218: hr_utility.set_location(l_proc, 15);
219: l_fct_ret := true;
220: End If;
221: End If;
222: hr_utility.set_location(' Leaving:'||l_proc, 20);
223: Return (l_fct_ret);
224: --
225: End api_updating;
226: --

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

345: --
346: l_proc varchar2(72) := g_package||'lck';
347: --
348: Begin
349: hr_utility.set_location('Entering:'||l_proc, 5);
350: --
351: -- Add any mandatory argument checking here:
352: -- Example:
353: -- hr_api.mandatory_arg_error

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

361: Close C_Sel1;
362: --
363: -- The primary key is invalid therefore we must error
364: --
365: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
366: hr_utility.raise_error;
367: End If;
368: Close C_Sel1;
369: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 366: hr_utility.raise_error;

362: --
363: -- The primary key is invalid therefore we must error
364: --
365: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
366: hr_utility.raise_error;
367: End If;
368: Close C_Sel1;
369: If (p_object_version_number <> g_old_rec.object_version_number) Then
370: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

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

366: hr_utility.raise_error;
367: End If;
368: Close C_Sel1;
369: If (p_object_version_number <> g_old_rec.object_version_number) Then
370: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
371: hr_utility.raise_error;
372: End If;
373: --
374: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 371: hr_utility.raise_error;

367: End If;
368: Close C_Sel1;
369: If (p_object_version_number <> g_old_rec.object_version_number) Then
370: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
371: hr_utility.raise_error;
372: End If;
373: --
374: hr_utility.set_location(' Leaving:'||l_proc, 10);
375: --

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

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

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

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

Line 385: hr_utility.set_message_token('TABLE_NAME', 'ben_benefit_actions');

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

Line 386: hr_utility.raise_error;

382: -- error message.
383: --
384: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
385: hr_utility.set_message_token('TABLE_NAME', 'ben_benefit_actions');
386: hr_utility.raise_error;
387: End lck;
388: --
389: -- ----------------------------------------------------------------------------
390: -- |-----------------------------< convert_args >-----------------------------|

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

501: l_proc varchar2(72) := g_package||'convert_args';
502: --
503: Begin
504: --
505: hr_utility.set_location('Entering:'||l_proc, 5);
506: --
507: -- Convert arguments into local l_rec structure.
508: --
509: l_rec.benefit_action_id := p_benefit_action_id;

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

611: l_rec.grant_price_val := p_grant_price_val;
612: --
613: -- Return the plsql record structure.
614: --
615: hr_utility.set_location(' Leaving:'||l_proc, 10);
616: Return(l_rec);
617: --
618: End convert_args;
619: --