DBA Data[Home] [Help]

APPS.HR_ABM_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 = 'HR_ABM_STATUS_CHECK') Then
37:
38: hr_utility.set_message(801, 'HR_7297_API_ARG_ONLY');

Line 38: hr_utility.set_message(801, 'HR_7297_API_ARG_ONLY');

34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'HR_ABM_STATUS_CHECK') Then
37:
38: hr_utility.set_message(801, 'HR_7297_API_ARG_ONLY');
39: hr_utility.set_message_token('ARG_NAME', 'status');
40: hr_utility.set_message_token('ARG_ONLY','(F,S)');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'HR_API_BATCH_MESSAGE_LINES_PK') Then

Line 39: hr_utility.set_message_token('ARG_NAME', 'status');

35: --
36: If (p_constraint_name = 'HR_ABM_STATUS_CHECK') Then
37:
38: hr_utility.set_message(801, 'HR_7297_API_ARG_ONLY');
39: hr_utility.set_message_token('ARG_NAME', 'status');
40: hr_utility.set_message_token('ARG_ONLY','(F,S)');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'HR_API_BATCH_MESSAGE_LINES_PK') Then
43: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

Line 40: hr_utility.set_message_token('ARG_ONLY','(F,S)');

36: If (p_constraint_name = 'HR_ABM_STATUS_CHECK') Then
37:
38: hr_utility.set_message(801, 'HR_7297_API_ARG_ONLY');
39: hr_utility.set_message_token('ARG_NAME', 'status');
40: hr_utility.set_message_token('ARG_ONLY','(F,S)');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'HR_API_BATCH_MESSAGE_LINES_PK') Then
43: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
44: hr_utility.raise_error;

Line 41: hr_utility.raise_error;

37:
38: hr_utility.set_message(801, 'HR_7297_API_ARG_ONLY');
39: hr_utility.set_message_token('ARG_NAME', 'status');
40: hr_utility.set_message_token('ARG_ONLY','(F,S)');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'HR_API_BATCH_MESSAGE_LINES_PK') Then
43: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
44: hr_utility.raise_error;
45: Else

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

39: hr_utility.set_message_token('ARG_NAME', 'status');
40: hr_utility.set_message_token('ARG_ONLY','(F,S)');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'HR_API_BATCH_MESSAGE_LINES_PK') Then
43: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
44: hr_utility.raise_error;
45: Else
46: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
47: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 44: hr_utility.raise_error;

40: hr_utility.set_message_token('ARG_ONLY','(F,S)');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'HR_API_BATCH_MESSAGE_LINES_PK') Then
43: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
44: hr_utility.raise_error;
45: Else
46: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
47: hr_utility.set_message_token('PROCEDURE', l_proc);
48: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);

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

42: ElsIf (p_constraint_name = 'HR_API_BATCH_MESSAGE_LINES_PK') Then
43: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
44: hr_utility.raise_error;
45: Else
46: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
47: hr_utility.set_message_token('PROCEDURE', l_proc);
48: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
49: hr_utility.raise_error;
50: End If;

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

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

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

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

Line 49: hr_utility.raise_error;

45: Else
46: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
47: hr_utility.set_message_token('PROCEDURE', l_proc);
48: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
49: hr_utility.raise_error;
50: End If;
51: --
52: hr_utility.set_location(' Leaving:'||l_proc, 10);
53: End constraint_error;

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

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

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

74: --
75: l_proc varchar2(72) := g_package||'lck';
76: --
77: Begin
78: hr_utility.set_location('Entering:'||l_proc, 5);
79: --
80: hr_api.mandatory_arg_error
81: (p_api_name => l_proc,
82: p_argument => 'line_id',

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

88: Close C_Sel1;
89: --
90: -- The primary key is invalid therefore we must error
91: --
92: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
93: hr_utility.raise_error;
94: End If;
95: Close C_Sel1;
96: --

Line 93: hr_utility.raise_error;

89: --
90: -- The primary key is invalid therefore we must error
91: --
92: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
93: hr_utility.raise_error;
94: End If;
95: Close C_Sel1;
96: --
97: --

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

94: End If;
95: Close C_Sel1;
96: --
97: --
98: hr_utility.set_location(' Leaving:'||l_proc, 10);
99: --
100: -- We need to trap the ORA LOCK exception
101: --
102: Exception

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

104: --
105: -- The object is locked therefore we need to supply a meaningful
106: -- error message.
107: --
108: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
109: hr_utility.set_message_token('TABLE_NAME', 'hr_api_batch_message_lines');
110: hr_utility.raise_error;
111: End lck;
112: --

Line 109: hr_utility.set_message_token('TABLE_NAME', 'hr_api_batch_message_lines');

105: -- The object is locked therefore we need to supply a meaningful
106: -- error message.
107: --
108: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
109: hr_utility.set_message_token('TABLE_NAME', 'hr_api_batch_message_lines');
110: hr_utility.raise_error;
111: End lck;
112: --
113: -- ----------------------------------------------------------------------------

Line 110: hr_utility.raise_error;

106: -- error message.
107: --
108: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
109: hr_utility.set_message_token('TABLE_NAME', 'hr_api_batch_message_lines');
110: hr_utility.raise_error;
111: End lck;
112: --
113: -- ----------------------------------------------------------------------------
114: -- |-----------------------------< convert_args >-----------------------------|

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

130: l_proc varchar2(72) := g_package||'convert_args';
131: --
132: Begin
133: --
134: hr_utility.set_location('Entering:'||l_proc, 5);
135: --
136: -- Convert arguments into local l_rec structure.
137: --
138: l_rec.line_id := p_line_id;

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

145: l_rec.source_row_information := p_source_row_information;
146: --
147: -- Return the plsql record structure.
148: --
149: hr_utility.set_location(' Leaving:'||l_proc, 10);
150: Return(l_rec);
151: --
152: End convert_args;
153: --