DBA Data[Home] [Help]

APPS.SSP_STP_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 = 'SSP_STOPPAGES_FK1') Then
37: fnd_message.set_name ('SSP', 'SSP_35069_STOPPAGES_FK1');
38: ElsIf (p_constraint_name = 'SSP_STOPPAGES_FK2') Then

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

54: End If;
55: --
56: fnd_message.raise_error;
57: --
58: hr_utility.set_location(' Leaving:'||l_proc, 10);
59: End constraint_error;
60: --
61: -- ----------------------------------------------------------------------------
62: -- |-----------------------------< api_updating >-----------------------------|

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

88: l_proc varchar2(72) := g_package||'api_updating';
89: l_fct_ret boolean;
90: --
91: Begin
92: hr_utility.set_location('Entering:'||l_proc, 5);
93: --
94: If (
95: p_stoppage_id is null and
96: p_object_version_number is null

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

104: If (
105: p_stoppage_id = g_old_rec.stoppage_id and
106: p_object_version_number = g_old_rec.object_version_number
107: ) Then
108: hr_utility.set_location(l_proc, 10);
109: --
110: -- The g_old_rec is current therefore we must
111: -- set the returning function to true
112: --

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

121: Close C_Sel1;
122: --
123: -- The primary key is invalid therefore we must error
124: --
125: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
126: hr_utility.raise_error;
127: End If;
128: Close C_Sel1;
129: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 126: hr_utility.raise_error;

122: --
123: -- The primary key is invalid therefore we must error
124: --
125: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
126: hr_utility.raise_error;
127: End If;
128: Close C_Sel1;
129: If (p_object_version_number <> g_old_rec.object_version_number) Then
130: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

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

126: hr_utility.raise_error;
127: End If;
128: Close C_Sel1;
129: If (p_object_version_number <> g_old_rec.object_version_number) Then
130: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
131: hr_utility.raise_error;
132: End If;
133: hr_utility.set_location(l_proc, 15);
134: l_fct_ret := true;

Line 131: hr_utility.raise_error;

127: End If;
128: Close C_Sel1;
129: If (p_object_version_number <> g_old_rec.object_version_number) Then
130: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
131: hr_utility.raise_error;
132: End If;
133: hr_utility.set_location(l_proc, 15);
134: l_fct_ret := true;
135: End If;

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

129: If (p_object_version_number <> g_old_rec.object_version_number) Then
130: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
131: hr_utility.raise_error;
132: End If;
133: hr_utility.set_location(l_proc, 15);
134: l_fct_ret := true;
135: End If;
136: End If;
137: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

133: hr_utility.set_location(l_proc, 15);
134: l_fct_ret := true;
135: End If;
136: End If;
137: hr_utility.set_location(' Leaving:'||l_proc, 20);
138: Return (l_fct_ret);
139: --
140: End api_updating;
141: --

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

167: --
168: l_proc varchar2(72) := g_package||'lck';
169: --
170: Begin
171: hr_utility.set_location('Entering:'||l_proc, 5);
172: --
173: -- Add any mandatory argument checking here:
174: -- Example:
175: -- hr_api.mandatory_arg_error

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

183: Close C_Sel1;
184: --
185: -- The primary key is invalid therefore we must error
186: --
187: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
188: hr_utility.raise_error;
189: End If;
190: Close C_Sel1;
191: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 188: hr_utility.raise_error;

184: --
185: -- The primary key is invalid therefore we must error
186: --
187: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
188: hr_utility.raise_error;
189: End If;
190: Close C_Sel1;
191: If (p_object_version_number <> g_old_rec.object_version_number) Then
192: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

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

188: hr_utility.raise_error;
189: End If;
190: Close C_Sel1;
191: If (p_object_version_number <> g_old_rec.object_version_number) Then
192: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
193: hr_utility.raise_error;
194: End If;
195: --
196: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 193: hr_utility.raise_error;

189: End If;
190: Close C_Sel1;
191: If (p_object_version_number <> g_old_rec.object_version_number) Then
192: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
193: hr_utility.raise_error;
194: End If;
195: --
196: hr_utility.set_location(' Leaving:'||l_proc, 10);
197: --

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

192: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
193: hr_utility.raise_error;
194: End If;
195: --
196: hr_utility.set_location(' Leaving:'||l_proc, 10);
197: --
198: -- We need to trap the ORA LOCK exception
199: --
200: Exception

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

202: --
203: -- The object is locked therefore we need to supply a meaningful
204: -- error message.
205: --
206: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
207: hr_utility.set_message_token('TABLE_NAME', 'ssp_stoppages');
208: hr_utility.raise_error;
209: End lck;
210: --

Line 207: hr_utility.set_message_token('TABLE_NAME', 'ssp_stoppages');

203: -- The object is locked therefore we need to supply a meaningful
204: -- error message.
205: --
206: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
207: hr_utility.set_message_token('TABLE_NAME', 'ssp_stoppages');
208: hr_utility.raise_error;
209: End lck;
210: --
211: -- ----------------------------------------------------------------------------

Line 208: hr_utility.raise_error;

204: -- error message.
205: --
206: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
207: hr_utility.set_message_token('TABLE_NAME', 'ssp_stoppages');
208: hr_utility.raise_error;
209: End lck;
210: --
211: -- ----------------------------------------------------------------------------
212: -- |-----------------------------< convert_args >-----------------------------|

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

230: l_proc varchar2(72) := g_package||'convert_args';
231: --
232: Begin
233: --
234: hr_utility.set_location('Entering:'||l_proc, 5);
235: --
236: -- Convert arguments into local l_rec structure.
237: --
238: l_rec.stoppage_id := p_stoppage_id;

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

247: l_rec.withhold_to := p_withhold_to;
248: --
249: -- Return the plsql record structure.
250: --
251: hr_utility.set_location(' Leaving:'||l_proc, 10);
252: Return(l_rec);
253: --
254: End convert_args;
255: --