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

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

166: -- or (pod.segment30 is null
167: -- and p_segment30 is null));
168: --
169: begin
170: hr_utility.set_location('Entering:'||l_proc, 5);
171: hr_api.validate_bus_grp_id(p_business_group_id);
172: --
173: -- Determine if all the segments are null
174: --

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

205: --
206: -- as the segments are null set the p_id_flex_num
207: -- explicitly to null.
208: --
209: hr_utility.set_location(l_proc, 10);
210: p_id_flex_num := null;
211: p_name := null;
212: else
213: --

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

212: else
213: --
214: -- segments exists therefore select the id_flex_num
215: --
216: hr_utility.set_location(l_proc, 15);
217: open idsel;
218: fetch idsel into l_id_flex_num;
219: if idsel%notfound then
220: close idsel;

Line 224: hr_utility.set_message(801, 'HR_51054_FLEX_POD_INVALID_ID');

220: close idsel;
221: --
222: -- the flex structure has not been found therefore we must error
223: --
224: hr_utility.set_message(801, 'HR_51054_FLEX_POD_INVALID_ID');
225: hr_utility.raise_error;
226: end if;
227: close idsel;
228: hr_utility.set_location(l_proc, 10);

Line 225: hr_utility.raise_error;

221: --
222: -- the flex structure has not been found therefore we must error
223: --
224: hr_utility.set_message(801, 'HR_51054_FLEX_POD_INVALID_ID');
225: hr_utility.raise_error;
226: end if;
227: close idsel;
228: hr_utility.set_location(l_proc, 10);
229: p_id_flex_num := l_id_flex_num;

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

224: hr_utility.set_message(801, 'HR_51054_FLEX_POD_INVALID_ID');
225: hr_utility.raise_error;
226: end if;
227: close idsel;
228: hr_utility.set_location(l_proc, 10);
229: p_id_flex_num := l_id_flex_num;
230: --
231: -- open and execute the partial segment cursor. if no rows are returned
232: -- then p_position_definition_id must be set to -1 (indicating a

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

231: -- open and execute the partial segment cursor. if no rows are returned
232: -- then p_position_definition_id must be set to -1 (indicating a
233: -- new combination needs to be inserted.
234: --
235: hr_utility.set_location(l_proc, 20);
236: --
237: -- we must derive the position name
238: --
239: p_name :=

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

274:
275: open pgsel;
276: fetch pgsel into p_position_definition_id;
277: if pgsel%notfound then
278: hr_utility.set_location(l_proc, 25);
279: p_position_definition_id := -1;
280: end if;
281: close pgsel;
282:

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

281: close pgsel;
282:
283: end if;
284: --
285: hr_utility.set_location(' Leaving:'||l_proc, 30);
286: end segment_combination_check;
287: --
288: -- ----------------------------------------------------------------------------
289: -- |------------------------< return_api_dml_status >-------------------------|

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

292: --
293: l_proc varchar2(72) := g_package||'return_api_dml_status';
294: --
295: Begin
296: hr_utility.set_location('Entering:'||l_proc, 5);
297: --
298: Return (nvl(g_api_dml, false));
299: --
300: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

296: hr_utility.set_location('Entering:'||l_proc, 5);
297: --
298: Return (nvl(g_api_dml, false));
299: --
300: hr_utility.set_location(' Leaving:'||l_proc, 10);
301: End return_api_dml_status;
302: --
303: -- ----------------------------------------------------------------------------
304: -- |---------------------------< constraint_error >---------------------------|

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

308: --
309: l_proc varchar2(72) := g_package||'constraint_error';
310: --
311: Begin
312: hr_utility.set_location('Entering:'||l_proc, 5);
313: --
314: If (p_constraint_name = 'PER_POSITION_DEFINITIONS_PK') Then
315: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
316: hr_utility.raise_error;

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

311: Begin
312: hr_utility.set_location('Entering:'||l_proc, 5);
313: --
314: If (p_constraint_name = 'PER_POSITION_DEFINITIONS_PK') Then
315: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
316: hr_utility.raise_error;
317: Else
318: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
319: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 316: hr_utility.raise_error;

312: hr_utility.set_location('Entering:'||l_proc, 5);
313: --
314: If (p_constraint_name = 'PER_POSITION_DEFINITIONS_PK') Then
315: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
316: hr_utility.raise_error;
317: Else
318: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
319: hr_utility.set_message_token('PROCEDURE', l_proc);
320: hr_utility.set_message_token('CONSTRAINT_NAME',p_constraint_name);

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

314: If (p_constraint_name = 'PER_POSITION_DEFINITIONS_PK') Then
315: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
316: hr_utility.raise_error;
317: Else
318: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
319: hr_utility.set_message_token('PROCEDURE', l_proc);
320: hr_utility.set_message_token('CONSTRAINT_NAME',p_constraint_name);
321: hr_utility.raise_error;
322: End If;

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

315: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
316: hr_utility.raise_error;
317: Else
318: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
319: hr_utility.set_message_token('PROCEDURE', l_proc);
320: hr_utility.set_message_token('CONSTRAINT_NAME',p_constraint_name);
321: hr_utility.raise_error;
322: End If;
323: --

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

316: hr_utility.raise_error;
317: Else
318: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
319: hr_utility.set_message_token('PROCEDURE', l_proc);
320: hr_utility.set_message_token('CONSTRAINT_NAME',p_constraint_name);
321: hr_utility.raise_error;
322: End If;
323: --
324: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 321: hr_utility.raise_error;

317: Else
318: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
319: hr_utility.set_message_token('PROCEDURE', l_proc);
320: hr_utility.set_message_token('CONSTRAINT_NAME',p_constraint_name);
321: hr_utility.raise_error;
322: End If;
323: --
324: hr_utility.set_location(' Leaving:'||l_proc, 10);
325: End constraint_error;

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

320: hr_utility.set_message_token('CONSTRAINT_NAME',p_constraint_name);
321: hr_utility.raise_error;
322: End If;
323: --
324: hr_utility.set_location(' Leaving:'||l_proc, 10);
325: End constraint_error;
326: --
327: -- ----------------------------------------------------------------------------
328: -- |-----------------------------< api_updating >-----------------------------|

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

376: l_proc varchar2(72) := g_package||'api_updating';
377: l_fct_ret boolean;
378: --
379: Begin
380: hr_utility.set_location('Entering:'||l_proc, 5);
381: --
382: If (p_position_definition_id is null) Then
383: --
384: -- One of the primary key arguments is null therefore we must

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

386: --
387: l_fct_ret := false;
388: Else
389: If (p_position_definition_id = g_old_rec.position_definition_id) Then
390: hr_utility.set_location(l_proc, 10);
391: --
392: -- The g_old_rec is current therefore we must
393: -- set the returning function to true
394: --

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

403: Close C_Sel1;
404: --
405: -- The primary key is invalid therefore we must error
406: --
407: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
408: hr_utility.raise_error;
409: End If;
410: Close C_Sel1;
411: hr_utility.set_location(l_proc, 15);

Line 408: hr_utility.raise_error;

404: --
405: -- The primary key is invalid therefore we must error
406: --
407: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
408: hr_utility.raise_error;
409: End If;
410: Close C_Sel1;
411: hr_utility.set_location(l_proc, 15);
412: l_fct_ret := true;

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

407: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
408: hr_utility.raise_error;
409: End If;
410: Close C_Sel1;
411: hr_utility.set_location(l_proc, 15);
412: l_fct_ret := true;
413: End If;
414: End If;
415: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

411: hr_utility.set_location(l_proc, 15);
412: l_fct_ret := true;
413: End If;
414: End If;
415: hr_utility.set_location(' Leaving:'||l_proc, 20);
416: Return (l_fct_ret);
417: --
418: End api_updating;
419: --

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

465: l_proc varchar2(72) := g_package||'convert_args';
466: --
467: Begin
468: --
469: hr_utility.set_location('Entering:'||l_proc, 5);
470: --
471: -- Convert arguments into local l_rec structure.
472: --
473: l_rec.position_definition_id := p_position_definition_id;

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

508: l_rec.segment30 := p_segment30;
509: --
510: -- Return the plsql record structure.
511: --
512: hr_utility.set_location(' Leaving:'||l_proc, 10);
513: Return(l_rec);
514: --
515: End convert_args;
516: --