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.HR_LOT_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: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);

Line 22: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');

18: --
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
25: hr_utility.raise_error;
26: --

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

19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
25: hr_utility.raise_error;
26: --
27: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
25: hr_utility.raise_error;
26: --
27: hr_utility.set_location(' Leaving:'||l_proc, 10);
28: End constraint_error;

Line 25: hr_utility.raise_error;

21: --
22: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
25: hr_utility.raise_error;
26: --
27: hr_utility.set_location(' Leaving:'||l_proc, 10);
28: End constraint_error;
29: --

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

23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
25: hr_utility.raise_error;
26: --
27: hr_utility.set_location(' Leaving:'||l_proc, 10);
28: End constraint_error;
29: --
30: -- ----------------------------------------------------------------------------
31: -- |-----------------------------< api_updating >-----------------------------|

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

54: l_proc varchar2(72) := g_package||'api_updating';
55: l_fct_ret boolean;
56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: If (
61: p_location_id is null or
62: p_language is null

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

70: If (
71: p_location_id = g_old_rec.location_id and
72: p_language = g_old_rec.language
73: ) Then
74: hr_utility.set_location(l_proc, 10);
75: --
76: -- The g_old_rec is current therefore we must
77: -- set the returning function to true
78: --

Line 91: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');

87: Close C_Sel1;
88: --
89: -- The primary key is invalid therefore we must error
90: --
91: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');
92: hr_utility.raise_error;
93: End If;
94: Close C_Sel1;
95: --

Line 92: hr_utility.raise_error;

88: --
89: -- The primary key is invalid therefore we must error
90: --
91: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');
92: hr_utility.raise_error;
93: End If;
94: Close C_Sel1;
95: --
96: hr_utility.set_location(l_proc, 15);

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

92: hr_utility.raise_error;
93: End If;
94: Close C_Sel1;
95: --
96: hr_utility.set_location(l_proc, 15);
97: l_fct_ret := true;
98: End If;
99: End If;
100: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

96: hr_utility.set_location(l_proc, 15);
97: l_fct_ret := true;
98: End If;
99: End If;
100: hr_utility.set_location(' Leaving:'||l_proc, 20);
101: Return (l_fct_ret);
102: --
103: End api_updating;
104: --

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

126: --
127: l_proc varchar2(72) := g_package||'lck';
128: --
129: Begin
130: hr_utility.set_location('Entering:'||l_proc, 5);
131: --
132: -- Add any mandatory argument checking here:
133: -- Example:
134: -- hr_api.mandatory_arg_error

Line 157: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');

153: Close C_Sel1;
154: --
155: -- The primary key is invalid therefore we must error
156: --
157: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');
158: hr_utility.raise_error;
159: End If;
160: Close C_Sel1;
161: --

Line 158: hr_utility.raise_error;

154: --
155: -- The primary key is invalid therefore we must error
156: --
157: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');
158: hr_utility.raise_error;
159: End If;
160: Close C_Sel1;
161: --
162: --

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

159: End If;
160: Close C_Sel1;
161: --
162: --
163: hr_utility.set_location(' Leaving:'||l_proc, 10);
164: --
165: -- We need to trap the ORA LOCK exception
166: --
167: Exception

Line 173: hr_utility.set_message(800, 'HR_7165_OBJECT_LOCKED');

169: --
170: -- The object is locked therefore we need to supply a meaningful
171: -- error message.
172: --
173: hr_utility.set_message(800, 'HR_7165_OBJECT_LOCKED');
174: hr_utility.set_message_token('TABLE_NAME', 'hr_locations_all_tl');
175: hr_utility.raise_error;
176: End lck;
177: --

Line 174: hr_utility.set_message_token('TABLE_NAME', 'hr_locations_all_tl');

170: -- The object is locked therefore we need to supply a meaningful
171: -- error message.
172: --
173: hr_utility.set_message(800, 'HR_7165_OBJECT_LOCKED');
174: hr_utility.set_message_token('TABLE_NAME', 'hr_locations_all_tl');
175: hr_utility.raise_error;
176: End lck;
177: --
178: -- ----------------------------------------------------------------------------

Line 175: hr_utility.raise_error;

171: -- error message.
172: --
173: hr_utility.set_message(800, 'HR_7165_OBJECT_LOCKED');
174: hr_utility.set_message_token('TABLE_NAME', 'hr_locations_all_tl');
175: hr_utility.raise_error;
176: End lck;
177: --
178: -- ----------------------------------------------------------------------------
179: -- |-----------------------------< add_language >-----------------------------|

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

245: and t.language = l.language_code);
246: -- Begin Bug: 2148847, Removed set_location to fix VALUE ERROR, this unknown
247: -- error is coming while running PERNLINS.sql script.
248:
249: -- hr_utility.set_location(' Leaving:'||l_proc, 10);
250:
251: -- End of Bug: 2148847.
252: End add_language;
253: --

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

268: l_proc varchar2(72) := g_package||'convert_args';
269: --
270: Begin
271: --
272: hr_utility.set_location('Entering:'||l_proc, 5);
273: --
274: -- Convert arguments into local l_rec structure.
275: --
276: l_rec.location_id := p_location_id;

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

280: l_rec.description := p_description;
281: --
282: -- Return the plsql record structure.
283: --
284: hr_utility.set_location(' Leaving:'||l_proc, 10);
285: Return(l_rec);
286: --
287: End convert_args;
288: --

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

303: --
304: begin
305: --
306: --
307: hr_utility.set_location('Entering:'||l_proc, 5);
308: --
309: if (p_location_id <> nvl(g_old_rec.location_id, hr_api.g_number) ) then
310: --
311: -- Only fetch business_group_id from database if required - i.e.

Line 325: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');

321: close csr_bg_id;
322: --
323: -- The primary key is invalid therefore we must error
324: --
325: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');
326: hr_utility.raise_error;
327: end if;
328: --
329: close csr_bg_id;

Line 326: hr_utility.raise_error;

322: --
323: -- The primary key is invalid therefore we must error
324: --
325: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');
326: hr_utility.raise_error;
327: end if;
328: --
329: close csr_bg_id;
330: end if;

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

328: --
329: close csr_bg_id;
330: end if;
331: --
332: hr_utility.set_location('Leaving:'||l_proc, 10);
333: --
334: return g_loc_bg_id;
335: --
336: end return_value_business_group_id;

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

343: --
344: l_proc varchar2(72) := g_package||'set_value_business_group_id';
345: begin
346: --
347: hr_utility.set_location('Entering:'||l_proc, 5);
348: --
349: g_loc_bg_id := p_business_group_id;
350: --
351: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

347: hr_utility.set_location('Entering:'||l_proc, 5);
348: --
349: g_loc_bg_id := p_business_group_id;
350: --
351: hr_utility.set_location(' Leaving:'||l_proc, 10);
352: --
353: end set_value_business_group_id;
354: --
355: end hr_lot_shd;