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

Line 69: hr_utility.set_location('Entering '||l_proc||': '||TO_CHAR(p_form_template_id),10);

65: l_form_template t_form_template;
66: --
67: BEGIN
68: --
69: hr_utility.set_location('Entering '||l_proc||': '||TO_CHAR(p_form_template_id),10);
70: --
71: IF (p_form_template_id = nvl(g_form_template_id,hr_api.g_number))
72: THEN
73: --

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

70: --
71: IF (p_form_template_id = nvl(g_form_template_id,hr_api.g_number))
72: THEN
73: --
74: hr_utility.set_location(l_proc,20);
75: --
76: -- The form template has already been found with a previous call to this
77: -- function. Just return the global variable.
78: --

Line 83: hr_utility.set_location(l_proc,30);

79: l_form_template := g_form_template;
80: --
81: ELSE
82: --
83: hr_utility.set_location(l_proc,30);
84: --
85: -- The identifier is different to the previous call to this function, or
86: -- this is the first call to this function.
87: --

Line 94: hr_utility.set_location(l_proc,40);

90: );
91: FETCH csr_form_templates INTO l_form_template;
92: IF (csr_form_templates%NOTFOUND)
93: THEN
94: hr_utility.set_location(l_proc,40);
95: END IF;
96: CLOSE csr_form_templates;
97: --
98: hr_utility.set_location(l_proc,50);

Line 98: hr_utility.set_location(l_proc,50);

94: hr_utility.set_location(l_proc,40);
95: END IF;
96: CLOSE csr_form_templates;
97: --
98: hr_utility.set_location(l_proc,50);
99: --
100: -- Set the global variables so the values are available to the next call to
101: -- the function.
102: --

Line 108: hr_utility.set_location('Leaving '||l_proc,60);

104: g_form_template := l_form_template;
105: --
106: END IF;
107: --
108: hr_utility.set_location('Leaving '||l_proc,60);
109: --
110: RETURN(l_form_template);
111: --
112: END form_template;

Line 161: hr_utility.set_location('Entering '||l_proc||': '||TO_CHAR(p_application_id)||', '||TO_CHAR(p_form_id)||', '||p_template_name||', '||p_legislation_code,10);

157: l_form_template_found BOOLEAN := FALSE;
158: --
159: BEGIN
160: --
161: hr_utility.set_location('Entering '||l_proc||': '||TO_CHAR(p_application_id)||', '||TO_CHAR(p_form_id)||', '||p_template_name||', '||p_legislation_code,10);
162: --
163: -- Search for a template within the specified legislation
164: --
165: IF (p_legislation_code IS NOT NULL)

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

163: -- Search for a template within the specified legislation
164: --
165: IF (p_legislation_code IS NOT NULL)
166: THEN
167: hr_utility.set_location(l_proc,20);
168: OPEN csr_form_templates
169: (p_application_id => p_application_id
170: ,p_form_id => p_form_id
171: ,p_template_name => p_template_name

Line 179: hr_utility.set_location(l_proc,30);

175: l_form_template_found := csr_form_templates%FOUND;
176: CLOSE csr_form_templates;
177: END IF;
178: --
179: hr_utility.set_location(l_proc,30);
180: --
181: -- Search for a template which is not specific to any legislation, if one has
182: -- not been found already
183: --

Line 186: hr_utility.set_location(l_proc||': '||TO_CHAR(p_application_id)||', '||TO_CHAR(p_form_id)||', '||p_template_name,40);

182: -- not been found already
183: --
184: IF (NOT l_form_template_found)
185: THEN
186: hr_utility.set_location(l_proc||': '||TO_CHAR(p_application_id)||', '||TO_CHAR(p_form_id)||', '||p_template_name,40);
187: OPEN csr_form_templates2
188: (p_application_id => p_application_id
189: ,p_form_id => p_form_id
190: ,p_template_name => p_template_name

Line 197: hr_utility.set_location(l_proc,50);

193: l_form_template_found := csr_form_templates2%FOUND;
194: CLOSE csr_form_templates2;
195: END IF;
196: --
197: hr_utility.set_location(l_proc,50);
198: --
199: IF (l_form_template_found)
200: THEN
201: hr_utility.set_location(l_proc,60);

Line 201: hr_utility.set_location(l_proc,60);

197: hr_utility.set_location(l_proc,50);
198: --
199: IF (l_form_template_found)
200: THEN
201: hr_utility.set_location(l_proc,60);
202: l_form_template := form_template
203: (p_form_template_id => l_form_template_internal.form_template_id
204: );
205: END IF;

Line 207: hr_utility.set_location('Leaving '||l_proc,70);

203: (p_form_template_id => l_form_template_internal.form_template_id
204: );
205: END IF;
206: --
207: hr_utility.set_location('Leaving '||l_proc,70);
208: --
209: RETURN(l_form_template);
210: --
211: END form_template;

Line 239: hr_utility.set_location('Entering '||l_proc||': '||p_function_name||', '||p_template_name||', '||p_legislation_code,10);

235: l_form_template t_form_template;
236: --
237: BEGIN
238: --
239: hr_utility.set_location('Entering '||l_proc||': '||p_function_name||', '||p_template_name||', '||p_legislation_code,10);
240: --
241: OPEN csr_form_functions
242: (p_function_name => p_function_name
243: );

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

243: );
244: FETCH csr_form_functions INTO l_form_function;
245: IF (csr_form_functions%FOUND)
246: THEN
247: hr_utility.set_location(l_proc,20);
248: l_form_template := form_template
249: (p_application_id => l_form_function.application_id
250: ,p_form_id => l_form_function.form_id
251: ,p_template_name => p_template_name

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

253: );
254: END IF;
255: CLOSE csr_form_functions;
256: --
257: hr_utility.set_location('Leaving '||l_proc,30);
258: --
259: RETURN(l_form_template);
260: --
261: END form_template;