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

Line 110: hr_utility.set_location(' Entering:' || l_proc,10);

106:
107:
108: begin
109:
110: hr_utility.set_location(' Entering:' || l_proc,10);
111:
112: -- check if the hierarchy id is not null
113: if(p_hierarchy_id is not null)
114: then

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

124: end if;
125: close csr_hrc_id;
126: end if;
127:
128: hr_utility.set_location(' Leaving:' || l_proc,20);
129: Exception
130: when app_exception.application_exception then
131: IF hr_multi_message.exception_add
132: (p_associated_column1 =>

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

131: IF hr_multi_message.exception_add
132: (p_associated_column1 =>
133: 'HR_KI_HIERARCHY_NODE_MAPS.HIERARCHY_ID'
134: ) THEN
135: hr_utility.set_location(' Leaving:'|| l_proc,30);
136: raise;
137: END IF;
138:
139: hr_utility.set_location(' Leaving:'|| l_proc,40);

Line 139: hr_utility.set_location(' Leaving:'|| l_proc,40);

135: hr_utility.set_location(' Leaving:'|| l_proc,30);
136: raise;
137: END IF;
138:
139: hr_utility.set_location(' Leaving:'|| l_proc,40);
140:
141: end chk_hierarchy_id;
142:
143: -- ----------------------------------------------------------------------------

Line 186: hr_utility.set_location(' Entering:' || l_proc,10);

182:
183:
184: begin
185:
186: hr_utility.set_location(' Entering:' || l_proc,10);
187:
188: -- if the topic id is not null, check whether it exists in hr_ki_topics
189: if(p_topic_id is not null)
190: then

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

200: end if;
201: close csr_tpc_id;
202: end if;
203:
204: hr_utility.set_location(' Leaving:' || l_proc,20);
205: Exception
206: when app_exception.application_exception then
207: IF hr_multi_message.exception_add
208: (p_associated_column1 =>

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

207: IF hr_multi_message.exception_add
208: (p_associated_column1 =>
209: 'HR_KI_HIERARCHY_NODE_MAPS.TOPIC_ID'
210: ) THEN
211: hr_utility.set_location(' Leaving:'|| l_proc,30);
212: raise;
213: END IF;
214:
215: hr_utility.set_location(' Leaving:'|| l_proc,40);

Line 215: hr_utility.set_location(' Leaving:'|| l_proc,40);

211: hr_utility.set_location(' Leaving:'|| l_proc,30);
212: raise;
213: END IF;
214:
215: hr_utility.set_location(' Leaving:'|| l_proc,40);
216:
217: end chk_topic_id;
218:
219: -- ----------------------------------------------------------------------------

Line 263: hr_utility.set_location(' Entering:' || l_proc,10);

259:
260:
261: begin
262:
263: hr_utility.set_location(' Entering:' || l_proc,10);
264:
265: -- if the topic id is not null, check whether it exists in hr_ki_topics
266: if(p_user_interface_id is not null)
267: then

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

277: end if;
278: close csr_itf_id;
279: end if;
280:
281: hr_utility.set_location(' Leaving:' || l_proc,20);
282: Exception
283: when app_exception.application_exception then
284: IF hr_multi_message.exception_add
285: (p_associated_column1 =>

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

284: IF hr_multi_message.exception_add
285: (p_associated_column1 =>
286: 'HR_KI_HIERARCHY_NODE_MAPS.USER_INTERFACE_ID'
287: ) THEN
288: hr_utility.set_location(' Leaving:'|| l_proc,30);
289: raise;
290: END IF;
291:
292: hr_utility.set_location(' Leaving:'|| l_proc,40);

Line 292: hr_utility.set_location(' Leaving:'|| l_proc,40);

288: hr_utility.set_location(' Leaving:'|| l_proc,30);
289: raise;
290: END IF;
291:
292: hr_utility.set_location(' Leaving:'|| l_proc,40);
293:
294: end chk_user_interface_id;
295:
296: -- ----------------------------------------------------------------------------

Line 338: hr_utility.set_location(' Entering:' || l_proc,10);

334: l_found varchar2(30);
335:
336: begin
337:
338: hr_utility.set_location(' Entering:' || l_proc,10);
339:
340: -- check if the combination of values entered for hierarchy_id, topic_id,
341: -- and user_interface_id are correct.
342:

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

364: end if;
365:
366: end if;
367:
368: hr_utility.set_location(' Leaving:' || l_proc,20);
369:
370: Exception
371: when app_exception.application_exception then
372: IF hr_multi_message.exception_add

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

376: 'HR_KI_HIERARCHY_NODE_MAPS.TOPIC_ID',
377: p_associated_column3 =>
378: 'HR_KI_HIERARCHY_NODE_MAPS.USER_INTERFACE_ID'
379: ) THEN
380: hr_utility.set_location(' Leaving:'|| l_proc,30);
381: raise;
382: END IF;
383:
384: hr_utility.set_location(' Leaving:'|| l_proc,40);

Line 384: hr_utility.set_location(' Leaving:'|| l_proc,40);

380: hr_utility.set_location(' Leaving:'|| l_proc,30);
381: raise;
382: END IF;
383:
384: hr_utility.set_location(' Leaving:'|| l_proc,40);
385:
386: end chk_valid_combination;
387:
388: -- ----------------------------------------------------------------------------

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

495: l_found varchar2(10);
496:
497: Begin
498:
499: hr_utility.set_location(' Entering:' || l_proc,10);
500:
501: -- the following validation needs to be done only if no errors have already
502: -- been detected previously, an inclusive error check needs to be done to
503: -- accomodate errors occuring from the first chk_valid_combination check.

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

569: end if;
570:
571: end if;
572:
573: hr_utility.set_location(' Leaving:' || l_proc,20);
574:
575: Exception
576: when app_exception.application_exception then
577: IF hr_multi_message.exception_add

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

581: 'HR_KI_HIERARCHY_NODE_MAPS.TOPIC_ID',
582: p_associated_column3 =>
583: 'HR_KI_HIERARCHY_NODE_MAPS.USER_INTERFACE_ID'
584: ) THEN
585: hr_utility.set_location(' Leaving:'|| l_proc,30);
586: raise;
587: END IF;
588:
589: hr_utility.set_location(' Leaving:'|| l_proc,40);

Line 589: hr_utility.set_location(' Leaving:'|| l_proc,40);

585: hr_utility.set_location(' Leaving:'|| l_proc,30);
586: raise;
587: END IF;
588:
589: hr_utility.set_location(' Leaving:'|| l_proc,40);
590:
591: End chk_unique_combination;
592:
593: --

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

600: --
601: l_proc varchar2(72) := g_package||'insert_validate';
602: --
603: Begin
604: hr_utility.set_location('Entering:'||l_proc, 5);
605: --
606: -- Call all supporting business operations
607: --
608: --

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

625:
626:
627: --
628: --
629: hr_utility.set_location(' Leaving:'||l_proc, 10);
630: End insert_validate;
631: --
632: -- ----------------------------------------------------------------------------
633: -- |---------------------------< update_validate >----------------------------|

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

638: --
639: l_proc varchar2(72) := g_package||'update_validate';
640: --
641: Begin
642: hr_utility.set_location('Entering:'||l_proc, 5);
643: --
644: -- Call all supporting business operations
645: --
646: --

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

665: p_topic_id => p_rec.topic_id,
666: p_user_interface_id => p_rec.user_interface_id);
667: --
668: --
669: hr_utility.set_location(' Leaving:'||l_proc, 10);
670: End update_validate;
671: --
672: -- ----------------------------------------------------------------------------
673: -- |---------------------------< delete_validate >----------------------------|

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

678: --
679: l_proc varchar2(72) := g_package||'delete_validate';
680: --
681: Begin
682: hr_utility.set_location('Entering:'||l_proc, 5);
683: --
684: -- Call all supporting business operations
685: --
686: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

682: hr_utility.set_location('Entering:'||l_proc, 5);
683: --
684: -- Call all supporting business operations
685: --
686: hr_utility.set_location(' Leaving:'||l_proc, 10);
687: End delete_validate;
688: --
689: end hr_hnm_bus;