APPS.PAY_MGR_UPD dependencies on HR_API

Line 87: When hr_api.check_integrity_violated Then

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

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

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

Line 92: When hr_api.parent_integrity_violated Then

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

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

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

Line 97: When hr_api.unique_integrity_violated Then

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

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

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

Line 248: If (p_rec.formula_id = hr_api.g_number) then

244: -- p_rec plsql record structure
245: -- to see if a system default is being used. If a system default
246: -- is being used then we must set to the 'current' argument value.
247: --
248: If (p_rec.formula_id = hr_api.g_number) then
249: p_rec.formula_id :=
250: pay_mgr_shd.g_old_rec.formula_id;
251: End If;
252: If (p_rec.next_block_id = hr_api.g_number) then

Line 252: If (p_rec.next_block_id = hr_api.g_number) then

248: If (p_rec.formula_id = hr_api.g_number) then
249: p_rec.formula_id :=
250: pay_mgr_shd.g_old_rec.formula_id;
251: End If;
252: If (p_rec.next_block_id = hr_api.g_number) then
253: p_rec.next_block_id :=
254: pay_mgr_shd.g_old_rec.next_block_id;
255: End If;
256: If (p_rec.last_run_executed_mode = hr_api.g_varchar2) then

Line 256: If (p_rec.last_run_executed_mode = hr_api.g_varchar2) then

252: If (p_rec.next_block_id = hr_api.g_number) then
253: p_rec.next_block_id :=
254: pay_mgr_shd.g_old_rec.next_block_id;
255: End If;
256: If (p_rec.last_run_executed_mode = hr_api.g_varchar2) then
257: p_rec.last_run_executed_mode :=
258: pay_mgr_shd.g_old_rec.last_run_executed_mode;
259: End If;
260: If (p_rec.overflow_mode = hr_api.g_varchar2) then

Line 260: If (p_rec.overflow_mode = hr_api.g_varchar2) then

256: If (p_rec.last_run_executed_mode = hr_api.g_varchar2) then
257: p_rec.last_run_executed_mode :=
258: pay_mgr_shd.g_old_rec.last_run_executed_mode;
259: End If;
260: If (p_rec.overflow_mode = hr_api.g_varchar2) then
261: p_rec.overflow_mode :=
262: pay_mgr_shd.g_old_rec.overflow_mode;
263: End If;
264: If (p_rec.frequency = hr_api.g_number) then

Line 264: If (p_rec.frequency = hr_api.g_number) then

260: If (p_rec.overflow_mode = hr_api.g_varchar2) then
261: p_rec.overflow_mode :=
262: pay_mgr_shd.g_old_rec.overflow_mode;
263: End If;
264: If (p_rec.frequency = hr_api.g_number) then
265: p_rec.frequency :=
266: pay_mgr_shd.g_old_rec.frequency;
267: End If;
268: If (p_rec.action_level = hr_api.g_varchar2) then

Line 268: If (p_rec.action_level = hr_api.g_varchar2) then

264: If (p_rec.frequency = hr_api.g_number) then
265: p_rec.frequency :=
266: pay_mgr_shd.g_old_rec.frequency;
267: End If;
268: If (p_rec.action_level = hr_api.g_varchar2) then
269: p_rec.action_level :=
270: pay_mgr_shd.g_old_rec.action_level;
271: End If;
272: If (p_rec.block_label = hr_api.g_varchar2) then

Line 272: If (p_rec.block_label = hr_api.g_varchar2) then

268: If (p_rec.action_level = hr_api.g_varchar2) then
269: p_rec.action_level :=
270: pay_mgr_shd.g_old_rec.action_level;
271: End If;
272: If (p_rec.block_label = hr_api.g_varchar2) then
273: p_rec.block_label :=
274: pay_mgr_shd.g_old_rec.block_label;
275: End If;
276: If (p_rec.block_row_label = hr_api.g_varchar2) then

Line 276: If (p_rec.block_row_label = hr_api.g_varchar2) then

272: If (p_rec.block_label = hr_api.g_varchar2) then
273: p_rec.block_label :=
274: pay_mgr_shd.g_old_rec.block_label;
275: End If;
276: If (p_rec.block_row_label = hr_api.g_varchar2) then
277: p_rec.block_row_label :=
278: pay_mgr_shd.g_old_rec.block_row_label;
279: End If;
280: If (p_rec.xml_proc_name = hr_api.g_varchar2) then

Line 280: If (p_rec.xml_proc_name = hr_api.g_varchar2) then

276: If (p_rec.block_row_label = hr_api.g_varchar2) then
277: p_rec.block_row_label :=
278: pay_mgr_shd.g_old_rec.block_row_label;
279: End If;
280: If (p_rec.xml_proc_name = hr_api.g_varchar2) then
281: p_rec.xml_proc_name :=
282: pay_mgr_shd.g_old_rec.xml_proc_name;
283: End If;
284: --

Line 346: Raise HR_Api.Validate_Enabled;

342: --
343: -- If we are validating then raise the Validate_Enabled exception
344: --
345: If p_validate then
346: Raise HR_Api.Validate_Enabled;
347: End If;
348: --
349: hr_utility.set_location(' Leaving:'||l_proc, 10);
350: Exception

Line 351: When HR_Api.Validate_Enabled Then

347: End If;
348: --
349: hr_utility.set_location(' Leaving:'||l_proc, 10);
350: Exception
351: When HR_Api.Validate_Enabled Then
352: --
353: -- As the Validate_Enabled exception has been raised
354: -- we must rollback to the savepoint
355: --

Line 364: p_formula_id in number default hr_api.g_number,

360: -- |---------------------------------< upd >----------------------------------|
361: -- ----------------------------------------------------------------------------
362: Procedure upd
363: (
364: p_formula_id in number default hr_api.g_number,
365: p_magnetic_block_id in number,
366: p_next_block_id in number default hr_api.g_number,
367: p_last_run_executed_mode in varchar2 default hr_api.g_varchar2,
368: p_overflow_mode in varchar2 default hr_api.g_varchar2,

Line 366: p_next_block_id in number default hr_api.g_number,

362: Procedure upd
363: (
364: p_formula_id in number default hr_api.g_number,
365: p_magnetic_block_id in number,
366: p_next_block_id in number default hr_api.g_number,
367: p_last_run_executed_mode in varchar2 default hr_api.g_varchar2,
368: p_overflow_mode in varchar2 default hr_api.g_varchar2,
369: p_sequence in number,
370: p_frequency in number default hr_api.g_number,

Line 367: p_last_run_executed_mode in varchar2 default hr_api.g_varchar2,

363: (
364: p_formula_id in number default hr_api.g_number,
365: p_magnetic_block_id in number,
366: p_next_block_id in number default hr_api.g_number,
367: p_last_run_executed_mode in varchar2 default hr_api.g_varchar2,
368: p_overflow_mode in varchar2 default hr_api.g_varchar2,
369: p_sequence in number,
370: p_frequency in number default hr_api.g_number,
371: p_validate in boolean default false ,

Line 368: p_overflow_mode in varchar2 default hr_api.g_varchar2,

364: p_formula_id in number default hr_api.g_number,
365: p_magnetic_block_id in number,
366: p_next_block_id in number default hr_api.g_number,
367: p_last_run_executed_mode in varchar2 default hr_api.g_varchar2,
368: p_overflow_mode in varchar2 default hr_api.g_varchar2,
369: p_sequence in number,
370: p_frequency in number default hr_api.g_number,
371: p_validate in boolean default false ,
372: p_action_level in varchar2 default hr_api.g_varchar2,

Line 370: p_frequency in number default hr_api.g_number,

366: p_next_block_id in number default hr_api.g_number,
367: p_last_run_executed_mode in varchar2 default hr_api.g_varchar2,
368: p_overflow_mode in varchar2 default hr_api.g_varchar2,
369: p_sequence in number,
370: p_frequency in number default hr_api.g_number,
371: p_validate in boolean default false ,
372: p_action_level in varchar2 default hr_api.g_varchar2,
373: p_block_label in varchar2 default hr_api.g_varchar2,
374: p_block_row_label in varchar2 default hr_api.g_varchar2,

Line 372: p_action_level in varchar2 default hr_api.g_varchar2,

368: p_overflow_mode in varchar2 default hr_api.g_varchar2,
369: p_sequence in number,
370: p_frequency in number default hr_api.g_number,
371: p_validate in boolean default false ,
372: p_action_level in varchar2 default hr_api.g_varchar2,
373: p_block_label in varchar2 default hr_api.g_varchar2,
374: p_block_row_label in varchar2 default hr_api.g_varchar2,
375: p_xml_proc_name in varchar2 default hr_api.g_varchar2
376: ) is

Line 373: p_block_label in varchar2 default hr_api.g_varchar2,

369: p_sequence in number,
370: p_frequency in number default hr_api.g_number,
371: p_validate in boolean default false ,
372: p_action_level in varchar2 default hr_api.g_varchar2,
373: p_block_label in varchar2 default hr_api.g_varchar2,
374: p_block_row_label in varchar2 default hr_api.g_varchar2,
375: p_xml_proc_name in varchar2 default hr_api.g_varchar2
376: ) is
377: --

Line 374: p_block_row_label in varchar2 default hr_api.g_varchar2,

370: p_frequency in number default hr_api.g_number,
371: p_validate in boolean default false ,
372: p_action_level in varchar2 default hr_api.g_varchar2,
373: p_block_label in varchar2 default hr_api.g_varchar2,
374: p_block_row_label in varchar2 default hr_api.g_varchar2,
375: p_xml_proc_name in varchar2 default hr_api.g_varchar2
376: ) is
377: --
378: l_rec pay_mgr_shd.g_rec_type;

Line 375: p_xml_proc_name in varchar2 default hr_api.g_varchar2

371: p_validate in boolean default false ,
372: p_action_level in varchar2 default hr_api.g_varchar2,
373: p_block_label in varchar2 default hr_api.g_varchar2,
374: p_block_row_label in varchar2 default hr_api.g_varchar2,
375: p_xml_proc_name in varchar2 default hr_api.g_varchar2
376: ) is
377: --
378: l_rec pay_mgr_shd.g_rec_type;
379: l_proc varchar2(72) := g_package||'upd';