DBA Data[Home] [Help]

APPS.PAY_USER_TABLE_API dependencies on HR_API

Line 56: when hr_api.cannot_find_prog_unit then

52: ,p_user_table_name => p_user_table_name
53: ,p_user_row_title => p_user_row_title
54: );
55: exception
56: when hr_api.cannot_find_prog_unit then
57: hr_api.cannot_find_prog_unit_error
58: (p_module_name => 'create_user_table'
59: ,p_hook_type => 'BP'
60: );

Line 57: hr_api.cannot_find_prog_unit_error

53: ,p_user_row_title => p_user_row_title
54: );
55: exception
56: when hr_api.cannot_find_prog_unit then
57: hr_api.cannot_find_prog_unit_error
58: (p_module_name => 'create_user_table'
59: ,p_hook_type => 'BP'
60: );
61: end;

Line 92: when hr_api.cannot_find_prog_unit then

88: ,p_user_table_id => l_user_table_id
89: ,p_object_version_number => l_ovn
90: );
91: exception
92: when hr_api.cannot_find_prog_unit then
93: hr_api.cannot_find_prog_unit_error
94: (p_module_name => 'create_user_table'
95: ,p_hook_type => 'AP'
96: );

Line 93: hr_api.cannot_find_prog_unit_error

89: ,p_object_version_number => l_ovn
90: );
91: exception
92: when hr_api.cannot_find_prog_unit then
93: hr_api.cannot_find_prog_unit_error
94: (p_module_name => 'create_user_table'
95: ,p_hook_type => 'AP'
96: );
97: end;

Line 102: raise hr_api.validate_enabled;

98: --
99: -- When in validation only mode raise the Validate_Enabled exception
100: --
101: if p_validate then
102: raise hr_api.validate_enabled;
103: end if;
104: --
105: -- Set all output arguments
106: --

Line 116: when hr_api.validate_enabled then

112: p_user_table_name,p_user_row_title);
113: --------------------------------------------------------------------------------
114: hr_utility.set_location(' Leaving:'||l_proc, 70);
115: exception
116: when hr_api.validate_enabled then
117: --
118: -- As the Validate_Enabled exception has been raised
119: -- we must rollback to the savepoint
120: --

Line 147: ,p_user_table_name in varchar2 default hr_api.g_varchar2

143: procedure update_user_table
144: (p_validate in boolean default false
145: ,p_user_table_id in number
146: ,p_effective_date in date
147: ,p_user_table_name in varchar2 default hr_api.g_varchar2
148: ,p_user_row_title in varchar2 default hr_api.g_varchar2
149: ,p_object_version_number in out nocopy number
150: ) is
151: --

Line 148: ,p_user_row_title in varchar2 default hr_api.g_varchar2

144: (p_validate in boolean default false
145: ,p_user_table_id in number
146: ,p_effective_date in date
147: ,p_user_table_name in varchar2 default hr_api.g_varchar2
148: ,p_user_row_title in varchar2 default hr_api.g_varchar2
149: ,p_object_version_number in out nocopy number
150: ) is
151: --
152: -- Declare cursors and local variables

Line 179: when hr_api.cannot_find_prog_unit then

175: ,p_user_row_title => p_user_row_title
176: ,p_object_version_number => l_ovn
177: );
178: exception
179: when hr_api.cannot_find_prog_unit then
180: hr_api.cannot_find_prog_unit_error
181: (p_module_name => 'update_user_table'
182: ,p_hook_type => 'BP'
183: );

Line 180: hr_api.cannot_find_prog_unit_error

176: ,p_object_version_number => l_ovn
177: );
178: exception
179: when hr_api.cannot_find_prog_unit then
180: hr_api.cannot_find_prog_unit_error
181: (p_module_name => 'update_user_table'
182: ,p_hook_type => 'BP'
183: );
184: end;

Line 207: when hr_api.cannot_find_prog_unit then

203: ,p_user_row_title => p_user_row_title
204: ,p_object_version_number => l_ovn
205: );
206: exception
207: when hr_api.cannot_find_prog_unit then
208: hr_api.cannot_find_prog_unit_error
209: (p_module_name => 'update_user_table'
210: ,p_hook_type => 'AP'
211: );

Line 208: hr_api.cannot_find_prog_unit_error

204: ,p_object_version_number => l_ovn
205: );
206: exception
207: when hr_api.cannot_find_prog_unit then
208: hr_api.cannot_find_prog_unit_error
209: (p_module_name => 'update_user_table'
210: ,p_hook_type => 'AP'
211: );
212: end;

Line 217: raise hr_api.validate_enabled;

213: --
214: -- When in validation only mode raise the Validate_Enabled exception
215: --
216: if p_validate then
217: raise hr_api.validate_enabled;
218: end if;
219: --
220: -- Set all output arguments
221: --

Line 230: when hr_api.validate_enabled then

226: p_user_table_name,p_user_row_title);
227: --------------------------------------------------------------------------------
228: hr_utility.set_location(' Leaving:'||l_proc, 70);
229: exception
230: when hr_api.validate_enabled then
231: --
232: -- As the Validate_Enabled exception has been raised
233: -- we must rollback to the savepoint
234: --

Line 282: when hr_api.cannot_find_prog_unit then

278: (p_user_table_id => p_user_table_id
279: ,p_object_version_number => l_ovn
280: );
281: exception
282: when hr_api.cannot_find_prog_unit then
283: hr_api.cannot_find_prog_unit_error
284: (p_module_name => 'delete_user_table'
285: ,p_hook_type => 'BP'
286: );

Line 283: hr_api.cannot_find_prog_unit_error

279: ,p_object_version_number => l_ovn
280: );
281: exception
282: when hr_api.cannot_find_prog_unit then
283: hr_api.cannot_find_prog_unit_error
284: (p_module_name => 'delete_user_table'
285: ,p_hook_type => 'BP'
286: );
287: end;

Line 304: when hr_api.cannot_find_prog_unit then

300: (p_user_table_id => p_user_table_id
301: ,p_object_version_number => l_ovn
302: );
303: exception
304: when hr_api.cannot_find_prog_unit then
305: hr_api.cannot_find_prog_unit_error
306: (p_module_name => 'delete_user_table'
307: ,p_hook_type => 'AP'
308: );

Line 305: hr_api.cannot_find_prog_unit_error

301: ,p_object_version_number => l_ovn
302: );
303: exception
304: when hr_api.cannot_find_prog_unit then
305: hr_api.cannot_find_prog_unit_error
306: (p_module_name => 'delete_user_table'
307: ,p_hook_type => 'AP'
308: );
309: end;

Line 314: raise hr_api.validate_enabled;

310: --
311: -- When in validation only mode raise the Validate_Enabled exception
312: --
313: if p_validate then
314: raise hr_api.validate_enabled;
315: end if;
316: --
317: -- Set all output arguments
318: --

Line 327: when hr_api.validate_enabled then

323: --------------------------------------------------------------------------------
324:
325: hr_utility.set_location(' Leaving:'||l_proc, 70);
326: exception
327: when hr_api.validate_enabled then
328: --
329: -- As the Validate_Enabled exception has been raised
330: -- we must rollback to the savepoint
331: --