DBA Data[Home] [Help]

APPS.OTA_FRM_NOTIF_SUBSCRIBER_API dependencies on HR_UTILITY

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

29:
30: l_mode varchar2(1);
31:
32: begin
33: hr_utility.set_location('Entering:'|| l_proc, 10);
34: --
35: -- Issue a savepoint
36: --
37: savepoint CREATE_FRM_NOTIF_SUBSCRIBER;

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

99: if p_validate then
100: raise hr_api.validate_enabled;
101: end if;
102:
103: hr_utility.set_location(' Leaving:'||l_proc, 70);
104: exception
105: when hr_api.validate_enabled then
106: --
107: -- As the Validate_Enabled exception has been raised

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

113: -- (Any key or derived arguments must be set to null
114: -- when validation only mode is being used.)
115: --
116: p_object_version_number := null;
117: hr_utility.set_location(' Leaving:'||l_proc, 80);
118: when others then
119: --
120: -- A validation or unexpected error has occured
121: --

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

120: -- A validation or unexpected error has occured
121: --
122: rollback to CREATE_FRM_NOTIF_SUBSCRIBER;
123: p_object_version_number := null;
124: hr_utility.set_location(' Leaving:'||l_proc, 90);
125: raise;
126: end create_frm_notif_subscriber;
127: -- ----------------------------------------------------------------------------
128: -- |-------------------------< UPDATE_FRM_NOTIF_SUBSCRIBER >-------------------------|

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

146:
147: l_mode varchar2(1);
148:
149: begin
150: hr_utility.set_location('Entering:'|| l_proc, 10);
151: --
152: -- Issue a savepoint
153: --
154: savepoint UPDATE_FRM_NOTIF_SUBSCRIBER;

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

215: -- Set all output arguments
216: --
217: p_object_version_number := l_object_version_number;
218:
219: hr_utility.set_location(' Leaving:'||l_proc, 70);
220: exception
221: when hr_api.validate_enabled then
222: --
223: -- As the Validate_Enabled exception has been raised

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

225: --
226: rollback to UPDATE_FRM_NOTIF_SUBSCRIBER;
227: --
228: p_object_version_number := null;
229: hr_utility.set_location(' Leaving:'||l_proc, 80);
230: when others then
231: --
232: -- A validation or unexpected error has occured
233: --

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

232: -- A validation or unexpected error has occured
233: --
234: rollback to UPDATE_FRM_NOTIF_SUBSCRIBER;
235: p_object_version_number := l_object_version_number;
236: hr_utility.set_location(' Leaving:'||l_proc, 90);
237: raise;
238: end update_frm_notif_subscriber;
239: --
240: -- ----------------------------------------------------------------------------

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

254: l_proc varchar2(72) := g_package||' delete_frm_notif_subscriber';
255: --
256: --
257: begin
258: hr_utility.set_location('Entering:'|| l_proc, 10);
259: --
260: -- Issue a savepoint
261: --
262: savepoint DEELTE_FRM_NOTIF_SUBSCRIBER ;

Line 321: hr_utility.set_location(' Leaving:'||l_proc, 170);

317: --
318: -- Set all output arguments
319: --
320: --
321: hr_utility.set_location(' Leaving:'||l_proc, 170);
322: exception
323: when hr_api.validate_enabled then
324: --
325: -- As the Validate_Enabled exception has been raised

Line 334: hr_utility.set_location(' Leaving:'||l_proc, 180);

330: -- Only set output warning arguments
331: -- (Any key or derived arguments must be set to null
332: -- when validation only mode is being used.)
333: --
334: hr_utility.set_location(' Leaving:'||l_proc, 180);
335: when others then
336: --
337: -- A validation or unexpected error has occured
338: --

Line 340: hr_utility.set_location(' Leaving:'||l_proc, 190);

336: --
337: -- A validation or unexpected error has occured
338: --
339: rollback to DEELTE_FRM_NOTIF_SUBSCRIBER ;
340: hr_utility.set_location(' Leaving:'||l_proc, 190);
341: raise;
342: end delete_frm_notif_subscriber;
343: --
344: end OTA_FRM_NOTIF_SUBSCRIBER_API;