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

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

27: l_proc varchar2(72) := g_package||'set_security_group_id';
28: --
29: begin
30: --
31: hr_utility.set_location('Entering:'|| l_proc, 10);
32: --
33: -- Ensure that all the mandatory parameter are not null
34: --
35: hr_api.mandatory_arg_error

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

38: ,p_argument_value => p_document_id
39: );
40: --
41: --
42: hr_utility.set_location(' Leaving:'|| l_proc, 20);
43: --
44: end set_security_group_id;
45: --
46: -- ---------------------------------------------------------------------------

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

60: l_proc varchar2(72) := g_package||'return_legislation_code';
61: --
62: Begin
63: --
64: hr_utility.set_location('Entering:'|| l_proc, 10);
65: --
66: -- Ensure that all the mandatory parameter are not null
67: --
68: hr_api.mandatory_arg_error

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

70: ,p_argument => 'document_id'
71: ,p_argument_value => p_document_id
72: );
73: --
74: hr_utility.set_location(' Leaving:'|| l_proc, 40);
75: return l_legislation_code;
76: end return_legislation_code;
77: -- ---------------------------------------------------------------------------
78: -- |--------------------------< chk_party_id >-------------------------------|

Line 111: hr_utility.set_location('Entering: '|| l_proc, 1);

107: select hp.party_id
108: from hz_parties hp
109: where hp.party_id = p_party_id;
110: begin
111: hr_utility.set_location('Entering: '|| l_proc, 1);
112: --
113: -- Check the party_id being passed exists on HZ_PARTIES table.
114: --
115: open csr_valid_party;

Line 119: hr_utility.set_message(800,'IRC_289477_RTM_INV_PARTY_ID');

115: open csr_valid_party;
116: fetch csr_valid_party into l_party_id;
117: if csr_valid_party%notfound then
118: close csr_valid_party;
119: hr_utility.set_message(800,'IRC_289477_RTM_INV_PARTY_ID');
120: hr_utility.raise_error;
121: end if;
122: close csr_valid_party;
123: --

Line 120: hr_utility.raise_error;

116: fetch csr_valid_party into l_party_id;
117: if csr_valid_party%notfound then
118: close csr_valid_party;
119: hr_utility.set_message(800,'IRC_289477_RTM_INV_PARTY_ID');
120: hr_utility.raise_error;
121: end if;
122: close csr_valid_party;
123: --
124: hr_utility.set_location('Exiting: '|| l_proc, 2);

Line 124: hr_utility.set_location('Exiting: '|| l_proc, 2);

120: hr_utility.raise_error;
121: end if;
122: close csr_valid_party;
123: --
124: hr_utility.set_location('Exiting: '|| l_proc, 2);
125: end chk_party_id;
126: -- ---------------------------------------------------------------------------
127: -- |--------------------------< chk_person_id >-------------------------------|
128: -- ---------------------------------------------------------------------------

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

168: where per.person_id = p_person_id
169: and p_effective_date between effective_start_date and effective_end_date;
170: Begin
171: --
172: hr_utility.set_location(' Entering:'||l_proc,10);
173: --
174: -- Check if the person_id exists in PER_ALL_PEOPLE_F.
175: --
176: open csr_person_id;

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

174: -- Check if the person_id exists in PER_ALL_PEOPLE_F.
175: --
176: open csr_person_id;
177: fetch csr_person_id into l_party_id;
178: hr_utility.set_location(l_proc, 30);
179: if csr_person_id%notfound then
180: close csr_person_id;
181: fnd_message.set_name('PER','IRC_412249_DOC_NO_PERSON');
182: fnd_message.raise_error;

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

240: and doc.end_date is null
241: and months_between(p_effective_date,doc.creation_date) <= 1;
242: Begin
243: --
244: hr_utility.set_location(' Entering:'||l_proc,10);
245: --
246: --
247: open csr_doc_upload_count;
248: fetch csr_doc_upload_count into l_count;

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

246: --
247: open csr_doc_upload_count;
248: fetch csr_doc_upload_count into l_count;
249: close csr_doc_upload_count;
250: hr_utility.set_location(l_proc, 20);
251: l_max_count := to_number(fnd_profile.value('IRC_MONTHLY_DOC_UPLOAD_COUNT'));
252: if l_count >= l_max_count then
253: hr_utility.set_location(l_proc, 30);
254: fnd_message.set_name('PER','IRC_MAX_DOC_UPLOADS_EXCEEDED');

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

249: close csr_doc_upload_count;
250: hr_utility.set_location(l_proc, 20);
251: l_max_count := to_number(fnd_profile.value('IRC_MONTHLY_DOC_UPLOAD_COUNT'));
252: if l_count >= l_max_count then
253: hr_utility.set_location(l_proc, 30);
254: fnd_message.set_name('PER','IRC_MAX_DOC_UPLOADS_EXCEEDED');
255: fnd_message.raise_error;
256: end if;
257: hr_utility.set_location('Leaving'||l_proc, 40);

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

253: hr_utility.set_location(l_proc, 30);
254: fnd_message.set_name('PER','IRC_MAX_DOC_UPLOADS_EXCEEDED');
255: fnd_message.raise_error;
256: end if;
257: hr_utility.set_location('Leaving'||l_proc, 40);
258: --
259: End chk_monthly_doc_upload_count;
260: --
261: -- ---------------------------------------------------------------------------

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

301: where doc.person_id = p_person_id
302: and doc.end_date is null;
303: Begin
304: --
305: hr_utility.set_location(' Entering:'||l_proc,10);
306: --
307: --
308: open csr_doc_upload_count;
309: fetch csr_doc_upload_count into l_count;

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

307: --
308: open csr_doc_upload_count;
309: fetch csr_doc_upload_count into l_count;
310: close csr_doc_upload_count;
311: hr_utility.set_location(l_proc, 20);
312: l_max_count := to_number(fnd_profile.value('IRC_TOTAL_DOC_UPLOAD_COUNT'));
313: if l_count >= l_max_count then
314: hr_utility.set_location(l_proc, 30);
315: fnd_message.set_name('PER','IRC_TOT_DOC_UPLOADS_EXCEEDED');

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

310: close csr_doc_upload_count;
311: hr_utility.set_location(l_proc, 20);
312: l_max_count := to_number(fnd_profile.value('IRC_TOTAL_DOC_UPLOAD_COUNT'));
313: if l_count >= l_max_count then
314: hr_utility.set_location(l_proc, 30);
315: fnd_message.set_name('PER','IRC_TOT_DOC_UPLOADS_EXCEEDED');
316: fnd_message.raise_error;
317: end if;
318: hr_utility.set_location('Leaving'||l_proc, 40);

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

314: hr_utility.set_location(l_proc, 30);
315: fnd_message.set_name('PER','IRC_TOT_DOC_UPLOADS_EXCEEDED');
316: fnd_message.raise_error;
317: end if;
318: hr_utility.set_location('Leaving'||l_proc, 40);
319: --
320: End chk_total_doc_upload_count;
321: --
322: -- ---------------------------------------------------------------------------

Line 359: hr_utility.set_location('Entering: '|| l_proc, 1);

355: l_proc varchar2(72) := g_package||'chk_type';
356: l_api_updating boolean;
357: --
358: begin
359: hr_utility.set_location('Entering: '|| l_proc, 1);
360: l_api_updating := irc_ido_shd.api_updating
361: (p_document_id => p_document_id,
362: p_object_version_number => p_object_version_number);
363: --

Line 378: hr_utility.set_location('Leaving: '|| l_proc, 3);

374: then
375: --
376: -- raise error as does not exist as lookup
377: --
378: hr_utility.set_location('Leaving: '|| l_proc, 3);
379: hr_utility.set_message(800,'IRC_412089_NO_SUCH_DOC_TYPE');
380: hr_utility.raise_error;
381: end if;
382: end if;

Line 379: hr_utility.set_message(800,'IRC_412089_NO_SUCH_DOC_TYPE');

375: --
376: -- raise error as does not exist as lookup
377: --
378: hr_utility.set_location('Leaving: '|| l_proc, 3);
379: hr_utility.set_message(800,'IRC_412089_NO_SUCH_DOC_TYPE');
380: hr_utility.raise_error;
381: end if;
382: end if;
383: hr_utility.set_location('Leaving: '|| l_proc, 2);

Line 380: hr_utility.raise_error;

376: -- raise error as does not exist as lookup
377: --
378: hr_utility.set_location('Leaving: '|| l_proc, 3);
379: hr_utility.set_message(800,'IRC_412089_NO_SUCH_DOC_TYPE');
380: hr_utility.raise_error;
381: end if;
382: end if;
383: hr_utility.set_location('Leaving: '|| l_proc, 2);
384: end chk_type;

Line 383: hr_utility.set_location('Leaving: '|| l_proc, 2);

379: hr_utility.set_message(800,'IRC_412089_NO_SUCH_DOC_TYPE');
380: hr_utility.raise_error;
381: end if;
382: end if;
383: hr_utility.set_location('Leaving: '|| l_proc, 2);
384: end chk_type;
385:
386: --
387: -- ----------------------------------------------------------------------------

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

455: --
456: l_proc varchar2(72) := g_package||'insert_validate';
457: --
458: Begin
459: hr_utility.set_location('Entering:'||l_proc, 5);
460: --
461: -- Call all supporting business operations
462: --
463: chk_person_id

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

479: -- chk_monthly_doc_upload_count
480: -- (p_person_id => p_rec.person_id
481: -- ,p_effective_date => p_effective_date
482: -- );
483: hr_utility.set_location(' Leaving:'||l_proc, 10);
484: End insert_validate;
485: --
486: -- ----------------------------------------------------------------------------
487: -- |---------------------------< update_validate >----------------------------|

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

493: --
494: l_proc varchar2(72) := g_package||'update_validate';
495: --
496: Begin
497: hr_utility.set_location('Entering:'||l_proc, 5);
498: --
499: -- Call all supporting business operations
500: --
501: chk_type

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

503: p_document_id => p_rec.document_id,
504: p_effective_date => p_effective_date,
505: p_object_version_number => p_rec.object_version_number);
506: --
507: hr_utility.set_location(' Leaving:'||l_proc, 10);
508: End update_validate;
509: --
510: -- ----------------------------------------------------------------------------
511: -- |---------------------------< delete_validate >----------------------------|

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

516: --
517: l_proc varchar2(72) := g_package||'delete_validate';
518: --
519: Begin
520: hr_utility.set_location('Entering:'||l_proc, 5);
521: --
522: -- Call all supporting business operations
523: --
524: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

520: hr_utility.set_location('Entering:'||l_proc, 5);
521: --
522: -- Call all supporting business operations
523: --
524: hr_utility.set_location(' Leaving:'||l_proc, 10);
525: End delete_validate;
526: --
527: end irc_ido_bus;