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

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

20: --
21: l_proc varchar2(72) := g_package||'insert_dml';
22: --
23: Begin
24: hr_utility.set_location('Entering:'||l_proc, 5);
25: --
26: -- Insert the row into: hr_comments
27: --
28: insert into hr_comments

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

35: p_rec.source_table_name,
36: p_rec.comment_text
37: );
38: --
39: hr_utility.set_location(' Leaving:'||l_proc, 10);
40: End insert_dml;
41: --
42: -- ----------------------------------------------------------------------------
43: -- |------------------------------< update_dml >------------------------------|

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

50: --
51: l_proc varchar2(72) := g_package||'update_dml';
52: --
53: Begin
54: hr_utility.set_location('Entering:'||l_proc, 5);
55: --
56: --
57: -- Update the hr_comments Row
58: --

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

62: source_table_name = p_rec.source_table_name,
63: comment_text = p_rec.comment_text
64: where comment_id = p_rec.comment_id;
65: --
66: hr_utility.set_location(' Leaving:'||l_proc, 10);
67: End update_dml;
68: --
69: -- ----------------------------------------------------------------------------
70: -- |------------------------------< delete_dml >------------------------------|

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

77: --
78: l_proc varchar2(72) := g_package||'delete_dml';
79: --
80: Begin
81: hr_utility.set_location('Entering:'||l_proc, 5);
82: --
83: -- Delete the hr_comments row.
84: --
85: delete from hr_comments

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

84: --
85: delete from hr_comments
86: where comment_id = p_rec.comment_id;
87: --
88: hr_utility.set_location(' Leaving:'||l_proc, 10);
89: End delete_dml;
90: --
91: -- ----------------------------------------------------------------------------
92: -- |------------------------------< pre_insert >------------------------------|

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

101: --
102: Cursor C_Sel1 is select hr_comments_s.nextval from sys.dual;
103: --
104: Begin
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --
107: --
108: -- Select the next sequence number
109: --

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

110: Open C_Sel1;
111: Fetch C_Sel1 Into p_rec.comment_id;
112: Close C_Sel1;
113: --
114: hr_utility.set_location(' Leaving:'||l_proc, 10);
115: End pre_insert;
116: --
117: -- ----------------------------------------------------------------------------
118: -- |------------------------------< pre_update >------------------------------|

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

125: --
126: l_proc varchar2(72) := g_package||'pre_update';
127: --
128: Begin
129: hr_utility.set_location('Entering:'||l_proc, 5);
130: --
131: hr_utility.set_location(' Leaving:'||l_proc, 10);
132: End pre_update;
133: --

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

127: --
128: Begin
129: hr_utility.set_location('Entering:'||l_proc, 5);
130: --
131: hr_utility.set_location(' Leaving:'||l_proc, 10);
132: End pre_update;
133: --
134: -- ----------------------------------------------------------------------------
135: -- |------------------------------< pre_delete >------------------------------|

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

142: --
143: l_proc varchar2(72) := g_package||'pre_delete';
144: --
145: Begin
146: hr_utility.set_location('Entering:'||l_proc, 5);
147: --
148: hr_utility.set_location(' Leaving:'||l_proc, 10);
149: End pre_delete;
150: --

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

144: --
145: Begin
146: hr_utility.set_location('Entering:'||l_proc, 5);
147: --
148: hr_utility.set_location(' Leaving:'||l_proc, 10);
149: End pre_delete;
150: --
151: -- ----------------------------------------------------------------------------
152: -- |-----------------------------< post_insert >------------------------------|

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

159: --
160: l_proc varchar2(72) := g_package||'post_insert';
161: --
162: Begin
163: hr_utility.set_location('Entering:'||l_proc, 5);
164: --
165: hr_utility.set_location(' Leaving:'||l_proc, 10);
166: End post_insert;
167: --

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

161: --
162: Begin
163: hr_utility.set_location('Entering:'||l_proc, 5);
164: --
165: hr_utility.set_location(' Leaving:'||l_proc, 10);
166: End post_insert;
167: --
168: -- ----------------------------------------------------------------------------
169: -- |-----------------------------< post_update >------------------------------|

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

176: --
177: l_proc varchar2(72) := g_package||'post_update';
178: --
179: Begin
180: hr_utility.set_location('Entering:'||l_proc, 5);
181: --
182: hr_utility.set_location(' Leaving:'||l_proc, 10);
183: End post_update;
184: --

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

178: --
179: Begin
180: hr_utility.set_location('Entering:'||l_proc, 5);
181: --
182: hr_utility.set_location(' Leaving:'||l_proc, 10);
183: End post_update;
184: --
185: -- ----------------------------------------------------------------------------
186: -- |-----------------------------< post_delete >------------------------------|

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

193: --
194: l_proc varchar2(72) := g_package||'post_delete';
195: --
196: Begin
197: hr_utility.set_location('Entering:'||l_proc, 5);
198: --
199: hr_utility.set_location(' Leaving:'||l_proc, 10);
200: End post_delete;
201: --

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

195: --
196: Begin
197: hr_utility.set_location('Entering:'||l_proc, 5);
198: --
199: hr_utility.set_location(' Leaving:'||l_proc, 10);
200: End post_delete;
201: --
202: -- ----------------------------------------------------------------------------
203: -- |---------------------------------< lck >----------------------------------|

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

224: --
225: l_proc varchar2(72) := g_package||'lck';
226: --
227: Begin
228: hr_utility.set_location('Entering:'||l_proc, 5);
229: --
230: -- The primary key exists therefore we must now attempt to lock the
231: -- row.
232: --

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

237: -- If the row wasn't returned then:
238: -- a) The row does NOT exist.
239: --
240: Close C_Sel1;
241: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
242: hr_utility.set_message_token('TABLE_NAME', 'hr_comments');
243: hr_utility.raise_error;
244: End If;
245: Close C_Sel1;

Line 242: hr_utility.set_message_token('TABLE_NAME', 'hr_comments');

238: -- a) The row does NOT exist.
239: --
240: Close C_Sel1;
241: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
242: hr_utility.set_message_token('TABLE_NAME', 'hr_comments');
243: hr_utility.raise_error;
244: End If;
245: Close C_Sel1;
246: --

Line 243: hr_utility.raise_error;

239: --
240: Close C_Sel1;
241: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
242: hr_utility.set_message_token('TABLE_NAME', 'hr_comments');
243: hr_utility.raise_error;
244: End If;
245: Close C_Sel1;
246: --
247: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

243: hr_utility.raise_error;
244: End If;
245: Close C_Sel1;
246: --
247: hr_utility.set_location(' Leaving:'||l_proc, 10);
248: --
249: -- We need to trap the ORA LOCK exception
250: --
251: Exception

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

253: --
254: -- The object is locked therefore we need to supply a meaningful
255: -- error message.
256: --
257: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
258: hr_utility.set_message_token('TABLE_NAME', 'hr_comments');
259: hr_utility.raise_error;
260: End lck;
261: --

Line 258: hr_utility.set_message_token('TABLE_NAME', 'hr_comments');

254: -- The object is locked therefore we need to supply a meaningful
255: -- error message.
256: --
257: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
258: hr_utility.set_message_token('TABLE_NAME', 'hr_comments');
259: hr_utility.raise_error;
260: End lck;
261: --
262: -- ----------------------------------------------------------------------------

Line 259: hr_utility.raise_error;

255: -- error message.
256: --
257: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
258: hr_utility.set_message_token('TABLE_NAME', 'hr_comments');
259: hr_utility.raise_error;
260: End lck;
261: --
262: -- ----------------------------------------------------------------------------
263: -- |-----------------------------< convert_args >-----------------------------|

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

280: l_proc varchar2(72) := g_package||'convert_args';
281: --
282: Begin
283: --
284: hr_utility.set_location('Entering:'||l_proc, 5);
285: --
286: -- Convert arguments into local l_rec structure.
287: --
288: l_rec.comment_id := p_comment_id;

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

290: l_rec.comment_text := p_comment_text;
291: --
292: -- Return the plsql record structure.
293: --
294: hr_utility.set_location(' Leaving:'||l_proc, 10);
295: Return(l_rec);
296: --
297: End convert_args;
298: --

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

310: l_proc varchar2(72) := g_package||'convert_defs';
311: --
312: Begin
313: --
314: hr_utility.set_location('Entering:'||l_proc, 5);
315: --
316: -- We must now examine each argument value in the
317: -- p_rec plsql record structure
318: -- to see if a system default is being used. If a system default

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

326: End If;
327: --
328: -- Return the plsql record structure.
329: --
330: hr_utility.set_location(' Leaving:'||l_proc, 10);
331: Return(p_rec);
332: --
333: End convert_defs;
334: --

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

343: --
344: l_proc varchar2(72) := g_package||'insert_validate';
345: --
346: Begin
347: hr_utility.set_location('Entering:'||l_proc, 5);
348: --
349: -- Call all supporting business operations
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: -- Call all supporting business operations
350: --
351: hr_utility.set_location(' Leaving:'||l_proc, 10);
352: End insert_validate;
353: --
354: -- ----------------------------------------------------------------------------
355: -- |---------------------------< update_validate >----------------------------|

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

362: --
363: l_proc varchar2(72) := g_package||'update_validate';
364: --
365: Begin
366: hr_utility.set_location('Entering:'||l_proc, 5);
367: --
368: -- Call all supporting business operations
369: --
370: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

366: hr_utility.set_location('Entering:'||l_proc, 5);
367: --
368: -- Call all supporting business operations
369: --
370: hr_utility.set_location(' Leaving:'||l_proc, 10);
371: End update_validate;
372: --
373: -- ----------------------------------------------------------------------------
374: -- |---------------------------< delete_validate >----------------------------|

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

381: --
382: l_proc varchar2(72) := g_package||'delete_validate';
383: --
384: Begin
385: hr_utility.set_location('Entering:'||l_proc, 5);
386: --
387: -- Call all supporting business operations
388: --
389: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

385: hr_utility.set_location('Entering:'||l_proc, 5);
386: --
387: -- Call all supporting business operations
388: --
389: hr_utility.set_location(' Leaving:'||l_proc, 10);
390: End delete_validate;
391: --
392: -- ----------------------------------------------------------------------------
393: -- |---------------------------------< ins >----------------------------------|

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

417: --
418: l_proc varchar2(72) := g_package||'ins';
419: --
420: Begin
421: hr_utility.set_location('Entering:'||l_proc, 5);
422: --
423: -- Determine if the business process is to be validated.
424: --
425: If p_validate then

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

450: If p_validate then
451: Raise HR_Api.Validate_Enabled;
452: End If;
453: --
454: hr_utility.set_location(' Leaving:'||l_proc, 10);
455: Exception
456: When HR_Api.Validate_Enabled Then
457: --
458: -- As the Validate_Enabled exception has been raised

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

495: l_rec g_rec_type;
496: l_proc varchar2(72) := g_package||'ins';
497: --
498: Begin
499: hr_utility.set_location('Entering:'||l_proc, 5);
500: --
501: -- Call conversion function to turn arguments into the
502: -- p_rec structure.
503: --

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

518: -- are specified as an OUT's we must set these values.
519: --
520: p_comment_id := l_rec.comment_id;
521: --
522: hr_utility.set_location(' Leaving:'||l_proc, 10);
523: End ins;
524: --
525: -- ----------------------------------------------------------------------------
526: -- |---------------------------------< upd >----------------------------------|

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

552: --
553: l_proc varchar2(72) := g_package||'upd';
554: --
555: Begin
556: hr_utility.set_location('Entering:'||l_proc, 5);
557: --
558: -- We are updating using the primary key therefore
559: -- we must ensure that the argument value is NOT null.
560: --

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

558: -- We are updating using the primary key therefore
559: -- we must ensure that the argument value is NOT null.
560: --
561: If (p_rec.comment_id is null) then
562: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
563: hr_utility.set_message_token('PROCEDURE', l_proc);
564: hr_utility.set_message_token('STEP','5');
565: hr_utility.raise_error;
566: Else

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

559: -- we must ensure that the argument value is NOT null.
560: --
561: If (p_rec.comment_id is null) then
562: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
563: hr_utility.set_message_token('PROCEDURE', l_proc);
564: hr_utility.set_message_token('STEP','5');
565: hr_utility.raise_error;
566: Else
567: --

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

560: --
561: If (p_rec.comment_id is null) then
562: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
563: hr_utility.set_message_token('PROCEDURE', l_proc);
564: hr_utility.set_message_token('STEP','5');
565: hr_utility.raise_error;
566: Else
567: --
568: -- Determine if the business process is to be validated.

Line 565: hr_utility.raise_error;

561: If (p_rec.comment_id is null) then
562: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
563: hr_utility.set_message_token('PROCEDURE', l_proc);
564: hr_utility.set_message_token('STEP','5');
565: hr_utility.raise_error;
566: Else
567: --
568: -- Determine if the business process is to be validated.
569: --

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

604: Raise HR_Api.Validate_Enabled;
605: End If;
606: --
607: End If;
608: hr_utility.set_location(' Leaving:'||l_proc, 10);
609: Exception
610: When HR_Api.Validate_Enabled Then
611: --
612: -- As the Validate_Enabled exception has been raised

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

651: l_rec g_rec_type;
652: l_proc varchar2(72) := g_package||'upd';
653: --
654: Begin
655: hr_utility.set_location('Entering:'||l_proc, 5);
656: --
657: -- Call conversion function to turn arguments into the
658: -- l_rec structure.
659: --

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

670: -- business process.
671: --
672: upd(l_rec, p_validate);
673: --
674: hr_utility.set_location(' Leaving:'||l_proc, 10);
675: End upd;
676: --
677: -- ----------------------------------------------------------------------------
678: -- |---------------------------------< del >----------------------------------|

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

703: --
704: l_proc varchar2(72) := g_package||'del';
705: --
706: Begin
707: hr_utility.set_location('Entering:'||l_proc, 5);
708: --
709: -- We are deleting using the primary key therefore
710: -- we must ensure that the argument value is NOT null.
711: --

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

709: -- We are deleting using the primary key therefore
710: -- we must ensure that the argument value is NOT null.
711: --
712: If (p_rec.comment_id is null) then
713: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
714: hr_utility.set_message_token('PROCEDURE', l_proc);
715: hr_utility.set_message_token('STEP','5');
716: hr_utility.raise_error;
717: Else

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

710: -- we must ensure that the argument value is NOT null.
711: --
712: If (p_rec.comment_id is null) then
713: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
714: hr_utility.set_message_token('PROCEDURE', l_proc);
715: hr_utility.set_message_token('STEP','5');
716: hr_utility.raise_error;
717: Else
718: --

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

711: --
712: If (p_rec.comment_id is null) then
713: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
714: hr_utility.set_message_token('PROCEDURE', l_proc);
715: hr_utility.set_message_token('STEP','5');
716: hr_utility.raise_error;
717: Else
718: --
719: -- Determine if the business process is to be validated.

Line 716: hr_utility.raise_error;

712: If (p_rec.comment_id is null) then
713: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
714: hr_utility.set_message_token('PROCEDURE', l_proc);
715: hr_utility.set_message_token('STEP','5');
716: hr_utility.raise_error;
717: Else
718: --
719: -- Determine if the business process is to be validated.
720: --

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

751: Raise HR_Api.Validate_Enabled;
752: End If;
753: End If;
754: --
755: hr_utility.set_location(' Leaving:'||l_proc, 10);
756: Exception
757: When HR_Api.Validate_Enabled Then
758: --
759: -- As the Validate_Enabled exception has been raised

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

794: l_rec g_rec_type;
795: l_proc varchar2(72) := g_package||'del';
796: --
797: Begin
798: hr_utility.set_location('Entering:'||l_proc, 5);
799: --
800: -- As the delete procedure accepts a plsql record structure we do need to
801: -- convert the arguments into the record structure.
802: -- We don't need to call the supplied conversion argument routine as we

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

810: -- business process
811: --
812: del(l_rec, p_validate);
813: --
814: hr_utility.set_location(' Leaving:'||l_proc, 10);
815: End del;
816: --
817: end hr_comm_api;