DBA Data[Home] [Help]

APPS.BEN_CWB_MATRIX_API dependencies on HR_API

Line 55: when hr_api.cannot_find_prog_unit then

51: ,p_col_crit_cd => p_col_crit_cd
52: ,p_alct_by_cd => p_alct_by_cd
53: );
54: exception
55: when hr_api.cannot_find_prog_unit then
56: hr_api.cannot_find_prog_unit_error
57: (p_module_name => 'create_cwb_matrix'
58: ,p_hook_type => 'BP'
59: );

Line 56: hr_api.cannot_find_prog_unit_error

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

Line 97: when hr_api.cannot_find_prog_unit then

93: ,p_object_version_number => l_object_version_number
94: );
95:
96: exception
97: when hr_api.cannot_find_prog_unit then
98: hr_api.cannot_find_prog_unit_error
99: (p_module_name => 'create_cwb_matrix'
100: ,p_hook_type => 'AP'
101: );

Line 98: hr_api.cannot_find_prog_unit_error

94: );
95:
96: exception
97: when hr_api.cannot_find_prog_unit then
98: hr_api.cannot_find_prog_unit_error
99: (p_module_name => 'create_cwb_matrix'
100: ,p_hook_type => 'AP'
101: );
102: end;

Line 107: raise hr_api.validate_enabled;

103: --
104: -- When in validation only mode raise the Validate_Enabled exception
105: --
106: if p_validate then
107: raise hr_api.validate_enabled;
108: end if;
109: --
110: -- Set all output arguments
111: --

Line 118: when hr_api.validate_enabled then

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

Line 153: ,p_business_group_id in number default hr_api.g_number

149: procedure update_cwb_matrix
150: (p_validate in boolean default false
151: ,p_cwb_matrix_id in number
152: ,p_effective_date in date
153: ,p_business_group_id in number default hr_api.g_number
154: ,p_name in varchar2 default hr_api.g_varchar2
155: ,p_plan_id in number default hr_api.g_number
156: ,p_matrix_typ_cd in varchar2 default hr_api.g_varchar2
157: ,p_person_id in number default hr_api.g_number

Line 154: ,p_name in varchar2 default hr_api.g_varchar2

150: (p_validate in boolean default false
151: ,p_cwb_matrix_id in number
152: ,p_effective_date in date
153: ,p_business_group_id in number default hr_api.g_number
154: ,p_name in varchar2 default hr_api.g_varchar2
155: ,p_plan_id in number default hr_api.g_number
156: ,p_matrix_typ_cd in varchar2 default hr_api.g_varchar2
157: ,p_person_id in number default hr_api.g_number
158: ,p_row_crit_cd in varchar2 default hr_api.g_varchar2

Line 155: ,p_plan_id in number default hr_api.g_number

151: ,p_cwb_matrix_id in number
152: ,p_effective_date in date
153: ,p_business_group_id in number default hr_api.g_number
154: ,p_name in varchar2 default hr_api.g_varchar2
155: ,p_plan_id in number default hr_api.g_number
156: ,p_matrix_typ_cd in varchar2 default hr_api.g_varchar2
157: ,p_person_id in number default hr_api.g_number
158: ,p_row_crit_cd in varchar2 default hr_api.g_varchar2
159: ,p_col_crit_cd in varchar2 default hr_api.g_varchar2

Line 156: ,p_matrix_typ_cd in varchar2 default hr_api.g_varchar2

152: ,p_effective_date in date
153: ,p_business_group_id in number default hr_api.g_number
154: ,p_name in varchar2 default hr_api.g_varchar2
155: ,p_plan_id in number default hr_api.g_number
156: ,p_matrix_typ_cd in varchar2 default hr_api.g_varchar2
157: ,p_person_id in number default hr_api.g_number
158: ,p_row_crit_cd in varchar2 default hr_api.g_varchar2
159: ,p_col_crit_cd in varchar2 default hr_api.g_varchar2
160: ,p_alct_by_cd in varchar2 default hr_api.g_varchar2

Line 157: ,p_person_id in number default hr_api.g_number

153: ,p_business_group_id in number default hr_api.g_number
154: ,p_name in varchar2 default hr_api.g_varchar2
155: ,p_plan_id in number default hr_api.g_number
156: ,p_matrix_typ_cd in varchar2 default hr_api.g_varchar2
157: ,p_person_id in number default hr_api.g_number
158: ,p_row_crit_cd in varchar2 default hr_api.g_varchar2
159: ,p_col_crit_cd in varchar2 default hr_api.g_varchar2
160: ,p_alct_by_cd in varchar2 default hr_api.g_varchar2
161: ,p_object_version_number in out nocopy number

Line 158: ,p_row_crit_cd in varchar2 default hr_api.g_varchar2

154: ,p_name in varchar2 default hr_api.g_varchar2
155: ,p_plan_id in number default hr_api.g_number
156: ,p_matrix_typ_cd in varchar2 default hr_api.g_varchar2
157: ,p_person_id in number default hr_api.g_number
158: ,p_row_crit_cd in varchar2 default hr_api.g_varchar2
159: ,p_col_crit_cd in varchar2 default hr_api.g_varchar2
160: ,p_alct_by_cd in varchar2 default hr_api.g_varchar2
161: ,p_object_version_number in out nocopy number
162: ) is

Line 159: ,p_col_crit_cd in varchar2 default hr_api.g_varchar2

155: ,p_plan_id in number default hr_api.g_number
156: ,p_matrix_typ_cd in varchar2 default hr_api.g_varchar2
157: ,p_person_id in number default hr_api.g_number
158: ,p_row_crit_cd in varchar2 default hr_api.g_varchar2
159: ,p_col_crit_cd in varchar2 default hr_api.g_varchar2
160: ,p_alct_by_cd in varchar2 default hr_api.g_varchar2
161: ,p_object_version_number in out nocopy number
162: ) is
163: --

Line 160: ,p_alct_by_cd in varchar2 default hr_api.g_varchar2

156: ,p_matrix_typ_cd in varchar2 default hr_api.g_varchar2
157: ,p_person_id in number default hr_api.g_number
158: ,p_row_crit_cd in varchar2 default hr_api.g_varchar2
159: ,p_col_crit_cd in varchar2 default hr_api.g_varchar2
160: ,p_alct_by_cd in varchar2 default hr_api.g_varchar2
161: ,p_object_version_number in out nocopy number
162: ) is
163: --
164: -- Declare cursors and local variables

Line 200: when hr_api.cannot_find_prog_unit then

196: ,p_object_version_number => p_object_version_number
197: );
198:
199: exception
200: when hr_api.cannot_find_prog_unit then
201: hr_api.cannot_find_prog_unit_error
202: (p_module_name => 'update_cwb_matrix'
203: ,p_hook_type => 'BP'
204: );

Line 201: hr_api.cannot_find_prog_unit_error

197: );
198:
199: exception
200: when hr_api.cannot_find_prog_unit then
201: hr_api.cannot_find_prog_unit_error
202: (p_module_name => 'update_cwb_matrix'
203: ,p_hook_type => 'BP'
204: );
205: end;

Line 245: when hr_api.cannot_find_prog_unit then

241: ,p_object_version_number => l_object_version_number
242: );
243:
244: exception
245: when hr_api.cannot_find_prog_unit then
246: hr_api.cannot_find_prog_unit_error
247: (p_module_name => 'update_cwb_matrix'
248: ,p_hook_type => 'AP'
249: );

Line 246: hr_api.cannot_find_prog_unit_error

242: );
243:
244: exception
245: when hr_api.cannot_find_prog_unit then
246: hr_api.cannot_find_prog_unit_error
247: (p_module_name => 'update_cwb_matrix'
248: ,p_hook_type => 'AP'
249: );
250: --

Line 258: raise hr_api.validate_enabled;

254: --
255: -- When in validation only mode raise the Validate_Enabled exception
256: --
257: if p_validate then
258: raise hr_api.validate_enabled;
259: end if;
260: --
261: -- Set all output arguments
262: --

Line 268: when hr_api.validate_enabled then

264: --
265: hr_utility.set_location(' Leaving:'||l_proc, 70);
266: --
267: exception
268: when hr_api.validate_enabled then
269: --
270: -- As the Validate_Enabled exception has been raised
271: -- we must rollback to the savepoint
272: --

Line 330: when hr_api.cannot_find_prog_unit then

326: ,p_object_version_number => p_object_version_number
327: );
328:
329: exception
330: when hr_api.cannot_find_prog_unit then
331: hr_api.cannot_find_prog_unit_error
332: (p_module_name => 'delete_cwb_matrix'
333: ,p_hook_type => 'BP'
334: );

Line 331: hr_api.cannot_find_prog_unit_error

327: );
328:
329: exception
330: when hr_api.cannot_find_prog_unit then
331: hr_api.cannot_find_prog_unit_error
332: (p_module_name => 'delete_cwb_matrix'
333: ,p_hook_type => 'BP'
334: );
335: end;

Line 357: when hr_api.cannot_find_prog_unit then

353: ,p_object_version_number => l_object_version_number
354: );
355:
356: exception
357: when hr_api.cannot_find_prog_unit then
358: hr_api.cannot_find_prog_unit_error
359: (p_module_name => 'delete_cwb_matrix'
360: ,p_hook_type => 'AP'
361: );

Line 358: hr_api.cannot_find_prog_unit_error

354: );
355:
356: exception
357: when hr_api.cannot_find_prog_unit then
358: hr_api.cannot_find_prog_unit_error
359: (p_module_name => 'delete_cwb_matrix'
360: ,p_hook_type => 'AP'
361: );
362: --

Line 370: raise hr_api.validate_enabled;

366: --
367: -- When in validation only mode raise the Validate_Enabled exception
368: --
369: if p_validate then
370: raise hr_api.validate_enabled;
371: end if;
372: --
373: hr_utility.set_location(' Leaving:'||l_proc, 70);
374: --

Line 376: when hr_api.validate_enabled then

372: --
373: hr_utility.set_location(' Leaving:'||l_proc, 70);
374: --
375: exception
376: when hr_api.validate_enabled then
377: --
378: -- As the Validate_Enabled exception has been raised
379: -- we must rollback to the savepoint
380: --