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_EPE_SHD dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 35: If (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT1') Then

31: l_proc varchar2(72) := g_package||'constraint_error';
32: --
33: Begin
34: --
35: If (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT1') Then
36: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
37: hr_utility.set_message_token('PROCEDURE', l_proc);
38: hr_utility.set_message_token('STEP','10');
39: hr_utility.raise_error;

Line 40: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT2') Then

36: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
37: hr_utility.set_message_token('PROCEDURE', l_proc);
38: hr_utility.set_message_token('STEP','10');
39: hr_utility.raise_error;
40: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT2') Then
41: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
42: hr_utility.set_message_token('PROCEDURE', l_proc);
43: hr_utility.set_message_token('STEP','');
44: hr_utility.raise_error;

Line 45: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT3') Then

41: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
42: hr_utility.set_message_token('PROCEDURE', l_proc);
43: hr_utility.set_message_token('STEP','');
44: hr_utility.raise_error;
45: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT3') Then
46: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
47: hr_utility.set_message_token('PROCEDURE', l_proc);
48: hr_utility.set_message_token('STEP','');
49: hr_utility.raise_error;

Line 50: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT4') Then

46: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
47: hr_utility.set_message_token('PROCEDURE', l_proc);
48: hr_utility.set_message_token('STEP','');
49: hr_utility.raise_error;
50: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT4') Then
51: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
52: hr_utility.set_message_token('PROCEDURE', l_proc);
53: hr_utility.set_message_token('STEP','');
54: hr_utility.raise_error;

Line 55: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT5') Then

51: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
52: hr_utility.set_message_token('PROCEDURE', l_proc);
53: hr_utility.set_message_token('STEP','');
54: hr_utility.raise_error;
55: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT5') Then
56: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
57: hr_utility.set_message_token('PROCEDURE', l_proc);
58: hr_utility.set_message_token('STEP','');
59: hr_utility.raise_error;

Line 60: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT6') Then

56: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
57: hr_utility.set_message_token('PROCEDURE', l_proc);
58: hr_utility.set_message_token('STEP','');
59: hr_utility.raise_error;
60: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT6') Then
61: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
62: hr_utility.set_message_token('PROCEDURE', l_proc);
63: hr_utility.set_message_token('STEP','');
64: hr_utility.raise_error;

Line 65: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT7') Then

61: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
62: hr_utility.set_message_token('PROCEDURE', l_proc);
63: hr_utility.set_message_token('STEP','');
64: hr_utility.raise_error;
65: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT7') Then
66: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
67: hr_utility.set_message_token('PROCEDURE', l_proc);
68: hr_utility.set_message_token('STEP','');
69: hr_utility.raise_error;

Line 70: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT8') Then

66: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
67: hr_utility.set_message_token('PROCEDURE', l_proc);
68: hr_utility.set_message_token('STEP','');
69: hr_utility.raise_error;
70: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT8') Then
71: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
72: hr_utility.set_message_token('PROCEDURE', l_proc);
73: hr_utility.set_message_token('STEP','');
74: hr_utility.raise_error;

Line 75: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT9') Then

71: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
72: hr_utility.set_message_token('PROCEDURE', l_proc);
73: hr_utility.set_message_token('STEP','');
74: hr_utility.raise_error;
75: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT9') Then
76: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
77: hr_utility.set_message_token('PROCEDURE', l_proc);
78: hr_utility.set_message_token('STEP','');
79: hr_utility.raise_error;

Line 80: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT10') Then

76: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
77: hr_utility.set_message_token('PROCEDURE', l_proc);
78: hr_utility.set_message_token('STEP','');
79: hr_utility.raise_error;
80: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT10') Then
81: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
82: hr_utility.set_message_token('PROCEDURE', l_proc);
83: hr_utility.set_message_token('STEP','');
84: hr_utility.raise_error;

Line 85: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT11') Then

81: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
82: hr_utility.set_message_token('PROCEDURE', l_proc);
83: hr_utility.set_message_token('STEP','');
84: hr_utility.raise_error;
85: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT11') Then
86: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
87: hr_utility.set_message_token('PROCEDURE', l_proc);
88: hr_utility.set_message_token('STEP','');
89: hr_utility.raise_error;

Line 90: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT12') Then

86: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
87: hr_utility.set_message_token('PROCEDURE', l_proc);
88: hr_utility.set_message_token('STEP','');
89: hr_utility.raise_error;
90: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT12') Then
91: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
92: hr_utility.set_message_token('PROCEDURE', l_proc);
93: hr_utility.set_message_token('STEP','');
94: hr_utility.raise_error;

Line 95: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT13') Then

91: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
92: hr_utility.set_message_token('PROCEDURE', l_proc);
93: hr_utility.set_message_token('STEP','');
94: hr_utility.raise_error;
95: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT13') Then
96: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
97: hr_utility.set_message_token('PROCEDURE', l_proc);
98: hr_utility.set_message_token('STEP','');
99: hr_utility.raise_error;

Line 100: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT14') Then

96: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
97: hr_utility.set_message_token('PROCEDURE', l_proc);
98: hr_utility.set_message_token('STEP','');
99: hr_utility.raise_error;
100: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT14') Then
101: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
102: hr_utility.set_message_token('PROCEDURE', l_proc);
103: hr_utility.set_message_token('STEP','');
104: hr_utility.raise_error;

Line 105: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT15') Then

101: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
102: hr_utility.set_message_token('PROCEDURE', l_proc);
103: hr_utility.set_message_token('STEP','');
104: hr_utility.raise_error;
105: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT15') Then
106: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
107: hr_utility.set_message_token('PROCEDURE', l_proc);
108: hr_utility.set_message_token('STEP','');
109: hr_utility.raise_error;

Line 110: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT16') Then

106: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
107: hr_utility.set_message_token('PROCEDURE', l_proc);
108: hr_utility.set_message_token('STEP','');
109: hr_utility.raise_error;
110: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_DT16') Then
111: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
112: hr_utility.set_message_token('PROCEDURE', l_proc);
113: hr_utility.set_message_token('STEP','');
114: hr_utility.raise_error;

Line 115: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_FK15') Then

111: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
112: hr_utility.set_message_token('PROCEDURE', l_proc);
113: hr_utility.set_message_token('STEP','');
114: hr_utility.raise_error;
115: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_FK15') Then
116: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
117: hr_utility.set_message_token('PROCEDURE', l_proc);
118: hr_utility.set_message_token('STEP','');
119: hr_utility.raise_error;

Line 120: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_FK18') Then

116: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
117: hr_utility.set_message_token('PROCEDURE', l_proc);
118: hr_utility.set_message_token('STEP','');
119: hr_utility.raise_error;
120: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_FK18') Then
121: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
122: hr_utility.set_message_token('PROCEDURE', l_proc);
123: hr_utility.set_message_token('STEP','');
124: hr_utility.raise_error;

Line 125: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_PK') Then

121: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
122: hr_utility.set_message_token('PROCEDURE', l_proc);
123: hr_utility.set_message_token('STEP','');
124: hr_utility.raise_error;
125: ElsIf (p_constraint_name = 'BEN_ELIG_PER_ELCTBL_CHC_PK') Then
126: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
127: hr_utility.set_message_token('PROCEDURE', l_proc);
128: hr_utility.set_message_token('STEP','5');
129: hr_utility.raise_error;

Line 254: from ben_elig_per_elctbl_chc

250: program_application_id,
251: program_id,
252: program_update_date,
253: object_version_number
254: from ben_elig_per_elctbl_chc
255: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;
256: --
257: l_proc varchar2(72) := g_package||'api_updating';
258: l_fct_ret boolean;

Line 432: from ben_elig_per_elctbl_chc

428: program_application_id,
429: program_id,
430: program_update_date,
431: object_version_number
432: from ben_elig_per_elctbl_chc
433: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
434: for update nowait;
435: --
436: l_proc varchar2(72) := g_package||'lck';

Line 475: --hr_utility.set_message_token('TABLE_NAME', 'ben_elig_per_elctbl_chc');

471: -- The object is locked therefore we need to supply a meaningful
472: -- error message.
473: --
474: hr_utility.set_message(805, 'BEN_93618_EPE_OBJECT_LOCKED'); -- Bug 3140549
475: --hr_utility.set_message_token('TABLE_NAME', 'ben_elig_per_elctbl_chc');
476: hr_utility.raise_error;
477: End lck;
478: --
479: -- ----------------------------------------------------------------------------