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_SCL_SHD dependencies on HR_UTILITY

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

172: or (scl.segment30 is null
173: and p_segment30 is null));
174: --
175: begin
176: hr_utility.set_location('Entering:'||l_proc, 5);
177: hr_api.validate_bus_grp_id(p_business_group_id);
178: --
179: -- Determine if all the segments are null
180: --

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

211: --
212: -- as the segments are null set the p_id_flex_num
213: -- explicitly to null.
214: --
215: hr_utility.set_location(l_proc, 10);
216: p_id_flex_num := null;
217: p_soft_coding_keyflex_id := null;
218: p_concatenated_segments := null;
219: else

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

219: else
220: --
221: -- segments exists therefore select the id_flex_num
222: --
223: hr_utility.set_location(l_proc, 15);
224: open idsel;
225: fetch idsel into l_id_flex_num;
226: if idsel%notfound then
227: close idsel;

Line 231: hr_utility.set_message(801, 'HR_7384_ASG_INV_KEYFLEX_LINK');

227: close idsel;
228: --
229: -- the flex structure has not been found therefore we must error
230: --
231: hr_utility.set_message(801, 'HR_7384_ASG_INV_KEYFLEX_LINK');
232: hr_utility.raise_error;
233: end if;
234: close idsel;
235: hr_utility.set_location(l_proc, 10);

Line 232: hr_utility.raise_error;

228: --
229: -- the flex structure has not been found therefore we must error
230: --
231: hr_utility.set_message(801, 'HR_7384_ASG_INV_KEYFLEX_LINK');
232: hr_utility.raise_error;
233: end if;
234: close idsel;
235: hr_utility.set_location(l_proc, 10);
236: p_id_flex_num := l_id_flex_num;

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

231: hr_utility.set_message(801, 'HR_7384_ASG_INV_KEYFLEX_LINK');
232: hr_utility.raise_error;
233: end if;
234: close idsel;
235: hr_utility.set_location(l_proc, 10);
236: p_id_flex_num := l_id_flex_num;
237: --
238: -- open and execute the partial segment cursor. if no rows are returned
239: -- then p_soft_coding_keyflex_id must be set to -1 (indicating a

Line 242: hr_utility.set_location(l_proc, 20);

238: -- open and execute the partial segment cursor. if no rows are returned
239: -- then p_soft_coding_keyflex_id must be set to -1 (indicating a
240: -- new combination needs to be inserted.
241: --
242: hr_utility.set_location(l_proc, 20);
243: open sclsel;
244: fetch sclsel into p_soft_coding_keyflex_id, p_concatenated_segments;
245: if sclsel%notfound then
246: hr_utility.set_location(l_proc, 25);

Line 246: hr_utility.set_location(l_proc, 25);

242: hr_utility.set_location(l_proc, 20);
243: open sclsel;
244: fetch sclsel into p_soft_coding_keyflex_id, p_concatenated_segments;
245: if sclsel%notfound then
246: hr_utility.set_location(l_proc, 25);
247: p_soft_coding_keyflex_id := -1;
248: p_concatenated_segments := null;
249: end if;
250: close sclsel;

Line 254: hr_utility.set_location(' Leaving:'||l_proc, 30);

250: close sclsel;
251: end if;
252: --
253: --
254: hr_utility.set_location(' Leaving:'||l_proc, 30);
255: end segment_combination_check;
256: --
257: -- ----------------------------------------------------------------------------
258: -- |------------------------< return_api_dml_status >-------------------------|

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

261: --
262: l_proc varchar2(72) := g_package||'return_api_dml_status';
263: --
264: Begin
265: hr_utility.set_location('Entering:'||l_proc, 5);
266: --
267: Return (nvl(g_api_dml, false));
268: --
269: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

265: hr_utility.set_location('Entering:'||l_proc, 5);
266: --
267: Return (nvl(g_api_dml, false));
268: --
269: hr_utility.set_location(' Leaving:'||l_proc, 10);
270: End return_api_dml_status;
271: --
272: -- ----------------------------------------------------------------------------
273: -- |---------------------------< constraint_error >---------------------------|

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

277: --
278: l_proc varchar2(72) := g_package||'constraint_error';
279: --
280: Begin
281: hr_utility.set_location('Entering:'||l_proc, 5);
282: --
283: If (p_constraint_name = 'HR_SOFT_CODING_KEYFLEX_PK') Then
284: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
285: hr_utility.raise_error;

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

280: Begin
281: hr_utility.set_location('Entering:'||l_proc, 5);
282: --
283: If (p_constraint_name = 'HR_SOFT_CODING_KEYFLEX_PK') Then
284: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
285: hr_utility.raise_error;
286: Else
287: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
288: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 285: hr_utility.raise_error;

281: hr_utility.set_location('Entering:'||l_proc, 5);
282: --
283: If (p_constraint_name = 'HR_SOFT_CODING_KEYFLEX_PK') Then
284: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
285: hr_utility.raise_error;
286: Else
287: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
288: hr_utility.set_message_token('PROCEDURE', l_proc);
289: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);

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

283: If (p_constraint_name = 'HR_SOFT_CODING_KEYFLEX_PK') Then
284: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
285: hr_utility.raise_error;
286: Else
287: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
288: hr_utility.set_message_token('PROCEDURE', l_proc);
289: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
290: hr_utility.raise_error;
291: End If;

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

284: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
285: hr_utility.raise_error;
286: Else
287: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
288: hr_utility.set_message_token('PROCEDURE', l_proc);
289: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
290: hr_utility.raise_error;
291: End If;
292: --

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

285: hr_utility.raise_error;
286: Else
287: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
288: hr_utility.set_message_token('PROCEDURE', l_proc);
289: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
290: hr_utility.raise_error;
291: End If;
292: --
293: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 290: hr_utility.raise_error;

286: Else
287: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
288: hr_utility.set_message_token('PROCEDURE', l_proc);
289: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
290: hr_utility.raise_error;
291: End If;
292: --
293: hr_utility.set_location(' Leaving:'||l_proc, 10);
294: End constraint_error;

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

289: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
290: hr_utility.raise_error;
291: End If;
292: --
293: hr_utility.set_location(' Leaving:'||l_proc, 10);
294: End constraint_error;
295: --
296: -- ----------------------------------------------------------------------------
297: -- |-----------------------------< api_updating >-----------------------------|

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

351: l_proc varchar2(72) := g_package||'api_updating';
352: l_fct_ret boolean;
353: --
354: Begin
355: hr_utility.set_location('Entering:'||l_proc, 5);
356: --
357: If (p_soft_coding_keyflex_id is null) Then
358: --
359: -- One of the primary key arguments is null therefore we must

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

361: --
362: l_fct_ret := false;
363: Else
364: If (p_soft_coding_keyflex_id = g_old_rec.soft_coding_keyflex_id) Then
365: hr_utility.set_location(l_proc, 10);
366: --
367: -- The g_old_rec is current therefore we must
368: -- set the returning function to true
369: --

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

378: Close C_Sel1;
379: --
380: -- The primary key is invalid therefore we must error
381: --
382: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
383: hr_utility.raise_error;
384: End If;
385: Close C_Sel1;
386: --

Line 383: hr_utility.raise_error;

379: --
380: -- The primary key is invalid therefore we must error
381: --
382: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
383: hr_utility.raise_error;
384: End If;
385: Close C_Sel1;
386: --
387: hr_utility.set_location(l_proc, 15);

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

383: hr_utility.raise_error;
384: End If;
385: Close C_Sel1;
386: --
387: hr_utility.set_location(l_proc, 15);
388: l_fct_ret := true;
389: End If;
390: End If;
391: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

387: hr_utility.set_location(l_proc, 15);
388: l_fct_ret := true;
389: End If;
390: End If;
391: hr_utility.set_location(' Leaving:'||l_proc, 20);
392: Return (l_fct_ret);
393: --
394: End api_updating;
395: --

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

446: l_proc varchar2(72) := g_package||'convert_args';
447: --
448: Begin
449: --
450: hr_utility.set_location('Entering:'||l_proc, 5);
451: --
452: -- Convert arguments into local l_rec structure.
453: --
454: l_rec.soft_coding_keyflex_id := p_soft_coding_keyflex_id;

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

494: l_rec.segment30 := p_segment30;
495: --
496: -- Return the plsql record structure.
497: --
498: hr_utility.set_location(' Leaving:'||l_proc, 10);
499: Return(l_rec);
500: --
501: End convert_args;
502: --