[Home] [Help]
42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ghr_dut_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_duty_station_id => p_duty_station_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_duty_station_id;
78: --
79: --
120: and effective_end_date;
121: --
122: Begin
123: --
124: hr_utility.set_location('Entering:'||l_proc, 5);
125: --
126: l_api_updating := ghr_dut_shd.api_updating
127: (p_effective_date => p_effective_date,
128: p_duty_station_id => p_duty_station_id,
155: AND
156: SUBSTR(p_duty_station_code,2,1) not in ('0','1','2','3','4','5','6','7','8','9')
157: ) AND
158: SUBSTR(p_duty_station_code,-3,3) <> '000' then
159: hr_utility.set_message(8301, 'GHR_38829_INVALID_DUTYSTN_CODE');
160: hr_utility.raise_error;
161: end if;
162:
163: end if;
156: SUBSTR(p_duty_station_code,2,1) not in ('0','1','2','3','4','5','6','7','8','9')
157: ) AND
158: SUBSTR(p_duty_station_code,-3,3) <> '000' then
159: hr_utility.set_message(8301, 'GHR_38829_INVALID_DUTYSTN_CODE');
160: hr_utility.raise_error;
161: end if;
162:
163: end if;
164: --
161: end if;
162:
163: end if;
164: --
165: hr_utility.set_location('Leaving:'||l_proc, 10);
166: --
167: End chk_duty_station_code;
168: --
169: ----------------------------------------------------------------------------
205: l_api_updating boolean;
206: --
207: Begin
208: --
209: hr_utility.set_location('Entering:'||l_proc, 5);
210: --
211: l_api_updating := ghr_dut_shd.api_updating
212: (p_effective_date => p_effective_date,
213: p_duty_station_id => p_duty_station_id,
228: end if;
229:
230: end if;
231: --
232: hr_utility.set_location('Leaving:'||l_proc, 10);
233: --
234: End chk_duty_station_flag;
235: --
236: -- --------------------------------------------------------------------------
321: l_integrity_error Exception;
322: l_table_name all_tables.table_name%TYPE;
323: --
324: Begin
325: hr_utility.set_location('Entering:'||l_proc, 5);
326: --
327: -- Ensure that the p_datetrack_mode argument is not null
328: --
329: hr_api.mandatory_arg_error
350: --
351: --
352: End If;
353: --
354: hr_utility.set_location(' Leaving:'||l_proc, 10);
355: Exception
356: When Others Then
357: --
358: -- An unhandled or unexpected error has occurred which
409: l_rows_exist Exception;
410: l_table_name all_tables.table_name%TYPE;
411: --
412: Begin
413: hr_utility.set_location('Entering:'||l_proc, 5);
414: --
415: -- Ensure that the p_datetrack_mode argument is not null
416: --
417: hr_api.mandatory_arg_error
443: p_argument_value => p_duty_station_id);
444: --
445: End If;
446: --
447: hr_utility.set_location(' Leaving:'||l_proc, 10);
448: Exception
449: When l_rows_exist Then
450: --
451: -- A referential integrity check was violated therefore
476: --
477: l_proc varchar2(72) := g_package||'insert_validate';
478: --
479: Begin
480: hr_utility.set_location('Entering:'||l_proc, 5);
481: --
482: chk_duty_station_id
483: (p_duty_station_id => p_rec.duty_station_id,
484: p_effective_date => p_effective_date,
498: p_object_version_number => p_rec.object_version_number);
499: --
500: -- hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
501: --
502: hr_utility.set_location(' Leaving:'||l_proc, 10);
503: End insert_validate;
504: --
505: -- ----------------------------------------------------------------------------
506: -- |---------------------------< update_validate >----------------------------|
514: --
515: l_proc varchar2(72) := g_package||'update_validate';
516: --
517: Begin
518: hr_utility.set_location('Entering:'||l_proc, 5);
519: --
520: -- Call all supporting business operations
521: --
522: chk_duty_station_id
535: --
536: dt_update_validate (p_datetrack_mode => p_datetrack_mode,
537: p_validation_start_date => p_validation_start_date,
538: p_validation_end_date => p_validation_end_date);
539: hr_utility.set_location(' Leaving:'||l_proc, 10);
540: End update_validate;
541: --
542: -- ----------------------------------------------------------------------------
543: -- |---------------------------< delete_validate >----------------------------|
551: --
552: l_proc varchar2(72) := g_package||'delete_validate';
553: --
554: Begin
555: hr_utility.set_location('Entering:'||l_proc, 5);
556: --
557: -- Call all supporting business operations
558: --
559: chk_active_assignments(p_duty_station_id => p_rec.duty_station_id,
564: p_validation_start_date => p_validation_start_date,
565: p_validation_end_date => p_validation_end_date,
566: p_duty_station_id => p_rec.duty_station_id);
567: --
568: hr_utility.set_location(' Leaving:'||l_proc, 10);
569: End delete_validate;
570: --
571: --
572: -- ---------------------------------------------------------------------------
582: l_proc varchar2(72) := g_package||'return_legislation_code';
583: --
584: begin
585: --
586: hr_utility.set_location('Entering:'|| l_proc, 10);
587: --
588: l_legislation_code := 'US';
589: --
590: hr_utility.set_location(' Leaving:'|| l_proc, 20);
586: hr_utility.set_location('Entering:'|| l_proc, 10);
587: --
588: l_legislation_code := 'US';
589: --
590: hr_utility.set_location(' Leaving:'|| l_proc, 20);
591: --
592: return l_legislation_code;
593: --
594: end return_legislation_code;