[Home] [Help]
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_asg_bus1.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- The following two global variables are only to be
12: -- used by the return_legislation_code function.
13: --
41: l_proc varchar2(72) := g_package||'set_security_group_id';
42: --
43: begin
44: if g_debug then
45: hr_utility.set_location('Entering:'|| l_proc, 10);
46: end if;
47: --
48: -- Ensure that all the mandatory parameter are not null
49: --
57: close csr_sec_grp;
58: --
59: -- The primary key is invalid therefore we must error
60: --
61: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
62: hr_utility.raise_error;
63: /*hr_multi_message.add
64: (p_associated_column1
65: => nvl(p_associated_column1,'ASSIGNMENT_ID')
58: --
59: -- The primary key is invalid therefore we must error
60: --
61: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
62: hr_utility.raise_error;
63: /*hr_multi_message.add
64: (p_associated_column1
65: => nvl(p_associated_column1,'ASSIGNMENT_ID')
66: ); */
79: hr_api.set_legislation_context(l_legislation_code);
80: --
81: --
82: if g_debug then
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: end if;
85: --
86: end set_security_group_id;
87: --
119: l_proc varchar2(72) := g_package||'check_non_updateable_args';
120: --
121: Begin
122: if g_debug then
123: hr_utility.set_location('Entering:'||l_proc, 5);
124: end if;
125: --
126: -- Only proceed with validation if a row exists for
127: -- the current record in the HR Schema
130: (p_assignment_id => p_rec.assignment_id
131: ,p_object_version_number => p_rec.object_version_number
132: ,p_effective_date => p_effective_date
133: ) then
134: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
135: hr_utility.set_message_token('PROCEDURE', l_proc);
136: hr_utility.set_message_token('STEP', '5');
137: end if;
138: --
131: ,p_object_version_number => p_rec.object_version_number
132: ,p_effective_date => p_effective_date
133: ) then
134: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
135: hr_utility.set_message_token('PROCEDURE', l_proc);
136: hr_utility.set_message_token('STEP', '5');
137: end if;
138: --
139: if g_debug then
132: ,p_effective_date => p_effective_date
133: ) then
134: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
135: hr_utility.set_message_token('PROCEDURE', l_proc);
136: hr_utility.set_message_token('STEP', '5');
137: end if;
138: --
139: if g_debug then
140: hr_utility.set_location(l_proc, 6);
136: hr_utility.set_message_token('STEP', '5');
137: end if;
138: --
139: if g_debug then
140: hr_utility.set_location(l_proc, 6);
141: end if;
142: --
143: if nvl(p_rec.business_group_id, hr_api.g_number) <>
144: nvl(per_asg_shd.g_old_rec.business_group_id, hr_api.g_number) then
148: ,p_base_table => per_asg_shd.g_tab_nam
149: );
150: end if;
151: if g_debug then
152: hr_utility.set_location(l_proc, 7);
153: end if;
154: --
155: if p_rec.assignment_id <> per_asg_shd.g_old_rec.assignment_id then
156: hr_api.argument_changed_error
159: ,p_base_table => per_asg_shd.g_tab_nam
160: );
161: end if;
162: if g_debug then
163: hr_utility.set_location(l_proc, 8);
164: end if;
165: --
166: if p_rec.person_id <> per_asg_shd.g_old_rec.person_id then
167: hr_api.argument_changed_error
170: ,p_base_table => per_asg_shd.g_tab_nam
171: );
172: end if;
173: if g_debug then
174: hr_utility.set_location(l_proc, 9);
175: end if;
176: --
177: if p_rec.assignment_sequence <> per_asg_shd.g_old_rec.assignment_sequence then
178: hr_api.argument_changed_error
182: );
183: end if;
184: --
185: if g_debug then
186: hr_utility.set_location(l_proc, 10);
187: end if;
188: --
189: -- Bug fix 3101091 starts. Commenting out the check that makes vendor_id
190: -- non updatable
198: end if; */
199: -- End fix 3101091.
200: --
201: if g_debug then
202: hr_utility.set_location(' Leaving:'||l_proc, 999);
203: end if;
204: --
205: end check_non_updateable_args;
206: --
252: --
253: Begin
254: if g_debug then
255: l_proc:= g_package||'delete_validate';
256: hr_utility.set_location('Entering:'||l_proc, 5);
257: end if;
258: --
259: -- 4888485 starts here
260: --
260: --
261: -- Bug 5012157 : Commented out BEN type assgt checks and moved the logic to API.
262: /* if per_asg_shd.g_old_rec.assignment_type = 'B' then
263: if g_debug then
264: hr_utility.set_location('Selected assignment is of type Benifits', 10);
265: end if;
266: --
267: fnd_message.set_name('PER', 'HR_449746_DEL_BEN_ASG');
268: fnd_message.raise_error;
268: fnd_message.raise_error;
269: end if;
270: -- */
271: if g_debug then
272: hr_utility.set_location('Before calling pre_delete checks ', 20);
273: end if;
274: --
275: -- Added IF Condition for 5012244.
276: if (p_datetrack_mode <> 'DELETE') THEN
315: ,p_effective_date => p_effective_date
316: );
317: --
318: if g_debug then
319: hr_utility.set_location(l_proc, 6);
320: end if;
321: --
322: per_asg_bus2.chk_ref_int_del
323: (p_assignment_id => p_rec.assignment_id
326: ,p_datetrack_mode => p_datetrack_mode
327: );
328: --
329: if g_debug then
330: hr_utility.set_location(l_proc, 7);
331: end if;
332: --
333: if g_debug then
334: hr_utility.set_location(l_proc, 8);
330: hr_utility.set_location(l_proc, 7);
331: end if;
332: --
333: if g_debug then
334: hr_utility.set_location(l_proc, 8);
335: end if;
336: --
337: per_asg_bus1.chk_future_primary
338: (p_assignment_id => p_rec.assignment_id
342:
343: );
344: --
345: if g_debug then
346: hr_utility.set_location(l_proc, 9);
347: end if;
348: --
349: per_asg_bus2.chk_term_status
350: (p_assignment_id => p_rec.assignment_id
352: ,p_validation_start_date => p_validation_start_date
353: );
354: --
355: if g_debug then
356: hr_utility.set_location(l_proc, 10);
357: end if;
358: --
359: -- Start changes for bug 8687386
360: --
369: ,p_validation_end_date => p_validation_end_date
370: ,p_datetrack_mode => p_datetrack_mode
371: );
372: if g_debug then
373: hr_utility.set_location(l_proc, 11);
374: end if;
375: -- End changes for bug 8687386
376: --
377: per_asg_bus1.dt_delete_validate
381: ,p_validation_start_date => p_validation_start_date
382: ,p_validation_end_date => p_validation_end_date
383: );
384: if g_debug then
385: hr_utility.set_location(l_proc, 20);
386: end if;
387: --
388: per_asg_bus2.chk_payroll_id
389: (p_assignment_id => p_rec.assignment_id
398: ,p_payroll_id_updated => l_temp_flag
399: ,p_object_version_number => p_rec.object_version_number
400: );
401: if g_debug then
402: hr_utility.set_location(l_proc, 30);
403: end if;
404: --
405: per_asg_bus1.chk_del_organization_id
406: (p_assignment_id => p_rec.assignment_id
411: ,p_org_now_no_manager_warning => l_org_now_no_manager_warning
412: );
413: --
414: if g_debug then
415: hr_utility.set_location(l_proc, 40);
416: end if;
417: --
418: per_pqh_shr.per_asg_bus('DELETE_VALIDATE',
419: p_rec,
422: p_validation_end_date,
423: p_datetrack_mode);
424: p_org_now_no_manager_warning := l_org_now_no_manager_warning;
425: if g_debug then
426: hr_utility.set_location(' Leaving:'||l_proc, 11);
427: end if;
428: End delete_validate;
429: --
430: -- ----------------------------------------------------------------------------
482:
483: --
484: Begin
485: if g_debug then
486: hr_utility.set_location('Entering:'||l_proc, 5);
487: end if;
488: --
489: -- Ensure that the p_datetrack_mode argument is not null
490: --
487: end if;
488: --
489: -- Ensure that the p_datetrack_mode argument is not null
490: --
491: hr_utility.set_location(l_proc,10);
492:
493: hr_api.mandatory_arg_error
494: (p_api_name => l_proc,
495: p_argument => 'datetrack_mode',
497: --
498: -- Only perform the validation if the datetrack mode is either
499: -- DELETE or ZAP
500: --
501: hr_utility.set_location(l_proc,20);
502:
503: If (p_datetrack_mode = 'DELETE' or
504: p_datetrack_mode = 'ZAP') then
505: --
505: --
506: --
507: -- Ensure the arguments are not null
508: --
509: hr_utility.set_location(l_proc,30);
510:
511: hr_api.mandatory_arg_error
512: (p_api_name => l_proc,
513: p_argument => 'validation_start_date',
512: (p_api_name => l_proc,
513: p_argument => 'validation_start_date',
514: p_argument_value => p_validation_start_date);
515: --
516: hr_utility.set_location(l_proc,40);
517:
518: hr_api.mandatory_arg_error
519: (p_api_name => l_proc,
520: p_argument => 'validation_end_date',
519: (p_api_name => l_proc,
520: p_argument => 'validation_end_date',
521: p_argument_value => p_validation_end_date);
522: --
523: hr_utility.set_location(l_proc,50);
524:
525: hr_api.mandatory_arg_error
526: (p_api_name => l_proc,
527: p_argument => 'assignment_id',
526: (p_api_name => l_proc,
527: p_argument => 'assignment_id',
528: p_argument_value => p_assignment_id);
529: --
530: hr_utility.set_location(l_proc,60);
531:
532: If (dt_api.rows_exist
533: (p_base_table_name => 'pay_cost_allocations_f',
534: p_base_key_column => 'assignment_id',
537: p_to_date => p_validation_end_date)) Then
538: l_table_name := 'cost allocations';
539: Raise l_rows_exist;
540: End If;
541: hr_utility.set_location(l_proc,70);
542:
543: If (dt_api.rows_exist
544: (p_base_table_name => 'pay_assignment_link_usages_f',
545: p_base_key_column => 'assignment_id',
549: l_table_name := 'assignment link usages';
550: Raise l_rows_exist;
551: End If;
552: --
553: hr_utility.set_location(l_proc,80);
554:
555: If (dt_api.rows_exist
556: (p_base_table_name => 'pay_personal_payment_methods_f',
557: p_base_key_column => 'assignment_id',
561: l_table_name := 'personal payment methods';
562: Raise l_rows_exist;
563: End If;
564: --
565: hr_utility.set_location(l_proc,90);
566:
567: If (dt_api.rows_exist
568: (p_base_table_name => 'per_spinal_point_placements_f',
569: p_base_key_column => 'assignment_id',
573: l_table_name := 'spinal point placements';
574: Raise l_rows_exist;
575: End If;
576: --
577: hr_utility.set_location(l_proc,100);
578:
579: If (dt_api.rows_exist
580: (p_base_table_name => 'pay_element_entries_f',
581: p_base_key_column => 'assignment_id',
585: l_table_name := 'element entries';
586: Raise l_rows_exist;
587: End If;
588: --
589: hr_utility.set_location(l_proc,110);
590: OPEN c_business_group_legislation; -- added for bug 6917434
591: FETCH c_business_group_legislation INTO l_legislation_code;
592: CLOSE c_business_group_legislation;
593: hr_utility.set_location(l_proc,120);
589: hr_utility.set_location(l_proc,110);
590: OPEN c_business_group_legislation; -- added for bug 6917434
591: FETCH c_business_group_legislation INTO l_legislation_code;
592: CLOSE c_business_group_legislation;
593: hr_utility.set_location(l_proc,120);
594: IF l_legislation_code = 'US' THEN
595: hr_utility.set_location(l_proc,130);
596:
597: If (dt_api.rows_exist
591: FETCH c_business_group_legislation INTO l_legislation_code;
592: CLOSE c_business_group_legislation;
593: hr_utility.set_location(l_proc,120);
594: IF l_legislation_code = 'US' THEN
595: hr_utility.set_location(l_proc,130);
596:
597: If (dt_api.rows_exist
598: (p_base_table_name => 'pay_us_emp_fed_tax_rules_f',
599: p_base_key_column => 'assignment_id',
603: l_table_name := 'us emp fed tax rules';
604: Raise l_rows_exist;
605: End If;
606: --
607: hr_utility.set_location(l_proc,140);
608:
609: If (dt_api.rows_exist
610: (p_base_table_name => 'pay_us_emp_county_tax_rules_f',
611: p_base_key_column => 'assignment_id',
615: l_table_name := 'us emp county tax rules';
616: Raise l_rows_exist;
617: End If;
618: --
619: hr_utility.set_location(l_proc,150);
620:
621: If (dt_api.rows_exist
622: (p_base_table_name => 'pay_us_emp_state_tax_rules_f',
623: p_base_key_column => 'assignment_id',
627: l_table_name := 'us emp state tax rules';
628: Raise l_rows_exist;
629: End If;
630: --
631: hr_utility.set_location(l_proc,160);
632:
633: If (dt_api.rows_exist
634: (p_base_table_name => 'pay_us_emp_city_tax_rules_f',
635: p_base_key_column => 'assignment_id',
639: l_table_name := 'us emp city tax rules';
640: Raise l_rows_exist;
641: End If;
642: --
643: hr_utility.set_location(l_proc,170);
644: END IF ; -- l_business_group = 'US' condition
645: -- added for Bug 6917434
646: --
647: End If;
644: END IF ; -- l_business_group = 'US' condition
645: -- added for Bug 6917434
646: --
647: End If;
648: hr_utility.set_location(l_proc,180);
649: --
650: if g_debug then
651: hr_utility.set_location(' Leaving:'||l_proc, 10);
652: end if;
647: End If;
648: hr_utility.set_location(l_proc,180);
649: --
650: if g_debug then
651: hr_utility.set_location(' Leaving:'||l_proc, 10);
652: end if;
653: Exception
654: WHEN l_rows_exist THEN -- added for bug 6917434
655: -- child rows exist for the assignment to be deleted.
653: Exception
654: WHEN l_rows_exist THEN -- added for bug 6917434
655: -- child rows exist for the assignment to be deleted.
656: -- this is not allowed. Throw an error
657: hr_utility.set_message(800, 'HR_7215_DT_CHILD_EXISTS');
658: hr_utility.set_message_token('TABLE_NAME',l_table_name);
659: hr_utility.raise_error;
660:
661: When Others Then
654: WHEN l_rows_exist THEN -- added for bug 6917434
655: -- child rows exist for the assignment to be deleted.
656: -- this is not allowed. Throw an error
657: hr_utility.set_message(800, 'HR_7215_DT_CHILD_EXISTS');
658: hr_utility.set_message_token('TABLE_NAME',l_table_name);
659: hr_utility.raise_error;
660:
661: When Others Then
662: --
655: -- child rows exist for the assignment to be deleted.
656: -- this is not allowed. Throw an error
657: hr_utility.set_message(800, 'HR_7215_DT_CHILD_EXISTS');
658: hr_utility.set_message_token('TABLE_NAME',l_table_name);
659: hr_utility.raise_error;
660:
661: When Others Then
662: --
663: -- An unhandled or unexpected error has occurred which
662: --
663: -- An unhandled or unexpected error has occurred which
664: -- we must report
665: --
666: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
667: hr_utility.set_message_token('PROCEDURE', l_proc);
668: hr_utility.set_message_token('STEP','15');
669: hr_utility.raise_error;
670: End dt_delete_validate;
663: -- An unhandled or unexpected error has occurred which
664: -- we must report
665: --
666: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
667: hr_utility.set_message_token('PROCEDURE', l_proc);
668: hr_utility.set_message_token('STEP','15');
669: hr_utility.raise_error;
670: End dt_delete_validate;
671: --
664: -- we must report
665: --
666: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
667: hr_utility.set_message_token('PROCEDURE', l_proc);
668: hr_utility.set_message_token('STEP','15');
669: hr_utility.raise_error;
670: End dt_delete_validate;
671: --
672: -- ----------------------------------------------------------------------------
665: --
666: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
667: hr_utility.set_message_token('PROCEDURE', l_proc);
668: hr_utility.set_message_token('STEP','15');
669: hr_utility.raise_error;
670: End dt_delete_validate;
671: --
672: -- ----------------------------------------------------------------------------
673: -- |--------------------------< dt_update_validate >--------------------------|
710: l_table_name all_tables.table_name%TYPE;
711: --
712: Begin
713: if g_debug then
714: hr_utility.set_location('Entering:'||l_proc, 5);
715: end if;
716: --
717: -- Ensure that the p_datetrack_mode argument is not null
718: --
763: Raise l_integrity_error;
764: End If;
765: --
766: if g_debug then
767: hr_utility.set_location(' Leaving:'||l_proc, 10);
768: end if;
769: Exception
770: When Others Then
771: --
771: --
772: -- An unhandled or unexpected error has occurred which
773: -- we must report
774: --
775: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
776: hr_utility.set_message_token('PROCEDURE', l_proc);
777: hr_utility.set_message_token('STEP','15');
778: hr_utility.raise_error;
779: End dt_update_validate;
772: -- An unhandled or unexpected error has occurred which
773: -- we must report
774: --
775: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
776: hr_utility.set_message_token('PROCEDURE', l_proc);
777: hr_utility.set_message_token('STEP','15');
778: hr_utility.raise_error;
779: End dt_update_validate;
780: -- -----------------------------------------------------------------------
773: -- we must report
774: --
775: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
776: hr_utility.set_message_token('PROCEDURE', l_proc);
777: hr_utility.set_message_token('STEP','15');
778: hr_utility.raise_error;
779: End dt_update_validate;
780: -- -----------------------------------------------------------------------
781: -- |------------------------------< chk_df >-----------------------------|
774: --
775: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
776: hr_utility.set_message_token('PROCEDURE', l_proc);
777: hr_utility.set_message_token('STEP','15');
778: hr_utility.raise_error;
779: End dt_update_validate;
780: -- -----------------------------------------------------------------------
781: -- |------------------------------< chk_df >-----------------------------|
782: -- -----------------------------------------------------------------------
814: begin
815: --
816: if g_debug then
817: l_proc := g_package||'chk_df';
818: hr_utility.set_location('Entering:'||l_proc, 10);
819: end if;
820: --
821: -- if inserting and not required to validate flex data
822: -- then ensure all flex data passed is null
856: (p_rec.ass_attribute28 is null) and
857: (p_rec.ass_attribute29 is null) and
858: (p_rec.ass_attribute30 is null) ) )
859: then
860: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
861: hr_utility.set_message_token('PROCEDURE','chk_df');
862: hr_utility.set_message_token('STEP',1);
863: hr_utility.raise_error;
864: End if;
857: (p_rec.ass_attribute29 is null) and
858: (p_rec.ass_attribute30 is null) ) )
859: then
860: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
861: hr_utility.set_message_token('PROCEDURE','chk_df');
862: hr_utility.set_message_token('STEP',1);
863: hr_utility.raise_error;
864: End if;
865: End if;
858: (p_rec.ass_attribute30 is null) ) )
859: then
860: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
861: hr_utility.set_message_token('PROCEDURE','chk_df');
862: hr_utility.set_message_token('STEP',1);
863: hr_utility.raise_error;
864: End if;
865: End if;
866: --
859: then
860: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
861: hr_utility.set_message_token('PROCEDURE','chk_df');
862: hr_utility.set_message_token('STEP',1);
863: hr_utility.raise_error;
864: End if;
865: End if;
866: --
867: --
1046: );
1047: End if;
1048: --
1049: if g_debug then
1050: hr_utility.set_location(' Leaving:'||l_proc, 20);
1051: end if;
1052: --
1053: end chk_df;
1054: --
1076: --
1077: Begin
1078: if g_debug then
1079: l_proc := g_package||'insert_validate';
1080: hr_utility.set_location('Entering: '||l_proc, 10);
1081: end if;
1082: --
1083: -- Validate Important Attributes
1084: --
1098: --
1099: hr_multi_message.end_validation_set;
1100: --
1101: if g_debug then
1102: hr_utility.set_location(l_proc, 15);
1103: end if;
1104: --
1105: -- per_asg_bus2.chk_title (p_title => p_rec.title);
1106: --
1111: ,p_effective_date => p_effective_date
1112: ,p_assignment_type => p_rec.assignment_type
1113: );
1114: if g_debug then
1115: hr_utility.set_location(l_proc, 22);
1116: end if;
1117: --
1118: per_asg_bus2.chk_time_finish_formatted --#2734822
1119: (p_time_normal_finish => p_rec.time_normal_finish
1118: per_asg_bus2.chk_time_finish_formatted --#2734822
1119: (p_time_normal_finish => p_rec.time_normal_finish
1120: );
1121: if g_debug then
1122: hr_utility.set_location(l_proc, 25);
1123: end if;
1124: --
1125: per_asg_bus2.chk_time_start_formatted --#2734822
1126: (p_time_normal_start => p_rec.time_normal_start
1125: per_asg_bus2.chk_time_start_formatted --#2734822
1126: (p_time_normal_start => p_rec.time_normal_start
1127: );
1128: if g_debug then
1129: hr_utility.set_location(l_proc, 27);
1130: end if;
1131: --
1132: per_asg_bus1.chk_assignment_type
1133: (p_assignment_id => p_rec.assignment_id
1137: ,p_object_version_number => p_rec.object_version_number
1138: ,p_validation_start_date => p_validation_start_date
1139: );
1140: if g_debug then
1141: hr_utility.set_location(l_proc, 30);
1142: end if;
1143: --
1144: hr_multi_message.end_validation_set;
1145: --
1151: ,p_validation_end_date => p_validation_end_date
1152: ,p_object_version_number => p_rec.object_version_number
1153: );
1154: if g_debug then
1155: hr_utility.set_location(l_proc, 40);
1156: end if;
1157: --
1158: per_asg_bus2.chk_probation_period
1159: (p_assignment_id => p_rec.assignment_id
1161: ,p_effective_date => p_effective_date
1162: ,p_object_version_number => p_rec.object_version_number
1163: );
1164: if g_debug then
1165: hr_utility.set_location(l_proc, 50);
1166: end if;
1167: --
1168: per_asg_bus2.chk_prob_unit_prob_period
1169: (p_assignment_id => p_rec.assignment_id
1172: ,p_effective_date => p_effective_date
1173: ,p_object_version_number => p_rec.object_version_number
1174: );
1175: if g_debug then
1176: hr_utility.set_location(l_proc, 60);
1177: end if;
1178: --- Fix For Bug # 7481310 Starts ---
1179: -- if p_rec.assignment_type = 'O' then -- fix for the bug#11905251
1180: hr_utility.set_location(l_proc || 'This is an Offer Assignment', 60);
1176: hr_utility.set_location(l_proc, 60);
1177: end if;
1178: --- Fix For Bug # 7481310 Starts ---
1179: -- if p_rec.assignment_type = 'O' then -- fix for the bug#11905251
1180: hr_utility.set_location(l_proc || 'This is an Offer Assignment', 60);
1181:
1182: -- if p_rec.vacancy_id is not null then -- fix for the bug#11905251
1183:
1184: if p_rec.assignment_type = 'O' and p_rec.vacancy_id is not null then
1222: );
1223: end if;
1224: --- Fix For Bug # 7481310 Ends ---
1225: if g_debug then
1226: hr_utility.set_location(l_proc, 70);
1227: end if;
1228: --
1229: per_asg_bus1.chk_date_probation_end
1230: (p_assignment_id => p_rec.assignment_id
1236: ,p_effective_date => p_effective_date
1237: ,p_object_version_number => p_rec.object_version_number
1238: );
1239: if g_debug then
1240: hr_utility.set_location(l_proc, 80);
1241: end if;
1242: --
1243: per_asg_bus2.chk_internal_address_line
1244: (p_assignment_id => p_rec.assignment_id
1247: ,p_effective_date => p_effective_date
1248: ,p_object_version_number => p_rec.object_version_number
1249: );
1250: if g_debug then
1251: hr_utility.set_location(l_proc, 90);
1252: end if;
1253: --
1254: per_asg_bus1.chk_change_reason
1255: (p_assignment_id => p_rec.assignment_id
1260: ,p_validation_end_date => p_validation_end_date
1261: ,p_object_version_number => p_rec.object_version_number
1262: );
1263: if g_debug then
1264: hr_utility.set_location(l_proc, 100);
1265: end if;
1266: --
1267: per_asg_bus1.chk_default_code_comb_id
1268: (p_assignment_id => p_rec.assignment_id
1272: ,p_validation_start_date => p_validation_start_date
1273: ,p_object_version_number => p_rec.object_version_number
1274: );
1275: if g_debug then
1276: hr_utility.set_location(l_proc, 110);
1277: end if;
1278: --
1279: per_asg_bus1.chk_employment_category
1280: (p_assignment_id => p_rec.assignment_id
1285: ,p_validation_end_date => p_validation_end_date
1286: ,p_object_version_number => p_rec.object_version_number
1287: );
1288: if g_debug then
1289: hr_utility.set_location(l_proc, 120);
1290: end if;
1291: --
1292: per_asg_bus2.chk_sal_review_period
1293: (p_assignment_id => p_rec.assignment_id
1296: ,p_effective_date => p_effective_date
1297: ,p_object_version_number => p_rec.object_version_number
1298: );
1299: if g_debug then
1300: hr_utility.set_location(l_proc, 130);
1301: end if;
1302: --
1303: per_asg_bus2.chk_sal_review_period_freq
1304: (p_assignment_id => p_rec.assignment_id
1309: ,p_validation_end_date => p_validation_end_date
1310: ,p_object_version_number => p_rec.object_version_number
1311: );
1312: if g_debug then
1313: hr_utility.set_location(l_proc, 140);
1314: end if;
1315: --
1316: per_asg_bus2.chk_sal_rp_freq_sal_rp
1317: (p_assignment_id => p_rec.assignment_id
1320: ,p_effective_date => p_effective_date
1321: ,p_object_version_number => p_rec.object_version_number
1322: );
1323: if g_debug then
1324: hr_utility.set_location(l_proc, 150);
1325: end if;
1326: --
1327: per_asg_bus2.chk_perf_review_period
1328: (p_assignment_id => p_rec.assignment_id
1331: ,p_effective_date => p_effective_date
1332: ,p_object_version_number => p_rec.object_version_number
1333: );
1334: if g_debug then
1335: hr_utility.set_location(l_proc, 160);
1336: end if;
1337: --
1338: per_asg_bus2.chk_perf_review_period_freq
1339: (p_assignment_id => p_rec.assignment_id
1344: ,p_validation_end_date => p_validation_end_date
1345: ,p_object_version_number => p_rec.object_version_number
1346: );
1347: if g_debug then
1348: hr_utility.set_location(l_proc, 170);
1349: end if;
1350: --
1351: per_asg_bus2.chk_perf_rp_freq_perf_rp
1352: (p_assignment_id => p_rec.assignment_id
1355: ,p_effective_date => p_effective_date
1356: ,p_object_version_number => p_rec.object_version_number
1357: );
1358: if g_debug then
1359: hr_utility.set_location(l_proc, 180);
1360: end if;
1361: --
1362: per_asg_bus1.chk_frequency
1363: (p_assignment_id => p_rec.assignment_id
1367: ,p_validation_end_date => p_validation_end_date
1368: ,p_object_version_number => p_rec.object_version_number
1369: );
1370: if g_debug then
1371: hr_utility.set_location(l_proc, 190);
1372: end if;
1373: --
1374: per_asg_bus1.chk_frequency_normal_hours
1375: (p_assignment_id => p_rec.assignment_id
1378: ,p_effective_date => p_effective_date
1379: ,p_object_version_number => p_rec.object_version_number
1380: );
1381: if g_debug then
1382: hr_utility.set_location(l_proc, 200);
1383: end if;
1384: --
1385: per_asg_bus2.chk_set_of_books_id
1386: (p_assignment_id => p_rec.assignment_id
1390: ,p_effective_date => p_effective_date
1391: ,p_object_version_number => p_rec.object_version_number
1392: );
1393: if g_debug then
1394: hr_utility.set_location(l_proc, 210);
1395: end if;
1396: --
1397: per_asg_bus2.chk_source_organization_id
1398: (p_assignment_id => p_rec.assignment_id
1404: ,p_validation_start_date => p_validation_start_date
1405: ,p_validation_end_date => p_validation_end_date
1406: );
1407: if g_debug then
1408: hr_utility.set_location(l_proc, 230);
1409: end if;
1410: --
1411: per_asg_bus2.chk_soft_coding_keyflex_id
1412: (p_assignment_id => p_rec.assignment_id
1418: ,p_payroll_id => p_rec.payroll_id
1419: ,p_business_group_id => p_rec.business_group_id
1420: );
1421: if g_debug then
1422: hr_utility.set_location(l_proc, 240);
1423: end if;
1424: --
1425: per_asg_bus2.chk_pay_basis_id
1426: (p_assignment_id => p_rec.assignment_id
1431: ,p_validation_start_date => p_validation_start_date
1432: ,p_object_version_number => p_rec.object_version_number
1433: );
1434: if g_debug then
1435: hr_utility.set_location(l_proc, 250);
1436: end if;
1437: --
1438: per_asg_bus2.chk_recruitment_activity_id
1439: (p_assignment_id => p_rec.assignment_id
1445: ,p_validation_start_date => p_validation_start_date
1446: ,p_validation_end_date => p_validation_end_date
1447: );
1448: if g_debug then
1449: hr_utility.set_location(l_proc, 260);
1450: end if;
1451: --
1452: per_asg_bus2.chk_vacancy_id
1453: (p_assignment_id => p_rec.assignment_id
1459: ,p_validation_start_date => p_validation_start_date
1460: ,p_validation_end_date => p_validation_end_date
1461: );
1462: if g_debug then
1463: hr_utility.set_location(l_proc, 270);
1464: end if;
1465: --
1466: per_asg_bus1.chk_location_id
1467: (p_assignment_id => p_rec.assignment_id
1474: ,p_object_version_number => p_rec.object_version_number
1475: ,p_business_group_id => p_rec.business_group_id --added for bug 11063182
1476: );
1477: if g_debug then
1478: hr_utility.set_location(l_proc, 280);
1479: end if;
1480: --
1481: per_asg_bus2.chk_people_group_id
1482: (p_assignment_id => p_rec.assignment_id
1489: ,p_effective_date => p_effective_date
1490: ,p_object_version_number => p_rec.object_version_number
1491: );
1492: if g_debug then
1493: hr_utility.set_location(l_proc, 290);
1494: end if;
1495: --
1496: if g_debug then
1497: hr_utility.set_location(p_validation_start_date, 290);
1493: hr_utility.set_location(l_proc, 290);
1494: end if;
1495: --
1496: if g_debug then
1497: hr_utility.set_location(p_validation_start_date, 290);
1498: end if;
1499: if g_debug then
1500: hr_utility.set_location(p_validation_end_date, 290);
1501: end if;
1496: if g_debug then
1497: hr_utility.set_location(p_validation_start_date, 290);
1498: end if;
1499: if g_debug then
1500: hr_utility.set_location(p_validation_end_date, 290);
1501: end if;
1502: per_asg_bus2.chk_position_id
1503: (p_assignment_id => p_rec.assignment_id
1504: ,p_position_id => p_rec.position_id
1510: ,p_effective_date => p_effective_date
1511: ,p_object_version_number => p_rec.object_version_number
1512: );
1513: if g_debug then
1514: hr_utility.set_location(l_proc, 300);
1515: end if;
1516: -- fix for 6331872 starts here
1517: per_asg_bus1.chk_frozen_single_pos
1518: (p_assignment_id => p_rec.assignment_id
1522: ,p_assignment_type => p_rec.assignment_type -- parameter added for tbe bug#7685281
1523: );
1524:
1525: if g_debug then
1526: hr_utility.set_location(p_validation_end_date, 305);
1527: end if;
1528: -- fix for 6331872 ends here
1529: per_asg_bus1.chk_job_id
1530: (p_assignment_id => p_rec.assignment_id
1537: ,p_validation_end_date => p_validation_end_date
1538: ,p_object_version_number => p_rec.object_version_number
1539: );
1540: if g_debug then
1541: hr_utility.set_location(l_proc, 310);
1542: end if;
1543: --
1544: per_asg_bus2.chk_position_id_job_id
1545: (p_assignment_id => p_rec.assignment_id
1550: ,p_effective_date => p_effective_date
1551: ,p_object_version_number => p_rec.object_version_number
1552: );
1553: if g_debug then
1554: hr_utility.set_location(l_proc, 320);
1555: end if;
1556: --
1557: per_asg_bus1.chk_grade_id
1558: (p_assignment_id => p_rec.assignment_id
1566: ,p_validation_end_date => p_validation_end_date
1567: ,p_object_version_number => p_rec.object_version_number
1568: );
1569: if g_debug then
1570: hr_utility.set_location(l_proc, 330);
1571: end if;
1572: --
1573: per_asg_bus2.chk_special_ceiling_step_id
1574: (p_assignment_id => p_rec.assignment_id
1581: ,p_effective_date => p_effective_date
1582: ,p_object_version_number => p_rec.object_version_number
1583: );
1584: if g_debug then
1585: hr_utility.set_location(l_proc, 340);
1586: end if;
1587: --
1588: per_asg_bus2.chk_position_id_grade_id
1589: (p_assignment_id => p_rec.assignment_id
1595: ,p_object_version_number => p_rec.object_version_number
1596: ,p_inv_pos_grade_warning => l_inv_pos_grade_warning
1597: );
1598: if g_debug then
1599: hr_utility.set_location(l_proc, 350);
1600: end if;
1601: --
1602: per_asg_bus1.chk_job_id_grade_id
1603: (p_assignment_id => p_rec.assignment_id
1609: ,p_object_version_number => p_rec.object_version_number
1610: ,p_inv_job_grade_warning => l_inv_job_grade_warning
1611: );
1612: if g_debug then
1613: hr_utility.set_location(l_proc, 360);
1614: end if;
1615: --
1616: per_asg_bus2.chk_person_id
1617: (p_person_id => p_rec.person_id
1618: ,p_business_group_id => p_rec.business_group_id
1619: ,p_effective_date => p_effective_date
1620: );
1621: if g_debug then
1622: hr_utility.set_location(l_proc, 370);
1623: end if;
1624: --
1625: per_asg_bus2.chk_supervisor_id
1626: (p_assignment_id => p_rec.assignment_id
1631: ,p_effective_date => p_effective_date
1632: ,p_object_version_number => p_rec.object_version_number
1633: );
1634: if g_debug then
1635: hr_utility.set_location(l_proc, 375);
1636: end if;
1637: --
1638: per_asg_bus2.chk_supervisor_assignment_id
1639: (p_assignment_id => p_rec.assignment_id
1643: ,p_effective_date => p_effective_date
1644: ,p_object_version_number => p_rec.object_version_number
1645: );
1646: if g_debug then
1647: hr_utility.set_location(l_proc, 380);
1648: end if;
1649: --
1650: per_asg_bus2.chk_person_referred_by_id
1651: (p_assignment_id => p_rec.assignment_id
1658: ,p_validation_start_date => p_validation_start_date
1659: ,p_validation_end_date => p_validation_end_date
1660: );
1661: if g_debug then
1662: hr_utility.set_location(l_proc, 390);
1663: end if;
1664: --
1665: per_asg_bus2.chk_recruiter_id
1666: (p_assignment_id => p_rec.assignment_id
1674: ,p_validation_start_date => p_validation_start_date
1675: ,p_validation_end_date => p_validation_end_date
1676: );
1677: if g_debug then
1678: hr_utility.set_location(l_proc, 400);
1679: end if;
1680: --
1681: per_asg_bus2.chk_period_of_service_id
1682: (p_assignment_id => p_rec.assignment_id
1689: ,p_effective_date => p_effective_date
1690: ,p_object_version_number => p_rec.object_version_number
1691: );
1692: if g_debug then
1693: hr_utility.set_location(l_proc, 405);
1694: end if;
1695: --
1696: per_asg_bus2.gen_assignment_sequence
1697: (p_assignment_type => p_rec.assignment_type
1698: ,p_person_id => p_rec.person_id
1699: ,p_assignment_sequence => p_rec.assignment_sequence
1700: );
1701: if g_debug then
1702: hr_utility.set_location(l_proc, 410);
1703: end if;
1704: --
1705: per_asg_bus1.gen_chk_assignment_number
1706: (p_assignment_id => p_rec.assignment_id
1712: ,p_effective_date => p_effective_date
1713: ,p_object_version_number => p_rec.object_version_number
1714: );
1715: if g_debug then
1716: hr_utility.set_location(l_proc, 420);
1717: end if;
1718: --
1719: per_asg_bus2.chk_primary_flag
1720: (p_assignment_id => p_rec.assignment_id
1728: ,p_validation_start_date => p_validation_start_date
1729: ,p_validation_end_date => p_validation_end_date
1730: );
1731: if g_debug then
1732: hr_utility.set_location(l_proc, 430);
1733: end if;
1734: --
1735: per_asg_bus2.chk_applicant_rank
1736: (p_applicant_rank => p_rec.applicant_rank
1756: ,p_other_manager_warning => l_other_manager_warning
1757: ,p_no_managers_warning => l_temp_flag
1758: );
1759: if g_debug then
1760: hr_utility.set_location(l_proc, 440);
1761: end if;
1762: --
1763: per_asg_bus1.chk_organization_id
1764: (p_assignment_id => p_rec.assignment_id
1775: ,p_org_now_no_manager_warning => l_temp_flag
1776: ,p_other_manager_warning => l_other_manager_warning
1777: );
1778: if g_debug then
1779: hr_utility.set_location(l_proc, 450);
1780: end if;
1781: --
1782: per_asg_bus2.chk_position_id_org_id
1783: (p_assignment_id => p_rec.assignment_id
1788: ,p_effective_date => p_effective_date
1789: ,p_object_version_number => p_rec.object_version_number
1790: );
1791: if g_debug then
1792: hr_utility.set_location(l_proc, 460);
1793: end if;
1794: --
1795: per_asg_bus1.chk_application_id
1796: (p_assignment_id => p_rec.assignment_id
1802: ,p_object_version_number => p_rec.object_version_number
1803: ,p_validation_start_date => p_validation_start_date
1804: );
1805: if g_debug then
1806: hr_utility.set_location(l_proc, 470);
1807: end if;
1808: --
1809: per_asg_bus2.chk_payroll_id
1810: (p_assignment_id => p_rec.assignment_id
1819: ,p_payroll_id_updated => l_temp_flag
1820: ,p_object_version_number => p_rec.object_version_number
1821: );
1822: if g_debug then
1823: hr_utility.set_location(l_proc, 490);
1824: end if;
1825: --
1826: per_asg_bus1.chk_assignment_status_type_id
1827: (p_rec => p_rec
1828: ,p_effective_date => p_effective_date
1829: ,p_validation_start_date => p_validation_start_date
1830: );
1831: if g_debug then
1832: hr_utility.set_location(l_proc, 500);
1833: end if;
1834: --
1835: per_asg_bus1.chk_bargaining_unit_code
1836: (p_assignment_id => p_rec.assignment_id
1840: ,p_validation_start_date => p_validation_start_date
1841: ,p_validation_end_date => p_validation_end_date
1842: );
1843: if g_debug then
1844: hr_utility.set_location(l_proc, 511);
1845: end if;
1846: --
1847: per_asg_bus1.chk_hourly_salaried_code
1848: (p_assignment_id => p_rec.assignment_id
1864: ,p_assignment_type => p_rec.assignment_type
1865: );
1866: --
1867: if g_debug then
1868: hr_utility.set_location(l_proc, 513);
1869: end if;
1870: per_asg_bus3.chk_contract_id
1871: (p_assignment_id => p_rec.assignment_id
1872: ,p_effective_date => p_effective_date
1876: ,p_validation_start_date => p_validation_start_date
1877: ,p_business_group_id => p_rec.business_group_id
1878: ) ;
1879: if g_debug then
1880: hr_utility.set_location(l_proc, 515);
1881: end if;
1882: --
1883: per_asg_bus3.chk_establishment_id
1884: (p_assignment_id => p_rec.assignment_id
1888: ,p_assignment_type => p_rec.assignment_type
1889: ,p_business_group_id => p_rec.business_group_id
1890: );
1891: if g_debug then
1892: hr_utility.set_location(l_proc, 520);
1893: end if;
1894: --
1895: per_asg_bus3.chk_collective_agreement_id
1896: (p_assignment_id => p_rec.assignment_id
1900: ,p_business_group_id => p_rec.business_group_id
1901: ,p_establishment_id => p_rec.establishment_id
1902: );
1903: if g_debug then
1904: hr_utility.set_location(l_proc, 530);
1905: end if;
1906: --
1907: per_asg_bus3.chk_cagr_id_flex_num
1908: (p_assignment_id => p_rec.assignment_id
1911: ,p_cagr_id_flex_num => p_rec.cagr_id_flex_num
1912: ,p_collective_agreement_id => p_rec.collective_agreement_id
1913: ) ;
1914: if g_debug then
1915: hr_utility.set_location(l_proc, 535);
1916: end if;
1917: --
1918: per_asg_bus3.chk_cagr_grade_def_id
1919: (p_assignment_id => p_rec.assignment_id
1954: ,p_validation_end_date => p_validation_end_date
1955: );
1956: --
1957: if g_debug then
1958: hr_utility.set_location(l_proc, 600);
1959: end if;
1960: --
1961: per_asg_bus1.chk_assignment_category
1962: (p_assignment_id => p_rec.assignment_id
1967: ,p_validation_start_date => p_validation_start_date
1968: ,p_validation_end_date => p_validation_end_date);
1969: --
1970: if g_debug then
1971: hr_utility.set_location(l_proc, 610);
1972: end if;
1973: --
1974: per_asg_bus3.chk_vendor_id
1975: (p_assignment_id => p_rec.assignment_id
1979: ,p_object_version_number => p_rec.object_version_number
1980: ,p_effective_date => p_effective_date);
1981: --
1982: if g_debug then
1983: hr_utility.set_location(l_proc, 620);
1984: end if;
1985: --
1986: per_asg_bus3.chk_vendor_site_id
1987: (p_assignment_id => p_rec.assignment_id
1990: ,p_object_version_number => p_rec.object_version_number
1991: ,p_effective_date => p_effective_date);
1992: --
1993: if g_debug then
1994: hr_utility.set_location(l_proc, 630);
1995: end if;
1996: --
1997: per_asg_bus3.chk_po_header_id
1998: (p_assignment_id => p_rec.assignment_id
2002: ,p_object_version_number => p_rec.object_version_number
2003: ,p_effective_date => p_effective_date);
2004: --
2005: if g_debug then
2006: hr_utility.set_location(l_proc, 640);
2007: end if;
2008: --
2009: per_asg_bus3.chk_po_line_id
2010: (p_assignment_id => p_rec.assignment_id
2013: ,p_object_version_number => p_rec.object_version_number
2014: ,p_effective_date => p_effective_date);
2015: --
2016: if g_debug then
2017: hr_utility.set_location(l_proc, 650);
2018: end if;
2019: --
2020: per_asg_bus3.chk_projected_assignment_end
2021: (p_assignment_id => p_rec.assignment_id
2025: ,p_object_version_number => p_rec.object_version_number
2026: ,p_effective_date => p_effective_date);
2027: --
2028: if g_debug then
2029: hr_utility.set_location(l_proc, 660);
2030: end if;
2031: --
2032: per_asg_bus3.chk_vendor_id_site_id
2033: (p_assignment_id => p_rec.assignment_id
2036: ,p_object_version_number => p_rec.object_version_number
2037: ,p_effective_date => p_effective_date);
2038: --
2039: if g_debug then
2040: hr_utility.set_location(l_proc, 670);
2041: end if;
2042: --
2043: per_asg_bus3.chk_po_header_id_line_id
2044: (p_assignment_id => p_rec.assignment_id
2047: ,p_object_version_number => p_rec.object_version_number
2048: ,p_effective_date => p_effective_date);
2049: --
2050: if g_debug then
2051: hr_utility.set_location(l_proc, 680);
2052: end if;
2053: --
2054: per_asg_bus3.chk_vendor_po_match
2055: (p_assignment_id => p_rec.assignment_id
2059: ,p_object_version_number => p_rec.object_version_number
2060: ,p_effective_date => p_effective_date);
2061: --
2062: if g_debug then
2063: hr_utility.set_location(l_proc, 690);
2064: end if;
2065: --
2066: per_asg_bus3.chk_po_job_match
2067: (p_assignment_id => p_rec.assignment_id
2070: ,p_object_version_number => p_rec.object_version_number
2071: ,p_effective_date => p_effective_date);
2072: --
2073: if g_debug then
2074: hr_utility.set_location(l_proc, 700);
2075: end if;
2076: --
2077: per_asg_bus3.chk_vendor_assignment_number
2078: (p_assignment_id => p_rec.assignment_id
2082: ,p_object_version_number => p_rec.object_version_number
2083: ,p_effective_date => p_effective_date);
2084: --
2085: if g_debug then
2086: hr_utility.set_location(l_proc, 710);
2087: end if;
2088: --
2089: per_asg_bus3.chk_vendor_employee_number
2090: (p_assignment_id => p_rec.assignment_id
2094: ,p_object_version_number => p_rec.object_version_number
2095: ,p_effective_date => p_effective_date);
2096: --
2097: if g_debug then
2098: hr_utility.set_location(l_proc, 720);
2099: end if;
2100: --
2101: per_asg_bus3.chk_pop_date_start
2102: (p_assignment_id => p_rec.assignment_id
2109: ,p_effective_date => p_effective_date
2110: ,p_object_version_number => p_rec.object_version_number);
2111: --
2112: if g_debug then
2113: hr_utility.set_location(l_proc, 730);
2114: end if;
2115: --
2116: per_asg_bus3.chk_grade_ladder_pgm_id
2117: (p_grade_id => p_rec.grade_id
2161: --
2162: */
2163: --
2164: if g_debug then
2165: hr_utility.set_location(' Leaving:'||l_proc, 740);
2166: end if;
2167: End insert_validate;
2168: --
2169: -- ----------------------------------------------------------------------------
2201: --
2202: Begin
2203: if g_debug then
2204: l_proc := g_package||'update_validate';
2205: hr_utility.set_location('Entering:'||l_proc, 10);
2206: end if;
2207: --
2208: -- Call all supporting business operations. Mapping to the
2209: -- appropriate Business Rules in perasg.bru is provided (where relevant).
2236: (p_rec => p_rec
2237: ,p_effective_date => p_effective_date
2238: );
2239: if g_debug then
2240: hr_utility.set_location(l_proc, 20);
2241: end if;
2242: --
2243: per_asg_bus2.chk_system_pers_type
2244: (p_person_id => p_rec.person_id
2248: ,p_effective_date => p_effective_date
2249:
2250: );
2251: if g_debug then
2252: hr_utility.set_location(l_proc, 21);
2253: end if;
2254: --
2255: per_asg_bus2.chk_term_status
2256: (p_assignment_id => p_rec.assignment_id
2257: ,p_datetrack_mode => p_datetrack_mode
2258: ,p_validation_start_date => p_validation_start_date
2259: );
2260: if g_debug then
2261: hr_utility.set_location(l_proc, 22);
2262: end if;
2263: --
2264: -- per_asg_bus2.chk_title(p_title => p_rec.title);
2265: --
2266: per_asg_bus2.chk_time_finish_formatted --#2734822
2267: (p_time_normal_finish => p_rec.time_normal_finish
2268: );
2269: if g_debug then
2270: hr_utility.set_location(l_proc, 25);
2271: end if;
2272: --
2273: -- Start changes for bug 8672114
2274: --
2285: ,p_datetrack_mode => p_datetrack_mode
2286: -- End changes for bug 8687386
2287: );
2288: if g_debug then
2289: hr_utility.set_location(l_proc, 26);
2290: end if;
2291: --
2292: -- End changes for bug 8672114
2293: --
2295: per_asg_bus2.chk_time_start_formatted --#2734822
2296: (p_time_normal_start => p_rec.time_normal_start
2297: );
2298: if g_debug then
2299: hr_utility.set_location(l_proc, 30);
2300: end if;
2301: --
2302: per_asg_bus1.chk_assignment_type
2303: (p_assignment_id => p_rec.assignment_id
2307: ,p_object_version_number => p_rec.object_version_number
2308: ,p_validation_start_date => p_validation_start_date
2309: );
2310: if g_debug then
2311: hr_utility.set_location(l_proc, 30);
2312: end if;
2313: --
2314: per_asg_bus2.chk_probation_unit
2315: (p_assignment_id => p_rec.assignment_id
2320: ,p_validation_end_date => p_validation_end_date
2321: ,p_object_version_number => p_rec.object_version_number
2322: );
2323: if g_debug then
2324: hr_utility.set_location(l_proc, 40);
2325: end if;
2326: --
2327: per_asg_bus2.chk_probation_period
2328: (p_assignment_id => p_rec.assignment_id
2330: ,p_effective_date => p_effective_date
2331: ,p_object_version_number => p_rec.object_version_number
2332: );
2333: if g_debug then
2334: hr_utility.set_location(l_proc, 50);
2335: end if;
2336: --
2337:
2338: per_asg_bus2.chk_prob_unit_prob_period
2342: ,p_effective_date => p_effective_date
2343: ,p_object_version_number => p_rec.object_version_number
2344: );
2345: if g_debug then
2346: hr_utility.set_location(l_proc, 60);
2347: end if;
2348: --
2349: per_asg_bus2.chk_source_type
2350: (p_assignment_id => p_rec.assignment_id
2356: ,p_validation_end_date => p_validation_end_date
2357: ,p_object_version_number => p_rec.object_version_number
2358: );
2359: if g_debug then
2360: hr_utility.set_location(l_proc, 70);
2361: end if;
2362: --
2363: per_asg_bus1.chk_date_probation_end
2364: (p_assignment_id => p_rec.assignment_id
2371: ,p_effective_date => p_effective_date
2372: ,p_object_version_number => p_rec.object_version_number
2373: );
2374: if g_debug then
2375: hr_utility.set_location(l_proc, 80);
2376: end if;
2377: --
2378: per_asg_bus2.chk_internal_address_line
2379: (p_assignment_id => p_rec.assignment_id
2383: ,p_object_version_number => p_rec.object_version_number
2384: );
2385:
2386: if g_debug then
2387: hr_utility.set_location(l_proc, 90);
2388: end if;
2389: --
2390: per_asg_bus1.chk_change_reason
2391: (p_assignment_id => p_rec.assignment_id
2396: ,p_validation_end_date => p_validation_end_date
2397: ,p_object_version_number => p_rec.object_version_number
2398: );
2399: if g_debug then
2400: hr_utility.set_location(l_proc, 100);
2401: end if;
2402: --
2403:
2404: per_asg_bus1.chk_default_code_comb_id
2409: ,p_validation_start_date => p_validation_start_date
2410: ,p_object_version_number => p_rec.object_version_number
2411: );
2412: if g_debug then
2413: hr_utility.set_location(l_proc, 110);
2414: end if;
2415: --
2416: per_asg_bus1.chk_employment_category
2417: (p_assignment_id => p_rec.assignment_id
2423: ,p_validation_end_date => p_validation_end_date
2424: ,p_object_version_number => p_rec.object_version_number
2425: );
2426: if g_debug then
2427: hr_utility.set_location(l_proc, 120);
2428: end if;
2429: --
2430: per_asg_bus2.chk_sal_review_period
2431: (p_assignment_id => p_rec.assignment_id
2435:
2436: ,p_object_version_number => p_rec.object_version_number
2437: );
2438: if g_debug then
2439: hr_utility.set_location(l_proc, 130);
2440: end if;
2441: --
2442: per_asg_bus2.chk_sal_review_period_freq
2443: (p_assignment_id => p_rec.assignment_id
2449: ,p_object_version_number => p_rec.object_version_number
2450: );
2451:
2452: if g_debug then
2453: hr_utility.set_location(l_proc, 140);
2454: end if;
2455: --
2456: per_asg_bus2.chk_sal_rp_freq_sal_rp
2457: (p_assignment_id => p_rec.assignment_id
2460: ,p_effective_date => p_effective_date
2461: ,p_object_version_number => p_rec.object_version_number
2462: );
2463: if g_debug then
2464: hr_utility.set_location(l_proc, 150);
2465: end if;
2466: --
2467: per_asg_bus2.chk_perf_review_period
2468: (p_assignment_id => p_rec.assignment_id
2472: ,p_effective_date => p_effective_date
2473: ,p_object_version_number => p_rec.object_version_number
2474: );
2475: if g_debug then
2476: hr_utility.set_location(l_proc, 160);
2477: end if;
2478: --
2479: per_asg_bus2.chk_perf_review_period_freq
2480: (p_assignment_id => p_rec.assignment_id
2486: ,p_validation_end_date => p_validation_end_date
2487: ,p_object_version_number => p_rec.object_version_number
2488: );
2489: if g_debug then
2490: hr_utility.set_location(l_proc, 170);
2491: end if;
2492: --
2493: per_asg_bus2.chk_perf_rp_freq_perf_rp
2494: (p_assignment_id => p_rec.assignment_id
2497: ,p_effective_date => p_effective_date
2498: ,p_object_version_number => p_rec.object_version_number
2499: );
2500: if g_debug then
2501: hr_utility.set_location(l_proc, 180);
2502: end if;
2503:
2504: --
2505: per_asg_bus1.chk_frequency
2510: ,p_validation_end_date => p_validation_end_date
2511: ,p_object_version_number => p_rec.object_version_number
2512: );
2513: if g_debug then
2514: hr_utility.set_location(l_proc, 190);
2515: end if;
2516: --
2517: per_asg_bus1.chk_frequency_normal_hours
2518: (p_assignment_id => p_rec.assignment_id
2522: ,p_effective_date => p_effective_date
2523: ,p_object_version_number => p_rec.object_version_number
2524: );
2525: if g_debug then
2526: hr_utility.set_location(l_proc, 200);
2527: end if;
2528: --
2529: per_asg_bus2.chk_set_of_books_id
2530: (p_assignment_id => p_rec.assignment_id
2535:
2536: ,p_object_version_number => p_rec.object_version_number
2537: );
2538: if g_debug then
2539: hr_utility.set_location(l_proc, 210);
2540: end if;
2541: --
2542: per_asg_bus2.chk_source_organization_id
2543: (p_assignment_id => p_rec.assignment_id
2550: ,p_validation_end_date => p_validation_end_date
2551:
2552: );
2553: if g_debug then
2554: hr_utility.set_location(l_proc, 220);
2555: end if;
2556: --
2557: per_asg_bus2.chk_soft_coding_keyflex_id
2558: (p_assignment_id => p_rec.assignment_id
2564: ,p_payroll_id => p_rec.payroll_id
2565: ,p_business_group_id => p_rec.business_group_id
2566: );
2567: if g_debug then
2568: hr_utility.set_location(l_proc, 230);
2569: end if;
2570: --
2571:
2572: per_asg_bus2.chk_pay_basis_id
2578: ,p_validation_start_date => p_validation_start_date
2579: ,p_object_version_number => p_rec.object_version_number
2580: );
2581: if g_debug then
2582: hr_utility.set_location(l_proc, 240);
2583: end if;
2584: --
2585: per_asg_bus2.chk_recruitment_activity_id
2586: (p_assignment_id => p_rec.assignment_id
2592: ,p_validation_start_date => p_validation_start_date
2593: ,p_validation_end_date => p_validation_end_date
2594: );
2595: if g_debug then
2596: hr_utility.set_location(l_proc, 250);
2597: end if;
2598: --
2599: per_asg_bus2.chk_vacancy_id
2600: (p_assignment_id => p_rec.assignment_id
2607: ,p_validation_start_date => p_validation_start_date
2608: ,p_validation_end_date => p_validation_end_date
2609: );
2610: if g_debug then
2611: hr_utility.set_location(l_proc, 260);
2612: end if;
2613: --
2614: per_asg_bus1.chk_location_id
2615: (p_assignment_id => p_rec.assignment_id
2623: ,p_object_version_number => p_rec.object_version_number
2624: ,p_business_group_id => p_rec.business_group_id --added for bug 11063182
2625: );
2626: if g_debug then
2627: hr_utility.set_location(l_proc, 270);
2628: end if;
2629: --
2630: per_asg_bus2.chk_people_group_id
2631: (p_assignment_id => p_rec.assignment_id
2639: ,p_effective_date => p_effective_date
2640: ,p_object_version_number => p_rec.object_version_number
2641: );
2642: if g_debug then
2643: hr_utility.set_location(l_proc, 280);
2644: end if;
2645: --
2646: if g_debug then
2647: hr_utility.set_location(p_validation_start_date, 290);
2643: hr_utility.set_location(l_proc, 280);
2644: end if;
2645: --
2646: if g_debug then
2647: hr_utility.set_location(p_validation_start_date, 290);
2648: end if;
2649: if g_debug then
2650: hr_utility.set_location(p_validation_end_date, 290);
2651: end if;
2646: if g_debug then
2647: hr_utility.set_location(p_validation_start_date, 290);
2648: end if;
2649: if g_debug then
2650: hr_utility.set_location(p_validation_end_date, 290);
2651: end if;
2652: per_asg_bus2.chk_position_id
2653: (p_assignment_id => p_rec.assignment_id
2654: ,p_position_id => p_rec.position_id
2661: ,p_effective_date => p_effective_date
2662: ,p_object_version_number => p_rec.object_version_number
2663: );
2664: if g_debug then
2665: hr_utility.set_location(l_proc, 290);
2666: end if;
2667: --
2668: per_asg_bus1.chk_job_id
2669: (p_assignment_id => p_rec.assignment_id
2677: ,p_validation_end_date => p_validation_end_date
2678: ,p_object_version_number => p_rec.object_version_number
2679: );
2680: if g_debug then
2681: hr_utility.set_location(l_proc, 300);
2682: end if;
2683: --
2684: per_asg_bus2.chk_position_id_job_id
2685: (p_assignment_id => p_rec.assignment_id
2691: ,p_effective_date => p_effective_date
2692: ,p_object_version_number => p_rec.object_version_number
2693: );
2694: if g_debug then
2695: hr_utility.set_location(l_proc, 310);
2696: end if;
2697: --
2698: per_asg_bus1.chk_grade_id
2699: (p_assignment_id => p_rec.assignment_id
2708: ,p_validation_end_date => p_validation_end_date
2709: ,p_object_version_number => p_rec.object_version_number
2710: );
2711: if g_debug then
2712: hr_utility.set_location(l_proc, 320);
2713: end if;
2714: --
2715: per_asg_bus2.chk_special_ceiling_step_id
2716: (p_assignment_id => p_rec.assignment_id
2724: ,p_effective_date => p_effective_date
2725: ,p_object_version_number => p_rec.object_version_number
2726: );
2727: if g_debug then
2728: hr_utility.set_location(l_proc, 330);
2729: end if;
2730: --
2731: per_asg_bus2.chk_position_id_grade_id
2732: (p_assignment_id => p_rec.assignment_id
2739: ,p_object_version_number => p_rec.object_version_number
2740: ,p_inv_pos_grade_warning => l_inv_pos_grade_warning
2741: );
2742: if g_debug then
2743: hr_utility.set_location(l_proc, 340);
2744: end if;
2745: --
2746: per_asg_bus1.chk_job_id_grade_id
2747: (p_assignment_id => p_rec.assignment_id
2754: ,p_object_version_number => p_rec.object_version_number
2755: ,p_inv_job_grade_warning => l_inv_pos_grade_warning
2756: );
2757: if g_debug then
2758: hr_utility.set_location(l_proc, 350);
2759: end if;
2760: --
2761: per_asg_bus2.chk_supervisor_id
2762: (p_assignment_id => p_rec.assignment_id
2767: ,p_effective_date => p_effective_date
2768: ,p_object_version_number => p_rec.object_version_number
2769: );
2770: if g_debug then
2771: hr_utility.set_location(l_proc, 360);
2772: end if;
2773: --
2774: per_asg_bus2.chk_supervisor_assignment_id
2775: (p_assignment_id => p_rec.assignment_id
2779: ,p_effective_date => p_effective_date
2780: ,p_object_version_number => p_rec.object_version_number
2781: );
2782: if g_debug then
2783: hr_utility.set_location(l_proc, 350);
2784: end if;
2785: --
2786: per_asg_bus2.chk_person_referred_by_id
2787: (p_assignment_id => p_rec.assignment_id
2795: ,p_validation_end_date => p_validation_end_date
2796:
2797: );
2798: if g_debug then
2799: hr_utility.set_location(l_proc, 370);
2800: end if;
2801: --
2802: per_asg_bus2.chk_recruiter_id
2803: (p_assignment_id => p_rec.assignment_id
2812:
2813: ,p_validation_end_date => p_validation_end_date
2814: );
2815: if g_debug then
2816: hr_utility.set_location(l_proc, 380);
2817: end if;
2818: --
2819: per_asg_bus2.chk_period_of_service_id
2820: (p_assignment_id => p_rec.assignment_id
2827: ,p_effective_date => p_effective_date
2828: ,p_object_version_number => p_rec.object_version_number
2829: );
2830: if g_debug then
2831: hr_utility.set_location(l_proc, 385);
2832: end if;
2833: --
2834: -- bug 5404529
2835: l_api_updating := per_asg_shd.api_updating
2849: );
2850:
2851: end if;
2852: if ( l_assignment_sequence =1 ) then
2853: hr_utility.set_location(l_proc, 386);
2854: p_rec.assignment_sequence:=1;
2855: per_asg_bus1.gen_chk_assignment_number
2856: (p_assignment_id => p_rec.assignment_id
2857: ,p_business_group_id => p_rec.business_group_id
2861: ,p_person_id => p_rec.person_id
2862: ,p_effective_date => p_effective_date
2863: ,p_object_version_number => p_rec.object_version_number
2864: );
2865: hr_utility.set_location(l_proc, 387);
2866: else
2867: hr_utility.set_location(l_proc, 388);
2868: per_asg_bus1.gen_chk_assignment_number
2869: (p_assignment_id => p_rec.assignment_id
2863: ,p_object_version_number => p_rec.object_version_number
2864: );
2865: hr_utility.set_location(l_proc, 387);
2866: else
2867: hr_utility.set_location(l_proc, 388);
2868: per_asg_bus1.gen_chk_assignment_number
2869: (p_assignment_id => p_rec.assignment_id
2870: ,p_business_group_id => p_rec.business_group_id
2871: ,p_assignment_type => p_rec.assignment_type
2874: ,p_person_id => p_rec.person_id
2875: ,p_effective_date => p_effective_date
2876: ,p_object_version_number => p_rec.object_version_number
2877: );
2878: hr_utility.set_location(l_proc, 389);
2879: end if;
2880:
2881: -- end of bug 5404529
2882:
2880:
2881: -- end of bug 5404529
2882:
2883: if g_debug then
2884: hr_utility.set_location(l_proc, 390);
2885: end if;
2886: --
2887: per_asg_bus2.chk_primary_flag
2888: (p_assignment_id => p_rec.assignment_id
2896: ,p_validation_start_date => p_validation_start_date
2897: ,p_validation_end_date => p_validation_end_date
2898: );
2899: if g_debug then
2900: hr_utility.set_location(l_proc, 430);
2901: end if;
2902: --
2903: per_asg_bus1.chk_manager_flag
2904: (p_assignment_id => p_rec.assignment_id
2911: ,p_no_managers_warning => l_no_managers_warning
2912: );
2913:
2914: if g_debug then
2915: hr_utility.set_location(l_proc, 400);
2916: end if;
2917: --
2918: per_asg_bus1.chk_organization_id
2919: (p_assignment_id => p_rec.assignment_id
2931: ,p_org_now_no_manager_warning => l_temp_flag
2932: ,p_other_manager_warning => l_other_manager_warning
2933: );
2934: if g_debug then
2935: hr_utility.set_location(l_proc, 410);
2936: end if;
2937: --
2938: per_asg_bus2.chk_position_id_org_id
2939: (p_assignment_id => p_rec.assignment_id
2945: ,p_effective_date => p_effective_date
2946: ,p_object_version_number => p_rec.object_version_number
2947: );
2948: if g_debug then
2949: hr_utility.set_location(l_proc, 420);
2950: end if;
2951: --
2952: per_asg_bus1.chk_application_id
2953: (p_assignment_id => p_rec.assignment_id
2960:
2961: ,p_validation_start_date => p_validation_start_date
2962: );
2963: if g_debug then
2964: hr_utility.set_location(l_proc, 430);
2965: end if;
2966: --
2967: per_asg_bus2.chk_payroll_id
2968: (p_assignment_id => p_rec.assignment_id
2978: ,p_payroll_id_updated => l_payroll_id_updated
2979: ,p_object_version_number => p_rec.object_version_number
2980: );
2981: if g_debug then
2982: hr_utility.set_location(l_proc, 440);
2983: end if;
2984: --
2985: per_asg_bus1.chk_assignment_status_type_id
2986: (p_rec => p_rec
2987: ,p_effective_date => p_effective_date
2988: ,p_validation_start_date => p_validation_start_date
2989: );
2990: if g_debug then
2991: hr_utility.set_location(l_proc, 450);
2992: end if;
2993: --
2994: per_asg_bus1.chk_bargaining_unit_code
2995: (p_assignment_id => p_rec.assignment_id
2999: ,p_validation_start_date => p_validation_start_date
3000: ,p_validation_end_date => p_validation_end_date
3001: );
3002: if g_debug then
3003: hr_utility.set_location(l_proc, 451);
3004: end if;
3005: --
3006: per_asg_bus1.chk_hourly_salaried_code
3007: (p_assignment_id => p_rec.assignment_id
3014: ,p_hourly_salaried_warning => l_hourly_salaried_warning
3015: ,p_assignment_type => p_rec.assignment_type);
3016: --
3017: if g_debug then
3018: hr_utility.set_location(l_proc, 452);
3019: end if;
3020: --
3021: per_asg_bus1.chk_single_position
3022: (p_assignment_id => p_rec.assignment_id
3027: ,p_assignment_type => p_rec.assignment_type
3028: );
3029: --
3030: if g_debug then
3031: hr_utility.set_location(l_proc, 453);
3032: end if;
3033: --
3034: per_asg_bus3.chk_contract_id
3035: (p_assignment_id => p_rec.assignment_id
3040: ,p_validation_start_date => p_validation_start_date
3041: ,p_business_group_id => p_rec.business_group_id
3042: ) ;
3043: if g_debug then
3044: hr_utility.set_location(l_proc, 510);
3045: end if;
3046: --
3047: per_asg_bus3.chk_establishment_id
3048: (p_assignment_id => p_rec.assignment_id
3052: ,p_assignment_type => p_rec.assignment_type
3053: ,p_business_group_id => p_rec.business_group_id
3054: );
3055: if g_debug then
3056: hr_utility.set_location(l_proc, 520);
3057: end if;
3058: --
3059: per_asg_bus3.chk_collective_agreement_id
3060: (p_assignment_id => p_rec.assignment_id
3064: ,p_business_group_id => p_rec.business_group_id
3065: ,p_establishment_id => p_rec.establishment_id
3066: );
3067: if g_debug then
3068: hr_utility.set_location(l_proc, 530);
3069: end if;
3070: --
3071: per_asg_bus3.chk_cagr_id_flex_num
3072: (p_assignment_id => p_rec.assignment_id
3075: ,p_cagr_id_flex_num => p_rec.cagr_id_flex_num
3076: ,p_collective_agreement_id => p_rec.collective_agreement_id
3077: ) ;
3078: if g_debug then
3079: hr_utility.set_location(l_proc, 535);
3080: end if;
3081: --
3082: per_asg_bus3.chk_cagr_grade_def_id
3083: (p_assignment_id => p_rec.assignment_id
3118: ,p_validation_end_date => p_validation_end_date
3119: );
3120: --
3121: if g_debug then
3122: hr_utility.set_location(l_proc, 600);
3123: end if;
3124: --
3125: per_asg_bus1.chk_assignment_category
3126: (p_assignment_id => p_rec.assignment_id
3131: ,p_validation_start_date => p_validation_start_date
3132: ,p_validation_end_date => p_validation_end_date);
3133: --
3134: if g_debug then
3135: hr_utility.set_location(l_proc, 610);
3136: end if;
3137: --
3138: per_asg_bus3.chk_vendor_id
3139: (p_assignment_id => p_rec.assignment_id
3143: ,p_object_version_number => p_rec.object_version_number
3144: ,p_effective_date => p_effective_date);
3145: --
3146: if g_debug then
3147: hr_utility.set_location(l_proc, 620);
3148: end if;
3149: per_asg_bus3.chk_vendor_site_id
3150: (p_assignment_id => p_rec.assignment_id
3151: ,p_assignment_type => p_rec.assignment_type
3153: ,p_object_version_number => p_rec.object_version_number
3154: ,p_effective_date => p_effective_date);
3155: --
3156: if g_debug then
3157: hr_utility.set_location(l_proc, 630);
3158: end if;
3159: --
3160: per_asg_bus3.chk_po_header_id
3161: (p_assignment_id => p_rec.assignment_id
3165: ,p_object_version_number => p_rec.object_version_number
3166: ,p_effective_date => p_effective_date);
3167: --
3168: if g_debug then
3169: hr_utility.set_location(l_proc, 640);
3170: end if;
3171: --
3172: per_asg_bus3.chk_po_line_id
3173: (p_assignment_id => p_rec.assignment_id
3176: ,p_object_version_number => p_rec.object_version_number
3177: ,p_effective_date => p_effective_date);
3178: --
3179: if g_debug then
3180: hr_utility.set_location(l_proc, 650);
3181: end if;
3182: --
3183: per_asg_bus3.chk_projected_assignment_end
3184: (p_assignment_id => p_rec.assignment_id
3188: ,p_object_version_number => p_rec.object_version_number
3189: ,p_effective_date => p_effective_date);
3190: --
3191: if g_debug then
3192: hr_utility.set_location(l_proc, 660);
3193: end if;
3194: --
3195: per_asg_bus3.chk_vendor_id_site_id
3196: (p_assignment_id => p_rec.assignment_id
3199: ,p_object_version_number => p_rec.object_version_number
3200: ,p_effective_date => p_effective_date);
3201: --
3202: if g_debug then
3203: hr_utility.set_location(l_proc, 670);
3204: end if;
3205: --
3206: per_asg_bus3.chk_po_header_id_line_id
3207: (p_assignment_id => p_rec.assignment_id
3210: ,p_object_version_number => p_rec.object_version_number
3211: ,p_effective_date => p_effective_date);
3212: --
3213: if g_debug then
3214: hr_utility.set_location(l_proc, 680);
3215: end if;
3216: --
3217: per_asg_bus3.chk_vendor_po_match
3218: (p_assignment_id => p_rec.assignment_id
3222: ,p_object_version_number => p_rec.object_version_number
3223: ,p_effective_date => p_effective_date);
3224: --
3225: if g_debug then
3226: hr_utility.set_location(l_proc, 690);
3227: end if;
3228: --
3229: per_asg_bus3.chk_po_job_match
3230: (p_assignment_id => p_rec.assignment_id
3233: ,p_object_version_number => p_rec.object_version_number
3234: ,p_effective_date => p_effective_date);
3235: --
3236: if g_debug then
3237: hr_utility.set_location(l_proc, 700);
3238: end if;
3239: --
3240: per_asg_bus3.chk_vendor_assignment_number
3241: (p_assignment_id => p_rec.assignment_id
3245: ,p_object_version_number => p_rec.object_version_number
3246: ,p_effective_date => p_effective_date);
3247: --
3248: if g_debug then
3249: hr_utility.set_location(l_proc, 710);
3250: end if;
3251: --
3252: per_asg_bus3.chk_vendor_employee_number
3253: (p_assignment_id => p_rec.assignment_id
3257: ,p_object_version_number => p_rec.object_version_number
3258: ,p_effective_date => p_effective_date);
3259: --
3260: if g_debug then
3261: hr_utility.set_location(l_proc, 720);
3262: end if;
3263: --
3264: per_asg_bus3.chk_pop_date_start
3265: (p_assignment_id => p_rec.assignment_id
3272: ,p_effective_date => p_effective_date
3273: ,p_object_version_number => p_rec.object_version_number);
3274: --
3275: if g_debug then
3276: hr_utility.set_location(l_proc, 730);
3277: end if;
3278: --
3279: per_asg_bus2.chk_applicant_rank
3280: (p_applicant_rank => p_rec.applicant_rank
3290: ,p_object_version_number => p_rec.object_version_number
3291: ,p_effective_date => p_effective_date);
3292: --
3293: if g_debug then
3294: hr_utility.set_location(l_proc, 740);
3295: end if;
3296: --
3297: per_asg_bus3.chk_grade_ladder_pgm_id
3298: (p_grade_id => p_rec.grade_id
3306: --
3307: per_asg_bus1.chk_df(p_rec => p_rec);
3308:
3309: if g_debug then
3310: hr_utility.set_location(l_proc, 750);
3311: end if;
3312: --
3313: -- Call the datetrack update integrity operation
3314: --
3362: */
3363: --
3364: --
3365: if g_debug then
3366: hr_utility.set_location(' Leaving:'||l_proc, 999);
3367: end if;
3368: End update_validate;
3369: --
3370: -- ---------------------------------------------------------------------------
3403: and nvl(date_end,hr_api.g_eot);
3404: --
3405: begin
3406: if g_debug then
3407: hr_utility.set_location('Entering:'|| l_proc, 10);
3408: end if;
3409: --
3410: --
3411: -- Check mandatory parameters have been set
3421: ,p_argument => 'validation_start_date'
3422: ,p_argument_value => p_validation_start_date
3423: );
3424: if g_debug then
3425: hr_utility.set_location(l_proc, 20);
3426: end if;
3427: --
3428: -- Check if the assignment is being updated.
3429: --
3431: (p_assignment_id => p_assignment_id
3432: ,p_effective_date => p_effective_date
3433: ,p_object_version_number => p_object_version_number);
3434: if g_debug then
3435: hr_utility.set_location(l_proc, 30);
3436: end if;
3437: --
3438: -- Check if the assignment is being inserted or updated.
3439: --
3442: <> nvl(p_application_id, hr_api.g_number))
3443: or (NOT l_api_updating))
3444: then
3445: if g_debug then
3446: hr_utility.set_location(l_proc, 40);
3447: end if;
3448: --
3449: -- Check if the assignment is an applicant assignment or
3450: -- offer assignment or an employee assignment which is being updated.
3462: --
3463: if p_assignment_type = 'A'
3464: or p_assignment_type = 'O' then
3465: --
3466: hr_utility.set_message(801, 'HR_51212_ASG_INV_APL_ASG_APL');
3467: hr_utility.raise_error;
3468: /* hr_multi_message.add
3469: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICATION_ID'
3470: );*/
3463: if p_assignment_type = 'A'
3464: or p_assignment_type = 'O' then
3465: --
3466: hr_utility.set_message(801, 'HR_51212_ASG_INV_APL_ASG_APL');
3467: hr_utility.raise_error;
3468: /* hr_multi_message.add
3469: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICATION_ID'
3470: );*/
3471: --
3470: );*/
3471: --
3472: end if;
3473: if g_debug then
3474: hr_utility.set_location(l_proc, 50);
3475: end if;
3476: --
3477: -- Check if the existing application is set
3478: --
3477: -- Check if the existing application is set
3478: --
3479: If per_asg_shd.g_old_rec.application_id is not null then
3480: --
3481: hr_utility.set_message(801, 'HR_51213_ASG_INV_UPD_APL');
3482: hr_utility.raise_error;
3483: /*hr_multi_message.add
3484: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICATION_ID'
3485: ); */ --
3478: --
3479: If per_asg_shd.g_old_rec.application_id is not null then
3480: --
3481: hr_utility.set_message(801, 'HR_51213_ASG_INV_UPD_APL');
3482: hr_utility.raise_error;
3483: /*hr_multi_message.add
3484: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICATION_ID'
3485: ); */ --
3486: --
3485: ); */ --
3486: --
3487: end if;
3488: if g_debug then
3489: hr_utility.set_location(l_proc, 60);
3490: end if;
3491: --
3492: end if;
3493: --
3505: open csr_valid_apl_1;
3506: fetch csr_valid_apl_1 into l_business_group_id;
3507: if csr_valid_apl_1%notfound then
3508: close csr_valid_apl_1;
3509: hr_utility.set_message(801, 'HR_51210_ASG_INV_APL');
3510: hr_utility.raise_error;
3511: /* hr_multi_message.add
3512: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICATION_ID'
3513: ,p_associated_column2 =>
3506: fetch csr_valid_apl_1 into l_business_group_id;
3507: if csr_valid_apl_1%notfound then
3508: close csr_valid_apl_1;
3509: hr_utility.set_message(801, 'HR_51210_ASG_INV_APL');
3510: hr_utility.raise_error;
3511: /* hr_multi_message.add
3512: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICATION_ID'
3513: ,p_associated_column2 =>
3514: 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
3529: open csr_valid_apl_2;
3530: fetch csr_valid_apl_2 into l_business_group_id;
3531: if csr_valid_apl_2%notfound then
3532: close csr_valid_apl_2;
3533: hr_utility.set_message(801, 'HR_51375_ASG_INV_APL_NOT_1_ASG');
3534: hr_multi_message.add
3535: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICATION_ID'
3536: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
3537: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_SEQUENCE'
3543: -- Check that the application is in the same business group
3544: -- as the business group of the assignment.
3545: --
3546: if g_debug then
3547: hr_utility.set_location(l_proc, 90);
3548: end if;
3549: If p_business_group_id <> l_business_group_id then
3550: --
3551: hr_utility.set_message(801, 'HR_51214_ASG_INV_APL_BUS_GRP');
3547: hr_utility.set_location(l_proc, 90);
3548: end if;
3549: If p_business_group_id <> l_business_group_id then
3550: --
3551: hr_utility.set_message(801, 'HR_51214_ASG_INV_APL_BUS_GRP');
3552: hr_multi_message.add
3553: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICATION_ID'
3554: );
3555: --
3555: --
3556: end if;
3557: end if;
3558: if g_debug then
3559: hr_utility.set_location(l_proc, 100);
3560: end if;
3561: --
3562: end if;
3563: --
3566: -- Check that application is null
3567: --
3568: If p_application_id is not null then
3569: --
3570: hr_utility.set_message(801, 'HR_51211_ASG_INV_E_ASG_APL_ID');
3571: hr_multi_message.add
3572: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICATION_ID'
3573: );
3574: --
3573: );
3574: --
3575: end if;
3576: if g_debug then
3577: hr_utility.set_location(l_proc, 110);
3578: end if;
3579: --
3580: end if;
3581: --
3581: --
3582: end if;
3583: --
3584: if g_debug then
3585: hr_utility.set_location(' Leaving:'|| l_proc, 120);
3586: end if;
3587: end chk_application_id;
3588: --
3589: -- ---------------------------------------------------------------------------
3615: --
3616: begin
3617: --
3618: if g_debug then
3619: hr_utility.set_location('Entering: '|| l_proc, 10);
3620: end if;
3621: --
3622: hr_api.mandatory_arg_error
3623: (p_api_name => l_proc
3642: ,p_argument => 'assignment_sequence'
3643: ,p_argument_value => p_assignment_sequence
3644: );
3645: if g_debug then
3646: hr_utility.set_location(l_proc, 20);
3647: end if;
3648: --
3649: -- Only proceed with validation if :
3650: -- a) The current g_old_rec is current and
3656: ,p_effective_date => p_effective_date
3657: ,p_object_version_number => p_object_version_number
3658: );
3659: if g_debug then
3660: hr_utility.set_location(l_proc, 30);
3661: end if;
3662: --
3663: -- Amended for bug 942142
3664: -- Removed p_assignment_number is not null from the check condition
3669: nvl(p_assignment_number, hr_api.g_varchar2)) or
3670: (NOT l_api_updating)) then
3671: --
3672: if g_debug then
3673: hr_utility.set_location(l_proc, 40);
3674: end if;
3675: --
3676: -- For applicant and offer assignments ensure the assignment_number
3677: -- is null
3684: if p_assignment_number is not null then
3685: --
3686: -- Raise an error: Assignment Number must be null for
3687: -- applicant, offer and benefit assignments
3688: hr_utility.set_message(801, 'HR_51017_ASG_NUM_NULL_FOR_APL');
3689: hr_multi_message.add
3690: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER');
3691: --
3692: end if;
3691: --
3692: end if;
3693: --
3694: if g_debug then
3695: hr_utility.set_location(l_proc, 50);
3696: end if;
3697: --
3698: -- For Employee and Contingent Labour assignments derive the
3699: -- assignment number.
3711: if csr_get_work_no%found then
3712: --
3713: close csr_get_work_no;
3714: if g_debug then
3715: hr_utility.set_location(l_proc, 60);
3716: end if;
3717: --
3718: hr_assignment.gen_new_ass_number
3719: (p_assignment_id => p_assignment_id
3723: ,p_assignment_sequence => p_assignment_sequence
3724: ,p_assignment_number => p_assignment_number);
3725: --
3726: if g_debug then
3727: hr_utility.set_location(l_proc, 70);
3728: end if;
3729: --
3730: else
3731: --
3731: --
3732: -- No worker number found for assignment
3733: --
3734: close csr_get_work_no;
3735: hr_utility.set_message(801, 'HR_7390_ASG_NO_EMP_NO');
3736: hr_multi_message.add
3737: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
3738: ,p_associated_column2 =>
3739: 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE');
3742: --
3743: end if; -- no exclusive error
3744: --
3745: if g_debug then
3746: hr_utility.set_location(l_proc, 90);
3747: end if;
3748: --
3749: end if;
3750: --
3766: if csr_get_work_no%found then
3767: --
3768: close csr_get_work_no;
3769: if g_debug then
3770: hr_utility.set_location(l_proc, 60);
3771: end if;
3772: --
3773: hr_assignment.gen_new_ass_number
3774: (p_assignment_id => p_assignment_id
3778: ,p_assignment_sequence => p_assignment_sequence
3779: ,p_assignment_number => p_assignment_number);
3780: --
3781: if g_debug then
3782: hr_utility.set_location(l_proc, 70);
3783: end if;
3784: --
3785: else
3786: --
3787: -- No employee number found for assignment
3788: --
3789: close csr_get_work_no;
3790: --
3791: hr_utility.set_message(801, 'HR_7390_ASG_NO_EMP_NO');
3792: hr_multi_message.add
3793: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
3794: ,p_associated_column2 =>
3795: 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE');
3798: --
3799: end if; -- no exclusive error
3800: --
3801: if g_debug then
3802: hr_utility.set_location(l_proc, 90);
3803: end if;
3804: --
3805: end if;
3806: --
3804: --
3805: end if;
3806: --
3807: if g_debug then
3808: hr_utility.set_location(' Leaving:'|| l_proc, 91);
3809: end if;
3810: --
3811: end gen_chk_assignment_number;
3812: --
3829: BEGIN
3830: --
3831: if g_debug then
3832: l_proc := g_package||'chk_assignment_category';
3833: hr_utility.set_location('Entering:'|| l_proc, 10);
3834: end if;
3835: --
3836: -- Check if inserting or updating the assignment
3837: --
3840: ,p_effective_date => p_effective_date
3841: ,p_object_version_number => p_object_version_number);
3842: --
3843: if g_debug then
3844: hr_utility.set_location(l_proc, 30);
3845: end if;
3846: --
3847: -- Check if inserting or assignment type has changed
3848: --
3851: nvl(p_assignment_category, hr_api.g_varchar2)) OR
3852: (NOT l_api_updating)) THEN
3853: --
3854: if g_debug then
3855: hr_utility.set_location(l_proc, 40);
3856: end if;
3857: --
3858: -- Check that assignment type is 'C' (Contingent Worker) and
3859: -- that the value entered exists in the CWK_ASG_CATEOGRY lookup
3867: ,p_validation_end_date => p_validation_end_date
3868: ,p_lookup_type => 'CWK_ASG_CATEGORY'
3869: ,p_lookup_code => p_assignment_category) THEN
3870: --
3871: hr_utility.set_message(800,'HR_289642_INV_CWK_ASG_CAT');
3872: hr_utility.raise_error;
3873: --
3874: END IF;
3875: --
3868: ,p_lookup_type => 'CWK_ASG_CATEGORY'
3869: ,p_lookup_code => p_assignment_category) THEN
3870: --
3871: hr_utility.set_message(800,'HR_289642_INV_CWK_ASG_CAT');
3872: hr_utility.raise_error;
3873: --
3874: END IF;
3875: --
3876: -- Check that if the assignment type is not a CWK assignment that
3878: --
3879: ELSIF p_assignment_type <> 'C' AND
3880: p_assignment_category IS NOT NULL THEN
3881: --
3882: hr_utility.set_message(800,'HR_289643_CWK_ASG_CAT_NULL');
3883: hr_utility.raise_error;
3884: --
3885: END IF;
3886: --
3879: ELSIF p_assignment_type <> 'C' AND
3880: p_assignment_category IS NOT NULL THEN
3881: --
3882: hr_utility.set_message(800,'HR_289643_CWK_ASG_CAT_NULL');
3883: hr_utility.raise_error;
3884: --
3885: END IF;
3886: --
3887: END IF;
3886: --
3887: END IF;
3888: --
3889: if g_debug then
3890: hr_utility.set_location(' Leaving:'|| l_proc, 997);
3891: end if;
3892: --
3893: EXCEPTION
3894: --
3897: IF hr_multi_message.exception_add
3898: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_CATEGORY') THEN
3899: --
3900: if g_debug then
3901: hr_utility.set_location(' Leaving:'|| l_proc, 998);
3902: end if;
3903: --
3904: RAISE;
3905: --
3905: --
3906: END IF;
3907: --
3908: if g_debug then
3909: hr_utility.set_location(' Leaving:'|| l_proc, 999);
3910: end if;
3911: --
3912: END chk_assignment_category;
3913: -- ----------------------------------------------------------------------------
3964: --
3965: begin
3966: if g_debug then
3967: l_proc := g_package || 'chk_assignment_status_type';
3968: hr_utility.set_location('Entering:'|| l_proc, 1);
3969: end if;
3970: --
3971: if hr_multi_message.no_exclusive_error
3972: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
3976: --
3977: if nvl(p_assignment_status_type_id, hr_api.g_number) = hr_api.g_number then
3978: --
3979: if g_debug then
3980: hr_utility.set_location(l_proc, 10);
3981: end if;
3982: --
3983: -- Derive default value.
3984: --
3982: --
3983: -- Derive default value.
3984: --
3985: if g_debug then
3986: hr_utility.set_location(l_proc, 20);
3987: end if;
3988: --
3989: per_people3_pkg.get_default_person_type
3990: (p_required_type => p_expected_system_status
3994: );
3995: else
3996: --
3997: if g_debug then
3998: hr_utility.set_location(l_proc, 30);
3999: end if;
4000: --
4001: -- Validate that assignment status type id is for the expected system
4002: -- status in the assignment's business group.
4008: --
4009: if csr_get_ast_details%NOTFOUND then
4010: --
4011: if g_debug then
4012: hr_utility.set_location(l_proc, 40);
4013: end if;
4014: --
4015: close csr_get_ast_details;
4016: --
4013: end if;
4014: --
4015: close csr_get_ast_details;
4016: --
4017: hr_utility.set_message(801,'HR_7940_ASG_INV_ASG_STAT_TYPE');
4018: hr_utility.raise_error;
4019: --
4020: elsif l_per_system_status <> p_expected_system_status
4021: then
4014: --
4015: close csr_get_ast_details;
4016: --
4017: hr_utility.set_message(801,'HR_7940_ASG_INV_ASG_STAT_TYPE');
4018: hr_utility.raise_error;
4019: --
4020: elsif l_per_system_status <> p_expected_system_status
4021: then
4022: --
4020: elsif l_per_system_status <> p_expected_system_status
4021: then
4022: --
4023: if g_debug then
4024: hr_utility.set_location(l_proc, 50);
4025: end if;
4026: --
4027: close csr_get_ast_details;
4028: --
4025: end if;
4026: --
4027: close csr_get_ast_details;
4028: --
4029: hr_utility.set_message(801,'HR_7949_ASG_DIF_SYSTEM_TYPES');
4030: hr_utility.set_message_token('SYSTYPE', p_expected_system_status);
4031: hr_utility.raise_error;
4032: --
4033: --
4026: --
4027: close csr_get_ast_details;
4028: --
4029: hr_utility.set_message(801,'HR_7949_ASG_DIF_SYSTEM_TYPES');
4030: hr_utility.set_message_token('SYSTYPE', p_expected_system_status);
4031: hr_utility.raise_error;
4032: --
4033: --
4034: elsif nvl(l_ast_business_group_id, p_business_group_id) <>
4027: close csr_get_ast_details;
4028: --
4029: hr_utility.set_message(801,'HR_7949_ASG_DIF_SYSTEM_TYPES');
4030: hr_utility.set_message_token('SYSTYPE', p_expected_system_status);
4031: hr_utility.raise_error;
4032: --
4033: --
4034: elsif nvl(l_ast_business_group_id, p_business_group_id) <>
4035: p_business_group_id
4035: p_business_group_id
4036: then
4037: --
4038: if g_debug then
4039: hr_utility.set_location(l_proc, 60);
4040: end if;
4041: --
4042: close csr_get_ast_details;
4043: --
4040: end if;
4041: --
4042: close csr_get_ast_details;
4043: --
4044: hr_utility.set_message(801,'HR_7372_ASG_INV_BG_ASS_STATUS');
4045: hr_utility.raise_error;
4046: else
4047: --
4048: if g_debug then
4041: --
4042: close csr_get_ast_details;
4043: --
4044: hr_utility.set_message(801,'HR_7372_ASG_INV_BG_ASS_STATUS');
4045: hr_utility.raise_error;
4046: else
4047: --
4048: if g_debug then
4049: hr_utility.set_location(l_proc, 70);
4045: hr_utility.raise_error;
4046: else
4047: --
4048: if g_debug then
4049: hr_utility.set_location(l_proc, 70);
4050: end if;
4051: --
4052: -- No error.
4053: --
4054: close csr_get_ast_details;
4055: end if;
4056: --
4057: if g_debug then
4058: hr_utility.set_location(l_proc, 80);
4059: end if;
4060: end if;
4061: end if;
4062: --
4060: end if;
4061: end if;
4062: --
4063: if g_debug then
4064: hr_utility.set_location(' Leaving:'|| l_proc, 200);
4065: end if;
4066: end chk_assignment_status_type;
4067: --
4068: -- ---------------------------------------------------------------------------
4163: and ast.assignment_status_type_id = asg.assignment_status_type_id;
4164: --
4165: begin
4166: if g_debug then
4167: hr_utility.set_location('Entering:'|| l_proc, 1);
4168: end if;
4169: --
4170: -- Check mandatory parameters have been set.
4171: --
4193: ,p_argument_value => p_rec.business_group_id
4194: );
4195: --
4196: if g_debug then
4197: hr_utility.set_location(l_proc, 10);
4198: end if;
4199: --
4200: -- Check if the assignment is being updated.
4201: --
4203: (p_assignment_id => p_rec.assignment_id
4204: ,p_effective_date => p_effective_date
4205: ,p_object_version_number => p_rec.object_version_number);
4206: if g_debug then
4207: hr_utility.set_location(l_proc, 15);
4208: end if;
4209: --
4210: -- Check if the assignment is being updated.
4211: --
4217: open csr_get_old_per_system_type;
4218: fetch csr_get_old_per_system_type into l_old_per_system_status;
4219: close csr_get_old_per_system_type;
4220: if g_debug then
4221: hr_utility.set_location(l_proc, 20);
4222: end if;
4223: --
4224: -- Check if the assignment is an employee assignment
4225: --
4338: per_asg_shd.g_old_rec.ass_attribute_category
4339: )
4340: then
4341: --
4342: hr_utility.set_message(801, 'HR_7946_ASG_INV_TERM_ASS_UPD');
4343: hr_multi_message.add
4344: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4345: );
4346: --
4380: p_rec.title <> per_asg_shd.g_old_rec.title
4381: )
4382: then
4383: --
4384: hr_utility.set_message(801, 'HR_7946_ASG_INV_TERM_ASS_UPD');
4385: hr_multi_message.add
4386: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4387: );
4388: --
4387: );
4388: --
4389: end if;
4390: if g_debug then
4391: hr_utility.set_location(l_proc, 25);
4392: end if;
4393: --
4394: end if;
4395: --
4400: open csr_get_apl_asg_min_esd;
4401: fetch csr_get_apl_asg_min_esd into l_apl_asg_min_esd;
4402: close csr_get_apl_asg_min_esd;
4403: if g_debug then
4404: hr_utility.set_location(l_proc, 160);
4405: end if;
4406: --
4407: -- Check if the first dt instance of an applicant assignment has an
4408: -- assignment status type PER SYSTEM STATUS of 'TERM_APL'
4410: open csr_get_fir_dt_inst_ast_pss(l_apl_asg_min_esd);
4411: fetch csr_get_fir_dt_inst_ast_pss into l_fir_dt_ast_pss;
4412: close csr_get_fir_dt_inst_ast_pss;
4413: if g_debug then
4414: hr_utility.set_location(l_proc, 170);
4415: end if;
4416: --
4417: If l_fir_dt_ast_pss = 'TERM_APL' then
4418: --
4415: end if;
4416: --
4417: If l_fir_dt_ast_pss = 'TERM_APL' then
4418: --
4419: hr_utility.set_message(801, 'HR_51275_ASG_INV_F_DT_AST_PSS');
4420: hr_multi_message.add
4421: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4422: );
4423: --
4422: );
4423: --
4424: end if;
4425: if g_debug then
4426: hr_utility.set_location(l_proc, 180);
4427: end if;
4428: --
4429: end if;
4430: --
4440: )
4441: or not l_api_updating
4442: then
4443: if g_debug then
4444: hr_utility.set_location(l_proc, 30);
4445: end if;
4446: --
4447: -- Check if the assignment status type exists in
4448: -- PER_ASSIGNMENT_STATUS_TYPES.
4455: ,l_ast_per_system_status;
4456: --
4457: if csr_valid_ast%notfound then
4458: close csr_valid_ast;
4459: hr_utility.set_message(801, 'HR_7940_ASG_INV_ASG_STAT_TYPE');
4460: hr_multi_message.add
4461: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4462: );
4463: else
4463: else
4464: close csr_valid_ast;
4465: end if;
4466: if g_debug then
4467: hr_utility.set_location(l_proc, 40);
4468: end if;
4469: --
4470: -- Check that when set the business group for the assignment status type
4471: -- is the same as the business group of the assignment.
4472: --
4473: If l_business_group_id is not null
4474: and l_business_group_id <> p_rec.business_group_id then
4475: --
4476: hr_utility.set_message(801, 'HR_51207_ASG_INV_AST_BUS_GRP');
4477: hr_multi_message.add
4478: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4479: );
4480: --
4479: );
4480: --
4481: end if;
4482: if g_debug then
4483: hr_utility.set_location(l_proc, 50);
4484: end if;
4485: --
4486: -- Retrieve the legislation code for the business group of the assignment.
4487: --
4488: open csr_get_bus_legislation_code;
4489: fetch csr_get_bus_legislation_code into l_bus_legislation_code;
4490: close csr_get_bus_legislation_code;
4491: if g_debug then
4492: hr_utility.set_location(l_proc, 60);
4493: end if;
4494: --
4495: if l_ast_legislation_code is not null
4496: and (nvl(l_bus_legislation_code, l_ast_legislation_code) <>
4496: and (nvl(l_bus_legislation_code, l_ast_legislation_code) <>
4497: l_ast_legislation_code)
4498: then
4499: --
4500: hr_utility.set_message(801, 'HR_7964_ASG_INV_BUS_ATT_LEG');
4501: hr_multi_message.add;
4502: --
4503: end if;
4504: if g_debug then
4501: hr_multi_message.add;
4502: --
4503: end if;
4504: if g_debug then
4505: hr_utility.set_location(l_proc, 70);
4506: end if;
4507: --
4508: -- Check if the assignment status type exists in
4509: -- PER_ASS_STATUS_TYPE_AMENDS for the assignment business group.
4520: --
4521: end if;
4522: close csr_chk_amends;
4523: if g_debug then
4524: hr_utility.set_location(l_proc, 80);
4525: end if;
4526: --
4527: -- Check that active flag for the assignment status type is set to 'Y'
4528: --
4527: -- Check that active flag for the assignment status type is set to 'Y'
4528: --
4529: If l_active_flag <> 'Y' then
4530: --
4531: hr_utility.set_message(801, 'HR_51206_ASG_INV_AST_ACT_FLG');
4532: hr_multi_message.add
4533: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4534: );
4535: --
4534: );
4535: --
4536: end if;
4537: if g_debug then
4538: hr_utility.set_location(l_proc, 90);
4539: end if;
4540: --
4541: -- Check if the assignment is an employee assignment
4542: --
4553: and l_per_system_status <> 'SUSP_ASSIGN'
4554: and l_per_system_status <> 'TERM_ASSIGN'
4555: then
4556: --
4557: hr_utility.set_message(801, 'HR_7917_ASG_INV_STAT_TYPE');
4558: hr_multi_message.add
4559: (p_associated_column1 =>
4560: 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4561: );
4561: );
4562: --
4563: end if;
4564: if g_debug then
4565: hr_utility.set_location(l_proc, 100);
4566: end if;
4567: --
4568: -- Check that the new PER_SYSTEM_STATUS for the assignment status type
4569: -- of the employee assignment is also 'TERM_ASSIGN' when the existing
4572: if l_old_per_system_status = 'TERM_ASSIGN'
4573: and l_per_system_status <> 'TERM_ASSIGN'
4574: then
4575: --
4576: hr_utility.set_message(801, 'HR_7942_ASG_INV_STAT_NOT_TERM');
4577: hr_multi_message.add
4578: (p_associated_column1 =>
4579: 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4580: );
4580: );
4581: --
4582: end if;
4583: if g_debug then
4584: hr_utility.set_location(l_proc, 110);
4585: end if;
4586: --
4587: -- Check that the change of assignment_status_type_id to represent a
4588: -- per_system_status other than ACTIVE_ASSIGN is not effective as of the
4598: open csr_get_initial_ins_date;
4599: fetch csr_get_initial_ins_date into l_initial_ins_date;
4600: close csr_get_initial_ins_date;
4601: if g_debug then
4602: hr_utility.set_location(l_proc, 120);
4603: end if;
4604: --
4605: if p_validation_start_date <= l_initial_ins_date
4606: then
4604: --
4605: if p_validation_start_date <= l_initial_ins_date
4606: then
4607: --
4608: hr_utility.set_message(800,'HR_7915_ASG_INV_STAT_UPD_DATE');
4609: hr_multi_message.add
4610: (p_associated_column1 =>
4611: 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4612: ,p_associated_column2 =>
4614: );
4615: --
4616: end if;
4617: if g_debug then
4618: hr_utility.set_location(l_proc, 130);
4619: end if;
4620: --
4621: end if;
4622: if g_debug then
4619: end if;
4620: --
4621: end if;
4622: if g_debug then
4623: hr_utility.set_location(l_proc, 150);
4624: end if;
4625: --
4626: else -- Inserting Employee assignment
4627: --
4629: --
4630: if l_per_system_status <> 'ACTIVE_ASSIGN'
4631: then
4632: --
4633: hr_utility.set_message(801, 'HR_7941_ASG_INV_STAT_NOT_ACT');
4634: hr_multi_message.add
4635: (p_associated_column1 =>
4636: 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4637: );
4639: end if;
4640: --
4641: end if;
4642: if g_debug then
4643: hr_utility.set_location(l_proc, 160);
4644: end if;
4645: elsif p_rec.assignment_type = 'B' then
4646: --
4647: --
4654: --
4655: ELSIF p_rec.assignment_type = 'C' THEN
4656: --
4657: if g_debug then
4658: hr_utility.set_location(l_proc, 170);
4659: end if;
4660: --
4661: -- If Updating then check that the assignment status type id
4662: -- is set to either ACTIVE_NPW_ASG or SUSP_NPW_ASG
4663: --
4664: IF l_api_updating THEN
4665: --
4666: if g_debug then
4667: hr_utility.set_location(l_proc, 180);
4668: end if;
4669: --
4670: IF l_per_system_status NOT IN ('ACTIVE_CWK','SUSP_CWK_ASG') AND
4671: l_old_per_system_status = 'ACTIVE_CWK' THEN
4669: --
4670: IF l_per_system_status NOT IN ('ACTIVE_CWK','SUSP_CWK_ASG') AND
4671: l_old_per_system_status = 'ACTIVE_CWK' THEN
4672: --
4673: hr_utility.set_message(801, 'HR_289644_CWL_INV_ASS_STAT_TYP');
4674: hr_utility.raise_error;
4675: --
4676: END IF;
4677: --
4670: IF l_per_system_status NOT IN ('ACTIVE_CWK','SUSP_CWK_ASG') AND
4671: l_old_per_system_status = 'ACTIVE_CWK' THEN
4672: --
4673: hr_utility.set_message(801, 'HR_289644_CWL_INV_ASS_STAT_TYP');
4674: hr_utility.raise_error;
4675: --
4676: END IF;
4677: --
4678: ELSE -- Inserting
4677: --
4678: ELSE -- Inserting
4679: --
4680: if g_debug then
4681: hr_utility.set_location(l_proc, 190);
4682: end if;
4683: --
4684: IF l_per_system_status <> 'ACTIVE_CWK' THEN
4685: --
4682: end if;
4683: --
4684: IF l_per_system_status <> 'ACTIVE_CWK' THEN
4685: --
4686: hr_utility.set_message(801, 'HR_289645_CWK_INV_INS_ASS_TYPE');
4687: hr_utility.raise_error;
4688: --
4689: END IF;
4690: --
4683: --
4684: IF l_per_system_status <> 'ACTIVE_CWK' THEN
4685: --
4686: hr_utility.set_message(801, 'HR_289645_CWK_INV_INS_ASS_TYPE');
4687: hr_utility.raise_error;
4688: --
4689: END IF;
4690: --
4691: END IF;
4706: and l_per_system_status <> 'ACCEPTED'
4707: and l_per_system_status <> 'INTERVIEW1'
4708: and l_per_system_status <> 'INTERVIEW2'
4709: then
4710: hr_utility.set_message(801, 'HR_51232_ASG_INV_AASG_AST');
4711: hr_multi_message.add
4712: (p_associated_column1 =>
4713: 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4714: );
4714: );
4715: --
4716: end if;
4717: if g_debug then
4718: hr_utility.set_location(l_proc, 170);
4719: end if;
4720: --
4721: end if;
4722: --
4723: end if;
4724: --
4725: end if;
4726: if g_debug then
4727: hr_utility.set_location(' Leaving:'|| l_proc, 220);
4728: end if;
4729: --
4730: end chk_assignment_status_type_id;
4731: --
4759: --
4760: begin
4761: --
4762: if g_debug then
4763: hr_utility.set_location('Entering:'|| l_proc, 10);
4764: end if;
4765: --
4766: -- Check mandatory parameters have been set
4767: --
4771:
4772: ,p_argument_value => p_assignment_type
4773: );
4774: if g_debug then
4775: hr_utility.set_location(l_proc, 20);
4776: end if;
4777: --
4778: -- Check if inserting or updating the assignment
4779: --
4782: ,p_effective_date => p_effective_date
4783: ,p_object_version_number => p_object_version_number
4784: );
4785: if g_debug then
4786: hr_utility.set_location(l_proc, 30);
4787: end if;
4788: --
4789: -- Check if inserting or assignment type has changed
4790: --
4794: or
4795: (NOT l_api_updating))
4796: then
4797: if g_debug then
4798: hr_utility.set_location(l_proc, 40);
4799: end if;
4800: --
4801: -- Check that assignment type is either 'E' or 'A'
4802: --
4810: (p_constraint_name => 'PER_ASS_ASSIGNMENT_TYPE_CHK');
4811: --
4812: end if;
4813: if g_debug then
4814: hr_utility.set_location(l_proc, 50);
4815: end if;
4816: --
4817: open csr_get_sys_per_typ;
4818: fetch csr_get_sys_per_typ into l_system_person_type;
4817: open csr_get_sys_per_typ;
4818: fetch csr_get_sys_per_typ into l_system_person_type;
4819: close csr_get_sys_per_typ;
4820: if g_debug then
4821: hr_utility.set_location(l_proc, 60);
4822: end if;
4823: --
4824: -- Check for an applicant or offer assignment
4825: --
4832: if l_system_person_type
4833: not in ('APL', 'APL_EX_APL', 'EMP_APL', 'EX_EMP_APL')
4834: then
4835: --
4836: hr_utility.set_message(801, 'HR_51294_ASG_INV_AASG_PET');
4837: hr_utility.raise_error;
4838: --
4839:
4840: end if;
4833: not in ('APL', 'APL_EX_APL', 'EMP_APL', 'EX_EMP_APL')
4834: then
4835: --
4836: hr_utility.set_message(801, 'HR_51294_ASG_INV_AASG_PET');
4837: hr_utility.raise_error;
4838: --
4839:
4840: end if;
4841: if g_debug then
4838: --
4839:
4840: end if;
4841: if g_debug then
4842: hr_utility.set_location(l_proc, 70);
4843: end if;
4844: --
4845: elsif p_assignment_type = 'B' then -- benefit assignments
4846: --
4853: --
4854: ELSIF p_assignment_type = 'C' THEN
4855: --
4856: if g_debug then
4857: hr_utility.set_location(l_proc, 75);
4858: end if;
4859: --
4860: -- If the person is not a contractor then raise an error
4861: --
4860: -- If the person is not a contractor then raise an error
4861: --
4862: IF NOT hr_general2.is_person_type(p_person_id,'CWK',p_effective_date) THEN
4863: --
4864: hr_utility.set_message(801, 'HR_289646_PER_TYPE_NOT_CWK');
4865: hr_utility.raise_error;
4866: --
4867: END IF;
4868: --
4861: --
4862: IF NOT hr_general2.is_person_type(p_person_id,'CWK',p_effective_date) THEN
4863: --
4864: hr_utility.set_message(801, 'HR_289646_PER_TYPE_NOT_CWK');
4865: hr_utility.raise_error;
4866: --
4867: END IF;
4868: --
4869: else -- employee assignments
4874: if l_system_person_type
4875: not in ('EMP', 'EMP_APL', 'EX_EMP')
4876: then
4877: --
4878: hr_utility.set_message(801, 'HR_51329_ASG_INV_EASG_PET');
4879:
4880: hr_utility.raise_error;
4881: --
4882: end if;
4876: then
4877: --
4878: hr_utility.set_message(801, 'HR_51329_ASG_INV_EASG_PET');
4879:
4880: hr_utility.raise_error;
4881: --
4882: end if;
4883: if g_debug then
4884: hr_utility.set_location(l_proc, 80);
4880: hr_utility.raise_error;
4881: --
4882: end if;
4883: if g_debug then
4884: hr_utility.set_location(l_proc, 80);
4885: end if;
4886: --
4887: end if;
4888: if g_debug then
4885: end if;
4886: --
4887: end if;
4888: if g_debug then
4889: hr_utility.set_location(l_proc, 90);
4890: end if;
4891: --
4892: end if;
4893: if g_debug then
4890: end if;
4891: --
4892: end if;
4893: if g_debug then
4894: hr_utility.set_location(' Leaving:'|| l_proc, 100);
4895: end if;
4896: exception
4897: when app_exception.application_exception then
4898: if hr_multi_message.exception_add
4900: 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4901: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
4902: ) then
4903: if g_debug then
4904: hr_utility.set_location(' Leaving:'|| l_proc, 110);
4905: end if;
4906: raise;
4907: end if;
4908: if g_debug then
4905: end if;
4906: raise;
4907: end if;
4908: if g_debug then
4909: hr_utility.set_location(' Leaving:'|| l_proc, 120);
4910: end if;
4911: --
4912: end chk_assignment_type;
4913: --
4930: l_proc varchar2(72) := g_package||'chk_change_reason';
4931: --
4932: begin
4933: if g_debug then
4934: hr_utility.set_location('Entering:'|| l_proc, 10);
4935: end if;
4936: --
4937: -- Check mandatory arguments
4938: --
4953: ,p_argument => 'validation_end_date'
4954: ,p_argument_value => p_validation_end_date
4955: );
4956: if g_debug then
4957: hr_utility.set_location(l_proc, 20);
4958: end if;
4959: --
4960: l_api_updating := per_asg_shd.api_updating
4961: (p_assignment_id => p_assignment_id
4962: ,p_effective_date => p_effective_date
4963: ,p_object_version_number => p_object_version_number
4964: );
4965: if g_debug then
4966: hr_utility.set_location(l_proc, 30);
4967: end if;
4968: --
4969: if ((l_api_updating and
4970: nvl(per_asg_shd.g_old_rec.change_reason, hr_api.g_varchar2) <>
4972: or
4973: (NOT l_api_updating))
4974: then
4975: if g_debug then
4976: hr_utility.set_location(l_proc, 40);
4977: end if;
4978: --
4979: -- Check if the change reason is set
4980: --
4997: ,p_lookup_code => p_change_reason
4998: )
4999: then
5000: --
5001: hr_utility.set_message(801, 'HR_51228_ASG_INV_EASG_CH_REAS');
5002: hr_utility.raise_error;
5003: --
5004: end if;
5005: if g_debug then
4998: )
4999: then
5000: --
5001: hr_utility.set_message(801, 'HR_51228_ASG_INV_EASG_CH_REAS');
5002: hr_utility.raise_error;
5003: --
5004: end if;
5005: if g_debug then
5006: hr_utility.set_location(l_proc, 50);
5002: hr_utility.raise_error;
5003: --
5004: end if;
5005: if g_debug then
5006: hr_utility.set_location(l_proc, 50);
5007: end if;
5008: --
5009: ELSIF p_assignment_type = 'C' THEN
5010: --
5008: --
5009: ELSIF p_assignment_type = 'C' THEN
5010: --
5011: if g_debug then
5012: hr_utility.set_location(l_proc, 50);
5013: end if;
5014: --
5015: -- Check that the change reason exists in hr_lookups for the
5016: -- lookup type 'CWK_ASSIGN_REASON' with an enabled flag set to 'Y'
5024: ,p_lookup_type => 'CWK_ASSIGN_REASON'
5025: ,p_lookup_code => p_change_reason) THEN
5026: --
5027: if g_debug then
5028: hr_utility.set_location(l_proc, 52);
5029: end if;
5030: --
5031: hr_utility.set_message(800, 'HR_289647_INV_CWK_CH_REASON');
5032: hr_utility.raise_error;
5027: if g_debug then
5028: hr_utility.set_location(l_proc, 52);
5029: end if;
5030: --
5031: hr_utility.set_message(800, 'HR_289647_INV_CWK_CH_REASON');
5032: hr_utility.raise_error;
5033: --
5034: END IF;
5035: --
5028: hr_utility.set_location(l_proc, 52);
5029: end if;
5030: --
5031: hr_utility.set_message(800, 'HR_289647_INV_CWK_CH_REASON');
5032: hr_utility.raise_error;
5033: --
5034: END IF;
5035: --
5036: else -- applicant assignment
5048: ,p_lookup_code => p_change_reason
5049: )
5050: then
5051: --
5052: hr_utility.set_message(801, 'HR_51229_ASG_INV_AASG_CH_REAS');
5053: hr_utility.raise_error;
5054: --
5055: end if;
5056: if g_debug then
5049: )
5050: then
5051: --
5052: hr_utility.set_message(801, 'HR_51229_ASG_INV_AASG_CH_REAS');
5053: hr_utility.raise_error;
5054: --
5055: end if;
5056: if g_debug then
5057: hr_utility.set_location(l_proc, 60);
5053: hr_utility.raise_error;
5054: --
5055: end if;
5056: if g_debug then
5057: hr_utility.set_location(l_proc, 60);
5058: end if;
5059: --
5060: end if;
5061: if g_debug then
5058: end if;
5059: --
5060: end if;
5061: if g_debug then
5062: hr_utility.set_location(l_proc, 70);
5063: end if;
5064: end if;
5065: end if;
5066: --
5064: end if;
5065: end if;
5066: --
5067: if g_debug then
5068: hr_utility.set_location(' Leaving:'|| l_proc, 80);
5069: end if;
5070: exception
5071: when app_exception.application_exception then
5072: if hr_multi_message.exception_add
5072: if hr_multi_message.exception_add
5073: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.CHANGE_REASON'
5074: ) then
5075: if g_debug then
5076: hr_utility.set_location(' Leaving:'|| l_proc, 90);
5077: end if;
5078: raise;
5079: end if;
5080: if g_debug then
5077: end if;
5078: raise;
5079: end if;
5080: if g_debug then
5081: hr_utility.set_location(' Leaving:'|| l_proc, 100);
5082: end if;
5083: --
5084: end chk_change_reason;
5085: --
5143: and pas2.period_of_service_id = ppos2.period_of_service_id ))); -- Added this last filter for Bug 4300591.
5144: --
5145: begin
5146: if g_debug then
5147: hr_utility.set_location('Entering:'|| l_proc, 1);
5148: end if;
5149: --
5150: -- Check mandatory parameters have been set
5151: --
5155: ,p_argument_value => p_primary_flag
5156: );
5157: --
5158: if g_debug then
5159: hr_utility.set_location(l_proc, 2);
5160: end if;
5161: --
5162: -- Check that contiguous non-primary assignment exists
5163: --
5165: open csr_chk_contig_ass;
5166: fetch csr_chk_contig_ass into l_exists;
5167: if csr_chk_contig_ass%notfound then
5168: close csr_chk_contig_ass;
5169: hr_utility.set_message(801, 'HR_7392_ASG_INV_DEL_OF_ASS');
5170: hr_utility.raise_error;
5171: end if;
5172: close csr_chk_contig_ass;
5173: end if;
5166: fetch csr_chk_contig_ass into l_exists;
5167: if csr_chk_contig_ass%notfound then
5168: close csr_chk_contig_ass;
5169: hr_utility.set_message(801, 'HR_7392_ASG_INV_DEL_OF_ASS');
5170: hr_utility.raise_error;
5171: end if;
5172: close csr_chk_contig_ass;
5173: end if;
5174: --
5172: close csr_chk_contig_ass;
5173: end if;
5174: --
5175: if g_debug then
5176: hr_utility.set_location(' Leaving:'|| l_proc, 3);
5177: end if;
5178: exception
5179: when app_exception.application_exception then
5180: if hr_multi_message.exception_add
5181: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
5182: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
5183: ) then
5184: if g_debug then
5185: hr_utility.set_location(' Leaving:'|| l_proc, 4);
5186: end if;
5187: raise;
5188: end if;
5189: if g_debug then
5186: end if;
5187: raise;
5188: end if;
5189: if g_debug then
5190: hr_utility.set_location(' Leaving:'|| l_proc, 5);
5191: end if;
5192: end chk_contig_ass;
5193: --
5194: -- ---------------------------------------------------------------------------
5218: where assignment_id = p_assignment_id;
5219: --
5220: begin
5221: if g_debug then
5222: hr_utility.set_location('Entering:'|| l_proc, 10);
5223: end if;
5224: --
5225: -- Check mandatory parameters have been set
5226: --
5241: ,p_argument => 'effective_date'
5242: ,p_argument_value => p_effective_date
5243: );
5244: if g_debug then
5245: hr_utility.set_location(l_proc, 20);
5246: end if;
5247: --
5248: -- Only proceed with validation if :
5249: -- a) The current g_old_rec is current and
5260: or
5261: (NOT l_api_updating))
5262: then
5263: if g_debug then
5264: hr_utility.set_location(l_proc, 30);
5265: end if;
5266: --
5267: -- Check if date probation end is not null
5268: --
5279: open csr_get_min_asg_esd;
5280: fetch csr_get_min_asg_esd into l_min_effective_start_date;
5281: close csr_get_min_asg_esd;
5282: if g_debug then
5283: hr_utility.set_location(l_proc, 40);
5284: end if;
5285: --
5286: if p_date_probation_end < l_min_effective_start_date then
5287: --
5284: end if;
5285: --
5286: if p_date_probation_end < l_min_effective_start_date then
5287: --
5288: hr_utility.set_message(801, 'HR_51147_ASG_DPE_BEF_MIN_ESD');
5289: hr_multi_message.add
5290: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.DATE_PROBATION_END'
5291: );
5292: --
5291: );
5292: --
5293: end if;
5294: if g_debug then
5295: hr_utility.set_location(l_proc, 50);
5296: end if;
5297: --
5298: else
5299: --
5301: -- validation start date on insert.
5302: --
5303: if p_date_probation_end < p_validation_start_date then
5304: --
5305: hr_utility.set_message(801, 'HR_51147_ASG_DPE_BEF_MIN_ESD');
5306: hr_multi_message.add
5307: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.DATE_PROBATION_END'
5308: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
5309: );
5309: );
5310: --
5311: end if;
5312: if g_debug then
5313: hr_utility.set_location(l_proc, 60);
5314: end if;
5315: --
5316: end if;
5317: if g_debug then
5314: end if;
5315: --
5316: end if;
5317: if g_debug then
5318: hr_utility.set_location(l_proc, 70);
5319: end if;
5320: --
5321: end if;
5322: if g_debug then
5319: end if;
5320: --
5321: end if;
5322: if g_debug then
5323: hr_utility.set_location(l_proc, 80);
5324: end if;
5325: --
5326: end if;
5327: --
5325: --
5326: end if;
5327: --
5328: if g_debug then
5329: hr_utility.set_location(' Leaving:'|| l_proc, 90);
5330: end if;
5331: --
5332: end chk_date_probation_end;
5333: --
5359: and nvl(end_date_active,hr_api.g_eot);
5360: --
5361: begin
5362: if g_debug then
5363: hr_utility.set_location('Entering:'|| l_proc, 10);
5364: end if;
5365: --
5366: -- Check mandatory parameters have been set
5367: --
5370: ,p_argument => 'effective_date'
5371: ,p_argument_value => p_effective_date
5372: );
5373: if g_debug then
5374: hr_utility.set_location(l_proc, 20);
5375: end if;
5376: --
5377: -- Only proceed with validation if :
5378: -- a) The current g_old_rec is current and
5383: ,p_effective_date => p_effective_date
5384: ,p_object_version_number => p_object_version_number
5385: );
5386: if g_debug then
5387: hr_utility.set_location(l_proc, 30);
5388: end if;
5389: --
5390: if ((l_api_updating and
5391: nvl(per_asg_shd.g_old_rec.default_code_comb_id, hr_api.g_number) <>
5392: nvl(p_default_code_comb_id, hr_api.g_number)) or
5393: (NOT l_api_updating))
5394: then
5395: if g_debug then
5396: hr_utility.set_location(l_proc, 40);
5397: end if;
5398: --
5399: -- Check if default code comb is not null
5400: --
5409: -- modified to allow offer to have this set
5410: --
5411: if p_assignment_type not in ('E','A','B','C','O') then
5412: --
5413: hr_utility.set_message(801, 'HR_51177_ASG_INV_ASG_TYP_DCC');
5414: hr_multi_message.add
5415: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.DEFAULT_CODE_COMB_ID'
5416: );
5417: --
5416: );
5417: --
5418: end if;
5419: if g_debug then
5420: hr_utility.set_location(l_proc, 50);
5421: end if;
5422: --
5423: -- Check that the default code comb exists in GL_CODE_COMBINATIONS
5424: --
5425: open csr_valid_def_cod_comb;
5426: fetch csr_valid_def_cod_comb into l_exists;
5427: if csr_valid_def_cod_comb%notfound then
5428: close csr_valid_def_cod_comb;
5429: hr_utility.set_message(801, 'HR_51148_ASG_INV_DEF_COD_COM');
5430: hr_multi_message.add
5431: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.DEFAULT_CODE_COMB_ID'
5432: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
5433: );
5435: else
5436: close csr_valid_def_cod_comb;
5437: end if;
5438: if g_debug then
5439: hr_utility.set_location(l_proc, 60);
5440: end if;
5441: --
5442: end if;
5443: --
5442: end if;
5443: --
5444: end if;
5445: if g_debug then
5446: hr_utility.set_location(' Leaving:'|| l_proc, 70);
5447: end if;
5448: end chk_default_code_comb_id;
5449: --
5450: -- ---------------------------------------------------------------------------
5490: --
5491: begin
5492: if g_debug then
5493: l_proc := g_package||'chk_del_organization_id';
5494: hr_utility.set_location('Entering:'|| l_proc, 1);
5495: end if;
5496: --
5497: if p_manager_flag = 'Y' then
5498: --
5506: )
5507: then
5508: --
5509: if g_debug then
5510: hr_utility.set_location(l_proc, 3);
5511: end if;
5512: --
5513: p_org_now_no_manager_warning := TRUE;
5514: end if;
5514: end if;
5515: end if;
5516: --
5517: if g_debug then
5518: hr_utility.set_location(' Leaving:'|| l_proc, 4);
5519: end if;
5520: end chk_del_organization_id;
5521: --
5522: -- ---------------------------------------------------------------------------
5539: l_api_updating boolean;
5540: --
5541: begin
5542: if g_debug then
5543: hr_utility.set_location('Entering:'|| l_proc, 10);
5544: end if;
5545: --
5546: -- Check mandatory parameters have been set
5547: --
5562: ,p_argument => 'validation_end_date'
5563: ,p_argument_value => p_validation_end_date
5564: );
5565: if g_debug then
5566: hr_utility.set_location(l_proc, 20);
5567: end if;
5568: --
5569: l_api_updating := per_asg_shd.api_updating
5570: (p_assignment_id => p_assignment_id
5571: ,p_effective_date => p_effective_date
5572: ,p_object_version_number => p_object_version_number
5573: );
5574: if g_debug then
5575: hr_utility.set_location(l_proc, 30);
5576: end if;
5577: --
5578: if ((l_api_updating and
5579: nvl(per_asg_shd.g_old_rec.employment_category, hr_api.g_varchar2) <>
5580: nvl(p_employment_category, hr_api.g_varchar2))
5581: or (NOT l_api_updating))
5582: then
5583: if g_debug then
5584: hr_utility.set_location(l_proc, 40);
5585: end if;
5586: --
5587: if p_employment_category is not null then
5588: --
5589: -- Check that the assignment is of a valid type.
5590: --
5591: if p_assignment_type not in ('E','A','B','C','O') then
5592: --
5593: hr_utility.set_message(801, 'HR_51217_ASG_INV_ASG_TYP_ECAT');
5594: hr_utility.raise_error;
5595: --
5596: end if;
5597: if g_debug then
5590: --
5591: if p_assignment_type not in ('E','A','B','C','O') then
5592: --
5593: hr_utility.set_message(801, 'HR_51217_ASG_INV_ASG_TYP_ECAT');
5594: hr_utility.raise_error;
5595: --
5596: end if;
5597: if g_debug then
5598: hr_utility.set_location(l_proc, 50);
5594: hr_utility.raise_error;
5595: --
5596: end if;
5597: if g_debug then
5598: hr_utility.set_location(l_proc, 50);
5599: end if;
5600: --
5601: -- Check that the employment category exists in hr_lookups for the
5602: -- lookup type 'EMP_CAT' with an enabled flag set to 'Y' and that
5619: --
5620: -- Use the employment category for non-contingent worker assignments.
5621: --
5622: if g_debug then
5623: hr_utility.set_location(l_proc, 60);
5624: end if;
5625:
5626: if hr_api.not_exists_in_leg_lookups
5627: (p_effective_date => p_effective_date
5629: ,p_lookup_code => p_employment_category
5630: )
5631: then
5632: --
5633: hr_utility.set_message(801, 'HR_51028_ASG_INV_EMP_CATEGORY');
5634: hr_utility.raise_error;
5635: --
5636: end if;
5637:
5630: )
5631: then
5632: --
5633: hr_utility.set_message(801, 'HR_51028_ASG_INV_EMP_CATEGORY');
5634: hr_utility.raise_error;
5635: --
5636: end if;
5637:
5638: elsif p_assignment_type = 'C' then
5645: -- Here the assignment category chk procedure is called to validate
5646: -- for contingent workers.
5647: --
5648: if g_debug then
5649: hr_utility.set_location(l_proc, 65);
5650: end if;
5651:
5652: per_asg_bus1.chk_assignment_category
5653: (p_assignment_id => p_assignment_id
5661: end if;
5662: --
5663: end if;
5664: if g_debug then
5665: hr_utility.set_location(l_proc, 70);
5666: end if;
5667: --
5668: end if;
5669: --
5667: --
5668: end if;
5669: --
5670: if g_debug then
5671: hr_utility.set_location(' Leaving:'|| l_proc, 80);
5672: end if;
5673: exception
5674: when app_exception.application_exception then
5675: if hr_multi_message.exception_add
5675: if hr_multi_message.exception_add
5676: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EMPLOYMENT_CATEGORY'
5677: ) then
5678: if g_debug then
5679: hr_utility.set_location(' Leaving:'|| l_proc, 90);
5680: end if;
5681: raise;
5682: end if;
5683: if g_debug then
5680: end if;
5681: raise;
5682: end if;
5683: if g_debug then
5684: hr_utility.set_location(' Leaving:'|| l_proc, 100);
5685: end if;
5686: end chk_employment_category;
5687: --
5688: -- ---------------------------------------------------------------------------
5704: l_proc varchar2(72) := g_package||'chk_frequency';
5705: --
5706: begin
5707: if g_debug then
5708: hr_utility.set_location('Entering:'|| l_proc, 10);
5709: end if;
5710: --
5711: -- Check mandatory parameters
5712: --
5727: ,p_argument => 'validation_end_date'
5728: ,p_argument_value => p_validation_end_date
5729: );
5730: if g_debug then
5731: hr_utility.set_location(l_proc, 20);
5732: end if;
5733: --
5734: -- Only proceed with validation if :
5735: -- a) The current g_old_rec is current and
5740: ,p_effective_date => p_effective_date
5741: ,p_object_version_number => p_object_version_number
5742: );
5743: if g_debug then
5744: hr_utility.set_location(l_proc, 30);
5745: end if;
5746: --
5747: if ((l_api_updating and
5748: nvl(per_asg_shd.g_old_rec.frequency, hr_api.g_varchar2) <>
5749: nvl(p_frequency, hr_api.g_varchar2)) or
5750: (NOT l_api_updating))
5751: then
5752: if g_debug then
5753: hr_utility.set_location(l_proc||' '||p_frequency, 40);
5754: end if;
5755: --
5756: -- Check if frequency is set.
5757: --
5770: ,p_lookup_code => p_frequency
5771: )
5772: then
5773: --
5774: hr_utility.set_message(801, 'HR_7388_ASG_INVALID_FREQUENCY');
5775: hr_utility.raise_error;
5776: --
5777: end if;
5778: if g_debug then
5771: )
5772: then
5773: --
5774: hr_utility.set_message(801, 'HR_7388_ASG_INVALID_FREQUENCY');
5775: hr_utility.raise_error;
5776: --
5777: end if;
5778: if g_debug then
5779: hr_utility.set_location(l_proc, 60);
5775: hr_utility.raise_error;
5776: --
5777: end if;
5778: if g_debug then
5779: hr_utility.set_location(l_proc, 60);
5780: end if;
5781: --
5782: end if;
5783: if g_debug then
5780: end if;
5781: --
5782: end if;
5783: if g_debug then
5784: hr_utility.set_location(l_proc, 70);
5785: end if;
5786: --
5787: end if;
5788: --
5786: --
5787: end if;
5788: --
5789: if g_debug then
5790: hr_utility.set_location(' Leaving:'|| l_proc, 80);
5791: end if;
5792: exception
5793: when app_exception.application_exception then
5794: if hr_multi_message.exception_add
5794: if hr_multi_message.exception_add
5795: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.FREQUENCY'
5796: ) then
5797: if g_debug then
5798: hr_utility.set_location(' Leaving:'|| l_proc, 90);
5799: end if;
5800: raise;
5801: end if;
5802: if g_debug then
5799: end if;
5800: raise;
5801: end if;
5802: if g_debug then
5803: hr_utility.set_location(' Leaving:'|| l_proc, 100);
5804: end if;
5805: end chk_frequency;
5806: --
5807: -- ---------------------------------------------------------------------------
5850: and primary_flag = 'Y';
5851: --
5852: begin
5853: if g_debug then
5854: hr_utility.set_location('Entering:'|| l_proc, 1);
5855: end if;
5856: --
5857: -- Check mandatory parameters have been set
5858: --
5862: ,p_argument_value => p_primary_flag
5863: );
5864: --
5865: if g_debug then
5866: hr_utility.set_location(l_proc, 2);
5867: end if;
5868: --
5869: if p_datetrack_mode = 'DELETE' and
5870: p_primary_flag = 'N' then
5871: open csr_chk_fut_prim;
5872: fetch csr_chk_fut_prim into l_exists;
5873: if csr_chk_fut_prim%found then
5874: close csr_chk_fut_prim;
5875: hr_utility.set_message(801, 'HR_7399_ASG_NO_DEL_NON_PRIM');
5876: hr_utility.raise_error;
5877: end if;
5878: close csr_chk_fut_prim;
5879: end if;
5872: fetch csr_chk_fut_prim into l_exists;
5873: if csr_chk_fut_prim%found then
5874: close csr_chk_fut_prim;
5875: hr_utility.set_message(801, 'HR_7399_ASG_NO_DEL_NON_PRIM');
5876: hr_utility.raise_error;
5877: end if;
5878: close csr_chk_fut_prim;
5879: end if;
5880: --
5878: close csr_chk_fut_prim;
5879: end if;
5880: --
5881: if g_debug then
5882: hr_utility.set_location(' Leaving:'|| l_proc, 3);
5883: end if;
5884: exception
5885: when app_exception.application_exception then
5886: if hr_multi_message.exception_add
5886: if hr_multi_message.exception_add
5887: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID'
5888: ) then
5889: if g_debug then
5890: hr_utility.set_location(' Leaving:'|| l_proc, 4);
5891: end if;
5892: raise;
5893: end if;
5894: if g_debug then
5891: end if;
5892: raise;
5893: end if;
5894: if g_debug then
5895: hr_utility.set_location(' Leaving:'|| l_proc, 5);
5896: end if;
5897: end chk_future_primary;
5898: --
5899: -- ---------------------------------------------------------------------------
5928: between date_from and nvl(date_to, hr_api.g_eot);
5929: --
5930: begin
5931: if g_debug then
5932: hr_utility.set_location('Entering:'|| l_proc, 10);
5933: end if;
5934: --
5935: --
5936: -- Check mandatory parameters have been set
5958: ,p_argument => 'business_group_id'
5959: ,p_argument_value => p_business_group_id
5960: );
5961: if g_debug then
5962: hr_utility.set_location(l_proc, 20);
5963: end if;
5964: --
5965: -- Only proceed with validation if :
5966: -- a) The current g_old_rec is current and
5971: ,p_effective_date => p_effective_date
5972: ,p_object_version_number => p_object_version_number
5973: );
5974: if g_debug then
5975: hr_utility.set_location(l_proc, 30);
5976: end if;
5977: --
5978: if ((l_api_updating and
5979: nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>
5979: nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>
5980: nvl(p_grade_id, hr_api.g_number)) or
5981: (NOT l_api_updating)) then
5982: if g_debug then
5983: hr_utility.set_location(l_proc, 40);
5984: end if;
5985: --
5986: -- Check if the grade is set.
5987: --
5993: open csr_valid_grade;
5994: fetch csr_valid_grade into l_business_group_id;
5995: if csr_valid_grade%notfound then
5996: close csr_valid_grade;
5997: hr_utility.set_message(801, 'HR_7393_ASG_INVALID_GRADE');
5998: hr_multi_message.add
5999: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
6000: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
6001: );
6003: else
6004: close csr_valid_grade;
6005: end if;
6006: if g_debug then
6007: hr_utility.set_location(l_proc, 50);
6008: end if;
6009: --
6010: -- Check that the business group for the grade is the same
6011: -- as that of the assignment
6011: -- as that of the assignment
6012: --
6013: if l_business_group_id <> p_business_group_id then
6014: --
6015: hr_utility.set_message(801, 'HR_7371_ASG_INVALID_BG_GRADE');
6016: hr_multi_message.add
6017: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
6018: );
6019: --
6018: );
6019: --
6020: end if;
6021: if g_debug then
6022: hr_utility.set_location(l_proc, 60);
6023: end if;
6024: --
6025: elsif p_special_ceiling_step_id is not null then
6026: -- When grade is null special ceiling step should be null
6024: --
6025: elsif p_special_ceiling_step_id is not null then
6026: -- When grade is null special ceiling step should be null
6027: --
6028: hr_utility.set_message(801, 'HR_7434_ASG_GRADE_REQUIRED');
6029: hr_multi_message.add
6030: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
6031: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'
6032: );
6032: );
6033: --
6034: end if;
6035: if g_debug then
6036: hr_utility.set_location(l_proc, 80);
6037: end if;
6038: --
6039: end if;
6040: if g_debug then
6037: end if;
6038: --
6039: end if;
6040: if g_debug then
6041: hr_utility.set_location(' Leaving:'|| l_proc, 110);
6042: end if;
6043: --
6044: end chk_grade_id;
6045: --
6094: -- Bug 33552211 End Here
6095: --
6096: begin
6097: if g_debug then
6098: hr_utility.set_location('Entering:'|| l_proc, 10);
6099: end if;
6100: --
6101: --
6102: -- Check mandatory arguments
6118: ,p_argument => 'validation_end_date'
6119: ,p_argument_value => p_validation_end_date
6120: );
6121: if g_debug then
6122: hr_utility.set_location(l_proc, 20);
6123: end if;
6124: --
6125: -- Check if the assignment is being updated.
6126: --
6129: ,p_effective_date => p_effective_date
6130: ,p_object_version_number => p_object_version_number
6131: );
6132: if g_debug then
6133: hr_utility.set_location(l_proc, 30);
6134: end if;
6135: --
6136: -- Only proceed with validation if :
6137: -- a) The current g_old_rec is current and
6142: hr_api.g_number) <> nvl(p_job_id, hr_api.g_number))
6143: or
6144: NOT l_api_updating) then
6145: if g_debug then
6146: hr_utility.set_location(l_proc, 40);
6147: end if;
6148: --
6149: -- Check if job is set
6150: --
6156: open csr_valid_job;
6157: fetch csr_valid_job into l_business_group_id;
6158: if csr_valid_job%notfound then
6159: close csr_valid_job;
6160: hr_utility.set_message(801, 'HR_51172_ASG_INV_DT_JOB');
6161: hr_multi_message.add
6162: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
6163: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
6164: );
6166: else
6167: close csr_valid_job;
6168: end if;
6169: if g_debug then
6170: hr_utility.set_location(l_proc, 50);
6171: end if;
6172: --
6173: -- Check that the job is in the same business group as the job of the
6174: -- assignment date effectively.
6174: -- assignment date effectively.
6175: --
6176: If p_business_group_id <> l_business_group_id then
6177: --
6178: hr_utility.set_message(801, 'HR_51173_ASG_INV_DT_JOB_BG');
6179: hr_multi_message.add
6180: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
6181: );
6182: --
6181: );
6182: --
6183: end if;
6184: if g_debug then
6185: hr_utility.set_location(l_proc, 60);
6186: end if;
6187: --
6188: end if;
6189: if g_debug then
6186: end if;
6187: --
6188: end if;
6189: if g_debug then
6190: hr_utility.set_location(l_proc, 70);
6191: end if;
6192: --
6193: end if;
6194: if g_debug then
6191: end if;
6192: --
6193: end if;
6194: if g_debug then
6195: hr_utility.set_location(' Leaving:'|| l_proc, 100);
6196: end if;
6197: --
6198: end chk_job_id;
6199: --
6252: and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
6253:
6254: begin
6255: if g_debug then
6256: hr_utility.set_location('Entering:'|| l_proc, 10);
6257: end if;
6258: --
6259: if hr_multi_message.no_exclusive_error
6260: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
6280: ,p_argument => 'validation_end_date'
6281: ,p_argument_value => p_validation_end_date
6282: );
6283: if g_debug then
6284: hr_utility.set_location(l_proc, 20);
6285: end if;
6286: --
6287: -- Check if the assignment is being updated.
6288: --
6291: ,p_effective_date => p_effective_date
6292: ,p_object_version_number => p_object_version_number
6293: );
6294: if g_debug then
6295: hr_utility.set_location(l_proc, 30);
6296: end if;
6297: --
6298: -- Only proceed with validation if :
6299: -- a) The current g_old_rec is current and
6308: <> nvl(p_grade_id, hr_api.g_number))))
6309: or
6310: NOT l_api_updating then
6311: if g_debug then
6312: hr_utility.set_location(l_proc, 40);
6313: end if;
6314: --
6315: -- Check that both job and grade are set.
6316: --
6342: --
6343: -- Bug 3566686 Ends Here
6344: --
6345: if g_debug then
6346: hr_utility.set_location(l_proc, 50);
6347: end if;
6348: --
6349: end if;
6350: if g_debug then
6347: end if;
6348: --
6349: end if;
6350: if g_debug then
6351: hr_utility.set_location(l_proc, 60);
6352: end if;
6353: --
6354: end if;
6355: end if;
6373: end if;
6374: -- End of fix for the issue in the bug#8857145
6375:
6376: if g_debug then
6377: hr_utility.set_location(' Leaving:'|| l_proc, 70);
6378: end if;
6379: end chk_job_id_grade_id;
6380:
6381: -- Start changes for bug 11063182
6457: -- Bug 4116879 Ends
6458: --
6459: begin
6460: if g_debug then
6461: hr_utility.set_location('Entering:'|| l_proc, 10);
6462: end if;
6463: --
6464: --
6465: -- Check mandatory parameters have been set
6481: ,p_argument => 'validation_end_date'
6482: ,p_argument_value => p_validation_end_date
6483: );
6484: if g_debug then
6485: hr_utility.set_location('Entering:'|| l_proc, 20);
6486: end if;
6487: --
6488: -- Only proceed with validation if :
6489: -- a) The current g_old_rec is current and
6494: ,p_effective_date => p_effective_date
6495: ,p_object_version_number => p_object_version_number
6496: );
6497: if g_debug then
6498: hr_utility.set_location('Entering:'|| l_proc, 30);
6499: end if;
6500: --
6501: if ((l_api_updating and
6502: nvl(per_asg_shd.g_old_rec.location_id, hr_api.g_number) <>
6504: (NOT l_api_updating))
6505: then
6506: --
6507: if g_debug then
6508: hr_utility.set_location('Entering:'|| l_proc, 40);
6509: end if;
6510: --
6511: if p_location_id is not null then
6512: --
6517: open csr_valid_location_upd;
6518: fetch csr_valid_location_upd into l_inactive_date;
6519: if csr_valid_location_upd%notfound then
6520: close csr_valid_location_upd;
6521: hr_utility.set_message(801, 'HR_7382_ASG_NON_EXIST_LOCATION');
6522: hr_multi_message.add
6523: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.LOCATION_ID');
6524: --
6525: else
6529: open csr_valid_location_ins;
6530: fetch csr_valid_location_ins into l_inactive_date;
6531: if csr_valid_location_ins%notfound then
6532: close csr_valid_location_ins;
6533: hr_utility.set_message(801, 'HR_7382_ASG_NON_EXIST_LOCATION');
6534: hr_multi_message.add
6535: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.LOCATION_ID');
6536: --
6537: else
6540: end if;
6541: -- Bug 4116879 Ends
6542: --
6543: if g_debug then
6544: hr_utility.set_location('Entering:'|| l_proc, 50);
6545: end if;
6546: --
6547: -- Check if the assignment ESD is before the location inactive date
6548: -- on insert
6549: --
6550: if p_validation_start_date >= nvl(l_inactive_date,hr_api.g_eot)
6551: then
6552: --
6553: hr_utility.set_message(801, 'HR_51215_ASG_INACT_LOCATION');
6554: hr_multi_message.add
6555: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.LOCATION_ID'
6556: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
6557: );
6557: );
6558: --
6559: end if;
6560: if g_debug then
6561: hr_utility.set_location('Entering:'|| l_proc, 60);
6562: end if;
6563: --
6564: end if;
6565: --
6565: --
6566: end if;
6567: --
6568: if g_debug then
6569: hr_utility.set_location('Entering:'|| l_proc, 90);
6570: end if;
6571: end chk_location_id;
6572: --
6573: -- ---------------------------------------------------------------------------
6590: l_api_updating boolean;
6591: --
6592: begin
6593: if g_debug then
6594: hr_utility.set_location('Entering:'|| l_proc, 10);
6595: end if;
6596: --
6597: -- Check mandatory parameters have been set
6598: --
6607: ,p_argument => 'organization_id'
6608: ,p_argument_value => p_organization_id
6609: );
6610: if g_debug then
6611: hr_utility.set_location(l_proc, 20);
6612: end if;
6613: --
6614: -- Only proceed with validation if :
6615: -- a) The current g_old_rec is current and
6620: ,p_effective_date => p_effective_date
6621: ,p_object_version_number => p_object_version_number
6622: );
6623: if g_debug then
6624: hr_utility.set_location(l_proc, 30);
6625: end if;
6626: --
6627: if ((l_api_updating and
6628: nvl(per_asg_shd.g_old_rec.manager_flag, hr_api.g_varchar2) <>
6630: or
6631: (NOT l_api_updating))
6632: then
6633: if g_debug then
6634: hr_utility.set_location(l_proc, 40);
6635: end if;
6636: --
6637: -- Check if manager flag is set and is either 'Y' or 'N'.
6638: --
6642: --
6643: per_asg_shd.constraint_error
6644: (p_constraint_name => 'PER_ASS_MANAGER_FLAG_CHK');
6645: if g_debug then
6646: hr_utility.set_location(l_proc, 50);
6647: end if;
6648: --
6649: end if;
6650: if g_debug then
6647: end if;
6648: --
6649: end if;
6650: if g_debug then
6651: hr_utility.set_location(l_proc, 60);
6652: end if;
6653: --
6654: -- Check if the assignment is an employee assignment.
6655: --
6731: --
6732: end if;
6733: --
6734: if g_debug then
6735: hr_utility.set_location(' Leaving:'|| l_proc, 110);
6736: end if;
6737: --
6738: end chk_manager_flag;
6739: --
6754: l_proc varchar2(72) := g_package||'chk_frequency_normal_hours';
6755: --
6756: begin
6757: if g_debug then
6758: hr_utility.set_location('Entering:'|| l_proc, 10);
6759: end if;
6760: --
6761: if hr_multi_message.no_all_inclusive_error
6762: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.FREQUENCY'
6769: ,p_argument => 'effective_date'
6770: ,p_argument_value => p_effective_date
6771: );
6772: if g_debug then
6773: hr_utility.set_location(l_proc, 20);
6774: end if;
6775: --
6776: -- Only proceed with validation if :
6777: -- a) The current g_old_rec is current and
6782: ,p_effective_date => p_effective_date
6783: ,p_object_version_number => p_object_version_number
6784: );
6785: if g_debug then
6786: hr_utility.set_location(l_proc, 30);
6787: end if;
6788: --
6789: if (l_api_updating and
6790: ((nvl(per_asg_shd.g_old_rec.frequency, hr_api.g_varchar2) <>
6795: or
6796: (NOT l_api_updating)
6797: then
6798: if g_debug then
6799: hr_utility.set_location(l_proc, 40);
6800: end if;
6801: --
6802: -- Check if normal hours is set
6803: --
6802: -- Check if normal hours is set
6803: --
6804: If p_frequency is not null and p_normal_hours is null then
6805: --
6806: hr_utility.set_message(801, 'HR_7387_ASG_NORMAL_HOURS_REQD');
6807: hr_utility.raise_error;
6808: --
6809: elsif p_normal_hours is not null and p_frequency is null then
6810: --
6803: --
6804: If p_frequency is not null and p_normal_hours is null then
6805: --
6806: hr_utility.set_message(801, 'HR_7387_ASG_NORMAL_HOURS_REQD');
6807: hr_utility.raise_error;
6808: --
6809: elsif p_normal_hours is not null and p_frequency is null then
6810: --
6811: hr_utility.set_message(801, 'HR_7396_ASG_FREQUENCY_REQD');
6807: hr_utility.raise_error;
6808: --
6809: elsif p_normal_hours is not null and p_frequency is null then
6810: --
6811: hr_utility.set_message(801, 'HR_7396_ASG_FREQUENCY_REQD');
6812: hr_utility.raise_error;
6813: --
6814: elsif p_frequency is not null and p_normal_hours is not null then
6815: --
6808: --
6809: elsif p_normal_hours is not null and p_frequency is null then
6810: --
6811: hr_utility.set_message(801, 'HR_7396_ASG_FREQUENCY_REQD');
6812: hr_utility.raise_error;
6813: --
6814: elsif p_frequency is not null and p_normal_hours is not null then
6815: --
6816: -- Check that value for working_hours does not
6820: (p_frequency => p_frequency
6821: ,p_normal_hours => p_normal_hours
6822: );
6823: if g_debug then
6824: hr_utility.set_location(l_proc, 50);
6825: end if;
6826: --
6827: end if;
6828: if g_debug then
6825: end if;
6826: --
6827: end if;
6828: if g_debug then
6829: hr_utility.set_location(l_proc, 60);
6830: end if;
6831: --
6832: end if;
6833: end if;
6832: end if;
6833: end if;
6834: --
6835: if g_debug then
6836: hr_utility.set_location(' Leaving:'|| l_proc, 70);
6837: end if;
6838: exception
6839: when app_exception.application_exception then
6840: if hr_multi_message.exception_add
6841: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.FREQUENCY'
6842: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.NORMAL_HOURS'
6843: ) then
6844: if g_debug then
6845: hr_utility.set_location(' Leaving:'|| l_proc, 80);
6846: end if;
6847: raise;
6848: end if;
6849: if g_debug then
6846: end if;
6847: raise;
6848: end if;
6849: if g_debug then
6850: hr_utility.set_location(' Leaving:'|| l_proc, 90);
6851: end if;
6852: end chk_frequency_normal_hours;
6853: --
6854: -- ---------------------------------------------------------------------------
6892: where organization_id = p_organization_id;
6893: --
6894: begin
6895: if g_debug then
6896: hr_utility.set_location('Entering:'|| l_proc, 10);
6897: end if;
6898: --
6899: --
6900: -- Check mandatory parameters have been set
6928: ,p_argument => 'validation_end_date'
6929: ,p_argument_value => p_validation_end_date
6930: );
6931: if g_debug then
6932: hr_utility.set_location(l_proc, 20);
6933: end if;
6934: --
6935: -- Only proceed with validation if :
6936: -- a) The current g_old_rec is current and
6941: ,p_effective_date => p_effective_date
6942: ,p_object_version_number => p_object_version_number
6943: );
6944: if g_debug then
6945: hr_utility.set_location(l_proc, 30);
6946: end if;
6947: --
6948: if (l_api_updating and
6949: per_asg_shd.g_old_rec.organization_id <> p_organization_id)
6950: or
6951: NOT l_api_updating
6952: then
6953: if g_debug then
6954: hr_utility.set_location(l_proc, 40);
6955: end if;
6956:
6957: --
6958: -- Check that organization exists and is date effective
6962: fetch csr_valid_int_hr_org into l_business_group_id;
6963: --
6964: if csr_valid_int_hr_org%notfound then
6965: close csr_valid_int_hr_org;
6966: hr_utility.set_message(801, 'HR_34983_ASG_INVALID_ORG');
6967: hr_multi_message.add
6968: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID'
6969: );
6970: --
6971: else
6972: close csr_valid_int_hr_org;
6973: end if;
6974: if g_debug then
6975: hr_utility.set_location(l_proc, 50);
6976: end if;
6977: --
6978: -- Check that the organization is in the same business group
6979: -- as the business group of the assignment.
6979: -- as the business group of the assignment.
6980: --
6981: If p_business_group_id <> l_business_group_id then
6982: --
6983: hr_utility.set_message(801, 'HR_7376_ASG_INVALID_BG_ORG');
6984: hr_multi_message.add
6985: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID'
6986: );
6987: --
6986: );
6987: --
6988: end if;
6989: if g_debug then
6990: hr_utility.set_location(l_proc, 60);
6991: end if;
6992: --
6993: -- Check if an insert is taking place.
6994: --
7006: open csr_valid_per_org;
7007: fetch csr_valid_per_org into l_exists;
7008: if csr_valid_per_org%notfound then
7009: close csr_valid_per_org;
7010: hr_utility.set_message(801, 'HR_51277_ASG_INV_HR_ORG');
7011: hr_multi_message.add
7012: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID'
7013: );
7014: --
7015: else
7016: close csr_valid_per_org;
7017: end if;
7018: if g_debug then
7019: hr_utility.set_location(l_proc, 70);
7020: end if;
7021: --
7022: end if;
7023: --
7045: )
7046: then
7047: --
7048: if g_debug then
7049: hr_utility.set_location(l_proc, 100);
7050: end if;
7051: --
7052: p_other_manager_warning := TRUE;
7053: else
7052: p_other_manager_warning := TRUE;
7053: else
7054: --
7055: if g_debug then
7056: hr_utility.set_location(l_proc, 110);
7057: end if;
7058: --
7059: p_org_now_no_manager_warning := TRUE;
7060: end if;
7063: end if; -- no exclusive error
7064: --
7065: end if; -- p_assignment_type = 'E'
7066: if g_debug then
7067: hr_utility.set_location(l_proc, 130);
7068: end if;
7069: --
7070: end if;
7071: --
7070: end if;
7071: --
7072: --
7073: if g_debug then
7074: hr_utility.set_location(' Leaving:'|| l_proc, 140);
7075: end if;
7076: end chk_organization_id;
7077: --
7078: --
7121: l_bargaining_unit_code varchar2(72);
7122: --
7123: begin
7124: if g_debug then
7125: hr_utility.set_location('Entering:'|| l_proc, 10);
7126: end if;
7127: --
7128: -- Check mandatory parameters have been set
7129: --
7132: ,p_argument => 'effective_date'
7133: ,p_argument_value => p_effective_date
7134: );
7135: if g_debug then
7136: hr_utility.set_location(l_proc, 20);
7137: end if;
7138: --
7139: if p_bargaining_unit_code is NOT NULL then
7140: if hr_api.not_exists_in_dt_hr_lookups
7144: ,p_lookup_type => 'BARGAINING_UNIT_CODE'
7145: ,p_lookup_code => p_bargaining_unit_code
7146: )
7147: then
7148: hr_utility.set_message(800, 'PER_52383_ASG_BARG_UNIT_CODE');
7149: hr_utility.raise_error;
7150: end if;
7151: end if;
7152: --
7145: ,p_lookup_code => p_bargaining_unit_code
7146: )
7147: then
7148: hr_utility.set_message(800, 'PER_52383_ASG_BARG_UNIT_CODE');
7149: hr_utility.raise_error;
7150: end if;
7151: end if;
7152: --
7153: if g_debug then
7150: end if;
7151: end if;
7152: --
7153: if g_debug then
7154: hr_utility.set_location(' Leaving:'||l_proc, 30);
7155: end if;
7156: exception
7157: when app_exception.application_exception then
7158: if hr_multi_message.exception_add
7158: if hr_multi_message.exception_add
7159: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.BARGAINING_UNIT_CODE'
7160: ) then
7161: if g_debug then
7162: hr_utility.set_location(' Leaving:'|| l_proc, 40);
7163: end if;
7164: raise;
7165: end if;
7166: if g_debug then
7163: end if;
7164: raise;
7165: end if;
7166: if g_debug then
7167: hr_utility.set_location(' Leaving:'|| l_proc, 50);
7168: end if;
7169: --
7170: end chk_bargaining_unit_code;
7171: --
7225: where pay.pay_basis_id = p_pay_basis_id;
7226:
7227: begin
7228: if g_debug then
7229: hr_utility.set_location('Entering:'|| l_proc, 10);
7230: end if;
7231: --
7232: --
7233: -- Check mandatory parameters have been set
7237: ,p_argument => 'effective_date'
7238: ,p_argument_value => p_effective_date
7239: );
7240: if g_debug then
7241: hr_utility.set_location(l_proc, 20);
7242: end if;
7243: --
7244: -- If the assignment is a CWK and the hourly salary
7245: -- code has been set then raise an error.
7246: --
7247: IF p_assignment_type = 'C' AND
7248: p_hourly_salaried_code IS NOT NULL THEN
7249: --
7250: hr_utility.set_message(800,'HR_289648_CWK_HR_CODE_NOT_NULL');
7251: hr_utility.raise_error;
7252: --
7253: END IF;
7254: --
7247: IF p_assignment_type = 'C' AND
7248: p_hourly_salaried_code IS NOT NULL THEN
7249: --
7250: hr_utility.set_message(800,'HR_289648_CWK_HR_CODE_NOT_NULL');
7251: hr_utility.raise_error;
7252: --
7253: END IF;
7254: --
7255: if p_hourly_salaried_code is NOT NULL then
7260: ,p_lookup_type => 'HOURLY_SALARIED_CODE'
7261: ,p_lookup_code => p_hourly_salaried_code
7262: )
7263: then
7264: hr_utility.set_message(800,'PER_52407_HOUR_SAL_CODE');
7265: hr_multi_message.add
7266: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.HOURLY_SALARIED_CODE'
7267: );
7268: else
7281:
7282: p_hourly_salaried_warning := TRUE;
7283: -- updated for bug 2033513
7284:
7285: -- hr_utility.set_message(800,'PER_6997_HOUR_SAL_BASIS');
7286: -- hr_utility.raise_error;
7287:
7288: else null;
7289: end if;
7282: p_hourly_salaried_warning := TRUE;
7283: -- updated for bug 2033513
7284:
7285: -- hr_utility.set_message(800,'PER_6997_HOUR_SAL_BASIS');
7286: -- hr_utility.raise_error;
7287:
7288: else null;
7289: end if;
7290: end if;
7293: end if; -- no exclusive error
7294: end if;
7295: --
7296: if g_debug then
7297: hr_utility.set_location(' Leaving:'||l_proc, 30);
7298: end if;
7299: --
7300: end chk_hourly_salaried_code;
7301: --
7323: l_legislation_code varchar2(150);
7324: l_proc varchar2(72) := g_package||'return_legislation_code';
7325: begin
7326: if g_debug then
7327: hr_utility.set_location('Entering:'|| l_proc, 10);
7328: end if;
7329: --
7330: -- Ensure that all the mandatory parameter are not null
7331: --
7341: -- variable.
7342: --
7343: l_legislation_code := g_legislation_code;
7344: if g_debug then
7345: hr_utility.set_location(l_proc, 20);
7346: end if;
7347: else
7348: --
7349: -- The ID is different to the last call to this function
7355: close csr_leg_code;
7356: --
7357: -- The primary key is invalid therefore we must error
7358: --
7359: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
7360: hr_utility.raise_error;
7361: end if;
7362: --
7363: close csr_leg_code;
7356: --
7357: -- The primary key is invalid therefore we must error
7358: --
7359: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
7360: hr_utility.raise_error;
7361: end if;
7362: --
7363: close csr_leg_code;
7364: if g_debug then
7361: end if;
7362: --
7363: close csr_leg_code;
7364: if g_debug then
7365: hr_utility.set_location(' Leaving:'|| l_proc, 20);
7366: end if;
7367: --
7368: g_assignment_id := p_assignment_id;
7369: g_legislation_code := l_legislation_code;
7368: g_assignment_id := p_assignment_id;
7369: g_legislation_code := l_legislation_code;
7370: end if;
7371: if g_debug then
7372: hr_utility.set_location(' Leaving:'|| l_proc, 30);
7373: end if;
7374: return l_legislation_code;
7375: end return_legislation_code;
7376: --
7481: close csr_is_apl_asg;
7482:
7483: if l_asg_type in ('E','C') then
7484: --
7485: hr_utility.set_location(l_proc|| '*** entering application assignment check',555);
7486: --
7487: -- Changes end for the bug 13571263
7488: --
7489:
7487: -- Changes end for the bug 13571263
7488: --
7489:
7490: if g_debug then
7491: hr_utility.set_location('Entering:'|| l_proc, 10);
7492: end if;
7493: if p_position_id is not null and p_assignment_start_date is not null then
7494:
7495: open c1;
7497: -- Start changes for bug 11828317
7498: close c1;
7499:
7500: if l_dummy is not null then -- c1
7501: hr_utility.set_location('Records found for cursor c1 ', 20);
7502: hr_utility.set_location('p_assignment_start_date'||p_assignment_start_date, 20);
7503: hr_utility.set_location('p_assignment_end_date'||p_assignment_end_date, 20);
7504: open c2;
7505: fetch c2 into l_ol_effective_start_date, l_ol_effective_end_date;
7498: close c1;
7499:
7500: if l_dummy is not null then -- c1
7501: hr_utility.set_location('Records found for cursor c1 ', 20);
7502: hr_utility.set_location('p_assignment_start_date'||p_assignment_start_date, 20);
7503: hr_utility.set_location('p_assignment_end_date'||p_assignment_end_date, 20);
7504: open c2;
7505: fetch c2 into l_ol_effective_start_date, l_ol_effective_end_date;
7506: close c2;
7499:
7500: if l_dummy is not null then -- c1
7501: hr_utility.set_location('Records found for cursor c1 ', 20);
7502: hr_utility.set_location('p_assignment_start_date'||p_assignment_start_date, 20);
7503: hr_utility.set_location('p_assignment_end_date'||p_assignment_end_date, 20);
7504: open c2;
7505: fetch c2 into l_ol_effective_start_date, l_ol_effective_end_date;
7506: close c2;
7507:
7505: fetch c2 into l_ol_effective_start_date, l_ol_effective_end_date;
7506: close c2;
7507:
7508: if l_ol_effective_start_date is not null then --c2
7509: hr_utility.set_location('Records found for cursor c2 ', 30);
7510: hr_utility.set_location('l_ol_effective_start_date'||l_ol_effective_start_date, 30);
7511: hr_utility.set_location('l_ol_effective_end_date'||l_ol_effective_end_date, 30);
7512: l_asg_effective_end_date := null;
7513:
7506: close c2;
7507:
7508: if l_ol_effective_start_date is not null then --c2
7509: hr_utility.set_location('Records found for cursor c2 ', 30);
7510: hr_utility.set_location('l_ol_effective_start_date'||l_ol_effective_start_date, 30);
7511: hr_utility.set_location('l_ol_effective_end_date'||l_ol_effective_end_date, 30);
7512: l_asg_effective_end_date := null;
7513:
7514: open c_position_type;
7507:
7508: if l_ol_effective_start_date is not null then --c2
7509: hr_utility.set_location('Records found for cursor c2 ', 30);
7510: hr_utility.set_location('l_ol_effective_start_date'||l_ol_effective_start_date, 30);
7511: hr_utility.set_location('l_ol_effective_end_date'||l_ol_effective_end_date, 30);
7512: l_asg_effective_end_date := null;
7513:
7514: open c_position_type;
7515: fetch c_position_type into l_position_type;
7520: fetch c3 into l_asg_number, l_asg_effective_start_date, l_asg_effective_end_date;
7521: close c3;
7522: --
7523: if l_asg_effective_end_date is not null then --c4
7524: hr_utility.set_location('Records found for cursor c3 ', 35);
7525: hr_utility.set_location('l_asg_effective_start_date'||l_asg_effective_start_date, 35);
7526: hr_utility.set_location('l_asg_effective_end_date'||l_asg_effective_end_date, 35);
7527: --
7528: if p_assignment_end_date > l_ol_effective_end_date and
7521: close c3;
7522: --
7523: if l_asg_effective_end_date is not null then --c4
7524: hr_utility.set_location('Records found for cursor c3 ', 35);
7525: hr_utility.set_location('l_asg_effective_start_date'||l_asg_effective_start_date, 35);
7526: hr_utility.set_location('l_asg_effective_end_date'||l_asg_effective_end_date, 35);
7527: --
7528: if p_assignment_end_date > l_ol_effective_end_date and
7529: p_assignment_start_date < l_asg_effective_end_date then--c5
7522: --
7523: if l_asg_effective_end_date is not null then --c4
7524: hr_utility.set_location('Records found for cursor c3 ', 35);
7525: hr_utility.set_location('l_asg_effective_start_date'||l_asg_effective_start_date, 35);
7526: hr_utility.set_location('l_asg_effective_end_date'||l_asg_effective_end_date, 35);
7527: --
7528: if p_assignment_end_date > l_ol_effective_end_date and
7529: p_assignment_start_date < l_asg_effective_end_date then--c5
7530: hr_utility.set_message(800,'HR_449891_OTHER_ASG_EXISTS');
7526: hr_utility.set_location('l_asg_effective_end_date'||l_asg_effective_end_date, 35);
7527: --
7528: if p_assignment_end_date > l_ol_effective_end_date and
7529: p_assignment_start_date < l_asg_effective_end_date then--c5
7530: hr_utility.set_message(800,'HR_449891_OTHER_ASG_EXISTS');
7531: hr_utility.set_message_token('ASG_NUM',l_asg_number);
7532: hr_utility.set_message_token('OL_START_DATE',l_ol_effective_start_date);
7533: hr_utility.set_message_token('OL_END_DATE',l_ol_effective_end_date);
7534: hr_utility.set_message_token('ASG_START_DATE',l_asg_effective_start_date);
7527: --
7528: if p_assignment_end_date > l_ol_effective_end_date and
7529: p_assignment_start_date < l_asg_effective_end_date then--c5
7530: hr_utility.set_message(800,'HR_449891_OTHER_ASG_EXISTS');
7531: hr_utility.set_message_token('ASG_NUM',l_asg_number);
7532: hr_utility.set_message_token('OL_START_DATE',l_ol_effective_start_date);
7533: hr_utility.set_message_token('OL_END_DATE',l_ol_effective_end_date);
7534: hr_utility.set_message_token('ASG_START_DATE',l_asg_effective_start_date);
7535: hr_utility.set_message_token('ASG_END_DATE',l_asg_effective_end_date);
7528: if p_assignment_end_date > l_ol_effective_end_date and
7529: p_assignment_start_date < l_asg_effective_end_date then--c5
7530: hr_utility.set_message(800,'HR_449891_OTHER_ASG_EXISTS');
7531: hr_utility.set_message_token('ASG_NUM',l_asg_number);
7532: hr_utility.set_message_token('OL_START_DATE',l_ol_effective_start_date);
7533: hr_utility.set_message_token('OL_END_DATE',l_ol_effective_end_date);
7534: hr_utility.set_message_token('ASG_START_DATE',l_asg_effective_start_date);
7535: hr_utility.set_message_token('ASG_END_DATE',l_asg_effective_end_date);
7536: hr_utility.raise_error;
7529: p_assignment_start_date < l_asg_effective_end_date then--c5
7530: hr_utility.set_message(800,'HR_449891_OTHER_ASG_EXISTS');
7531: hr_utility.set_message_token('ASG_NUM',l_asg_number);
7532: hr_utility.set_message_token('OL_START_DATE',l_ol_effective_start_date);
7533: hr_utility.set_message_token('OL_END_DATE',l_ol_effective_end_date);
7534: hr_utility.set_message_token('ASG_START_DATE',l_asg_effective_start_date);
7535: hr_utility.set_message_token('ASG_END_DATE',l_asg_effective_end_date);
7536: hr_utility.raise_error;
7537: else
7530: hr_utility.set_message(800,'HR_449891_OTHER_ASG_EXISTS');
7531: hr_utility.set_message_token('ASG_NUM',l_asg_number);
7532: hr_utility.set_message_token('OL_START_DATE',l_ol_effective_start_date);
7533: hr_utility.set_message_token('OL_END_DATE',l_ol_effective_end_date);
7534: hr_utility.set_message_token('ASG_START_DATE',l_asg_effective_start_date);
7535: hr_utility.set_message_token('ASG_END_DATE',l_asg_effective_end_date);
7536: hr_utility.raise_error;
7537: else
7538: return true;
7531: hr_utility.set_message_token('ASG_NUM',l_asg_number);
7532: hr_utility.set_message_token('OL_START_DATE',l_ol_effective_start_date);
7533: hr_utility.set_message_token('OL_END_DATE',l_ol_effective_end_date);
7534: hr_utility.set_message_token('ASG_START_DATE',l_asg_effective_start_date);
7535: hr_utility.set_message_token('ASG_END_DATE',l_asg_effective_end_date);
7536: hr_utility.raise_error;
7537: else
7538: return true;
7539: end if; --c5
7532: hr_utility.set_message_token('OL_START_DATE',l_ol_effective_start_date);
7533: hr_utility.set_message_token('OL_END_DATE',l_ol_effective_end_date);
7534: hr_utility.set_message_token('ASG_START_DATE',l_asg_effective_start_date);
7535: hr_utility.set_message_token('ASG_END_DATE',l_asg_effective_end_date);
7536: hr_utility.raise_error;
7537: else
7538: return true;
7539: end if; --c5
7540: --
7545: else
7546: return(true);
7547: end if; -- c3
7548: else
7549: hr_utility.set_location('No Records found for cursor c2 ', 40);
7550: return(false);
7551: -- End changes for bug 11828317
7552: end if; -- c2
7553:
7553:
7554:
7555: /*- Start Change open cursor c1 added for the bug 5840410 --*/
7556: else
7557: hr_utility.set_location('No Records found for cursor c1 ', 50);
7558: -- close c1;
7559: return(false);
7560: end if; -- c1
7561: /*- End changes for the bug 5840410 --*/
7559: return(false);
7560: end if; -- c1
7561: /*- End changes for the bug 5840410 --*/
7562: end if; -- position id not null
7563: hr_utility.set_location('Leaving:'|| l_proc, 100);
7564: --
7565: -- Changes start for the bug 13571263
7566: --
7567: hr_utility.set_location(l_proc|| '*** leaving application assignment check',666);
7563: hr_utility.set_location('Leaving:'|| l_proc, 100);
7564: --
7565: -- Changes start for the bug 13571263
7566: --
7567: hr_utility.set_location(l_proc|| '*** leaving application assignment check',666);
7568: --
7569: end if;
7570: -- Changes end for the bug 13571263
7571: --
7648: and p_effective_date between effective_start_date and effective_end_date;
7649: --
7650: begin
7651: if g_debug then
7652: hr_utility.set_location('Entering:'|| l_proc, 10);
7653: end if;
7654: --
7655: -- Check mandatory parameters have been set
7656: --
7659: ,p_argument => 'effective_date'
7660: ,p_argument_value => p_effective_date
7661: );
7662: if g_debug then
7663: hr_utility.set_location(l_proc, 20);
7664: end if;
7665: --
7666: if p_position_id is NOT NULL then
7667: open c_position_type(p_position_id, p_effective_date);
7669: close c_position_type;
7670: -- Check that the currne position is not Frozen
7671: if hr_psf_shd.get_availability_status(l_availability_status_id,l_business_group_id) ='FROZEN'
7672: then
7673: hr_utility.set_message(800, 'PER_NO_ASG_FOR_FROZEN_POS');
7674: hr_multi_message.add
7675: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
7676: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
7677: );
7686: /*---- Start change for the bug 5854568 ----(modified for the bug 6331872)*/
7687: if (per_asg_bus1.pos_assignments_exists(p_position_id, p_effective_date, p_assignment_id) and p_assignment_type in ('E','C'))
7688: /*---- End change for the bug 5854568 ----(modified for the bug 6331872)*/
7689: then
7690: hr_utility.set_message(800, 'PER_ASG_EXISTS_FOR_SINGLE_POS');
7691: hr_multi_message.add
7692: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
7693: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
7694: );
7698: end if;
7699: end if;
7700: --
7701: if g_debug then
7702: hr_utility.set_location(' Leaving:'||l_proc, 30);
7703: end if;
7704: --
7705: end chk_frozen_single_pos;
7706: --
7744: l_api_updating boolean;
7745: --
7746: begin
7747: if g_debug then
7748: hr_utility.set_location('Entering:'|| l_proc, 10);
7749: end if;
7750: --
7751: if hr_multi_message.no_exclusive_error
7752: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
7759: ,p_argument => 'effective_date'
7760: ,p_argument_value => p_effective_date
7761: );
7762: if g_debug then
7763: hr_utility.set_location(l_proc, 20);
7764: end if;
7765: --
7766: l_api_updating := per_asg_shd.api_updating
7767: (p_assignment_id => p_assignment_id
7768: ,p_effective_date => p_effective_date
7769: ,p_object_version_number => p_object_version_number
7770: );
7771: if g_debug then
7772: hr_utility.set_location(l_proc, 30);
7773: end if;
7774: --
7775: -- Modified the if condition for Bug #12615314
7776: if (l_api_updating and
7794: );
7795: end if;
7796: --
7797: if g_debug then
7798: hr_utility.set_location(' Leaving:'||l_proc, 30);
7799: end if;
7800:
7801: end if;
7802: --