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

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

90: l_proc varchar2(72) := g_package||'chk_date_validate';
91: l_temp varchar2(80) := '';
92: --
93: Begin
94: hr_utility.set_location('Entering:'||l_proc, 5);
95: --
96: -- Call all supporting business operations
97: --
98: if (p_start_date > p_end_date) then

Line 100: hr_utility.set_message(800,'PER_52833_FR_CAG_INV_START');

96: -- Call all supporting business operations
97: --
98: if (p_start_date > p_end_date) then
99: begin
100: hr_utility.set_message(800,'PER_52833_FR_CAG_INV_START');
101: hr_utility.raise_error;
102: end;
103: end if;
104: --

Line 101: hr_utility.raise_error;

97: --
98: if (p_start_date > p_end_date) then
99: begin
100: hr_utility.set_message(800,'PER_52833_FR_CAG_INV_START');
101: hr_utility.raise_error;
102: end;
103: end if;
104: --
105: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

101: hr_utility.raise_error;
102: end;
103: end if;
104: --
105: hr_utility.set_location(' Leaving:'||l_proc, 10);
106: End chk_date_validate;
107:
108: -- ---------------------------------------------------------------------------
109: -- |---------------------------------------------------|

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

121: l_proc varchar2(72) := g_package||'chk_status_validate';
122: l_temp varchar2(80) := '';
123: --
124: Begin
125: hr_utility.set_location('Entering:'||l_proc, 5);
126: --
127: -- Call all supporting business operations
128: --
129:

Line 136: hr_utility.set_message(800,'PER_289273_CAG_INV_STATUS');

132: fetch csr_status into l_temp;
133: if csr_status%notfound then
134: begin
135: close csr_status;
136: hr_utility.set_message(800,'PER_289273_CAG_INV_STATUS');
137: hr_utility.raise_error;
138: end;
139: end if;
140: close csr_status;

Line 137: hr_utility.raise_error;

133: if csr_status%notfound then
134: begin
135: close csr_status;
136: hr_utility.set_message(800,'PER_289273_CAG_INV_STATUS');
137: hr_utility.raise_error;
138: end;
139: end if;
140: close csr_status;
141: end;

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

139: end if;
140: close csr_status;
141: end;
142:
143: hr_utility.set_location(' Leaving:'||l_proc, 10);
144: End chk_status_validate;
145: --
146: -- ---------------------------------------------------------------------------
147: -- |---------------------------< chk_mandatory_date >------------------------|

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

154: l_proc varchar2(72) := g_package||'chk_mandatory_date';
155: l_temp varchar2(80) := '';
156: --
157: Begin
158: hr_utility.set_location('Entering:'||l_proc, 5);
159: --
160: -- Call all supporting business operations
161: --
162:

Line 165: hr_utility.set_message(800,'PER_52834_FR_CAG_MAN_DATE');

161: --
162:
163: if ((to_char(p_end_date) is NOT NULL) and (to_char(p_start_date) is NULL)) then
164: begin
165: hr_utility.set_message(800,'PER_52834_FR_CAG_MAN_DATE');
166: hr_utility.raise_error;
167: end;
168: end if;
169:

Line 166: hr_utility.raise_error;

162:
163: if ((to_char(p_end_date) is NOT NULL) and (to_char(p_start_date) is NULL)) then
164: begin
165: hr_utility.set_message(800,'PER_52834_FR_CAG_MAN_DATE');
166: hr_utility.raise_error;
167: end;
168: end if;
169:
170:

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

167: end;
168: end if;
169:
170:
171: hr_utility.set_location(' Leaving:'||l_proc, 10);
172: End chk_mandatory_date;
173: --
174: -- ---------------------------------------------------------------------------
175: -- |-------------< chk_employer_organization_id >----------------------------|

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

192: --
193: --
194: Begin
195:
196: hr_utility.set_location('Entering:'||l_proc, 5);
197: --
198: -- Call all supporting business operations
199: --
200:

Line 213: hr_utility.set_message(800,'PER_52846_CAG_INV_EMP_ORG');

209: fetch csr_employers into l_dummy;
210: if csr_employers%notfound then
211: begin
212: close csr_employers;
213: hr_utility.set_message(800,'PER_52846_CAG_INV_EMP_ORG');
214: hr_utility.raise_error;
215: end;
216: end if;
217: close csr_employers;

Line 214: hr_utility.raise_error;

210: if csr_employers%notfound then
211: begin
212: close csr_employers;
213: hr_utility.set_message(800,'PER_52846_CAG_INV_EMP_ORG');
214: hr_utility.raise_error;
215: end;
216: end if;
217: close csr_employers;
218: end;

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

217: close csr_employers;
218: end;
219: end if;
220:
221: hr_utility.set_location(' Leaving:'||l_proc, 10);
222: End chk_employer_organization_id;
223: --
224: --
225: -- ---------------------------------------------------------------------------

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

243: --
244: --
245: Begin
246:
247: hr_utility.set_location('Entering:'||l_proc, 5);
248: --
249: -- Call all supporting business operations
250: --
251:

Line 263: hr_utility.set_message(800,'PER_52847_CAG_INV_BARG_ORG');

259: fetch csr_bargaining_units into l_dummy;
260: if csr_bargaining_units%notfound then
261: begin
262: close csr_bargaining_units;
263: hr_utility.set_message(800,'PER_52847_CAG_INV_BARG_ORG');
264: hr_utility.raise_error;
265: end;
266: end if;
267: close csr_bargaining_units;

Line 264: hr_utility.raise_error;

260: if csr_bargaining_units%notfound then
261: begin
262: close csr_bargaining_units;
263: hr_utility.set_message(800,'PER_52847_CAG_INV_BARG_ORG');
264: hr_utility.raise_error;
265: end;
266: end if;
267: close csr_bargaining_units;
268: end;

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

267: close csr_bargaining_units;
268: end;
269: end if;
270:
271: hr_utility.set_location(' Leaving:'||l_proc, 10);
272: End chk_bargaining_organization_id;
273: --
274: -- -----------------------------------------------------------------------
275: -- |------------------------------< chk_df >-----------------------------|

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

303: --
304: l_proc varchar2(72) := g_package||'chk_df';
305: --
306: begin
307: hr_utility.set_location('Entering:'||l_proc, 10);
308: --
309: if ((p_rec.collective_agreement_id is NULL) and (
310: nvl(per_cag_shd.g_old_rec.attribute_category, hr_api.g_varchar2)<>
311: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

402: ,p_attribute20_value => p_rec.attribute20
403: );
404: end if;
405: --
406: hr_utility.set_location(' Leaving:'||l_proc, 20);
407:
408: end chk_df;
409: --
410: -- -----------------------------------------------------------------------

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

444: l_proc varchar2(72) := g_package||'chk_ddf';
445: l_error exception;
446: --
447: Begin
448: hr_utility.set_location('Entering:'||l_proc, 5);
449: --
450: -- Check if the row is being inserted or updated and a
451: -- value has changed
452: --

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

544: );
545: --
546: end if;
547: --
548: hr_utility.set_location(' Leaving:'||l_proc, 10);
549: end chk_ddf;
550: --
551:
552: --

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

557: --
558: l_proc varchar2(72) := g_package||'insert_validate';
559: --
560: Begin
561: hr_utility.set_location('Entering:'||l_proc, 5);
562: --
563: -- Validate Business Group Id
564: --
565: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

622: --
623: per_cag_bus.chk_df(p_rec => p_rec);
624: --
625: --
626: hr_utility.set_location(' Leaving:'||l_proc, 10);
627: End insert_validate;
628: --
629: -- ----------------------------------------------------------------------------
630: -- |---------------------------< update_validate >----------------------------|

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

633: --
634: l_proc varchar2(72) := g_package||'update_validate';
635: --
636: Begin
637: hr_utility.set_location('Entering:'||l_proc, 5);
638: --
639: -- Call all supporting business operations
640: --
641: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

680: --
681: per_cag_bus.chk_df(p_rec => p_rec);
682:
683:
684: hr_utility.set_location(' Leaving:'||l_proc, 10);
685: End update_validate;
686: --
687: -- ----------------------------------------------------------------------------
688: -- |---------------------------< delete_validate >----------------------------|

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

711: l_proc varchar2(72) := g_package||'delete_validate';
712: --
713: Begin
714:
715: hr_utility.set_location('Entering:'||l_proc, 5);
716: --
717: -- If the collective agreements exits in per_all_assignments
718: --
719: open csr_assignment;

Line 724: hr_utility.set_message(800,'PER_52838_CAG_DEL_ASG');

720: fetch csr_assignment into l_dummy;
721: if csr_assignment%found then
722: begin
723: close csr_assignment;
724: hr_utility.set_message(800,'PER_52838_CAG_DEL_ASG');
725: hr_utility.raise_error;
726: end;
727: end if;
728: close csr_assignment;

Line 725: hr_utility.raise_error;

721: if csr_assignment%found then
722: begin
723: close csr_assignment;
724: hr_utility.set_message(800,'PER_52838_CAG_DEL_ASG');
725: hr_utility.raise_error;
726: end;
727: end if;
728: close csr_assignment;
729: --

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

726: end;
727: end if;
728: close csr_assignment;
729: --
730: hr_utility.set_location(l_proc, 10);
731: --
732: -- If the collective agreements exits in hr_fr_estab_coll_agrs_v
733: --
734: open csr_establishment;

Line 739: hr_utility.set_message(800,'PER_52839_CAG_DEL_EST');

735: fetch csr_establishment into l_dummy;
736: if csr_establishment%found then
737: begin
738: close csr_establishment;
739: hr_utility.set_message(800,'PER_52839_CAG_DEL_EST');
740: hr_utility.raise_error;
741: end;
742: end if;
743: close csr_establishment;

Line 740: hr_utility.raise_error;

736: if csr_establishment%found then
737: begin
738: close csr_establishment;
739: hr_utility.set_message(800,'PER_52839_CAG_DEL_EST');
740: hr_utility.raise_error;
741: end;
742: end if;
743: close csr_establishment;
744: --

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

741: end;
742: end if;
743: close csr_establishment;
744: --
745: hr_utility.set_location(l_proc, 20);
746: --
747: -- If the collective agreements exits in per_cagr_grade_structures
748: --
749: open csr_grade;

Line 754: hr_utility.set_message(800,'PER_52840_CAG_DEL_GRADE');

750: fetch csr_grade into l_dummy;
751: if csr_grade%found then
752: begin
753: close csr_grade;
754: hr_utility.set_message(800,'PER_52840_CAG_DEL_GRADE');
755: hr_utility.raise_error;
756: end;
757: end if;
758: close csr_grade;

Line 755: hr_utility.raise_error;

751: if csr_grade%found then
752: begin
753: close csr_grade;
754: hr_utility.set_message(800,'PER_52840_CAG_DEL_GRADE');
755: hr_utility.raise_error;
756: end;
757: end if;
758: close csr_grade;
759: --

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

756: end;
757: end if;
758: close csr_grade;
759: --
760: hr_utility.set_location(l_proc,30);
761: --
762: OPEN csr_entitlement;
763: FETCH csr_entitlement INTO l_dummy;
764: --

Line 769: hr_utility.set_message(800,'HR_289398_ENTITLEMENTS_EXIST');

765: IF csr_entitlement%FOUND THEN
766: --
767: CLOSE csr_entitlement;
768: --
769: hr_utility.set_message(800,'HR_289398_ENTITLEMENTS_EXIST');
770: hr_utility.raise_error;
771: --
772: ELSE
773: --

Line 770: hr_utility.raise_error;

766: --
767: CLOSE csr_entitlement;
768: --
769: hr_utility.set_message(800,'HR_289398_ENTITLEMENTS_EXIST');
770: hr_utility.raise_error;
771: --
772: ELSE
773: --
774: CLOSE csr_entitlement;

Line 778: hr_utility.set_location(' Leaving:'||l_proc, 999);

774: CLOSE csr_entitlement;
775: --
776: END IF;
777: --
778: hr_utility.set_location(' Leaving:'||l_proc, 999);
779: --
780: End delete_validate;
781: --
782: --

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

801: --
802: l_legislation_code varchar2(150);
803: l_proc varchar2(72) := g_package||'return_legislation_code';
804: begin
805: hr_utility.set_location('Entering:'|| l_proc, 10);
806: --
807: -- Ensure that all the mandatory parameter are not null
808: --
809: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

816: -- call to this function. Just return the value in the global
817: -- variable.
818: --
819: l_legislation_code := g_legislation_code;
820: hr_utility.set_location(l_proc, 20);
821: else
822: --
823: -- The ID is different to the last call to this function
824: -- or this is the first call to this function.

Line 833: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

829: close csr_leg_code;
830: --
831: -- The primary key is invalid therefore we must error
832: --
833: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
834: hr_utility.raise_error;
835: end if;
836: --
837: close csr_leg_code;

Line 834: hr_utility.raise_error;

830: --
831: -- The primary key is invalid therefore we must error
832: --
833: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
834: hr_utility.raise_error;
835: end if;
836: --
837: close csr_leg_code;
838: hr_utility.set_location(' Leaving:'|| l_proc, 20);

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

834: hr_utility.raise_error;
835: end if;
836: --
837: close csr_leg_code;
838: hr_utility.set_location(' Leaving:'|| l_proc, 20);
839: --
840: g_collective_agreement_id := p_collective_agreement_id;
841: g_legislation_code := l_legislation_code;
842: end if;

Line 843: hr_utility.set_location(' Leaving:'|| l_proc, 25);

839: --
840: g_collective_agreement_id := p_collective_agreement_id;
841: g_legislation_code := l_legislation_code;
842: end if;
843: hr_utility.set_location(' Leaving:'|| l_proc, 25);
844: --
845: return l_legislation_code;
846: end return_legislation_code;
847: --