DBA Data[Home] [Help]

APPS.PAY_PWR_UPD dependencies on HR_API

Line 84: When hr_api.check_integrity_violated Then

80: --
81: hr_utility.set_location(' Leaving:'||l_proc, 10);
82: --
83: Exception
84: When hr_api.check_integrity_violated Then
85: -- A check constraint has been violated
86: pay_pwr_shd.g_api_dml := false; -- Unset the api dml status
87: pay_pwr_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

84: When hr_api.check_integrity_violated Then
85: -- A check constraint has been violated
86: pay_pwr_shd.g_api_dml := false; -- Unset the api dml status
87: pay_pwr_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: pay_pwr_shd.g_api_dml := false; -- Unset the api dml status
92: pay_pwr_shd.constraint_error

Line 89: When hr_api.parent_integrity_violated Then

85: -- A check constraint has been violated
86: pay_pwr_shd.g_api_dml := false; -- Unset the api dml status
87: pay_pwr_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: pay_pwr_shd.g_api_dml := false; -- Unset the api dml status
92: pay_pwr_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: pay_pwr_shd.g_api_dml := false; -- Unset the api dml status
92: pay_pwr_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: pay_pwr_shd.g_api_dml := false; -- Unset the api dml status
97: pay_pwr_shd.constraint_error

Line 94: When hr_api.unique_integrity_violated Then

90: -- Parent integrity has been violated
91: pay_pwr_shd.g_api_dml := false; -- Unset the api dml status
92: pay_pwr_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: pay_pwr_shd.g_api_dml := false; -- Unset the api dml status
97: pay_pwr_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: pay_pwr_shd.g_api_dml := false; -- Unset the api dml status
97: pay_pwr_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: pay_pwr_shd.g_api_dml := false; -- Unset the api dml status
101: Raise;
102: End update_dml;

Line 211: when hr_api.cannot_find_prog_unit then

207: );
208: --
209: exception
210: --
211: when hr_api.cannot_find_prog_unit then
212: --
213: hr_api.cannot_find_prog_unit_error
214: (p_module_name => 'pay_wci_rates'
215: ,p_hook_type => 'AU');

Line 213: hr_api.cannot_find_prog_unit_error

209: exception
210: --
211: when hr_api.cannot_find_prog_unit then
212: --
213: hr_api.cannot_find_prog_unit_error
214: (p_module_name => 'pay_wci_rates'
215: ,p_hook_type => 'AU');
216: --
217: end;

Line 281: If (p_rec.business_group_id = hr_api.g_number) then

277: -- p_rec plsql record structure
278: -- to see if a system default is being used. If a system default
279: -- is being used then we must set to the 'current' argument value.
280: --
281: If (p_rec.business_group_id = hr_api.g_number) then
282: p_rec.business_group_id :=
283: pay_pwr_shd.g_old_rec.business_group_id;
284: End If;
285: If (p_rec.account_id = hr_api.g_number) then

Line 285: If (p_rec.account_id = hr_api.g_number) then

281: If (p_rec.business_group_id = hr_api.g_number) then
282: p_rec.business_group_id :=
283: pay_pwr_shd.g_old_rec.business_group_id;
284: End If;
285: If (p_rec.account_id = hr_api.g_number) then
286: p_rec.account_id :=
287: pay_pwr_shd.g_old_rec.account_id;
288: End If;
289: If (p_rec.code = hr_api.g_varchar2) then

Line 289: If (p_rec.code = hr_api.g_varchar2) then

285: If (p_rec.account_id = hr_api.g_number) then
286: p_rec.account_id :=
287: pay_pwr_shd.g_old_rec.account_id;
288: End If;
289: If (p_rec.code = hr_api.g_varchar2) then
290: p_rec.code :=
291: pay_pwr_shd.g_old_rec.code;
292: End If;
293: If (p_rec.rate = hr_api.g_number) then

Line 293: If (p_rec.rate = hr_api.g_number) then

289: If (p_rec.code = hr_api.g_varchar2) then
290: p_rec.code :=
291: pay_pwr_shd.g_old_rec.code;
292: End If;
293: If (p_rec.rate = hr_api.g_number) then
294: p_rec.rate :=
295: pay_pwr_shd.g_old_rec.rate;
296: End If;
297: If (p_rec.description = hr_api.g_varchar2) then

Line 297: If (p_rec.description = hr_api.g_varchar2) then

293: If (p_rec.rate = hr_api.g_number) then
294: p_rec.rate :=
295: pay_pwr_shd.g_old_rec.rate;
296: End If;
297: If (p_rec.description = hr_api.g_varchar2) then
298: p_rec.description :=
299: pay_pwr_shd.g_old_rec.description;
300: End If;
301: If (p_rec.comments = hr_api.g_varchar2) then

Line 301: If (p_rec.comments = hr_api.g_varchar2) then

297: If (p_rec.description = hr_api.g_varchar2) then
298: p_rec.description :=
299: pay_pwr_shd.g_old_rec.description;
300: End If;
301: If (p_rec.comments = hr_api.g_varchar2) then
302: p_rec.comments :=
303: pay_pwr_shd.g_old_rec.comments;
304: End If;
305:

Line 360: p_code in varchar2 default hr_api.g_varchar2,

356: -- ----------------------------------------------------------------------------
357: Procedure upd
358: (
359: p_rate_id in number,
360: p_code in varchar2 default hr_api.g_varchar2,
361: p_rate in number default hr_api.g_number,
362: p_description in varchar2 default hr_api.g_varchar2,
363: p_comments in varchar2 default hr_api.g_varchar2,
364: p_object_version_number in out nocopy number

Line 361: p_rate in number default hr_api.g_number,

357: Procedure upd
358: (
359: p_rate_id in number,
360: p_code in varchar2 default hr_api.g_varchar2,
361: p_rate in number default hr_api.g_number,
362: p_description in varchar2 default hr_api.g_varchar2,
363: p_comments in varchar2 default hr_api.g_varchar2,
364: p_object_version_number in out nocopy number
365: ) is

Line 362: p_description in varchar2 default hr_api.g_varchar2,

358: (
359: p_rate_id in number,
360: p_code in varchar2 default hr_api.g_varchar2,
361: p_rate in number default hr_api.g_number,
362: p_description in varchar2 default hr_api.g_varchar2,
363: p_comments in varchar2 default hr_api.g_varchar2,
364: p_object_version_number in out nocopy number
365: ) is
366: --

Line 363: p_comments in varchar2 default hr_api.g_varchar2,

359: p_rate_id in number,
360: p_code in varchar2 default hr_api.g_varchar2,
361: p_rate in number default hr_api.g_number,
362: p_description in varchar2 default hr_api.g_varchar2,
363: p_comments in varchar2 default hr_api.g_varchar2,
364: p_object_version_number in out nocopy number
365: ) is
366: --
367: l_rec pay_pwr_shd.g_rec_type;

Line 380: hr_api.g_number,

376: l_rec :=
377: pay_pwr_shd.convert_args
378: (
379: p_rate_id,
380: hr_api.g_number,
381: hr_api.g_number,
382: p_code,
383: p_rate,
384: p_description,

Line 381: hr_api.g_number,

377: pay_pwr_shd.convert_args
378: (
379: p_rate_id,
380: hr_api.g_number,
381: hr_api.g_number,
382: p_code,
383: p_rate,
384: p_description,
385: p_comments,