eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PUM_UPD dependencies on HR_API

Line 92: When hr_api.check_integrity_violated Then

88: --
89: hr_utility.set_location(' Leaving:'||l_proc, 10);
90: --
91: Exception
92: When hr_api.check_integrity_violated Then
93: -- A check constraint has been violated
94: ben_pum_shd.g_api_dml := false; -- Unset the api dml status
95: ben_pum_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.check_integrity_violated Then
93: -- A check constraint has been violated
94: ben_pum_shd.g_api_dml := false; -- Unset the api dml status
95: ben_pum_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: ben_pum_shd.g_api_dml := false; -- Unset the api dml status
100: ben_pum_shd.constraint_error

Line 97: When hr_api.parent_integrity_violated Then

93: -- A check constraint has been violated
94: ben_pum_shd.g_api_dml := false; -- Unset the api dml status
95: ben_pum_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: ben_pum_shd.g_api_dml := false; -- Unset the api dml status
100: ben_pum_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.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: ben_pum_shd.g_api_dml := false; -- Unset the api dml status
100: ben_pum_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: ben_pum_shd.g_api_dml := false; -- Unset the api dml status
105: ben_pum_shd.constraint_error

Line 102: When hr_api.unique_integrity_violated Then

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

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

102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: ben_pum_shd.g_api_dml := false; -- Unset the api dml status
105: ben_pum_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When Others Then
108: ben_pum_shd.g_api_dml := false; -- Unset the api dml status
109: Raise;
110: End update_dml;

Line 233: when hr_api.cannot_find_prog_unit then

229: );
230: --
231: exception
232: --
233: when hr_api.cannot_find_prog_unit then
234: --
235: hr_api.cannot_find_prog_unit_error
236: (p_module_name => 'ben_pop_up_messages'
237: ,p_hook_type => 'AU');

Line 235: hr_api.cannot_find_prog_unit_error

231: exception
232: --
233: when hr_api.cannot_find_prog_unit then
234: --
235: hr_api.cannot_find_prog_unit_error
236: (p_module_name => 'ben_pop_up_messages'
237: ,p_hook_type => 'AU');
238: --
239: end;

Line 303: If (p_rec.pop_name = hr_api.g_varchar2) then

299: -- p_rec plsql record structure
300: -- to see if a system default is being used. If a system default
301: -- is being used then we must set to the 'current' argument value.
302: --
303: If (p_rec.pop_name = hr_api.g_varchar2) then
304: p_rec.pop_name :=
305: ben_pum_shd.g_old_rec.pop_name;
306: End If;
307: If (p_rec.formula_id = hr_api.g_number) then

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

303: If (p_rec.pop_name = hr_api.g_varchar2) then
304: p_rec.pop_name :=
305: ben_pum_shd.g_old_rec.pop_name;
306: End If;
307: If (p_rec.formula_id = hr_api.g_number) then
308: p_rec.formula_id :=
309: ben_pum_shd.g_old_rec.formula_id;
310: End If;
311: If (p_rec.function_name = hr_api.g_varchar2) then

Line 311: If (p_rec.function_name = hr_api.g_varchar2) then

307: If (p_rec.formula_id = hr_api.g_number) then
308: p_rec.formula_id :=
309: ben_pum_shd.g_old_rec.formula_id;
310: End If;
311: If (p_rec.function_name = hr_api.g_varchar2) then
312: p_rec.function_name :=
313: ben_pum_shd.g_old_rec.function_name;
314: End If;
315: If (p_rec.block_name = hr_api.g_varchar2) then

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

311: If (p_rec.function_name = hr_api.g_varchar2) then
312: p_rec.function_name :=
313: ben_pum_shd.g_old_rec.function_name;
314: End If;
315: If (p_rec.block_name = hr_api.g_varchar2) then
316: p_rec.block_name :=
317: ben_pum_shd.g_old_rec.block_name;
318: End If;
319: If (p_rec.field_name = hr_api.g_varchar2) then

Line 319: If (p_rec.field_name = hr_api.g_varchar2) then

315: If (p_rec.block_name = hr_api.g_varchar2) then
316: p_rec.block_name :=
317: ben_pum_shd.g_old_rec.block_name;
318: End If;
319: If (p_rec.field_name = hr_api.g_varchar2) then
320: p_rec.field_name :=
321: ben_pum_shd.g_old_rec.field_name;
322: End If;
323: If (p_rec.event_name = hr_api.g_varchar2) then

Line 323: If (p_rec.event_name = hr_api.g_varchar2) then

319: If (p_rec.field_name = hr_api.g_varchar2) then
320: p_rec.field_name :=
321: ben_pum_shd.g_old_rec.field_name;
322: End If;
323: If (p_rec.event_name = hr_api.g_varchar2) then
324: p_rec.event_name :=
325: ben_pum_shd.g_old_rec.event_name;
326: End If;
327: If (p_rec.message = hr_api.g_varchar2) then

Line 327: If (p_rec.message = hr_api.g_varchar2) then

323: If (p_rec.event_name = hr_api.g_varchar2) then
324: p_rec.event_name :=
325: ben_pum_shd.g_old_rec.event_name;
326: End If;
327: If (p_rec.message = hr_api.g_varchar2) then
328: p_rec.message :=
329: ben_pum_shd.g_old_rec.message;
330: End If;
331: If (p_rec.message_type = hr_api.g_varchar2) then

Line 331: If (p_rec.message_type = hr_api.g_varchar2) then

327: If (p_rec.message = hr_api.g_varchar2) then
328: p_rec.message :=
329: ben_pum_shd.g_old_rec.message;
330: End If;
331: If (p_rec.message_type = hr_api.g_varchar2) then
332: p_rec.message_type :=
333: ben_pum_shd.g_old_rec.message_type;
334: End If;
335: If (p_rec.business_group_id = hr_api.g_number) then

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

331: If (p_rec.message_type = hr_api.g_varchar2) then
332: p_rec.message_type :=
333: ben_pum_shd.g_old_rec.message_type;
334: End If;
335: If (p_rec.business_group_id = hr_api.g_number) then
336: p_rec.business_group_id :=
337: ben_pum_shd.g_old_rec.business_group_id;
338: End If;
339: If (p_rec.start_date = hr_api.g_date) then

Line 339: If (p_rec.start_date = hr_api.g_date) then

335: If (p_rec.business_group_id = hr_api.g_number) then
336: p_rec.business_group_id :=
337: ben_pum_shd.g_old_rec.business_group_id;
338: End If;
339: If (p_rec.start_date = hr_api.g_date) then
340: p_rec.start_date :=
341: ben_pum_shd.g_old_rec.start_date;
342: End If;
343: If (p_rec.end_date = hr_api.g_date) then

Line 343: If (p_rec.end_date = hr_api.g_date) then

339: If (p_rec.start_date = hr_api.g_date) then
340: p_rec.start_date :=
341: ben_pum_shd.g_old_rec.start_date;
342: End If;
343: If (p_rec.end_date = hr_api.g_date) then
344: p_rec.end_date :=
345: ben_pum_shd.g_old_rec.end_date;
346: End If;
347: If (p_rec.no_formula_flag = hr_api.g_varchar2) then

Line 347: If (p_rec.no_formula_flag = hr_api.g_varchar2) then

343: If (p_rec.end_date = hr_api.g_date) then
344: p_rec.end_date :=
345: ben_pum_shd.g_old_rec.end_date;
346: End If;
347: If (p_rec.no_formula_flag = hr_api.g_varchar2) then
348: p_rec.no_formula_flag :=
349: ben_pum_shd.g_old_rec.no_formula_flag;
350: End If;
351: --

Line 409: p_pop_name in varchar2 default hr_api.g_varchar2,

405: Procedure upd
406: (
407: p_effective_date in date,
408: p_pop_up_messages_id in number,
409: p_pop_name in varchar2 default hr_api.g_varchar2,
410: p_formula_id in number default hr_api.g_number,
411: p_function_name in varchar2 default hr_api.g_varchar2,
412: p_block_name in varchar2 default hr_api.g_varchar2,
413: p_field_name in varchar2 default hr_api.g_varchar2,

Line 410: p_formula_id in number default hr_api.g_number,

406: (
407: p_effective_date in date,
408: p_pop_up_messages_id in number,
409: p_pop_name in varchar2 default hr_api.g_varchar2,
410: p_formula_id in number default hr_api.g_number,
411: p_function_name in varchar2 default hr_api.g_varchar2,
412: p_block_name in varchar2 default hr_api.g_varchar2,
413: p_field_name in varchar2 default hr_api.g_varchar2,
414: p_event_name in varchar2 default hr_api.g_varchar2,

Line 411: p_function_name in varchar2 default hr_api.g_varchar2,

407: p_effective_date in date,
408: p_pop_up_messages_id in number,
409: p_pop_name in varchar2 default hr_api.g_varchar2,
410: p_formula_id in number default hr_api.g_number,
411: p_function_name in varchar2 default hr_api.g_varchar2,
412: p_block_name in varchar2 default hr_api.g_varchar2,
413: p_field_name in varchar2 default hr_api.g_varchar2,
414: p_event_name in varchar2 default hr_api.g_varchar2,
415: p_message in varchar2 default hr_api.g_varchar2,

Line 412: p_block_name in varchar2 default hr_api.g_varchar2,

408: p_pop_up_messages_id in number,
409: p_pop_name in varchar2 default hr_api.g_varchar2,
410: p_formula_id in number default hr_api.g_number,
411: p_function_name in varchar2 default hr_api.g_varchar2,
412: p_block_name in varchar2 default hr_api.g_varchar2,
413: p_field_name in varchar2 default hr_api.g_varchar2,
414: p_event_name in varchar2 default hr_api.g_varchar2,
415: p_message in varchar2 default hr_api.g_varchar2,
416: p_message_type in varchar2 default hr_api.g_varchar2,

Line 413: p_field_name in varchar2 default hr_api.g_varchar2,

409: p_pop_name in varchar2 default hr_api.g_varchar2,
410: p_formula_id in number default hr_api.g_number,
411: p_function_name in varchar2 default hr_api.g_varchar2,
412: p_block_name in varchar2 default hr_api.g_varchar2,
413: p_field_name in varchar2 default hr_api.g_varchar2,
414: p_event_name in varchar2 default hr_api.g_varchar2,
415: p_message in varchar2 default hr_api.g_varchar2,
416: p_message_type in varchar2 default hr_api.g_varchar2,
417: p_business_group_id in number default hr_api.g_number,

Line 414: p_event_name in varchar2 default hr_api.g_varchar2,

410: p_formula_id in number default hr_api.g_number,
411: p_function_name in varchar2 default hr_api.g_varchar2,
412: p_block_name in varchar2 default hr_api.g_varchar2,
413: p_field_name in varchar2 default hr_api.g_varchar2,
414: p_event_name in varchar2 default hr_api.g_varchar2,
415: p_message in varchar2 default hr_api.g_varchar2,
416: p_message_type in varchar2 default hr_api.g_varchar2,
417: p_business_group_id in number default hr_api.g_number,
418: p_object_version_number in out nocopy number,

Line 415: p_message in varchar2 default hr_api.g_varchar2,

411: p_function_name in varchar2 default hr_api.g_varchar2,
412: p_block_name in varchar2 default hr_api.g_varchar2,
413: p_field_name in varchar2 default hr_api.g_varchar2,
414: p_event_name in varchar2 default hr_api.g_varchar2,
415: p_message in varchar2 default hr_api.g_varchar2,
416: p_message_type in varchar2 default hr_api.g_varchar2,
417: p_business_group_id in number default hr_api.g_number,
418: p_object_version_number in out nocopy number,
419: p_start_date in date default hr_api.g_date,

Line 416: p_message_type in varchar2 default hr_api.g_varchar2,

412: p_block_name in varchar2 default hr_api.g_varchar2,
413: p_field_name in varchar2 default hr_api.g_varchar2,
414: p_event_name in varchar2 default hr_api.g_varchar2,
415: p_message in varchar2 default hr_api.g_varchar2,
416: p_message_type in varchar2 default hr_api.g_varchar2,
417: p_business_group_id in number default hr_api.g_number,
418: p_object_version_number in out nocopy number,
419: p_start_date in date default hr_api.g_date,
420: p_end_date in date default hr_api.g_date,

Line 417: p_business_group_id in number default hr_api.g_number,

413: p_field_name in varchar2 default hr_api.g_varchar2,
414: p_event_name in varchar2 default hr_api.g_varchar2,
415: p_message in varchar2 default hr_api.g_varchar2,
416: p_message_type in varchar2 default hr_api.g_varchar2,
417: p_business_group_id in number default hr_api.g_number,
418: p_object_version_number in out nocopy number,
419: p_start_date in date default hr_api.g_date,
420: p_end_date in date default hr_api.g_date,
421: p_no_formula_flag in varchar2 default hr_api.g_varchar2

Line 419: p_start_date in date default hr_api.g_date,

415: p_message in varchar2 default hr_api.g_varchar2,
416: p_message_type in varchar2 default hr_api.g_varchar2,
417: p_business_group_id in number default hr_api.g_number,
418: p_object_version_number in out nocopy number,
419: p_start_date in date default hr_api.g_date,
420: p_end_date in date default hr_api.g_date,
421: p_no_formula_flag in varchar2 default hr_api.g_varchar2
422: ) is
423: --

Line 420: p_end_date in date default hr_api.g_date,

416: p_message_type in varchar2 default hr_api.g_varchar2,
417: p_business_group_id in number default hr_api.g_number,
418: p_object_version_number in out nocopy number,
419: p_start_date in date default hr_api.g_date,
420: p_end_date in date default hr_api.g_date,
421: p_no_formula_flag in varchar2 default hr_api.g_varchar2
422: ) is
423: --
424: l_rec ben_pum_shd.g_rec_type;

Line 421: p_no_formula_flag in varchar2 default hr_api.g_varchar2

417: p_business_group_id in number default hr_api.g_number,
418: p_object_version_number in out nocopy number,
419: p_start_date in date default hr_api.g_date,
420: p_end_date in date default hr_api.g_date,
421: p_no_formula_flag in varchar2 default hr_api.g_varchar2
422: ) is
423: --
424: l_rec ben_pum_shd.g_rec_type;
425: l_proc varchar2(72) := g_package||'upd';