DBA Data[Home] [Help]

APPS.HR_CAGR_PARAMETER_API dependencies on HR_UTILITY

Line 37: hr_utility.set_location('Entering:'|| l_proc, 10);

33: l_effective_date DATE;
34: --
35: begin
36: --
37: hr_utility.set_location('Entering:'|| l_proc, 10);
38: --
39: -- Issue a savepoint if operating in validation only mode
40: --
41: savepoint create_cagr_parameter;

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

43: -- Truncate the time portion from all IN date parameters
44: --
45: l_effective_date := TRUNC(p_effective_date);
46: --
47: hr_utility.set_location(l_proc, 20);
48: --
49: -- Process Logic
50: --
51: --

Line 68: hr_utility.set_location(l_proc, 60);

64: ,p_cagr_api_param_id => l_cagr_api_param_id
65: ,p_object_version_number => l_object_version_number
66: );
67: --
68: hr_utility.set_location(l_proc, 60);
69: --
70: -- When in validation only mode raise the Validate_Enabled exception
71: --
72: if p_validate then

Line 81: hr_utility.set_location(' Leaving:'||l_proc, 70);

77: --
78: p_object_version_number := l_object_version_number;
79: p_cagr_api_param_id := l_cagr_api_param_id;
80: --
81: hr_utility.set_location(' Leaving:'||l_proc, 70);
82: --
83: exception
84: --
85: when hr_api.validate_enabled then

Line 99: hr_utility.set_location(' Leaving:'||l_proc, 80);

95: --
96: p_object_version_number := null;
97: p_cagr_api_param_id := null;
98: --
99: hr_utility.set_location(' Leaving:'||l_proc, 80);
100: --
101: when others then
102: --
103: -- A validation or unexpected error has occured

Line 110: hr_utility.set_location(' Leaving:'||l_proc, 90);

106: -- Set out parameters
107: p_object_version_number := null;
108: p_cagr_api_param_id := null;
109: --
110: hr_utility.set_location(' Leaving:'||l_proc, 90);
111: raise;
112: --
113: end create_cagr_parameter;
114: -- ----------------------------------------------------------------------------

Line 143: hr_utility.set_location('Entering:'|| l_proc, 10);

139: l_temp_object_version_number per_cagr_api_parameters.object_version_number%TYPE;
140: --
141: begin
142: --
143: hr_utility.set_location('Entering:'|| l_proc, 10);
144: --
145: -- Issue a savepoint if operating in validation only mode
146: --
147: savepoint update_cagr_parameter;

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

145: -- Issue a savepoint if operating in validation only mode
146: --
147: savepoint update_cagr_parameter;
148: --
149: hr_utility.set_location(l_proc, 20);
150: --
151: -- Truncate the time portion from all IN date parameters
152: --
153: l_effective_date := TRUNC(p_effective_date);

Line 176: hr_utility.set_location(l_proc, 60);

172: ,p_hidden => p_hidden
173: ,p_object_version_number => l_object_version_number
174: );
175: --
176: hr_utility.set_location(l_proc, 60);
177: --
178: -- When in validation only mode raise the Validate_Enabled exception
179: --
180: if p_validate then

Line 188: hr_utility.set_location(' Leaving:'||l_proc, 70);

184: -- Set all output arguments
185: --
186: p_object_version_number := l_object_version_number;
187: --
188: hr_utility.set_location(' Leaving:'||l_proc, 70);
189: --
190: exception
191: --
192: when hr_api.validate_enabled then

Line 203: hr_utility.set_location(' Leaving:'||l_proc, 80);

199: -- Only set output warning arguments
200: -- (Any key or derived arguments must be set to null
201: -- when validation only mode is being used.)
202: --
203: hr_utility.set_location(' Leaving:'||l_proc, 80);
204: --
205: when others then
206: --
207: -- A validation or unexpected error has occured

Line 214: hr_utility.set_location(' Leaving:'||l_proc, 90);

210: --
211: -- Reset in out parameters
212: p_object_version_number := l_temp_object_version_number;
213: --
214: hr_utility.set_location(' Leaving:'||l_proc, 90);
215: raise;
216: --
217: end update_cagr_parameter;
218: -- ----------------------------------------------------------------------------

Line 236: hr_utility.set_location('Entering:'|| l_proc, 10);

232: l_object_version_number per_cagr_api_parameters.object_version_number%TYPE;
233: --
234: begin
235: --
236: hr_utility.set_location('Entering:'|| l_proc, 10);
237: --
238: -- Issue a savepoint if operating in validation only mode
239: --
240: savepoint delete_cagr_parameter;

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

238: -- Issue a savepoint if operating in validation only mode
239: --
240: savepoint delete_cagr_parameter;
241: --
242: hr_utility.set_location(l_proc, 20);
243: --
244: -- Process Logic
245: --
246: l_object_version_number := p_object_version_number;

Line 254: hr_utility.set_location(l_proc, 60);

250: p_cagr_api_param_id => p_cagr_api_param_id
251: ,p_object_version_number => l_object_version_number
252: );
253: --
254: hr_utility.set_location(l_proc, 60);
255: --
256: -- When in validation only mode raise the Validate_Enabled exception
257: --
258: if p_validate then

Line 262: hr_utility.set_location(' Leaving:'||l_proc, 70);

258: if p_validate then
259: raise hr_api.validate_enabled;
260: end if;
261: --
262: hr_utility.set_location(' Leaving:'||l_proc, 70);
263: --
264: exception
265: --
266: when hr_api.validate_enabled then

Line 286: hr_utility.set_location(' Leaving:'||l_proc, 80);

282: ROLLBACK TO delete_cagr_parameter;
283: -- set in out parameters
284: p_object_version_number := l_object_version_number;
285: --
286: hr_utility.set_location(' Leaving:'||l_proc, 80);
287: raise;
288: --
289: end delete_cagr_parameter;
290: --