APPS.PAY_MGB_UPD dependencies on HR_API

Line 81: When hr_api.check_integrity_violated Then

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

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

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

Line 86: When hr_api.parent_integrity_violated Then

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

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

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

Line 91: When hr_api.unique_integrity_violated Then

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

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

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

Line 242: If (p_rec.block_name = hr_api.g_varchar2) then

238: -- p_rec plsql record structure
239: -- to see if a system default is being used. If a system default
240: -- is being used then we must set to the 'current' argument value.
241: --
242: If (p_rec.block_name = hr_api.g_varchar2) then
243: p_rec.block_name :=
244: pay_mgb_shd.g_old_rec.block_name;
245: End If;
246: If (p_rec.main_block_flag = hr_api.g_varchar2) then

Line 246: If (p_rec.main_block_flag = hr_api.g_varchar2) then

242: If (p_rec.block_name = hr_api.g_varchar2) then
243: p_rec.block_name :=
244: pay_mgb_shd.g_old_rec.block_name;
245: End If;
246: If (p_rec.main_block_flag = hr_api.g_varchar2) then
247: p_rec.main_block_flag :=
248: pay_mgb_shd.g_old_rec.main_block_flag;
249: End If;
250: If (p_rec.report_format = hr_api.g_varchar2) then

Line 250: If (p_rec.report_format = hr_api.g_varchar2) then

246: If (p_rec.main_block_flag = hr_api.g_varchar2) then
247: p_rec.main_block_flag :=
248: pay_mgb_shd.g_old_rec.main_block_flag;
249: End If;
250: If (p_rec.report_format = hr_api.g_varchar2) then
251: p_rec.report_format :=
252: pay_mgb_shd.g_old_rec.report_format;
253: End If;
254: If (p_rec.cursor_name = hr_api.g_varchar2) then

Line 254: If (p_rec.cursor_name = hr_api.g_varchar2) then

250: If (p_rec.report_format = hr_api.g_varchar2) then
251: p_rec.report_format :=
252: pay_mgb_shd.g_old_rec.report_format;
253: End If;
254: If (p_rec.cursor_name = hr_api.g_varchar2) then
255: p_rec.cursor_name :=
256: pay_mgb_shd.g_old_rec.cursor_name;
257: End If;
258: If (p_rec.no_column_returned = hr_api.g_number) then

Line 258: If (p_rec.no_column_returned = hr_api.g_number) then

254: If (p_rec.cursor_name = hr_api.g_varchar2) then
255: p_rec.cursor_name :=
256: pay_mgb_shd.g_old_rec.cursor_name;
257: End If;
258: If (p_rec.no_column_returned = hr_api.g_number) then
259: p_rec.no_column_returned :=
260: pay_mgb_shd.g_old_rec.no_column_returned;
261: End If;
262: --

Line 323: Raise HR_Api.Validate_Enabled;

319: --
320: -- If we are validating then raise the Validate_Enabled exception
321: --
322: If p_validate then
323: Raise HR_Api.Validate_Enabled;
324: End If;
325: --
326: hr_utility.set_location(' Leaving:'||l_proc, 10);
327: Exception

Line 328: When HR_Api.Validate_Enabled Then

324: End If;
325: --
326: hr_utility.set_location(' Leaving:'||l_proc, 10);
327: Exception
328: When HR_Api.Validate_Enabled Then
329: --
330: -- As the Validate_Enabled exception has been raised
331: -- we must rollback to the savepoint
332: --

Line 342: p_block_name in varchar2 default hr_api.g_varchar2,

338: -- ----------------------------------------------------------------------------
339: Procedure upd
340: (
341: p_magnetic_block_id in number,
342: p_block_name in varchar2 default hr_api.g_varchar2,
343: p_main_block_flag in varchar2 default hr_api.g_varchar2,
344: p_report_format in varchar2 default hr_api.g_varchar2,
345: p_cursor_name in varchar2 default hr_api.g_varchar2,
346: p_no_column_returned in number default hr_api.g_number,

Line 343: p_main_block_flag in varchar2 default hr_api.g_varchar2,

339: Procedure upd
340: (
341: p_magnetic_block_id in number,
342: p_block_name in varchar2 default hr_api.g_varchar2,
343: p_main_block_flag in varchar2 default hr_api.g_varchar2,
344: p_report_format in varchar2 default hr_api.g_varchar2,
345: p_cursor_name in varchar2 default hr_api.g_varchar2,
346: p_no_column_returned in number default hr_api.g_number,
347: p_validate in boolean default false

Line 344: p_report_format in varchar2 default hr_api.g_varchar2,

340: (
341: p_magnetic_block_id in number,
342: p_block_name in varchar2 default hr_api.g_varchar2,
343: p_main_block_flag in varchar2 default hr_api.g_varchar2,
344: p_report_format in varchar2 default hr_api.g_varchar2,
345: p_cursor_name in varchar2 default hr_api.g_varchar2,
346: p_no_column_returned in number default hr_api.g_number,
347: p_validate in boolean default false
348: ) is

Line 345: p_cursor_name in varchar2 default hr_api.g_varchar2,

341: p_magnetic_block_id in number,
342: p_block_name in varchar2 default hr_api.g_varchar2,
343: p_main_block_flag in varchar2 default hr_api.g_varchar2,
344: p_report_format in varchar2 default hr_api.g_varchar2,
345: p_cursor_name in varchar2 default hr_api.g_varchar2,
346: p_no_column_returned in number default hr_api.g_number,
347: p_validate in boolean default false
348: ) is
349: --

Line 346: p_no_column_returned in number default hr_api.g_number,

342: p_block_name in varchar2 default hr_api.g_varchar2,
343: p_main_block_flag in varchar2 default hr_api.g_varchar2,
344: p_report_format in varchar2 default hr_api.g_varchar2,
345: p_cursor_name in varchar2 default hr_api.g_varchar2,
346: p_no_column_returned in number default hr_api.g_number,
347: p_validate in boolean default false
348: ) is
349: --
350: l_rec pay_mgb_shd.g_rec_type;