DBA Data[Home] [Help]

APPS.IRC_CMT_BUS dependencies on HR_UTILITY

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

45: l_legislation_code varchar2(150);
46: --
47: begin
48: --
49: hr_utility.set_location('Entering:'|| l_proc, 10);
50: --
51: -- Ensure that all the mandatory parameter are not null
52: --
53: hr_api.mandatory_arg_error

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

85: --
86: hr_api.set_legislation_context(l_legislation_code);
87: end if;
88: --
89: hr_utility.set_location(' Leaving:'|| l_proc, 20);
90: --
91: end set_security_group_id;
92: --
93: -- ---------------------------------------------------------------------------

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

120: l_proc varchar2(72) := g_package||'return_legislation_code';
121: --
122: Begin
123: --
124: hr_utility.set_location('Entering:'|| l_proc, 10);
125: --
126: -- Ensure that all the mandatory parameter are not null
127: --
128: hr_api.mandatory_arg_error

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

138: -- call to this function. Just return the value in the global
139: -- variable.
140: --
141: l_legislation_code := irc_cmt_bus.g_legislation_code;
142: hr_utility.set_location(l_proc, 20);
143: else
144: --
145: -- The ID is different to the last call to this function
146: -- or this is the first call to this function.

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

155: close csr_leg_code;
156: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
157: fnd_message.raise_error;
158: end if;
159: hr_utility.set_location(l_proc,30);
160: --
161: -- Set the global variables so the values are
162: -- available for the next call to this function.
163: --

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

164: close csr_leg_code;
165: irc_cmt_bus.g_communication_topic_id := p_communication_topic_id;
166: irc_cmt_bus.g_legislation_code := l_legislation_code;
167: end if;
168: hr_utility.set_location(' Leaving:'|| l_proc, 40);
169: return l_legislation_code;
170: end return_legislation_code;
171: --
172: -- ----------------------------------------------------------------------------

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

266: --
267: --
268: Begin
269: --
270: hr_utility.set_location(' Entering:'||l_proc,10);
271: --
272: hr_api.mandatory_arg_error
273: (p_api_name => l_proc
274: ,p_argument => 'COMMUNICATION_ID'

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

282: fnd_message.set_name('PER','IRC_412405_WRNG_COMM_ID');
283: fnd_message.raise_error;
284: end if;
285: --
286: hr_utility.set_location(l_proc,20);
287: --
288: exception
289: when app_exception.application_exception then
290: if hr_multi_message.exception_add

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

290: if hr_multi_message.exception_add
291: (p_associated_column1 => 'IRC_COMM_TOPICS.COMMUNICATION_ID'
292: ) then
293: --
294: hr_utility.set_location(' Leaving:'||l_proc,30);
295: --
296: raise;
297: end if;
298: --

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

295: --
296: raise;
297: end if;
298: --
299: hr_utility.set_location(' Leaving:'||l_proc,40);
300: --
301: End chk_communication_id;
302: --
303: -- ----------------------------------------------------------------------------

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

323: --
324: --
325: Begin
326: --
327: hr_utility.set_location(' Entering:'||l_proc,10);
328: --
329: if p_subject is null or length(p_subject) = 0 then
330: fnd_message.set_name('PER','IRC_412246_NULL_TPC_SUB');
331: fnd_message.raise_error;

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

335: fnd_message.set_name('PER','IRC_412406_LONG_MSG_SUB');
336: fnd_message.raise_error;
337: end if;
338: --
339: hr_utility.set_location(l_proc,20);
340: --
341: exception
342: when app_exception.application_exception then
343: if hr_multi_message.exception_add

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

343: if hr_multi_message.exception_add
344: (p_associated_column1 => 'IRC_COMM_TOPICS.SUBJECT'
345: ) then
346: --
347: hr_utility.set_location(' Leaving:'||l_proc,30);
348: --
349: raise;
350: end if;
351: --

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

348: --
349: raise;
350: end if;
351: --
352: hr_utility.set_location(' Leaving:'||l_proc,40);
353: --
354: End chk_subject;
355: --
356: -- ----------------------------------------------------------------------------

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

377: --
378: --
379: Begin
380: --
381: hr_utility.set_location(' Entering:'||l_proc,10);
382: --
383: hr_api.mandatory_arg_error
384: (p_api_name => l_proc
385: ,p_argument => 'STATUS'

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

385: ,p_argument => 'STATUS'
386: ,p_argument_value => p_status
387: );
388: --
389: hr_utility.set_location(l_proc,20);
390: if hr_api.not_exists_in_hr_lookups(p_lookup_type => 'IRC_COMM_STATUS',
391: p_lookup_code => p_status,
392: p_effective_date => p_effective_date)
393: then

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

393: then
394: --
395: -- raise error as does not exist as lookup
396: --
397: hr_utility.set_location('Leaving: '|| l_proc, 30);
398: hr_utility.set_message(800,'IRC_412407_NO_SUCH_TOPIC_STATUS');
399: hr_utility.raise_error;
400: end if;
401: --

Line 398: hr_utility.set_message(800,'IRC_412407_NO_SUCH_TOPIC_STATUS');

394: --
395: -- raise error as does not exist as lookup
396: --
397: hr_utility.set_location('Leaving: '|| l_proc, 30);
398: hr_utility.set_message(800,'IRC_412407_NO_SUCH_TOPIC_STATUS');
399: hr_utility.raise_error;
400: end if;
401: --
402: exception

Line 399: hr_utility.raise_error;

395: -- raise error as does not exist as lookup
396: --
397: hr_utility.set_location('Leaving: '|| l_proc, 30);
398: hr_utility.set_message(800,'IRC_412407_NO_SUCH_TOPIC_STATUS');
399: hr_utility.raise_error;
400: end if;
401: --
402: exception
403: when app_exception.application_exception then

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

404: if hr_multi_message.exception_add
405: (p_associated_column1 => 'IRC_COMM_TOPICS.STATUS'
406: ) then
407: --
408: hr_utility.set_location(' Leaving:'||l_proc,40);
409: --
410: raise;
411: end if;
412: --

Line 413: hr_utility.set_location(' Leaving:'||l_proc,50);

409: --
410: raise;
411: end if;
412: --
413: hr_utility.set_location(' Leaving:'||l_proc,50);
414: --
415: End chk_status;
416: --
417: -- ----------------------------------------------------------------------------

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

424: --
425: l_proc varchar2(72) := g_package||'insert_validate';
426: --
427: Begin
428: hr_utility.set_location('Entering:'||l_proc, 5);
429: --
430: -- Call all supporting business operations
431: --
432: --

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

442: chk_communication_id(p_rec.communication_id);
443: --
444: chk_subject(p_rec.subject);
445: --
446: hr_utility.set_location('Entering:'||l_proc, 10);
447: --
448: chk_status(p_status => p_rec.status
449: ,p_effective_date => p_effective_date);
450: --

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

448: chk_status(p_status => p_rec.status
449: ,p_effective_date => p_effective_date);
450: --
451: --
452: hr_utility.set_location(' Leaving:'||l_proc, 20);
453: End insert_validate;
454: --
455: -- ----------------------------------------------------------------------------
456: -- |---------------------------< update_validate >----------------------------|

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

462: --
463: l_proc varchar2(72) := g_package||'update_validate';
464: --
465: Begin
466: hr_utility.set_location('Entering:'||l_proc, 5);
467: --
468: -- Call all supporting business operations
469: --
470: --

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

483: );
484: --
485: chk_subject(p_rec.subject);
486: --
487: hr_utility.set_location('Entering:'||l_proc, 10);
488: --
489: chk_status(p_status => p_rec.status
490: ,p_effective_date => p_effective_date);
491: --

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

489: chk_status(p_status => p_rec.status
490: ,p_effective_date => p_effective_date);
491: --
492: --
493: hr_utility.set_location(' Leaving:'||l_proc, 20);
494: --
495: --
496: hr_utility.set_location(' Leaving:'||l_proc, 30);
497: End update_validate;

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

492: --
493: hr_utility.set_location(' Leaving:'||l_proc, 20);
494: --
495: --
496: hr_utility.set_location(' Leaving:'||l_proc, 30);
497: End update_validate;
498: --
499: -- ----------------------------------------------------------------------------
500: -- |---------------------------< delete_validate >----------------------------|

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

505: --
506: l_proc varchar2(72) := g_package||'delete_validate';
507: --
508: Begin
509: hr_utility.set_location('Entering:'||l_proc, 5);
510: --
511: -- Call all supporting business operations
512: --
513: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

509: hr_utility.set_location('Entering:'||l_proc, 5);
510: --
511: -- Call all supporting business operations
512: --
513: hr_utility.set_location(' Leaving:'||l_proc, 10);
514: End delete_validate;
515: --
516: end irc_cmt_bus;