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

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

43: l_proc varchar2(72) := g_package||'set_security_group_id';
44: --
45: begin
46: --
47: hr_utility.set_location('Entering:'|| l_proc, 10);
48: --
49: -- Ensure that all the mandatory parameter are not null
50: --
51: hr_api.mandatory_arg_error

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

78: (p_security_group_id => l_security_group_id
79: );
80: end if;
81: --
82: hr_utility.set_location(' Leaving:'|| l_proc, 20);
83: --
84: end set_security_group_id;
85: --
86: -- ---------------------------------------------------------------------------

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

113: l_proc varchar2(72) := g_package||'return_legislation_code';
114: --
115: Begin
116: --
117: hr_utility.set_location('Entering:'|| l_proc, 10);
118: --
119: -- Ensure that all the mandatory parameter are not null
120: --
121: hr_api.mandatory_arg_error

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

131: -- call to this function. Just return the value in the global
132: -- variable.
133: --
134: l_legislation_code := pqh_tkt_bus.g_legislation_code;
135: hr_utility.set_location(l_proc, 20);
136: else
137: --
138: -- The ID is different to the last call to this function
139: -- or this is the first call to this function.

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

148: close csr_leg_code;
149: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
150: fnd_message.raise_error;
151: end if;
152: hr_utility.set_location(l_proc,30);
153: --
154: -- Set the global variables so the values are
155: -- available for the next call to this function.
156: --

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

157: close csr_leg_code;
158: pqh_tkt_bus.g_tatigkeit_detail_id := p_tatigkeit_detail_id;
159: pqh_tkt_bus.g_legislation_code := l_legislation_code;
160: end if;
161: hr_utility.set_location(' Leaving:'|| l_proc, 40);
162: return l_legislation_code;
163: end return_legislation_code;
164: --
165: -- ----------------------------------------------------------------------------

Line 220: hr_utility.set_message(8302, 'PQH_DE_NONUPD_TATIGKEIT_NUMBER');

216: -- not been updated.
217: --
218: IF nvl(p_rec.TATIGKEIT_NUMBER, hr_api.g_varchar2) <>
219: nvl(pqh_tkt_shd.g_old_rec.TATIGKEIT_NUMBER, hr_api.g_varchar2) THEN
220: hr_utility.set_message(8302, 'PQH_DE_NONUPD_TATIGKEIT_NUMBER');
221: fnd_message.raise_error;
222: END IF;
223:
224: End chk_non_updateable_args;

Line 241: hr_utility.set_message(8302, 'PQH_TKTDTLS_PRE_DEL');

237: Open Del;
238: Fetch Del into l_Status;
239: If Del%Found Then
240: Close Del;
241: hr_utility.set_message(8302, 'PQH_TKTDTLS_PRE_DEL');
242: hr_utility.raise_error;
243: End If;
244: Close Del;
245: Exception

Line 242: hr_utility.raise_error;

238: Fetch Del into l_Status;
239: If Del%Found Then
240: Close Del;
241: hr_utility.set_message(8302, 'PQH_TKTDTLS_PRE_DEL');
242: hr_utility.raise_error;
243: End If;
244: Close Del;
245: Exception
246: when app_exception.application_exception then

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

246: when app_exception.application_exception then
247: if hr_multi_message.exception_add
248: (p_associated_column1 => 'PQH_DE_TATIGKEIT_DETAILS.TATIGKEIT_NUMBER'
249: ) then
250: hr_utility.set_location(' Leaving:'||l_proc,60);
251: raise;
252: end if;
253: hr_utility.set_location(' Leaving:'||l_proc,70);
254: End Chk_Delete;

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

249: ) then
250: hr_utility.set_location(' Leaving:'||l_proc,60);
251: raise;
252: end if;
253: hr_utility.set_location(' Leaving:'||l_proc,70);
254: End Chk_Delete;
255: -- ----------------------------------------------------------------------------
256: -- |-----------------------< Chk_Unique_TATIGKEIT_NUMBER >---------------------|
257: -- ----------------------------------------------------------------------------

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

264: Where TATIGKEIT_NUMBER = p_rec.TATIGKEIT_NUMBER;
265: l_TATIGKEIT_NUMBER PQH_DE_TATIGKEIT_DETAILS.TATIGKEIT_NUMBER%TYPE;
266: l_proc varchar2(72) := g_package || 'Unique_TATIGKEIT_NUMBER';
267: Begin
268: hr_utility.set_location(l_proc, 10);
269: Open c_TATIGKEIT_NUMBER;
270: Fetch c_TATIGKEIT_NUMBER into l_TATIGKEIT_NUMBER;
271: If c_TATIGKEIT_NUMBER%ROWCOUNT > 0 Then
272: hr_utility.set_message(8302, 'PQH_DE_DUPVAL_tkt_Dtls');

Line 272: hr_utility.set_message(8302, 'PQH_DE_DUPVAL_tkt_Dtls');

268: hr_utility.set_location(l_proc, 10);
269: Open c_TATIGKEIT_NUMBER;
270: Fetch c_TATIGKEIT_NUMBER into l_TATIGKEIT_NUMBER;
271: If c_TATIGKEIT_NUMBER%ROWCOUNT > 0 Then
272: hr_utility.set_message(8302, 'PQH_DE_DUPVAL_tkt_Dtls');
273: Close c_TATIGKEIT_NUMBER;
274: fnd_message.raise_error;
275: End If;
276: Close c_TATIGKEIT_NUMBER;

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

278: when app_exception.application_exception then
279: if hr_multi_message.exception_add
280: (p_associated_column1 => 'PQH_DE_TATIGKEIT_DETAILS.TATIGKEIT_NUMBER'
281: ) then
282: hr_utility.set_location(' Leaving:'||l_proc,60);
283: raise;
284: end if;
285: hr_utility.set_location(' Leaving:'||l_proc,70);
286: End Chk_Unique_TATIGKEIT_NUMBER;

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

281: ) then
282: hr_utility.set_location(' Leaving:'||l_proc,60);
283: raise;
284: end if;
285: hr_utility.set_location(' Leaving:'||l_proc,70);
286: End Chk_Unique_TATIGKEIT_NUMBER;
287:
288:
289: -- ----------------------------------------------------------------------------

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

298: Where Description = p_rec.Description;
299: l_Description PQH_DE_TATIGKEIT_DETAILS.Description%TYPE;
300: l_proc varchar2(72) := g_package || 'Unique_Description';
301: Begin
302: hr_utility.set_location(l_proc, 10);
303: Open c_Description;
304: Fetch c_Description into l_Description;
305: If c_Description%ROWCOUNT > 0 Then
306: hr_utility.set_message(8302, 'PQH_DE_DUPVAL_Description');

Line 306: hr_utility.set_message(8302, 'PQH_DE_DUPVAL_Description');

302: hr_utility.set_location(l_proc, 10);
303: Open c_Description;
304: Fetch c_Description into l_Description;
305: If c_Description%ROWCOUNT > 0 Then
306: hr_utility.set_message(8302, 'PQH_DE_DUPVAL_Description');
307: Close c_Description;
308: fnd_message.raise_error;
309: End If;
310: Close c_Description;

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

312: when app_exception.application_exception then
313: if hr_multi_message.exception_add
314: (p_associated_column1 => 'PQH_DE_TATIGKEIT_DETAILS.Description'
315: ) then
316: hr_utility.set_location(' Leaving:'||l_proc,60);
317: raise;
318: end if;
319: hr_utility.set_location(' Leaving:'||l_proc,70);
320: End Chk_Unique_Description;

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

315: ) then
316: hr_utility.set_location(' Leaving:'||l_proc,60);
317: raise;
318: end if;
319: hr_utility.set_location(' Leaving:'||l_proc,70);
320: End Chk_Unique_Description;
321:
322:
323:

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

334: --
335: l_proc varchar2(72) := g_package||'insert_validate';
336: --
337: Begin
338: hr_utility.set_location('Entering:'||l_proc, 5);
339: --
340: -- Call all supporting business operations
341: --
342: --

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

352: --
353: -- Validate Dependent Attributes
354: --
355: --
356: hr_utility.set_location(' Leaving:'||l_proc, 10);
357: End insert_validate;
358: --
359: -- ----------------------------------------------------------------------------
360: -- |---------------------------< update_validate >----------------------------|

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

366: --
367: l_proc varchar2(72) := g_package||'update_validate';
368: --
369: Begin
370: hr_utility.set_location('Entering:'||l_proc, 5);
371: --
372: -- Call all supporting business operations
373: --
374: --

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

390: ,p_rec => p_rec
391: );
392: --
393: --
394: hr_utility.set_location(' Leaving:'||l_proc, 10);
395: End update_validate;
396: --
397: -- ----------------------------------------------------------------------------
398: -- |---------------------------< delete_validate >----------------------------|

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

403: --
404: l_proc varchar2(72) := g_package||'delete_validate';
405: --
406: Begin
407: hr_utility.set_location('Entering:'||l_proc, 5);
408: --
409: -- Call all supporting business operations
410: --
411: Chk_delete(P_Rec);

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

408: --
409: -- Call all supporting business operations
410: --
411: Chk_delete(P_Rec);
412: hr_utility.set_location(' Leaving:'||l_proc, 10);
413: End delete_validate;
414: --
415: end pqh_tkt_bus;