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.GHR_NLA_SHD dependencies on HR_UTILITY

Line 20: hr_utility.set_location('Entering:'||l_proc, 5);

16: --
17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: If (p_constraint_name = 'GHR_NOAC_LAS_FK1') Then
23: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
24: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 23: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: If (p_constraint_name = 'GHR_NOAC_LAS_FK1') Then
23: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'GHR_NOAC_LAS_PK') Then

Line 24: hr_utility.set_message_token('PROCEDURE', l_proc);

20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: If (p_constraint_name = 'GHR_NOAC_LAS_FK1') Then
23: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'GHR_NOAC_LAS_PK') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 25: hr_utility.set_message_token('STEP','5');

21: --
22: If (p_constraint_name = 'GHR_NOAC_LAS_FK1') Then
23: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'GHR_NOAC_LAS_PK') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 26: hr_utility.raise_error;

22: If (p_constraint_name = 'GHR_NOAC_LAS_FK1') Then
23: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'GHR_NOAC_LAS_PK') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message_token('PROCEDURE', l_proc);
30: hr_utility.set_message_token('STEP','10');

Line 28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'GHR_NOAC_LAS_PK') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message_token('PROCEDURE', l_proc);
30: hr_utility.set_message_token('STEP','10');
31: hr_utility.raise_error;
32: Else

Line 29: hr_utility.set_message_token('PROCEDURE', l_proc);

25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'GHR_NOAC_LAS_PK') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message_token('PROCEDURE', l_proc);
30: hr_utility.set_message_token('STEP','10');
31: hr_utility.raise_error;
32: Else
33: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

Line 30: hr_utility.set_message_token('STEP','10');

26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'GHR_NOAC_LAS_PK') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message_token('PROCEDURE', l_proc);
30: hr_utility.set_message_token('STEP','10');
31: hr_utility.raise_error;
32: Else
33: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
34: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 31: hr_utility.raise_error;

27: ElsIf (p_constraint_name = 'GHR_NOAC_LAS_PK') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message_token('PROCEDURE', l_proc);
30: hr_utility.set_message_token('STEP','10');
31: hr_utility.raise_error;
32: Else
33: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
34: hr_utility.set_message_token('PROCEDURE', l_proc);
35: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);

Line 33: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

29: hr_utility.set_message_token('PROCEDURE', l_proc);
30: hr_utility.set_message_token('STEP','10');
31: hr_utility.raise_error;
32: Else
33: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
34: hr_utility.set_message_token('PROCEDURE', l_proc);
35: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
36: hr_utility.raise_error;
37: End If;

Line 34: hr_utility.set_message_token('PROCEDURE', l_proc);

30: hr_utility.set_message_token('STEP','10');
31: hr_utility.raise_error;
32: Else
33: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
34: hr_utility.set_message_token('PROCEDURE', l_proc);
35: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
36: hr_utility.raise_error;
37: End If;
38: --

Line 35: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);

31: hr_utility.raise_error;
32: Else
33: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
34: hr_utility.set_message_token('PROCEDURE', l_proc);
35: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
36: hr_utility.raise_error;
37: End If;
38: --
39: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 36: hr_utility.raise_error;

32: Else
33: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
34: hr_utility.set_message_token('PROCEDURE', l_proc);
35: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
36: hr_utility.raise_error;
37: End If;
38: --
39: hr_utility.set_location(' Leaving:'||l_proc, 10);
40: End constraint_error;

Line 39: hr_utility.set_location(' Leaving:'||l_proc, 10);

35: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
36: hr_utility.raise_error;
37: End If;
38: --
39: hr_utility.set_location(' Leaving:'||l_proc, 10);
40: End constraint_error;
41: --
42: -- ----------------------------------------------------------------------------
43: -- |-----------------------------< api_updating >-----------------------------|

Line 72: hr_utility.set_location('Entering:'||l_proc, 5);

68: l_proc varchar2(72) := g_package||'api_updating';
69: l_fct_ret boolean;
70: --
71: Begin
72: hr_utility.set_location('Entering:'||l_proc, 5);
73: --
74: If (
75: p_noac_la_id is null and
76: p_object_version_number is null

Line 88: hr_utility.set_location(l_proc, 10);

84: If (
85: p_noac_la_id = g_old_rec.noac_la_id and
86: p_object_version_number = g_old_rec.object_version_number
87: ) Then
88: hr_utility.set_location(l_proc, 10);
89: --
90: -- The g_old_rec is current therefore we must
91: -- set the returning function to true
92: --

Line 105: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

101: Close C_Sel1;
102: --
103: -- The primary key is invalid therefore we must error
104: --
105: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
106: hr_utility.raise_error;
107: End If;
108: Close C_Sel1;
109: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 106: hr_utility.raise_error;

102: --
103: -- The primary key is invalid therefore we must error
104: --
105: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
106: hr_utility.raise_error;
107: End If;
108: Close C_Sel1;
109: If (p_object_version_number <> g_old_rec.object_version_number) Then
110: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

Line 110: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

106: hr_utility.raise_error;
107: End If;
108: Close C_Sel1;
109: If (p_object_version_number <> g_old_rec.object_version_number) Then
110: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
111: hr_utility.raise_error;
112: End If;
113: hr_utility.set_location(l_proc, 15);
114: l_fct_ret := true;

Line 111: hr_utility.raise_error;

107: End If;
108: Close C_Sel1;
109: If (p_object_version_number <> g_old_rec.object_version_number) Then
110: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
111: hr_utility.raise_error;
112: End If;
113: hr_utility.set_location(l_proc, 15);
114: l_fct_ret := true;
115: End If;

Line 113: hr_utility.set_location(l_proc, 15);

109: If (p_object_version_number <> g_old_rec.object_version_number) Then
110: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
111: hr_utility.raise_error;
112: End If;
113: hr_utility.set_location(l_proc, 15);
114: l_fct_ret := true;
115: End If;
116: End If;
117: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 117: hr_utility.set_location(' Leaving:'||l_proc, 20);

113: hr_utility.set_location(l_proc, 15);
114: l_fct_ret := true;
115: End If;
116: End If;
117: hr_utility.set_location(' Leaving:'||l_proc, 20);
118: Return (l_fct_ret);
119: --
120: End api_updating;
121: --

Line 150: hr_utility.set_location('Entering:'||l_proc, 5);

146: --
147: l_proc varchar2(72) := g_package||'lck';
148: --
149: Begin
150: hr_utility.set_location('Entering:'||l_proc, 5);
151: --
152: -- Add any mandatory argument checking here:
153: -- Example:
154: -- hr_api.mandatory_arg_error

Line 166: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

162: Close C_Sel1;
163: --
164: -- The primary key is invalid therefore we must error
165: --
166: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
167: hr_utility.raise_error;
168: End If;
169: Close C_Sel1;
170: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 167: hr_utility.raise_error;

163: --
164: -- The primary key is invalid therefore we must error
165: --
166: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
167: hr_utility.raise_error;
168: End If;
169: Close C_Sel1;
170: If (p_object_version_number <> g_old_rec.object_version_number) Then
171: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

Line 171: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

167: hr_utility.raise_error;
168: End If;
169: Close C_Sel1;
170: If (p_object_version_number <> g_old_rec.object_version_number) Then
171: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
172: hr_utility.raise_error;
173: End If;
174: --
175: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 172: hr_utility.raise_error;

168: End If;
169: Close C_Sel1;
170: If (p_object_version_number <> g_old_rec.object_version_number) Then
171: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
172: hr_utility.raise_error;
173: End If;
174: --
175: hr_utility.set_location(' Leaving:'||l_proc, 10);
176: --

Line 175: hr_utility.set_location(' Leaving:'||l_proc, 10);

171: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
172: hr_utility.raise_error;
173: End If;
174: --
175: hr_utility.set_location(' Leaving:'||l_proc, 10);
176: --
177: -- We need to trap the ORA LOCK exception
178: --
179: Exception

Line 185: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');

181: --
182: -- The object is locked therefore we need to supply a meaningful
183: -- error message.
184: --
185: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
186: hr_utility.set_message_token('TABLE_NAME', 'ghr_noac_las');
187: hr_utility.raise_error;
188: End lck;
189: --

Line 186: hr_utility.set_message_token('TABLE_NAME', 'ghr_noac_las');

182: -- The object is locked therefore we need to supply a meaningful
183: -- error message.
184: --
185: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
186: hr_utility.set_message_token('TABLE_NAME', 'ghr_noac_las');
187: hr_utility.raise_error;
188: End lck;
189: --
190: -- ----------------------------------------------------------------------------

Line 187: hr_utility.raise_error;

183: -- error message.
184: --
185: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
186: hr_utility.set_message_token('TABLE_NAME', 'ghr_noac_las');
187: hr_utility.raise_error;
188: End lck;
189: --
190: -- ----------------------------------------------------------------------------
191: -- |-----------------------------< convert_args >-----------------------------|

Line 212: hr_utility.set_location('Entering:'||l_proc, 5);

208: l_proc varchar2(72) := g_package||'convert_args';
209: --
210: Begin
211: --
212: hr_utility.set_location('Entering:'||l_proc, 5);
213: --
214: -- Convert arguments into local l_rec structure.
215: --
216: l_rec.noac_la_id := p_noac_la_id;

Line 228: hr_utility.set_location(' Leaving:'||l_proc, 10);

224: l_rec.valid_second_lac_flag := p_valid_second_lac_flag;
225: --
226: -- Return the plsql record structure.
227: --
228: hr_utility.set_location(' Leaving:'||l_proc, 10);
229: Return(l_rec);
230: --
231: End convert_args;
232: --