DBA Data[Home] [Help]

APPS.IRC_IDP_BUS dependencies on HR_UTILITY

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

48: --
49: l_proc varchar2(72) := g_package || 'chk_df';
50: --
51: begin
52: hr_utility.set_location('Entering:'||l_proc,10);
53: --
54: if ((p_rec.default_posting_id is not null) and (
55: nvl(irc_idp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
56: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

187: ,p_attribute30_value => p_rec.attribute30
188: );
189: end if;
190: --
191: hr_utility.set_location(' Leaving:'||l_proc,20);
192: end chk_df;
193: --
194: -- ----------------------------------------------------------------------------
195: -- |-----------------------< chk_non_updateable_args >------------------------|

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

289: l_proc varchar2(72) := g_package||'chk_one_id';
290: l_flag number;
291: --
292: begin
293: hr_utility.set_location('Entering:'|| l_proc, 10);
294: --
295: l_flag := 0;
296: --
297: if (p_job_id is not null) then

Line 310: hr_utility.set_message(800, 'IRC_412090_TOO_MANY_ARGS');

306: l_flag := l_flag + 1;
307: end if;
308: --
309: if (l_flag > 1) then
310: hr_utility.set_message(800, 'IRC_412090_TOO_MANY_ARGS');
311: hr_utility.raise_error;
312: end if;
313: --
314: hr_utility.set_location(' Leaving:'|| l_proc, 40);

Line 311: hr_utility.raise_error;

307: end if;
308: --
309: if (l_flag > 1) then
310: hr_utility.set_message(800, 'IRC_412090_TOO_MANY_ARGS');
311: hr_utility.raise_error;
312: end if;
313: --
314: hr_utility.set_location(' Leaving:'|| l_proc, 40);
315: end chk_one_id;

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

310: hr_utility.set_message(800, 'IRC_412090_TOO_MANY_ARGS');
311: hr_utility.raise_error;
312: end if;
313: --
314: hr_utility.set_location(' Leaving:'|| l_proc, 40);
315: end chk_one_id;
316:
317: --
318: -- ---------------------------------------------------------------------------

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

354: where haou.organization_id = p_organization_id;
355: --
356: --
357: begin
358: hr_utility.set_location('Entering:'|| l_proc, 10);
359: --
360: if p_organization_id is not null or p_organization_id <> hr_api.g_number then
361: open csr_org;
362: fetch csr_org into l_org;

Line 366: hr_utility.set_message(800, 'IRC_412091_ORG_NOT_EXIST');

362: fetch csr_org into l_org;
363: if (csr_org%notfound)
364: then
365: close csr_org;
366: hr_utility.set_message(800, 'IRC_412091_ORG_NOT_EXIST');
367: hr_utility.raise_error;
368: end if;
369: close csr_org;
370: end if;

Line 367: hr_utility.raise_error;

363: if (csr_org%notfound)
364: then
365: close csr_org;
366: hr_utility.set_message(800, 'IRC_412091_ORG_NOT_EXIST');
367: hr_utility.raise_error;
368: end if;
369: close csr_org;
370: end if;
371: --

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

368: end if;
369: close csr_org;
370: end if;
371: --
372: hr_utility.set_location(' Leaving:'|| l_proc, 40);
373: end chk_organization_id;
374:
375: --
376: -- ---------------------------------------------------------------------------

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

411: from per_jobs pj
412: where pj.job_id = p_job_id;
413: --
414: begin
415: hr_utility.set_location('Entering:'|| l_proc, 10);
416: --
417: if p_job_id is not null or p_job_id <> hr_api.g_number then
418: open csr_job;
419: fetch csr_job into l_job;

Line 424: hr_utility.set_message(800, 'IRC_412037_RTM_INV_JOB_ID');

420: --
421: if (csr_job%notfound) then
422: --
423: close csr_job;
424: hr_utility.set_message(800, 'IRC_412037_RTM_INV_JOB_ID');
425: hr_utility.raise_error;
426: --
427: end if;
428: --

Line 425: hr_utility.raise_error;

421: if (csr_job%notfound) then
422: --
423: close csr_job;
424: hr_utility.set_message(800, 'IRC_412037_RTM_INV_JOB_ID');
425: hr_utility.raise_error;
426: --
427: end if;
428: --
429: close csr_job;

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

427: end if;
428: --
429: close csr_job;
430: end if;
431: hr_utility.set_location(' Leaving:'|| l_proc, 40);
432: end chk_job_id;
433:
434: --
435: -- ---------------------------------------------------------------------------

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

472: and trunc(sysdate) between hapf.effective_start_date
473: and hapf.effective_end_date;
474: --
475: begin
476: hr_utility.set_location('Entering:'|| l_proc, 10);
477: --
478: if p_position_id is not null and p_position_id <> hr_api.g_number then
479: open csr_pos;
480: fetch csr_pos into l_pos;

Line 485: hr_utility.set_message(800, 'IRC_412092_POS_NOT_EXIST');

481: --
482: if (csr_pos%notfound) then
483: --
484: close csr_pos;
485: hr_utility.set_message(800, 'IRC_412092_POS_NOT_EXIST');
486: hr_utility.raise_error;
487: --
488: end if;
489: --

Line 486: hr_utility.raise_error;

482: if (csr_pos%notfound) then
483: --
484: close csr_pos;
485: hr_utility.set_message(800, 'IRC_412092_POS_NOT_EXIST');
486: hr_utility.raise_error;
487: --
488: end if;
489: --
490: close csr_pos;

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

489: --
490: close csr_pos;
491: end if;
492: --
493: hr_utility.set_location(' Leaving:'|| l_proc, 40);
494: end chk_position_id;
495:
496: --
497: -- ----------------------------------------------------------------------------

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

503: --
504: l_proc varchar2(72) := g_package||'insert_validate';
505: --
506: Begin
507: hr_utility.set_location('Entering:'||l_proc, 5);
508: --
509: -- Call all supporting business operations
510: --
511: -- CLIENT_INFO not set. No lookup validation or joins to HR_LOOKUPS."

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

544:
545: --
546: irc_idp_bus.chk_df(p_rec);
547: --
548: hr_utility.set_location(' Leaving:'||l_proc, 10);
549: End insert_validate;
550: --
551: -- ----------------------------------------------------------------------------
552: -- |---------------------------< update_validate >----------------------------|

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

557: --
558: l_proc varchar2(72) := g_package||'update_validate';
559: --
560: Begin
561: hr_utility.set_location('Entering:'||l_proc, 5);
562: --
563: -- Call all supporting business operations
564: --
565:

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

605:
606: --
607: irc_idp_bus.chk_df(p_rec);
608: --
609: hr_utility.set_location(' Leaving:'||l_proc, 10);
610: End update_validate;
611: --
612: -- ----------------------------------------------------------------------------
613: -- |---------------------------< delete_validate >----------------------------|

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

618: --
619: l_proc varchar2(72) := g_package||'delete_validate';
620: --
621: Begin
622: hr_utility.set_location('Entering:'||l_proc, 5);
623: --
624: -- Call all supporting business operations
625: --
626: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

622: hr_utility.set_location('Entering:'||l_proc, 5);
623: --
624: -- Call all supporting business operations
625: --
626: hr_utility.set_location(' Leaving:'||l_proc, 10);
627: End delete_validate;
628: --
629: end irc_idp_bus;