[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: per_asg_bus1.dt_delete_validate
360:
363: ,p_validation_start_date => p_validation_start_date
364: ,p_validation_end_date => p_validation_end_date
365: );
366: if g_debug then
367: hr_utility.set_location(l_proc, 20);
368: end if;
369: --
370: per_asg_bus2.chk_payroll_id
371: (p_assignment_id => p_rec.assignment_id
380: ,p_payroll_id_updated => l_temp_flag
381: ,p_object_version_number => p_rec.object_version_number
382: );
383: if g_debug then
384: hr_utility.set_location(l_proc, 30);
385: end if;
386: --
387: per_asg_bus1.chk_del_organization_id
388: (p_assignment_id => p_rec.assignment_id
393: ,p_org_now_no_manager_warning => l_org_now_no_manager_warning
394: );
395: --
396: if g_debug then
397: hr_utility.set_location(l_proc, 40);
398: end if;
399: --
400: per_pqh_shr.per_asg_bus('DELETE_VALIDATE',
401: p_rec,
404: p_validation_end_date,
405: p_datetrack_mode);
406: p_org_now_no_manager_warning := l_org_now_no_manager_warning;
407: if g_debug then
408: hr_utility.set_location(' Leaving:'||l_proc, 11);
409: end if;
410: End delete_validate;
411: --
412: -- ----------------------------------------------------------------------------
455: l_table_name all_tables.table_name%TYPE;
456: --
457: Begin
458: if g_debug then
459: hr_utility.set_location('Entering:'||l_proc, 5);
460: end if;
461: --
462: -- Ensure that the p_datetrack_mode argument is not null
463: --
581: --
582: End If;
583: --
584: if g_debug then
585: hr_utility.set_location(' Leaving:'||l_proc, 10);
586: end if;
587: Exception
588: When Others Then
589: --
589: --
590: -- An unhandled or unexpected error has occurred which
591: -- we must report
592: --
593: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
594: hr_utility.set_message_token('PROCEDURE', l_proc);
595: hr_utility.set_message_token('STEP','15');
596: hr_utility.raise_error;
597: End dt_delete_validate;
590: -- An unhandled or unexpected error has occurred which
591: -- we must report
592: --
593: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
594: hr_utility.set_message_token('PROCEDURE', l_proc);
595: hr_utility.set_message_token('STEP','15');
596: hr_utility.raise_error;
597: End dt_delete_validate;
598: --
591: -- we must report
592: --
593: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
594: hr_utility.set_message_token('PROCEDURE', l_proc);
595: hr_utility.set_message_token('STEP','15');
596: hr_utility.raise_error;
597: End dt_delete_validate;
598: --
599: -- ----------------------------------------------------------------------------
592: --
593: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
594: hr_utility.set_message_token('PROCEDURE', l_proc);
595: hr_utility.set_message_token('STEP','15');
596: hr_utility.raise_error;
597: End dt_delete_validate;
598: --
599: -- ----------------------------------------------------------------------------
600: -- |--------------------------< dt_update_validate >--------------------------|
637: l_table_name all_tables.table_name%TYPE;
638: --
639: Begin
640: if g_debug then
641: hr_utility.set_location('Entering:'||l_proc, 5);
642: end if;
643: --
644: -- Ensure that the p_datetrack_mode argument is not null
645: --
690: Raise l_integrity_error;
691: End If;
692: --
693: if g_debug then
694: hr_utility.set_location(' Leaving:'||l_proc, 10);
695: end if;
696: Exception
697: When Others Then
698: --
698: --
699: -- An unhandled or unexpected error has occurred which
700: -- we must report
701: --
702: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
703: hr_utility.set_message_token('PROCEDURE', l_proc);
704: hr_utility.set_message_token('STEP','15');
705: hr_utility.raise_error;
706: End dt_update_validate;
699: -- An unhandled or unexpected error has occurred which
700: -- we must report
701: --
702: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
703: hr_utility.set_message_token('PROCEDURE', l_proc);
704: hr_utility.set_message_token('STEP','15');
705: hr_utility.raise_error;
706: End dt_update_validate;
707: -- -----------------------------------------------------------------------
700: -- we must report
701: --
702: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
703: hr_utility.set_message_token('PROCEDURE', l_proc);
704: hr_utility.set_message_token('STEP','15');
705: hr_utility.raise_error;
706: End dt_update_validate;
707: -- -----------------------------------------------------------------------
708: -- |------------------------------< chk_df >-----------------------------|
701: --
702: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
703: hr_utility.set_message_token('PROCEDURE', l_proc);
704: hr_utility.set_message_token('STEP','15');
705: hr_utility.raise_error;
706: End dt_update_validate;
707: -- -----------------------------------------------------------------------
708: -- |------------------------------< chk_df >-----------------------------|
709: -- -----------------------------------------------------------------------
741: begin
742: --
743: if g_debug then
744: l_proc := g_package||'chk_df';
745: hr_utility.set_location('Entering:'||l_proc, 10);
746: end if;
747: --
748: -- if inserting and not required to validate flex data
749: -- then ensure all flex data passed is null
783: (p_rec.ass_attribute28 is null) and
784: (p_rec.ass_attribute29 is null) and
785: (p_rec.ass_attribute30 is null) ) )
786: then
787: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
788: hr_utility.set_message_token('PROCEDURE','chk_df');
789: hr_utility.set_message_token('STEP',1);
790: hr_utility.raise_error;
791: End if;
784: (p_rec.ass_attribute29 is null) and
785: (p_rec.ass_attribute30 is null) ) )
786: then
787: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
788: hr_utility.set_message_token('PROCEDURE','chk_df');
789: hr_utility.set_message_token('STEP',1);
790: hr_utility.raise_error;
791: End if;
792: End if;
785: (p_rec.ass_attribute30 is null) ) )
786: then
787: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
788: hr_utility.set_message_token('PROCEDURE','chk_df');
789: hr_utility.set_message_token('STEP',1);
790: hr_utility.raise_error;
791: End if;
792: End if;
793: --
786: then
787: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
788: hr_utility.set_message_token('PROCEDURE','chk_df');
789: hr_utility.set_message_token('STEP',1);
790: hr_utility.raise_error;
791: End if;
792: End if;
793: --
794: --
973: );
974: End if;
975: --
976: if g_debug then
977: hr_utility.set_location(' Leaving:'||l_proc, 20);
978: end if;
979: --
980: end chk_df;
981: --
1003: --
1004: Begin
1005: if g_debug then
1006: l_proc := g_package||'insert_validate';
1007: hr_utility.set_location('Entering: '||l_proc, 10);
1008: end if;
1009: --
1010: -- Validate Important Attributes
1011: --
1025: --
1026: hr_multi_message.end_validation_set;
1027: --
1028: if g_debug then
1029: hr_utility.set_location(l_proc, 15);
1030: end if;
1031: --
1032: -- per_asg_bus2.chk_title (p_title => p_rec.title);
1033: --
1038: ,p_effective_date => p_effective_date
1039: ,p_assignment_type => p_rec.assignment_type
1040: );
1041: if g_debug then
1042: hr_utility.set_location(l_proc, 22);
1043: end if;
1044: --
1045: per_asg_bus2.chk_time_finish_formatted --#2734822
1046: (p_time_normal_finish => p_rec.time_normal_finish
1045: per_asg_bus2.chk_time_finish_formatted --#2734822
1046: (p_time_normal_finish => p_rec.time_normal_finish
1047: );
1048: if g_debug then
1049: hr_utility.set_location(l_proc, 25);
1050: end if;
1051: --
1052: per_asg_bus2.chk_time_start_formatted --#2734822
1053: (p_time_normal_start => p_rec.time_normal_start
1052: per_asg_bus2.chk_time_start_formatted --#2734822
1053: (p_time_normal_start => p_rec.time_normal_start
1054: );
1055: if g_debug then
1056: hr_utility.set_location(l_proc, 27);
1057: end if;
1058: --
1059: per_asg_bus1.chk_assignment_type
1060: (p_assignment_id => p_rec.assignment_id
1064: ,p_object_version_number => p_rec.object_version_number
1065: ,p_validation_start_date => p_validation_start_date
1066: );
1067: if g_debug then
1068: hr_utility.set_location(l_proc, 30);
1069: end if;
1070: --
1071: hr_multi_message.end_validation_set;
1072: --
1078: ,p_validation_end_date => p_validation_end_date
1079: ,p_object_version_number => p_rec.object_version_number
1080: );
1081: if g_debug then
1082: hr_utility.set_location(l_proc, 40);
1083: end if;
1084: --
1085: per_asg_bus2.chk_probation_period
1086: (p_assignment_id => p_rec.assignment_id
1088: ,p_effective_date => p_effective_date
1089: ,p_object_version_number => p_rec.object_version_number
1090: );
1091: if g_debug then
1092: hr_utility.set_location(l_proc, 50);
1093: end if;
1094: --
1095: per_asg_bus2.chk_prob_unit_prob_period
1096: (p_assignment_id => p_rec.assignment_id
1099: ,p_effective_date => p_effective_date
1100: ,p_object_version_number => p_rec.object_version_number
1101: );
1102: if g_debug then
1103: hr_utility.set_location(l_proc, 60);
1104: end if;
1105: --- Fix For Bug # 7481310 Starts ---
1106: if p_rec.assignment_type = 'O' then
1107: hr_utility.set_location(l_proc || 'This is an Offer Assignment', 60);
1103: hr_utility.set_location(l_proc, 60);
1104: end if;
1105: --- Fix For Bug # 7481310 Starts ---
1106: if p_rec.assignment_type = 'O' then
1107: hr_utility.set_location(l_proc || 'This is an Offer Assignment', 60);
1108:
1109: select source_type into l_source_type from per_all_assignments_f
1110: where person_id = p_rec.person_id and BUSINESS_GROUP_ID = p_rec.business_group_id
1111: and ASSIGNMENT_TYPE = 'A' and VACANCY_ID = p_rec.vacancy_id and
1128: );
1129: end if;
1130: --- Fix For Bug # 7481310 Ends ---
1131: if g_debug then
1132: hr_utility.set_location(l_proc, 70);
1133: end if;
1134: --
1135: per_asg_bus1.chk_date_probation_end
1136: (p_assignment_id => p_rec.assignment_id
1142: ,p_effective_date => p_effective_date
1143: ,p_object_version_number => p_rec.object_version_number
1144: );
1145: if g_debug then
1146: hr_utility.set_location(l_proc, 80);
1147: end if;
1148: --
1149: per_asg_bus2.chk_internal_address_line
1150: (p_assignment_id => p_rec.assignment_id
1153: ,p_effective_date => p_effective_date
1154: ,p_object_version_number => p_rec.object_version_number
1155: );
1156: if g_debug then
1157: hr_utility.set_location(l_proc, 90);
1158: end if;
1159: --
1160: per_asg_bus1.chk_change_reason
1161: (p_assignment_id => p_rec.assignment_id
1166: ,p_validation_end_date => p_validation_end_date
1167: ,p_object_version_number => p_rec.object_version_number
1168: );
1169: if g_debug then
1170: hr_utility.set_location(l_proc, 100);
1171: end if;
1172: --
1173: per_asg_bus1.chk_default_code_comb_id
1174: (p_assignment_id => p_rec.assignment_id
1178: ,p_validation_start_date => p_validation_start_date
1179: ,p_object_version_number => p_rec.object_version_number
1180: );
1181: if g_debug then
1182: hr_utility.set_location(l_proc, 110);
1183: end if;
1184: --
1185: per_asg_bus1.chk_employment_category
1186: (p_assignment_id => p_rec.assignment_id
1191: ,p_validation_end_date => p_validation_end_date
1192: ,p_object_version_number => p_rec.object_version_number
1193: );
1194: if g_debug then
1195: hr_utility.set_location(l_proc, 120);
1196: end if;
1197: --
1198: per_asg_bus2.chk_sal_review_period
1199: (p_assignment_id => p_rec.assignment_id
1202: ,p_effective_date => p_effective_date
1203: ,p_object_version_number => p_rec.object_version_number
1204: );
1205: if g_debug then
1206: hr_utility.set_location(l_proc, 130);
1207: end if;
1208: --
1209: per_asg_bus2.chk_sal_review_period_freq
1210: (p_assignment_id => p_rec.assignment_id
1215: ,p_validation_end_date => p_validation_end_date
1216: ,p_object_version_number => p_rec.object_version_number
1217: );
1218: if g_debug then
1219: hr_utility.set_location(l_proc, 140);
1220: end if;
1221: --
1222: per_asg_bus2.chk_sal_rp_freq_sal_rp
1223: (p_assignment_id => p_rec.assignment_id
1226: ,p_effective_date => p_effective_date
1227: ,p_object_version_number => p_rec.object_version_number
1228: );
1229: if g_debug then
1230: hr_utility.set_location(l_proc, 150);
1231: end if;
1232: --
1233: per_asg_bus2.chk_perf_review_period
1234: (p_assignment_id => p_rec.assignment_id
1237: ,p_effective_date => p_effective_date
1238: ,p_object_version_number => p_rec.object_version_number
1239: );
1240: if g_debug then
1241: hr_utility.set_location(l_proc, 160);
1242: end if;
1243: --
1244: per_asg_bus2.chk_perf_review_period_freq
1245: (p_assignment_id => p_rec.assignment_id
1250: ,p_validation_end_date => p_validation_end_date
1251: ,p_object_version_number => p_rec.object_version_number
1252: );
1253: if g_debug then
1254: hr_utility.set_location(l_proc, 170);
1255: end if;
1256: --
1257: per_asg_bus2.chk_perf_rp_freq_perf_rp
1258: (p_assignment_id => p_rec.assignment_id
1261: ,p_effective_date => p_effective_date
1262: ,p_object_version_number => p_rec.object_version_number
1263: );
1264: if g_debug then
1265: hr_utility.set_location(l_proc, 180);
1266: end if;
1267: --
1268: per_asg_bus1.chk_frequency
1269: (p_assignment_id => p_rec.assignment_id
1273: ,p_validation_end_date => p_validation_end_date
1274: ,p_object_version_number => p_rec.object_version_number
1275: );
1276: if g_debug then
1277: hr_utility.set_location(l_proc, 190);
1278: end if;
1279: --
1280: per_asg_bus1.chk_frequency_normal_hours
1281: (p_assignment_id => p_rec.assignment_id
1284: ,p_effective_date => p_effective_date
1285: ,p_object_version_number => p_rec.object_version_number
1286: );
1287: if g_debug then
1288: hr_utility.set_location(l_proc, 200);
1289: end if;
1290: --
1291: per_asg_bus2.chk_set_of_books_id
1292: (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, 210);
1301: end if;
1302: --
1303: per_asg_bus2.chk_source_organization_id
1304: (p_assignment_id => p_rec.assignment_id
1310: ,p_validation_start_date => p_validation_start_date
1311: ,p_validation_end_date => p_validation_end_date
1312: );
1313: if g_debug then
1314: hr_utility.set_location(l_proc, 230);
1315: end if;
1316: --
1317: per_asg_bus2.chk_soft_coding_keyflex_id
1318: (p_assignment_id => p_rec.assignment_id
1324: ,p_payroll_id => p_rec.payroll_id
1325: ,p_business_group_id => p_rec.business_group_id
1326: );
1327: if g_debug then
1328: hr_utility.set_location(l_proc, 240);
1329: end if;
1330: --
1331: per_asg_bus2.chk_pay_basis_id
1332: (p_assignment_id => p_rec.assignment_id
1337: ,p_validation_start_date => p_validation_start_date
1338: ,p_object_version_number => p_rec.object_version_number
1339: );
1340: if g_debug then
1341: hr_utility.set_location(l_proc, 250);
1342: end if;
1343: --
1344: per_asg_bus2.chk_recruitment_activity_id
1345: (p_assignment_id => p_rec.assignment_id
1351: ,p_validation_start_date => p_validation_start_date
1352: ,p_validation_end_date => p_validation_end_date
1353: );
1354: if g_debug then
1355: hr_utility.set_location(l_proc, 260);
1356: end if;
1357: --
1358: per_asg_bus2.chk_vacancy_id
1359: (p_assignment_id => p_rec.assignment_id
1365: ,p_validation_start_date => p_validation_start_date
1366: ,p_validation_end_date => p_validation_end_date
1367: );
1368: if g_debug then
1369: hr_utility.set_location(l_proc, 270);
1370: end if;
1371: --
1372: per_asg_bus1.chk_location_id
1373: (p_assignment_id => p_rec.assignment_id
1379: ,p_effective_date => p_effective_date
1380: ,p_object_version_number => p_rec.object_version_number
1381: );
1382: if g_debug then
1383: hr_utility.set_location(l_proc, 280);
1384: end if;
1385: --
1386: per_asg_bus2.chk_people_group_id
1387: (p_assignment_id => p_rec.assignment_id
1394: ,p_effective_date => p_effective_date
1395: ,p_object_version_number => p_rec.object_version_number
1396: );
1397: if g_debug then
1398: hr_utility.set_location(l_proc, 290);
1399: end if;
1400: --
1401: if g_debug then
1402: hr_utility.set_location(p_validation_start_date, 290);
1398: hr_utility.set_location(l_proc, 290);
1399: end if;
1400: --
1401: if g_debug then
1402: hr_utility.set_location(p_validation_start_date, 290);
1403: end if;
1404: if g_debug then
1405: hr_utility.set_location(p_validation_end_date, 290);
1406: end if;
1401: if g_debug then
1402: hr_utility.set_location(p_validation_start_date, 290);
1403: end if;
1404: if g_debug then
1405: hr_utility.set_location(p_validation_end_date, 290);
1406: end if;
1407: per_asg_bus2.chk_position_id
1408: (p_assignment_id => p_rec.assignment_id
1409: ,p_position_id => p_rec.position_id
1415: ,p_effective_date => p_effective_date
1416: ,p_object_version_number => p_rec.object_version_number
1417: );
1418: if g_debug then
1419: hr_utility.set_location(l_proc, 300);
1420: end if;
1421: -- fix for 6331872 starts here
1422: per_asg_bus1.chk_frozen_single_pos
1423: (p_assignment_id => p_rec.assignment_id
1425: ,p_effective_date => p_effective_date
1426: );
1427:
1428: if g_debug then
1429: hr_utility.set_location(p_validation_end_date, 305);
1430: end if;
1431: -- fix for 6331872 ends here
1432: per_asg_bus1.chk_job_id
1433: (p_assignment_id => p_rec.assignment_id
1440: ,p_validation_end_date => p_validation_end_date
1441: ,p_object_version_number => p_rec.object_version_number
1442: );
1443: if g_debug then
1444: hr_utility.set_location(l_proc, 310);
1445: end if;
1446: --
1447: per_asg_bus2.chk_position_id_job_id
1448: (p_assignment_id => p_rec.assignment_id
1453: ,p_effective_date => p_effective_date
1454: ,p_object_version_number => p_rec.object_version_number
1455: );
1456: if g_debug then
1457: hr_utility.set_location(l_proc, 320);
1458: end if;
1459: --
1460: per_asg_bus1.chk_grade_id
1461: (p_assignment_id => p_rec.assignment_id
1469: ,p_validation_end_date => p_validation_end_date
1470: ,p_object_version_number => p_rec.object_version_number
1471: );
1472: if g_debug then
1473: hr_utility.set_location(l_proc, 330);
1474: end if;
1475: --
1476: per_asg_bus2.chk_special_ceiling_step_id
1477: (p_assignment_id => p_rec.assignment_id
1484: ,p_effective_date => p_effective_date
1485: ,p_object_version_number => p_rec.object_version_number
1486: );
1487: if g_debug then
1488: hr_utility.set_location(l_proc, 340);
1489: end if;
1490: --
1491: per_asg_bus2.chk_position_id_grade_id
1492: (p_assignment_id => p_rec.assignment_id
1498: ,p_object_version_number => p_rec.object_version_number
1499: ,p_inv_pos_grade_warning => l_inv_pos_grade_warning
1500: );
1501: if g_debug then
1502: hr_utility.set_location(l_proc, 350);
1503: end if;
1504: --
1505: per_asg_bus1.chk_job_id_grade_id
1506: (p_assignment_id => p_rec.assignment_id
1512: ,p_object_version_number => p_rec.object_version_number
1513: ,p_inv_job_grade_warning => l_inv_job_grade_warning
1514: );
1515: if g_debug then
1516: hr_utility.set_location(l_proc, 360);
1517: end if;
1518: --
1519: per_asg_bus2.chk_person_id
1520: (p_person_id => p_rec.person_id
1521: ,p_business_group_id => p_rec.business_group_id
1522: ,p_effective_date => p_effective_date
1523: );
1524: if g_debug then
1525: hr_utility.set_location(l_proc, 370);
1526: end if;
1527: --
1528: per_asg_bus2.chk_supervisor_id
1529: (p_assignment_id => p_rec.assignment_id
1534: ,p_effective_date => p_effective_date
1535: ,p_object_version_number => p_rec.object_version_number
1536: );
1537: if g_debug then
1538: hr_utility.set_location(l_proc, 375);
1539: end if;
1540: --
1541: per_asg_bus2.chk_supervisor_assignment_id
1542: (p_assignment_id => p_rec.assignment_id
1546: ,p_effective_date => p_effective_date
1547: ,p_object_version_number => p_rec.object_version_number
1548: );
1549: if g_debug then
1550: hr_utility.set_location(l_proc, 380);
1551: end if;
1552: --
1553: per_asg_bus2.chk_person_referred_by_id
1554: (p_assignment_id => p_rec.assignment_id
1561: ,p_validation_start_date => p_validation_start_date
1562: ,p_validation_end_date => p_validation_end_date
1563: );
1564: if g_debug then
1565: hr_utility.set_location(l_proc, 390);
1566: end if;
1567: --
1568: per_asg_bus2.chk_recruiter_id
1569: (p_assignment_id => p_rec.assignment_id
1577: ,p_validation_start_date => p_validation_start_date
1578: ,p_validation_end_date => p_validation_end_date
1579: );
1580: if g_debug then
1581: hr_utility.set_location(l_proc, 400);
1582: end if;
1583: --
1584: per_asg_bus2.chk_period_of_service_id
1585: (p_assignment_id => p_rec.assignment_id
1592: ,p_effective_date => p_effective_date
1593: ,p_object_version_number => p_rec.object_version_number
1594: );
1595: if g_debug then
1596: hr_utility.set_location(l_proc, 405);
1597: end if;
1598: --
1599: per_asg_bus2.gen_assignment_sequence
1600: (p_assignment_type => p_rec.assignment_type
1601: ,p_person_id => p_rec.person_id
1602: ,p_assignment_sequence => p_rec.assignment_sequence
1603: );
1604: if g_debug then
1605: hr_utility.set_location(l_proc, 410);
1606: end if;
1607: --
1608: per_asg_bus1.gen_chk_assignment_number
1609: (p_assignment_id => p_rec.assignment_id
1615: ,p_effective_date => p_effective_date
1616: ,p_object_version_number => p_rec.object_version_number
1617: );
1618: if g_debug then
1619: hr_utility.set_location(l_proc, 420);
1620: end if;
1621: --
1622: per_asg_bus2.chk_primary_flag
1623: (p_assignment_id => p_rec.assignment_id
1631: ,p_validation_start_date => p_validation_start_date
1632: ,p_validation_end_date => p_validation_end_date
1633: );
1634: if g_debug then
1635: hr_utility.set_location(l_proc, 430);
1636: end if;
1637: --
1638: per_asg_bus2.chk_applicant_rank
1639: (p_applicant_rank => p_rec.applicant_rank
1659: ,p_other_manager_warning => l_other_manager_warning
1660: ,p_no_managers_warning => l_temp_flag
1661: );
1662: if g_debug then
1663: hr_utility.set_location(l_proc, 440);
1664: end if;
1665: --
1666: per_asg_bus1.chk_organization_id
1667: (p_assignment_id => p_rec.assignment_id
1678: ,p_org_now_no_manager_warning => l_temp_flag
1679: ,p_other_manager_warning => l_other_manager_warning
1680: );
1681: if g_debug then
1682: hr_utility.set_location(l_proc, 450);
1683: end if;
1684: --
1685: per_asg_bus2.chk_position_id_org_id
1686: (p_assignment_id => p_rec.assignment_id
1691: ,p_effective_date => p_effective_date
1692: ,p_object_version_number => p_rec.object_version_number
1693: );
1694: if g_debug then
1695: hr_utility.set_location(l_proc, 460);
1696: end if;
1697: --
1698: per_asg_bus1.chk_application_id
1699: (p_assignment_id => p_rec.assignment_id
1705: ,p_object_version_number => p_rec.object_version_number
1706: ,p_validation_start_date => p_validation_start_date
1707: );
1708: if g_debug then
1709: hr_utility.set_location(l_proc, 470);
1710: end if;
1711: --
1712: per_asg_bus2.chk_payroll_id
1713: (p_assignment_id => p_rec.assignment_id
1722: ,p_payroll_id_updated => l_temp_flag
1723: ,p_object_version_number => p_rec.object_version_number
1724: );
1725: if g_debug then
1726: hr_utility.set_location(l_proc, 490);
1727: end if;
1728: --
1729: per_asg_bus1.chk_assignment_status_type_id
1730: (p_rec => p_rec
1731: ,p_effective_date => p_effective_date
1732: ,p_validation_start_date => p_validation_start_date
1733: );
1734: if g_debug then
1735: hr_utility.set_location(l_proc, 500);
1736: end if;
1737: --
1738: per_asg_bus1.chk_bargaining_unit_code
1739: (p_assignment_id => p_rec.assignment_id
1743: ,p_validation_start_date => p_validation_start_date
1744: ,p_validation_end_date => p_validation_end_date
1745: );
1746: if g_debug then
1747: hr_utility.set_location(l_proc, 511);
1748: end if;
1749: --
1750: per_asg_bus1.chk_hourly_salaried_code
1751: (p_assignment_id => p_rec.assignment_id
1766: ,p_assignment_type => p_rec.assignment_type
1767: );
1768: --
1769: if g_debug then
1770: hr_utility.set_location(l_proc, 513);
1771: end if;
1772: per_asg_bus3.chk_contract_id
1773: (p_assignment_id => p_rec.assignment_id
1774: ,p_effective_date => p_effective_date
1778: ,p_validation_start_date => p_validation_start_date
1779: ,p_business_group_id => p_rec.business_group_id
1780: ) ;
1781: if g_debug then
1782: hr_utility.set_location(l_proc, 515);
1783: end if;
1784: --
1785: per_asg_bus3.chk_establishment_id
1786: (p_assignment_id => p_rec.assignment_id
1790: ,p_assignment_type => p_rec.assignment_type
1791: ,p_business_group_id => p_rec.business_group_id
1792: );
1793: if g_debug then
1794: hr_utility.set_location(l_proc, 520);
1795: end if;
1796: --
1797: per_asg_bus3.chk_collective_agreement_id
1798: (p_assignment_id => p_rec.assignment_id
1802: ,p_business_group_id => p_rec.business_group_id
1803: ,p_establishment_id => p_rec.establishment_id
1804: );
1805: if g_debug then
1806: hr_utility.set_location(l_proc, 530);
1807: end if;
1808: --
1809: per_asg_bus3.chk_cagr_id_flex_num
1810: (p_assignment_id => p_rec.assignment_id
1813: ,p_cagr_id_flex_num => p_rec.cagr_id_flex_num
1814: ,p_collective_agreement_id => p_rec.collective_agreement_id
1815: ) ;
1816: if g_debug then
1817: hr_utility.set_location(l_proc, 535);
1818: end if;
1819: --
1820: per_asg_bus3.chk_cagr_grade_def_id
1821: (p_assignment_id => p_rec.assignment_id
1856: ,p_validation_end_date => p_validation_end_date
1857: );
1858: --
1859: if g_debug then
1860: hr_utility.set_location(l_proc, 600);
1861: end if;
1862: --
1863: per_asg_bus1.chk_assignment_category
1864: (p_assignment_id => p_rec.assignment_id
1869: ,p_validation_start_date => p_validation_start_date
1870: ,p_validation_end_date => p_validation_end_date);
1871: --
1872: if g_debug then
1873: hr_utility.set_location(l_proc, 610);
1874: end if;
1875: --
1876: per_asg_bus3.chk_vendor_id
1877: (p_assignment_id => p_rec.assignment_id
1881: ,p_object_version_number => p_rec.object_version_number
1882: ,p_effective_date => p_effective_date);
1883: --
1884: if g_debug then
1885: hr_utility.set_location(l_proc, 620);
1886: end if;
1887: --
1888: per_asg_bus3.chk_vendor_site_id
1889: (p_assignment_id => p_rec.assignment_id
1892: ,p_object_version_number => p_rec.object_version_number
1893: ,p_effective_date => p_effective_date);
1894: --
1895: if g_debug then
1896: hr_utility.set_location(l_proc, 630);
1897: end if;
1898: --
1899: per_asg_bus3.chk_po_header_id
1900: (p_assignment_id => p_rec.assignment_id
1904: ,p_object_version_number => p_rec.object_version_number
1905: ,p_effective_date => p_effective_date);
1906: --
1907: if g_debug then
1908: hr_utility.set_location(l_proc, 640);
1909: end if;
1910: --
1911: per_asg_bus3.chk_po_line_id
1912: (p_assignment_id => p_rec.assignment_id
1915: ,p_object_version_number => p_rec.object_version_number
1916: ,p_effective_date => p_effective_date);
1917: --
1918: if g_debug then
1919: hr_utility.set_location(l_proc, 650);
1920: end if;
1921: --
1922: per_asg_bus3.chk_projected_assignment_end
1923: (p_assignment_id => p_rec.assignment_id
1927: ,p_object_version_number => p_rec.object_version_number
1928: ,p_effective_date => p_effective_date);
1929: --
1930: if g_debug then
1931: hr_utility.set_location(l_proc, 660);
1932: end if;
1933: --
1934: per_asg_bus3.chk_vendor_id_site_id
1935: (p_assignment_id => p_rec.assignment_id
1938: ,p_object_version_number => p_rec.object_version_number
1939: ,p_effective_date => p_effective_date);
1940: --
1941: if g_debug then
1942: hr_utility.set_location(l_proc, 670);
1943: end if;
1944: --
1945: per_asg_bus3.chk_po_header_id_line_id
1946: (p_assignment_id => p_rec.assignment_id
1949: ,p_object_version_number => p_rec.object_version_number
1950: ,p_effective_date => p_effective_date);
1951: --
1952: if g_debug then
1953: hr_utility.set_location(l_proc, 680);
1954: end if;
1955: --
1956: per_asg_bus3.chk_vendor_po_match
1957: (p_assignment_id => p_rec.assignment_id
1961: ,p_object_version_number => p_rec.object_version_number
1962: ,p_effective_date => p_effective_date);
1963: --
1964: if g_debug then
1965: hr_utility.set_location(l_proc, 690);
1966: end if;
1967: --
1968: per_asg_bus3.chk_po_job_match
1969: (p_assignment_id => p_rec.assignment_id
1972: ,p_object_version_number => p_rec.object_version_number
1973: ,p_effective_date => p_effective_date);
1974: --
1975: if g_debug then
1976: hr_utility.set_location(l_proc, 700);
1977: end if;
1978: --
1979: per_asg_bus3.chk_vendor_assignment_number
1980: (p_assignment_id => p_rec.assignment_id
1984: ,p_object_version_number => p_rec.object_version_number
1985: ,p_effective_date => p_effective_date);
1986: --
1987: if g_debug then
1988: hr_utility.set_location(l_proc, 710);
1989: end if;
1990: --
1991: per_asg_bus3.chk_vendor_employee_number
1992: (p_assignment_id => p_rec.assignment_id
1996: ,p_object_version_number => p_rec.object_version_number
1997: ,p_effective_date => p_effective_date);
1998: --
1999: if g_debug then
2000: hr_utility.set_location(l_proc, 720);
2001: end if;
2002: --
2003: per_asg_bus3.chk_pop_date_start
2004: (p_assignment_id => p_rec.assignment_id
2011: ,p_effective_date => p_effective_date
2012: ,p_object_version_number => p_rec.object_version_number);
2013: --
2014: if g_debug then
2015: hr_utility.set_location(l_proc, 730);
2016: end if;
2017: --
2018: per_asg_bus3.chk_grade_ladder_pgm_id
2019: (p_grade_id => p_rec.grade_id
2063: --
2064: */
2065: --
2066: if g_debug then
2067: hr_utility.set_location(' Leaving:'||l_proc, 740);
2068: end if;
2069: End insert_validate;
2070: --
2071: -- ----------------------------------------------------------------------------
2103: --
2104: Begin
2105: if g_debug then
2106: l_proc := g_package||'update_validate';
2107: hr_utility.set_location('Entering:'||l_proc, 10);
2108: end if;
2109: --
2110: -- Call all supporting business operations. Mapping to the
2111: -- appropriate Business Rules in perasg.bru is provided (where relevant).
2138: (p_rec => p_rec
2139: ,p_effective_date => p_effective_date
2140: );
2141: if g_debug then
2142: hr_utility.set_location(l_proc, 20);
2143: end if;
2144: --
2145: per_asg_bus2.chk_system_pers_type
2146: (p_person_id => p_rec.person_id
2150: ,p_effective_date => p_effective_date
2151:
2152: );
2153: if g_debug then
2154: hr_utility.set_location(l_proc, 21);
2155: end if;
2156: --
2157: per_asg_bus2.chk_term_status
2158: (p_assignment_id => p_rec.assignment_id
2159: ,p_datetrack_mode => p_datetrack_mode
2160: ,p_validation_start_date => p_validation_start_date
2161: );
2162: if g_debug then
2163: hr_utility.set_location(l_proc, 22);
2164: end if;
2165: --
2166: -- per_asg_bus2.chk_title(p_title => p_rec.title);
2167: --
2168: per_asg_bus2.chk_time_finish_formatted --#2734822
2169: (p_time_normal_finish => p_rec.time_normal_finish
2170: );
2171: if g_debug then
2172: hr_utility.set_location(l_proc, 25);
2173: end if;
2174: --
2175: per_asg_bus2.chk_time_start_formatted --#2734822
2176: (p_time_normal_start => p_rec.time_normal_start
2175: per_asg_bus2.chk_time_start_formatted --#2734822
2176: (p_time_normal_start => p_rec.time_normal_start
2177: );
2178: if g_debug then
2179: hr_utility.set_location(l_proc, 30);
2180: end if;
2181: --
2182: per_asg_bus1.chk_assignment_type
2183: (p_assignment_id => p_rec.assignment_id
2187: ,p_object_version_number => p_rec.object_version_number
2188: ,p_validation_start_date => p_validation_start_date
2189: );
2190: if g_debug then
2191: hr_utility.set_location(l_proc, 30);
2192: end if;
2193: --
2194: per_asg_bus2.chk_probation_unit
2195: (p_assignment_id => p_rec.assignment_id
2200: ,p_validation_end_date => p_validation_end_date
2201: ,p_object_version_number => p_rec.object_version_number
2202: );
2203: if g_debug then
2204: hr_utility.set_location(l_proc, 40);
2205: end if;
2206: --
2207: per_asg_bus2.chk_probation_period
2208: (p_assignment_id => p_rec.assignment_id
2210: ,p_effective_date => p_effective_date
2211: ,p_object_version_number => p_rec.object_version_number
2212: );
2213: if g_debug then
2214: hr_utility.set_location(l_proc, 50);
2215: end if;
2216: --
2217:
2218: per_asg_bus2.chk_prob_unit_prob_period
2222: ,p_effective_date => p_effective_date
2223: ,p_object_version_number => p_rec.object_version_number
2224: );
2225: if g_debug then
2226: hr_utility.set_location(l_proc, 60);
2227: end if;
2228: --
2229: per_asg_bus2.chk_source_type
2230: (p_assignment_id => p_rec.assignment_id
2236: ,p_validation_end_date => p_validation_end_date
2237: ,p_object_version_number => p_rec.object_version_number
2238: );
2239: if g_debug then
2240: hr_utility.set_location(l_proc, 70);
2241: end if;
2242: --
2243: per_asg_bus1.chk_date_probation_end
2244: (p_assignment_id => p_rec.assignment_id
2251: ,p_effective_date => p_effective_date
2252: ,p_object_version_number => p_rec.object_version_number
2253: );
2254: if g_debug then
2255: hr_utility.set_location(l_proc, 80);
2256: end if;
2257: --
2258: per_asg_bus2.chk_internal_address_line
2259: (p_assignment_id => p_rec.assignment_id
2263: ,p_object_version_number => p_rec.object_version_number
2264: );
2265:
2266: if g_debug then
2267: hr_utility.set_location(l_proc, 90);
2268: end if;
2269: --
2270: per_asg_bus1.chk_change_reason
2271: (p_assignment_id => p_rec.assignment_id
2276: ,p_validation_end_date => p_validation_end_date
2277: ,p_object_version_number => p_rec.object_version_number
2278: );
2279: if g_debug then
2280: hr_utility.set_location(l_proc, 100);
2281: end if;
2282: --
2283:
2284: per_asg_bus1.chk_default_code_comb_id
2289: ,p_validation_start_date => p_validation_start_date
2290: ,p_object_version_number => p_rec.object_version_number
2291: );
2292: if g_debug then
2293: hr_utility.set_location(l_proc, 110);
2294: end if;
2295: --
2296: per_asg_bus1.chk_employment_category
2297: (p_assignment_id => p_rec.assignment_id
2303: ,p_validation_end_date => p_validation_end_date
2304: ,p_object_version_number => p_rec.object_version_number
2305: );
2306: if g_debug then
2307: hr_utility.set_location(l_proc, 120);
2308: end if;
2309: --
2310: per_asg_bus2.chk_sal_review_period
2311: (p_assignment_id => p_rec.assignment_id
2315:
2316: ,p_object_version_number => p_rec.object_version_number
2317: );
2318: if g_debug then
2319: hr_utility.set_location(l_proc, 130);
2320: end if;
2321: --
2322: per_asg_bus2.chk_sal_review_period_freq
2323: (p_assignment_id => p_rec.assignment_id
2329: ,p_object_version_number => p_rec.object_version_number
2330: );
2331:
2332: if g_debug then
2333: hr_utility.set_location(l_proc, 140);
2334: end if;
2335: --
2336: per_asg_bus2.chk_sal_rp_freq_sal_rp
2337: (p_assignment_id => p_rec.assignment_id
2340: ,p_effective_date => p_effective_date
2341: ,p_object_version_number => p_rec.object_version_number
2342: );
2343: if g_debug then
2344: hr_utility.set_location(l_proc, 150);
2345: end if;
2346: --
2347: per_asg_bus2.chk_perf_review_period
2348: (p_assignment_id => p_rec.assignment_id
2352: ,p_effective_date => p_effective_date
2353: ,p_object_version_number => p_rec.object_version_number
2354: );
2355: if g_debug then
2356: hr_utility.set_location(l_proc, 160);
2357: end if;
2358: --
2359: per_asg_bus2.chk_perf_review_period_freq
2360: (p_assignment_id => p_rec.assignment_id
2366: ,p_validation_end_date => p_validation_end_date
2367: ,p_object_version_number => p_rec.object_version_number
2368: );
2369: if g_debug then
2370: hr_utility.set_location(l_proc, 170);
2371: end if;
2372: --
2373: per_asg_bus2.chk_perf_rp_freq_perf_rp
2374: (p_assignment_id => p_rec.assignment_id
2377: ,p_effective_date => p_effective_date
2378: ,p_object_version_number => p_rec.object_version_number
2379: );
2380: if g_debug then
2381: hr_utility.set_location(l_proc, 180);
2382: end if;
2383:
2384: --
2385: per_asg_bus1.chk_frequency
2390: ,p_validation_end_date => p_validation_end_date
2391: ,p_object_version_number => p_rec.object_version_number
2392: );
2393: if g_debug then
2394: hr_utility.set_location(l_proc, 190);
2395: end if;
2396: --
2397: per_asg_bus1.chk_frequency_normal_hours
2398: (p_assignment_id => p_rec.assignment_id
2402: ,p_effective_date => p_effective_date
2403: ,p_object_version_number => p_rec.object_version_number
2404: );
2405: if g_debug then
2406: hr_utility.set_location(l_proc, 200);
2407: end if;
2408: --
2409: per_asg_bus2.chk_set_of_books_id
2410: (p_assignment_id => p_rec.assignment_id
2415:
2416: ,p_object_version_number => p_rec.object_version_number
2417: );
2418: if g_debug then
2419: hr_utility.set_location(l_proc, 210);
2420: end if;
2421: --
2422: per_asg_bus2.chk_source_organization_id
2423: (p_assignment_id => p_rec.assignment_id
2430: ,p_validation_end_date => p_validation_end_date
2431:
2432: );
2433: if g_debug then
2434: hr_utility.set_location(l_proc, 220);
2435: end if;
2436: --
2437: per_asg_bus2.chk_soft_coding_keyflex_id
2438: (p_assignment_id => p_rec.assignment_id
2444: ,p_payroll_id => p_rec.payroll_id
2445: ,p_business_group_id => p_rec.business_group_id
2446: );
2447: if g_debug then
2448: hr_utility.set_location(l_proc, 230);
2449: end if;
2450: --
2451:
2452: per_asg_bus2.chk_pay_basis_id
2458: ,p_validation_start_date => p_validation_start_date
2459: ,p_object_version_number => p_rec.object_version_number
2460: );
2461: if g_debug then
2462: hr_utility.set_location(l_proc, 240);
2463: end if;
2464: --
2465: per_asg_bus2.chk_recruitment_activity_id
2466: (p_assignment_id => p_rec.assignment_id
2472: ,p_validation_start_date => p_validation_start_date
2473: ,p_validation_end_date => p_validation_end_date
2474: );
2475: if g_debug then
2476: hr_utility.set_location(l_proc, 250);
2477: end if;
2478: --
2479: per_asg_bus2.chk_vacancy_id
2480: (p_assignment_id => p_rec.assignment_id
2487: ,p_validation_start_date => p_validation_start_date
2488: ,p_validation_end_date => p_validation_end_date
2489: );
2490: if g_debug then
2491: hr_utility.set_location(l_proc, 260);
2492: end if;
2493: --
2494: per_asg_bus1.chk_location_id
2495: (p_assignment_id => p_rec.assignment_id
2502: ,p_effective_date => p_effective_date
2503: ,p_object_version_number => p_rec.object_version_number
2504: );
2505: if g_debug then
2506: hr_utility.set_location(l_proc, 270);
2507: end if;
2508: --
2509: per_asg_bus2.chk_people_group_id
2510: (p_assignment_id => p_rec.assignment_id
2518: ,p_effective_date => p_effective_date
2519: ,p_object_version_number => p_rec.object_version_number
2520: );
2521: if g_debug then
2522: hr_utility.set_location(l_proc, 280);
2523: end if;
2524: --
2525: if g_debug then
2526: hr_utility.set_location(p_validation_start_date, 290);
2522: hr_utility.set_location(l_proc, 280);
2523: end if;
2524: --
2525: if g_debug then
2526: hr_utility.set_location(p_validation_start_date, 290);
2527: end if;
2528: if g_debug then
2529: hr_utility.set_location(p_validation_end_date, 290);
2530: end if;
2525: if g_debug then
2526: hr_utility.set_location(p_validation_start_date, 290);
2527: end if;
2528: if g_debug then
2529: hr_utility.set_location(p_validation_end_date, 290);
2530: end if;
2531: per_asg_bus2.chk_position_id
2532: (p_assignment_id => p_rec.assignment_id
2533: ,p_position_id => p_rec.position_id
2540: ,p_effective_date => p_effective_date
2541: ,p_object_version_number => p_rec.object_version_number
2542: );
2543: if g_debug then
2544: hr_utility.set_location(l_proc, 290);
2545: end if;
2546: --
2547: per_asg_bus1.chk_job_id
2548: (p_assignment_id => p_rec.assignment_id
2556: ,p_validation_end_date => p_validation_end_date
2557: ,p_object_version_number => p_rec.object_version_number
2558: );
2559: if g_debug then
2560: hr_utility.set_location(l_proc, 300);
2561: end if;
2562: --
2563: per_asg_bus2.chk_position_id_job_id
2564: (p_assignment_id => p_rec.assignment_id
2570: ,p_effective_date => p_effective_date
2571: ,p_object_version_number => p_rec.object_version_number
2572: );
2573: if g_debug then
2574: hr_utility.set_location(l_proc, 310);
2575: end if;
2576: --
2577: per_asg_bus1.chk_grade_id
2578: (p_assignment_id => p_rec.assignment_id
2587: ,p_validation_end_date => p_validation_end_date
2588: ,p_object_version_number => p_rec.object_version_number
2589: );
2590: if g_debug then
2591: hr_utility.set_location(l_proc, 320);
2592: end if;
2593: --
2594: per_asg_bus2.chk_special_ceiling_step_id
2595: (p_assignment_id => p_rec.assignment_id
2603: ,p_effective_date => p_effective_date
2604: ,p_object_version_number => p_rec.object_version_number
2605: );
2606: if g_debug then
2607: hr_utility.set_location(l_proc, 330);
2608: end if;
2609: --
2610: per_asg_bus2.chk_position_id_grade_id
2611: (p_assignment_id => p_rec.assignment_id
2618: ,p_object_version_number => p_rec.object_version_number
2619: ,p_inv_pos_grade_warning => l_inv_pos_grade_warning
2620: );
2621: if g_debug then
2622: hr_utility.set_location(l_proc, 340);
2623: end if;
2624: --
2625: per_asg_bus1.chk_job_id_grade_id
2626: (p_assignment_id => p_rec.assignment_id
2633: ,p_object_version_number => p_rec.object_version_number
2634: ,p_inv_job_grade_warning => l_inv_pos_grade_warning
2635: );
2636: if g_debug then
2637: hr_utility.set_location(l_proc, 350);
2638: end if;
2639: --
2640: per_asg_bus2.chk_supervisor_id
2641: (p_assignment_id => p_rec.assignment_id
2646: ,p_effective_date => p_effective_date
2647: ,p_object_version_number => p_rec.object_version_number
2648: );
2649: if g_debug then
2650: hr_utility.set_location(l_proc, 360);
2651: end if;
2652: --
2653: per_asg_bus2.chk_supervisor_assignment_id
2654: (p_assignment_id => p_rec.assignment_id
2658: ,p_effective_date => p_effective_date
2659: ,p_object_version_number => p_rec.object_version_number
2660: );
2661: if g_debug then
2662: hr_utility.set_location(l_proc, 350);
2663: end if;
2664: --
2665: per_asg_bus2.chk_person_referred_by_id
2666: (p_assignment_id => p_rec.assignment_id
2674: ,p_validation_end_date => p_validation_end_date
2675:
2676: );
2677: if g_debug then
2678: hr_utility.set_location(l_proc, 370);
2679: end if;
2680: --
2681: per_asg_bus2.chk_recruiter_id
2682: (p_assignment_id => p_rec.assignment_id
2691:
2692: ,p_validation_end_date => p_validation_end_date
2693: );
2694: if g_debug then
2695: hr_utility.set_location(l_proc, 380);
2696: end if;
2697: --
2698: per_asg_bus2.chk_period_of_service_id
2699: (p_assignment_id => p_rec.assignment_id
2706: ,p_effective_date => p_effective_date
2707: ,p_object_version_number => p_rec.object_version_number
2708: );
2709: if g_debug then
2710: hr_utility.set_location(l_proc, 385);
2711: end if;
2712: --
2713: -- bug 5404529
2714: l_api_updating := per_asg_shd.api_updating
2728: );
2729:
2730: end if;
2731: if ( l_assignment_sequence =1 ) then
2732: hr_utility.set_location(l_proc, 386);
2733: p_rec.assignment_sequence:=1;
2734: per_asg_bus1.gen_chk_assignment_number
2735: (p_assignment_id => p_rec.assignment_id
2736: ,p_business_group_id => p_rec.business_group_id
2740: ,p_person_id => p_rec.person_id
2741: ,p_effective_date => p_effective_date
2742: ,p_object_version_number => p_rec.object_version_number
2743: );
2744: hr_utility.set_location(l_proc, 387);
2745: else
2746: hr_utility.set_location(l_proc, 388);
2747: per_asg_bus1.gen_chk_assignment_number
2748: (p_assignment_id => p_rec.assignment_id
2742: ,p_object_version_number => p_rec.object_version_number
2743: );
2744: hr_utility.set_location(l_proc, 387);
2745: else
2746: hr_utility.set_location(l_proc, 388);
2747: per_asg_bus1.gen_chk_assignment_number
2748: (p_assignment_id => p_rec.assignment_id
2749: ,p_business_group_id => p_rec.business_group_id
2750: ,p_assignment_type => p_rec.assignment_type
2753: ,p_person_id => p_rec.person_id
2754: ,p_effective_date => p_effective_date
2755: ,p_object_version_number => p_rec.object_version_number
2756: );
2757: hr_utility.set_location(l_proc, 389);
2758: end if;
2759:
2760: -- end of bug 5404529
2761:
2759:
2760: -- end of bug 5404529
2761:
2762: if g_debug then
2763: hr_utility.set_location(l_proc, 390);
2764: end if;
2765: --
2766: per_asg_bus2.chk_primary_flag
2767: (p_assignment_id => p_rec.assignment_id
2775: ,p_validation_start_date => p_validation_start_date
2776: ,p_validation_end_date => p_validation_end_date
2777: );
2778: if g_debug then
2779: hr_utility.set_location(l_proc, 430);
2780: end if;
2781: --
2782: per_asg_bus1.chk_manager_flag
2783: (p_assignment_id => p_rec.assignment_id
2790: ,p_no_managers_warning => l_no_managers_warning
2791: );
2792:
2793: if g_debug then
2794: hr_utility.set_location(l_proc, 400);
2795: end if;
2796: --
2797: per_asg_bus1.chk_organization_id
2798: (p_assignment_id => p_rec.assignment_id
2810: ,p_org_now_no_manager_warning => l_temp_flag
2811: ,p_other_manager_warning => l_other_manager_warning
2812: );
2813: if g_debug then
2814: hr_utility.set_location(l_proc, 410);
2815: end if;
2816: --
2817: per_asg_bus2.chk_position_id_org_id
2818: (p_assignment_id => p_rec.assignment_id
2824: ,p_effective_date => p_effective_date
2825: ,p_object_version_number => p_rec.object_version_number
2826: );
2827: if g_debug then
2828: hr_utility.set_location(l_proc, 420);
2829: end if;
2830: --
2831: per_asg_bus1.chk_application_id
2832: (p_assignment_id => p_rec.assignment_id
2839:
2840: ,p_validation_start_date => p_validation_start_date
2841: );
2842: if g_debug then
2843: hr_utility.set_location(l_proc, 430);
2844: end if;
2845: --
2846: per_asg_bus2.chk_payroll_id
2847: (p_assignment_id => p_rec.assignment_id
2857: ,p_payroll_id_updated => l_payroll_id_updated
2858: ,p_object_version_number => p_rec.object_version_number
2859: );
2860: if g_debug then
2861: hr_utility.set_location(l_proc, 440);
2862: end if;
2863: --
2864: per_asg_bus1.chk_assignment_status_type_id
2865: (p_rec => p_rec
2866: ,p_effective_date => p_effective_date
2867: ,p_validation_start_date => p_validation_start_date
2868: );
2869: if g_debug then
2870: hr_utility.set_location(l_proc, 450);
2871: end if;
2872: --
2873: per_asg_bus1.chk_bargaining_unit_code
2874: (p_assignment_id => p_rec.assignment_id
2878: ,p_validation_start_date => p_validation_start_date
2879: ,p_validation_end_date => p_validation_end_date
2880: );
2881: if g_debug then
2882: hr_utility.set_location(l_proc, 451);
2883: end if;
2884: --
2885: per_asg_bus1.chk_hourly_salaried_code
2886: (p_assignment_id => p_rec.assignment_id
2893: ,p_hourly_salaried_warning => l_hourly_salaried_warning
2894: ,p_assignment_type => p_rec.assignment_type);
2895: --
2896: if g_debug then
2897: hr_utility.set_location(l_proc, 452);
2898: end if;
2899: --
2900: per_asg_bus1.chk_single_position
2901: (p_assignment_id => p_rec.assignment_id
2905: ,p_assignment_type => p_rec.assignment_type
2906: );
2907: --
2908: if g_debug then
2909: hr_utility.set_location(l_proc, 453);
2910: end if;
2911: --
2912: per_asg_bus3.chk_contract_id
2913: (p_assignment_id => p_rec.assignment_id
2918: ,p_validation_start_date => p_validation_start_date
2919: ,p_business_group_id => p_rec.business_group_id
2920: ) ;
2921: if g_debug then
2922: hr_utility.set_location(l_proc, 510);
2923: end if;
2924: --
2925: per_asg_bus3.chk_establishment_id
2926: (p_assignment_id => p_rec.assignment_id
2930: ,p_assignment_type => p_rec.assignment_type
2931: ,p_business_group_id => p_rec.business_group_id
2932: );
2933: if g_debug then
2934: hr_utility.set_location(l_proc, 520);
2935: end if;
2936: --
2937: per_asg_bus3.chk_collective_agreement_id
2938: (p_assignment_id => p_rec.assignment_id
2942: ,p_business_group_id => p_rec.business_group_id
2943: ,p_establishment_id => p_rec.establishment_id
2944: );
2945: if g_debug then
2946: hr_utility.set_location(l_proc, 530);
2947: end if;
2948: --
2949: per_asg_bus3.chk_cagr_id_flex_num
2950: (p_assignment_id => p_rec.assignment_id
2953: ,p_cagr_id_flex_num => p_rec.cagr_id_flex_num
2954: ,p_collective_agreement_id => p_rec.collective_agreement_id
2955: ) ;
2956: if g_debug then
2957: hr_utility.set_location(l_proc, 535);
2958: end if;
2959: --
2960: per_asg_bus3.chk_cagr_grade_def_id
2961: (p_assignment_id => p_rec.assignment_id
2996: ,p_validation_end_date => p_validation_end_date
2997: );
2998: --
2999: if g_debug then
3000: hr_utility.set_location(l_proc, 600);
3001: end if;
3002: --
3003: per_asg_bus1.chk_assignment_category
3004: (p_assignment_id => p_rec.assignment_id
3009: ,p_validation_start_date => p_validation_start_date
3010: ,p_validation_end_date => p_validation_end_date);
3011: --
3012: if g_debug then
3013: hr_utility.set_location(l_proc, 610);
3014: end if;
3015: --
3016: per_asg_bus3.chk_vendor_id
3017: (p_assignment_id => p_rec.assignment_id
3021: ,p_object_version_number => p_rec.object_version_number
3022: ,p_effective_date => p_effective_date);
3023: --
3024: if g_debug then
3025: hr_utility.set_location(l_proc, 620);
3026: end if;
3027: per_asg_bus3.chk_vendor_site_id
3028: (p_assignment_id => p_rec.assignment_id
3029: ,p_assignment_type => p_rec.assignment_type
3031: ,p_object_version_number => p_rec.object_version_number
3032: ,p_effective_date => p_effective_date);
3033: --
3034: if g_debug then
3035: hr_utility.set_location(l_proc, 630);
3036: end if;
3037: --
3038: per_asg_bus3.chk_po_header_id
3039: (p_assignment_id => p_rec.assignment_id
3043: ,p_object_version_number => p_rec.object_version_number
3044: ,p_effective_date => p_effective_date);
3045: --
3046: if g_debug then
3047: hr_utility.set_location(l_proc, 640);
3048: end if;
3049: --
3050: per_asg_bus3.chk_po_line_id
3051: (p_assignment_id => p_rec.assignment_id
3054: ,p_object_version_number => p_rec.object_version_number
3055: ,p_effective_date => p_effective_date);
3056: --
3057: if g_debug then
3058: hr_utility.set_location(l_proc, 650);
3059: end if;
3060: --
3061: per_asg_bus3.chk_projected_assignment_end
3062: (p_assignment_id => p_rec.assignment_id
3066: ,p_object_version_number => p_rec.object_version_number
3067: ,p_effective_date => p_effective_date);
3068: --
3069: if g_debug then
3070: hr_utility.set_location(l_proc, 660);
3071: end if;
3072: --
3073: per_asg_bus3.chk_vendor_id_site_id
3074: (p_assignment_id => p_rec.assignment_id
3077: ,p_object_version_number => p_rec.object_version_number
3078: ,p_effective_date => p_effective_date);
3079: --
3080: if g_debug then
3081: hr_utility.set_location(l_proc, 670);
3082: end if;
3083: --
3084: per_asg_bus3.chk_po_header_id_line_id
3085: (p_assignment_id => p_rec.assignment_id
3088: ,p_object_version_number => p_rec.object_version_number
3089: ,p_effective_date => p_effective_date);
3090: --
3091: if g_debug then
3092: hr_utility.set_location(l_proc, 680);
3093: end if;
3094: --
3095: per_asg_bus3.chk_vendor_po_match
3096: (p_assignment_id => p_rec.assignment_id
3100: ,p_object_version_number => p_rec.object_version_number
3101: ,p_effective_date => p_effective_date);
3102: --
3103: if g_debug then
3104: hr_utility.set_location(l_proc, 690);
3105: end if;
3106: --
3107: per_asg_bus3.chk_po_job_match
3108: (p_assignment_id => p_rec.assignment_id
3111: ,p_object_version_number => p_rec.object_version_number
3112: ,p_effective_date => p_effective_date);
3113: --
3114: if g_debug then
3115: hr_utility.set_location(l_proc, 700);
3116: end if;
3117: --
3118: per_asg_bus3.chk_vendor_assignment_number
3119: (p_assignment_id => p_rec.assignment_id
3123: ,p_object_version_number => p_rec.object_version_number
3124: ,p_effective_date => p_effective_date);
3125: --
3126: if g_debug then
3127: hr_utility.set_location(l_proc, 710);
3128: end if;
3129: --
3130: per_asg_bus3.chk_vendor_employee_number
3131: (p_assignment_id => p_rec.assignment_id
3135: ,p_object_version_number => p_rec.object_version_number
3136: ,p_effective_date => p_effective_date);
3137: --
3138: if g_debug then
3139: hr_utility.set_location(l_proc, 720);
3140: end if;
3141: --
3142: per_asg_bus3.chk_pop_date_start
3143: (p_assignment_id => p_rec.assignment_id
3150: ,p_effective_date => p_effective_date
3151: ,p_object_version_number => p_rec.object_version_number);
3152: --
3153: if g_debug then
3154: hr_utility.set_location(l_proc, 730);
3155: end if;
3156: --
3157: per_asg_bus2.chk_applicant_rank
3158: (p_applicant_rank => p_rec.applicant_rank
3168: ,p_object_version_number => p_rec.object_version_number
3169: ,p_effective_date => p_effective_date);
3170: --
3171: if g_debug then
3172: hr_utility.set_location(l_proc, 740);
3173: end if;
3174: --
3175: per_asg_bus3.chk_grade_ladder_pgm_id
3176: (p_grade_id => p_rec.grade_id
3184: --
3185: per_asg_bus1.chk_df(p_rec => p_rec);
3186:
3187: if g_debug then
3188: hr_utility.set_location(l_proc, 750);
3189: end if;
3190: --
3191: -- Call the datetrack update integrity operation
3192: --
3240: */
3241: --
3242: --
3243: if g_debug then
3244: hr_utility.set_location(' Leaving:'||l_proc, 999);
3245: end if;
3246: End update_validate;
3247: --
3248: -- ---------------------------------------------------------------------------
3281: and nvl(date_end,hr_api.g_eot);
3282: --
3283: begin
3284: if g_debug then
3285: hr_utility.set_location('Entering:'|| l_proc, 10);
3286: end if;
3287: --
3288: --
3289: -- Check mandatory parameters have been set
3299: ,p_argument => 'validation_start_date'
3300: ,p_argument_value => p_validation_start_date
3301: );
3302: if g_debug then
3303: hr_utility.set_location(l_proc, 20);
3304: end if;
3305: --
3306: -- Check if the assignment is being updated.
3307: --
3309: (p_assignment_id => p_assignment_id
3310: ,p_effective_date => p_effective_date
3311: ,p_object_version_number => p_object_version_number);
3312: if g_debug then
3313: hr_utility.set_location(l_proc, 30);
3314: end if;
3315: --
3316: -- Check if the assignment is being inserted or updated.
3317: --
3320: <> nvl(p_application_id, hr_api.g_number))
3321: or (NOT l_api_updating))
3322: then
3323: if g_debug then
3324: hr_utility.set_location(l_proc, 40);
3325: end if;
3326: --
3327: -- Check if the assignment is an applicant assignment or
3328: -- offer assignment or an employee assignment which is being updated.
3340: --
3341: if p_assignment_type = 'A'
3342: or p_assignment_type = 'O' then
3343: --
3344: hr_utility.set_message(801, 'HR_51212_ASG_INV_APL_ASG_APL');
3345: hr_utility.raise_error;
3346: /* hr_multi_message.add
3347: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICATION_ID'
3348: );*/
3341: if p_assignment_type = 'A'
3342: or p_assignment_type = 'O' then
3343: --
3344: hr_utility.set_message(801, 'HR_51212_ASG_INV_APL_ASG_APL');
3345: hr_utility.raise_error;
3346: /* hr_multi_message.add
3347: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICATION_ID'
3348: );*/
3349: --
3348: );*/
3349: --
3350: end if;
3351: if g_debug then
3352: hr_utility.set_location(l_proc, 50);
3353: end if;
3354: --
3355: -- Check if the existing application is set
3356: --
3355: -- Check if the existing application is set
3356: --
3357: If per_asg_shd.g_old_rec.application_id is not null then
3358: --
3359: hr_utility.set_message(801, 'HR_51213_ASG_INV_UPD_APL');
3360: hr_utility.raise_error;
3361: /*hr_multi_message.add
3362: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICATION_ID'
3363: ); */ --
3356: --
3357: If per_asg_shd.g_old_rec.application_id is not null then
3358: --
3359: hr_utility.set_message(801, 'HR_51213_ASG_INV_UPD_APL');
3360: hr_utility.raise_error;
3361: /*hr_multi_message.add
3362: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICATION_ID'
3363: ); */ --
3364: --
3363: ); */ --
3364: --
3365: end if;
3366: if g_debug then
3367: hr_utility.set_location(l_proc, 60);
3368: end if;
3369: --
3370: end if;
3371: --
3383: open csr_valid_apl_1;
3384: fetch csr_valid_apl_1 into l_business_group_id;
3385: if csr_valid_apl_1%notfound then
3386: close csr_valid_apl_1;
3387: hr_utility.set_message(801, 'HR_51210_ASG_INV_APL');
3388: hr_utility.raise_error;
3389: /* hr_multi_message.add
3390: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICATION_ID'
3391: ,p_associated_column2 =>
3384: fetch csr_valid_apl_1 into l_business_group_id;
3385: if csr_valid_apl_1%notfound then
3386: close csr_valid_apl_1;
3387: hr_utility.set_message(801, 'HR_51210_ASG_INV_APL');
3388: hr_utility.raise_error;
3389: /* hr_multi_message.add
3390: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICATION_ID'
3391: ,p_associated_column2 =>
3392: 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
3407: open csr_valid_apl_2;
3408: fetch csr_valid_apl_2 into l_business_group_id;
3409: if csr_valid_apl_2%notfound then
3410: close csr_valid_apl_2;
3411: hr_utility.set_message(801, 'HR_51375_ASG_INV_APL_NOT_1_ASG');
3412: hr_multi_message.add
3413: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICATION_ID'
3414: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
3415: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_SEQUENCE'
3421: -- Check that the application is in the same business group
3422: -- as the business group of the assignment.
3423: --
3424: if g_debug then
3425: hr_utility.set_location(l_proc, 90);
3426: end if;
3427: If p_business_group_id <> l_business_group_id then
3428: --
3429: hr_utility.set_message(801, 'HR_51214_ASG_INV_APL_BUS_GRP');
3425: hr_utility.set_location(l_proc, 90);
3426: end if;
3427: If p_business_group_id <> l_business_group_id then
3428: --
3429: hr_utility.set_message(801, 'HR_51214_ASG_INV_APL_BUS_GRP');
3430: hr_multi_message.add
3431: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICATION_ID'
3432: );
3433: --
3433: --
3434: end if;
3435: end if;
3436: if g_debug then
3437: hr_utility.set_location(l_proc, 100);
3438: end if;
3439: --
3440: end if;
3441: --
3444: -- Check that application is null
3445: --
3446: If p_application_id is not null then
3447: --
3448: hr_utility.set_message(801, 'HR_51211_ASG_INV_E_ASG_APL_ID');
3449: hr_multi_message.add
3450: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICATION_ID'
3451: );
3452: --
3451: );
3452: --
3453: end if;
3454: if g_debug then
3455: hr_utility.set_location(l_proc, 110);
3456: end if;
3457: --
3458: end if;
3459: --
3459: --
3460: end if;
3461: --
3462: if g_debug then
3463: hr_utility.set_location(' Leaving:'|| l_proc, 120);
3464: end if;
3465: end chk_application_id;
3466: --
3467: -- ---------------------------------------------------------------------------
3493: --
3494: begin
3495: --
3496: if g_debug then
3497: hr_utility.set_location('Entering: '|| l_proc, 10);
3498: end if;
3499: --
3500: hr_api.mandatory_arg_error
3501: (p_api_name => l_proc
3520: ,p_argument => 'assignment_sequence'
3521: ,p_argument_value => p_assignment_sequence
3522: );
3523: if g_debug then
3524: hr_utility.set_location(l_proc, 20);
3525: end if;
3526: --
3527: -- Only proceed with validation if :
3528: -- a) The current g_old_rec is current and
3534: ,p_effective_date => p_effective_date
3535: ,p_object_version_number => p_object_version_number
3536: );
3537: if g_debug then
3538: hr_utility.set_location(l_proc, 30);
3539: end if;
3540: --
3541: -- Amended for bug 942142
3542: -- Removed p_assignment_number is not null from the check condition
3547: nvl(p_assignment_number, hr_api.g_varchar2)) or
3548: (NOT l_api_updating)) then
3549: --
3550: if g_debug then
3551: hr_utility.set_location(l_proc, 40);
3552: end if;
3553: --
3554: -- For applicant and offer assignments ensure the assignment_number
3555: -- is null
3562: if p_assignment_number is not null then
3563: --
3564: -- Raise an error: Assignment Number must be null for
3565: -- applicant, offer and benefit assignments
3566: hr_utility.set_message(801, 'HR_51017_ASG_NUM_NULL_FOR_APL');
3567: hr_multi_message.add
3568: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER');
3569: --
3570: end if;
3569: --
3570: end if;
3571: --
3572: if g_debug then
3573: hr_utility.set_location(l_proc, 50);
3574: end if;
3575: --
3576: -- For Employee and Contingent Labour assignments derive the
3577: -- assignment number.
3589: if csr_get_work_no%found then
3590: --
3591: close csr_get_work_no;
3592: if g_debug then
3593: hr_utility.set_location(l_proc, 60);
3594: end if;
3595: --
3596: hr_assignment.gen_new_ass_number
3597: (p_assignment_id => p_assignment_id
3601: ,p_assignment_sequence => p_assignment_sequence
3602: ,p_assignment_number => p_assignment_number);
3603: --
3604: if g_debug then
3605: hr_utility.set_location(l_proc, 70);
3606: end if;
3607: --
3608: else
3609: --
3609: --
3610: -- No worker number found for assignment
3611: --
3612: close csr_get_work_no;
3613: hr_utility.set_message(801, 'HR_7390_ASG_NO_EMP_NO');
3614: hr_multi_message.add
3615: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
3616: ,p_associated_column2 =>
3617: 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE');
3620: --
3621: end if; -- no exclusive error
3622: --
3623: if g_debug then
3624: hr_utility.set_location(l_proc, 90);
3625: end if;
3626: --
3627: end if;
3628: --
3644: if csr_get_work_no%found then
3645: --
3646: close csr_get_work_no;
3647: if g_debug then
3648: hr_utility.set_location(l_proc, 60);
3649: end if;
3650: --
3651: hr_assignment.gen_new_ass_number
3652: (p_assignment_id => p_assignment_id
3656: ,p_assignment_sequence => p_assignment_sequence
3657: ,p_assignment_number => p_assignment_number);
3658: --
3659: if g_debug then
3660: hr_utility.set_location(l_proc, 70);
3661: end if;
3662: --
3663: else
3664: --
3665: -- No employee number found for assignment
3666: --
3667: close csr_get_work_no;
3668: --
3669: hr_utility.set_message(801, 'HR_7390_ASG_NO_EMP_NO');
3670: hr_multi_message.add
3671: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
3672: ,p_associated_column2 =>
3673: 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE');
3676: --
3677: end if; -- no exclusive error
3678: --
3679: if g_debug then
3680: hr_utility.set_location(l_proc, 90);
3681: end if;
3682: --
3683: end if;
3684: --
3682: --
3683: end if;
3684: --
3685: if g_debug then
3686: hr_utility.set_location(' Leaving:'|| l_proc, 91);
3687: end if;
3688: --
3689: end gen_chk_assignment_number;
3690: --
3707: BEGIN
3708: --
3709: if g_debug then
3710: l_proc := g_package||'chk_assignment_category';
3711: hr_utility.set_location('Entering:'|| l_proc, 10);
3712: end if;
3713: --
3714: -- Check if inserting or updating the assignment
3715: --
3718: ,p_effective_date => p_effective_date
3719: ,p_object_version_number => p_object_version_number);
3720: --
3721: if g_debug then
3722: hr_utility.set_location(l_proc, 30);
3723: end if;
3724: --
3725: -- Check if inserting or assignment type has changed
3726: --
3729: nvl(p_assignment_category, hr_api.g_varchar2)) OR
3730: (NOT l_api_updating)) THEN
3731: --
3732: if g_debug then
3733: hr_utility.set_location(l_proc, 40);
3734: end if;
3735: --
3736: -- Check that assignment type is 'C' (Contingent Worker) and
3737: -- that the value entered exists in the CWK_ASG_CATEOGRY lookup
3745: ,p_validation_end_date => p_validation_end_date
3746: ,p_lookup_type => 'CWK_ASG_CATEGORY'
3747: ,p_lookup_code => p_assignment_category) THEN
3748: --
3749: hr_utility.set_message(800,'HR_289642_INV_CWK_ASG_CAT');
3750: hr_utility.raise_error;
3751: --
3752: END IF;
3753: --
3746: ,p_lookup_type => 'CWK_ASG_CATEGORY'
3747: ,p_lookup_code => p_assignment_category) THEN
3748: --
3749: hr_utility.set_message(800,'HR_289642_INV_CWK_ASG_CAT');
3750: hr_utility.raise_error;
3751: --
3752: END IF;
3753: --
3754: -- Check that if the assignment type is not a CWK assignment that
3756: --
3757: ELSIF p_assignment_type <> 'C' AND
3758: p_assignment_category IS NOT NULL THEN
3759: --
3760: hr_utility.set_message(800,'HR_289643_CWK_ASG_CAT_NULL');
3761: hr_utility.raise_error;
3762: --
3763: END IF;
3764: --
3757: ELSIF p_assignment_type <> 'C' AND
3758: p_assignment_category IS NOT NULL THEN
3759: --
3760: hr_utility.set_message(800,'HR_289643_CWK_ASG_CAT_NULL');
3761: hr_utility.raise_error;
3762: --
3763: END IF;
3764: --
3765: END IF;
3764: --
3765: END IF;
3766: --
3767: if g_debug then
3768: hr_utility.set_location(' Leaving:'|| l_proc, 997);
3769: end if;
3770: --
3771: EXCEPTION
3772: --
3775: IF hr_multi_message.exception_add
3776: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_CATEGORY') THEN
3777: --
3778: if g_debug then
3779: hr_utility.set_location(' Leaving:'|| l_proc, 998);
3780: end if;
3781: --
3782: RAISE;
3783: --
3783: --
3784: END IF;
3785: --
3786: if g_debug then
3787: hr_utility.set_location(' Leaving:'|| l_proc, 999);
3788: end if;
3789: --
3790: END chk_assignment_category;
3791: -- ----------------------------------------------------------------------------
3842: --
3843: begin
3844: if g_debug then
3845: l_proc := g_package || 'chk_assignment_status_type';
3846: hr_utility.set_location('Entering:'|| l_proc, 1);
3847: end if;
3848: --
3849: if hr_multi_message.no_exclusive_error
3850: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
3854: --
3855: if nvl(p_assignment_status_type_id, hr_api.g_number) = hr_api.g_number then
3856: --
3857: if g_debug then
3858: hr_utility.set_location(l_proc, 10);
3859: end if;
3860: --
3861: -- Derive default value.
3862: --
3860: --
3861: -- Derive default value.
3862: --
3863: if g_debug then
3864: hr_utility.set_location(l_proc, 20);
3865: end if;
3866: --
3867: per_people3_pkg.get_default_person_type
3868: (p_required_type => p_expected_system_status
3872: );
3873: else
3874: --
3875: if g_debug then
3876: hr_utility.set_location(l_proc, 30);
3877: end if;
3878: --
3879: -- Validate that assignment status type id is for the expected system
3880: -- status in the assignment's business group.
3886: --
3887: if csr_get_ast_details%NOTFOUND then
3888: --
3889: if g_debug then
3890: hr_utility.set_location(l_proc, 40);
3891: end if;
3892: --
3893: close csr_get_ast_details;
3894: --
3891: end if;
3892: --
3893: close csr_get_ast_details;
3894: --
3895: hr_utility.set_message(801,'HR_7940_ASG_INV_ASG_STAT_TYPE');
3896: hr_utility.raise_error;
3897: --
3898: elsif l_per_system_status <> p_expected_system_status
3899: then
3892: --
3893: close csr_get_ast_details;
3894: --
3895: hr_utility.set_message(801,'HR_7940_ASG_INV_ASG_STAT_TYPE');
3896: hr_utility.raise_error;
3897: --
3898: elsif l_per_system_status <> p_expected_system_status
3899: then
3900: --
3898: elsif l_per_system_status <> p_expected_system_status
3899: then
3900: --
3901: if g_debug then
3902: hr_utility.set_location(l_proc, 50);
3903: end if;
3904: --
3905: close csr_get_ast_details;
3906: --
3903: end if;
3904: --
3905: close csr_get_ast_details;
3906: --
3907: hr_utility.set_message(801,'HR_7949_ASG_DIF_SYSTEM_TYPES');
3908: hr_utility.set_message_token('SYSTYPE', p_expected_system_status);
3909: hr_utility.raise_error;
3910: --
3911: --
3904: --
3905: close csr_get_ast_details;
3906: --
3907: hr_utility.set_message(801,'HR_7949_ASG_DIF_SYSTEM_TYPES');
3908: hr_utility.set_message_token('SYSTYPE', p_expected_system_status);
3909: hr_utility.raise_error;
3910: --
3911: --
3912: elsif nvl(l_ast_business_group_id, p_business_group_id) <>
3905: close csr_get_ast_details;
3906: --
3907: hr_utility.set_message(801,'HR_7949_ASG_DIF_SYSTEM_TYPES');
3908: hr_utility.set_message_token('SYSTYPE', p_expected_system_status);
3909: hr_utility.raise_error;
3910: --
3911: --
3912: elsif nvl(l_ast_business_group_id, p_business_group_id) <>
3913: p_business_group_id
3913: p_business_group_id
3914: then
3915: --
3916: if g_debug then
3917: hr_utility.set_location(l_proc, 60);
3918: end if;
3919: --
3920: close csr_get_ast_details;
3921: --
3918: end if;
3919: --
3920: close csr_get_ast_details;
3921: --
3922: hr_utility.set_message(801,'HR_7372_ASG_INV_BG_ASS_STATUS');
3923: hr_utility.raise_error;
3924: else
3925: --
3926: if g_debug then
3919: --
3920: close csr_get_ast_details;
3921: --
3922: hr_utility.set_message(801,'HR_7372_ASG_INV_BG_ASS_STATUS');
3923: hr_utility.raise_error;
3924: else
3925: --
3926: if g_debug then
3927: hr_utility.set_location(l_proc, 70);
3923: hr_utility.raise_error;
3924: else
3925: --
3926: if g_debug then
3927: hr_utility.set_location(l_proc, 70);
3928: end if;
3929: --
3930: -- No error.
3931: --
3932: close csr_get_ast_details;
3933: end if;
3934: --
3935: if g_debug then
3936: hr_utility.set_location(l_proc, 80);
3937: end if;
3938: end if;
3939: end if;
3940: --
3938: end if;
3939: end if;
3940: --
3941: if g_debug then
3942: hr_utility.set_location(' Leaving:'|| l_proc, 200);
3943: end if;
3944: end chk_assignment_status_type;
3945: --
3946: -- ---------------------------------------------------------------------------
4041: and ast.assignment_status_type_id = asg.assignment_status_type_id;
4042: --
4043: begin
4044: if g_debug then
4045: hr_utility.set_location('Entering:'|| l_proc, 1);
4046: end if;
4047: --
4048: -- Check mandatory parameters have been set.
4049: --
4071: ,p_argument_value => p_rec.business_group_id
4072: );
4073: --
4074: if g_debug then
4075: hr_utility.set_location(l_proc, 10);
4076: end if;
4077: --
4078: -- Check if the assignment is being updated.
4079: --
4081: (p_assignment_id => p_rec.assignment_id
4082: ,p_effective_date => p_effective_date
4083: ,p_object_version_number => p_rec.object_version_number);
4084: if g_debug then
4085: hr_utility.set_location(l_proc, 15);
4086: end if;
4087: --
4088: -- Check if the assignment is being updated.
4089: --
4095: open csr_get_old_per_system_type;
4096: fetch csr_get_old_per_system_type into l_old_per_system_status;
4097: close csr_get_old_per_system_type;
4098: if g_debug then
4099: hr_utility.set_location(l_proc, 20);
4100: end if;
4101: --
4102: -- Check if the assignment is an employee assignment
4103: --
4212: per_asg_shd.g_old_rec.ass_attribute_category
4213: )
4214: then
4215: --
4216: hr_utility.set_message(801, 'HR_7946_ASG_INV_TERM_ASS_UPD');
4217: hr_multi_message.add
4218: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4219: );
4220: --
4254: p_rec.title <> per_asg_shd.g_old_rec.title
4255: )
4256: then
4257: --
4258: hr_utility.set_message(801, 'HR_7946_ASG_INV_TERM_ASS_UPD');
4259: hr_multi_message.add
4260: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4261: );
4262: --
4261: );
4262: --
4263: end if;
4264: if g_debug then
4265: hr_utility.set_location(l_proc, 25);
4266: end if;
4267: --
4268: end if;
4269: --
4274: open csr_get_apl_asg_min_esd;
4275: fetch csr_get_apl_asg_min_esd into l_apl_asg_min_esd;
4276: close csr_get_apl_asg_min_esd;
4277: if g_debug then
4278: hr_utility.set_location(l_proc, 160);
4279: end if;
4280: --
4281: -- Check if the first dt instance of an applicant assignment has an
4282: -- assignment status type PER SYSTEM STATUS of 'TERM_APL'
4284: open csr_get_fir_dt_inst_ast_pss(l_apl_asg_min_esd);
4285: fetch csr_get_fir_dt_inst_ast_pss into l_fir_dt_ast_pss;
4286: close csr_get_fir_dt_inst_ast_pss;
4287: if g_debug then
4288: hr_utility.set_location(l_proc, 170);
4289: end if;
4290: --
4291: If l_fir_dt_ast_pss = 'TERM_APL' then
4292: --
4289: end if;
4290: --
4291: If l_fir_dt_ast_pss = 'TERM_APL' then
4292: --
4293: hr_utility.set_message(801, 'HR_51275_ASG_INV_F_DT_AST_PSS');
4294: hr_multi_message.add
4295: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4296: );
4297: --
4296: );
4297: --
4298: end if;
4299: if g_debug then
4300: hr_utility.set_location(l_proc, 180);
4301: end if;
4302: --
4303: end if;
4304: --
4314: )
4315: or not l_api_updating
4316: then
4317: if g_debug then
4318: hr_utility.set_location(l_proc, 30);
4319: end if;
4320: --
4321: -- Check if the assignment status type exists in
4322: -- PER_ASSIGNMENT_STATUS_TYPES.
4329: ,l_ast_per_system_status;
4330: --
4331: if csr_valid_ast%notfound then
4332: close csr_valid_ast;
4333: hr_utility.set_message(801, 'HR_7940_ASG_INV_ASG_STAT_TYPE');
4334: hr_multi_message.add
4335: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4336: );
4337: else
4337: else
4338: close csr_valid_ast;
4339: end if;
4340: if g_debug then
4341: hr_utility.set_location(l_proc, 40);
4342: end if;
4343: --
4344: -- Check that when set the business group for the assignment status type
4345: -- is the same as the business group of the assignment.
4346: --
4347: If l_business_group_id is not null
4348: and l_business_group_id <> p_rec.business_group_id then
4349: --
4350: hr_utility.set_message(801, 'HR_51207_ASG_INV_AST_BUS_GRP');
4351: hr_multi_message.add
4352: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4353: );
4354: --
4353: );
4354: --
4355: end if;
4356: if g_debug then
4357: hr_utility.set_location(l_proc, 50);
4358: end if;
4359: --
4360: -- Retrieve the legislation code for the business group of the assignment.
4361: --
4362: open csr_get_bus_legislation_code;
4363: fetch csr_get_bus_legislation_code into l_bus_legislation_code;
4364: close csr_get_bus_legislation_code;
4365: if g_debug then
4366: hr_utility.set_location(l_proc, 60);
4367: end if;
4368: --
4369: if l_ast_legislation_code is not null
4370: and (nvl(l_bus_legislation_code, l_ast_legislation_code) <>
4370: and (nvl(l_bus_legislation_code, l_ast_legislation_code) <>
4371: l_ast_legislation_code)
4372: then
4373: --
4374: hr_utility.set_message(801, 'HR_7964_ASG_INV_BUS_ATT_LEG');
4375: hr_multi_message.add;
4376: --
4377: end if;
4378: if g_debug then
4375: hr_multi_message.add;
4376: --
4377: end if;
4378: if g_debug then
4379: hr_utility.set_location(l_proc, 70);
4380: end if;
4381: --
4382: -- Check if the assignment status type exists in
4383: -- PER_ASS_STATUS_TYPE_AMENDS for the assignment business group.
4394: --
4395: end if;
4396: close csr_chk_amends;
4397: if g_debug then
4398: hr_utility.set_location(l_proc, 80);
4399: end if;
4400: --
4401: -- Check that active flag for the assignment status type is set to 'Y'
4402: --
4401: -- Check that active flag for the assignment status type is set to 'Y'
4402: --
4403: If l_active_flag <> 'Y' then
4404: --
4405: hr_utility.set_message(801, 'HR_51206_ASG_INV_AST_ACT_FLG');
4406: hr_multi_message.add
4407: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4408: );
4409: --
4408: );
4409: --
4410: end if;
4411: if g_debug then
4412: hr_utility.set_location(l_proc, 90);
4413: end if;
4414: --
4415: -- Check if the assignment is an employee assignment
4416: --
4427: and l_per_system_status <> 'SUSP_ASSIGN'
4428: and l_per_system_status <> 'TERM_ASSIGN'
4429: then
4430: --
4431: hr_utility.set_message(801, 'HR_7917_ASG_INV_STAT_TYPE');
4432: hr_multi_message.add
4433: (p_associated_column1 =>
4434: 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4435: );
4435: );
4436: --
4437: end if;
4438: if g_debug then
4439: hr_utility.set_location(l_proc, 100);
4440: end if;
4441: --
4442: -- Check that the new PER_SYSTEM_STATUS for the assignment status type
4443: -- of the employee assignment is also 'TERM_ASSIGN' when the existing
4446: if l_old_per_system_status = 'TERM_ASSIGN'
4447: and l_per_system_status <> 'TERM_ASSIGN'
4448: then
4449: --
4450: hr_utility.set_message(801, 'HR_7942_ASG_INV_STAT_NOT_TERM');
4451: hr_multi_message.add
4452: (p_associated_column1 =>
4453: 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4454: );
4454: );
4455: --
4456: end if;
4457: if g_debug then
4458: hr_utility.set_location(l_proc, 110);
4459: end if;
4460: --
4461: -- Check that the change of assignment_status_type_id to represent a
4462: -- per_system_status other than ACTIVE_ASSIGN is not effective as of the
4472: open csr_get_initial_ins_date;
4473: fetch csr_get_initial_ins_date into l_initial_ins_date;
4474: close csr_get_initial_ins_date;
4475: if g_debug then
4476: hr_utility.set_location(l_proc, 120);
4477: end if;
4478: --
4479: if p_validation_start_date <= l_initial_ins_date
4480: then
4478: --
4479: if p_validation_start_date <= l_initial_ins_date
4480: then
4481: --
4482: hr_utility.set_message(800,'HR_7915_ASG_INV_STAT_UPD_DATE');
4483: hr_multi_message.add
4484: (p_associated_column1 =>
4485: 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4486: ,p_associated_column2 =>
4488: );
4489: --
4490: end if;
4491: if g_debug then
4492: hr_utility.set_location(l_proc, 130);
4493: end if;
4494: --
4495: end if;
4496: if g_debug then
4493: end if;
4494: --
4495: end if;
4496: if g_debug then
4497: hr_utility.set_location(l_proc, 150);
4498: end if;
4499: --
4500: else -- Inserting Employee assignment
4501: --
4503: --
4504: if l_per_system_status <> 'ACTIVE_ASSIGN'
4505: then
4506: --
4507: hr_utility.set_message(801, 'HR_7941_ASG_INV_STAT_NOT_ACT');
4508: hr_multi_message.add
4509: (p_associated_column1 =>
4510: 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4511: );
4513: end if;
4514: --
4515: end if;
4516: if g_debug then
4517: hr_utility.set_location(l_proc, 160);
4518: end if;
4519: elsif p_rec.assignment_type = 'B' then
4520: --
4521: --
4528: --
4529: ELSIF p_rec.assignment_type = 'C' THEN
4530: --
4531: if g_debug then
4532: hr_utility.set_location(l_proc, 170);
4533: end if;
4534: --
4535: -- If Updating then check that the assignment status type id
4536: -- is set to either ACTIVE_NPW_ASG or SUSP_NPW_ASG
4537: --
4538: IF l_api_updating THEN
4539: --
4540: if g_debug then
4541: hr_utility.set_location(l_proc, 180);
4542: end if;
4543: --
4544: IF l_per_system_status NOT IN ('ACTIVE_CWK','SUSP_CWK_ASG') AND
4545: l_old_per_system_status = 'ACTIVE_CWK' THEN
4543: --
4544: IF l_per_system_status NOT IN ('ACTIVE_CWK','SUSP_CWK_ASG') AND
4545: l_old_per_system_status = 'ACTIVE_CWK' THEN
4546: --
4547: hr_utility.set_message(801, 'HR_289644_CWL_INV_ASS_STAT_TYP');
4548: hr_utility.raise_error;
4549: --
4550: END IF;
4551: --
4544: IF l_per_system_status NOT IN ('ACTIVE_CWK','SUSP_CWK_ASG') AND
4545: l_old_per_system_status = 'ACTIVE_CWK' THEN
4546: --
4547: hr_utility.set_message(801, 'HR_289644_CWL_INV_ASS_STAT_TYP');
4548: hr_utility.raise_error;
4549: --
4550: END IF;
4551: --
4552: ELSE -- Inserting
4551: --
4552: ELSE -- Inserting
4553: --
4554: if g_debug then
4555: hr_utility.set_location(l_proc, 190);
4556: end if;
4557: --
4558: IF l_per_system_status <> 'ACTIVE_CWK' THEN
4559: --
4556: end if;
4557: --
4558: IF l_per_system_status <> 'ACTIVE_CWK' THEN
4559: --
4560: hr_utility.set_message(801, 'HR_289645_CWK_INV_INS_ASS_TYPE');
4561: hr_utility.raise_error;
4562: --
4563: END IF;
4564: --
4557: --
4558: IF l_per_system_status <> 'ACTIVE_CWK' THEN
4559: --
4560: hr_utility.set_message(801, 'HR_289645_CWK_INV_INS_ASS_TYPE');
4561: hr_utility.raise_error;
4562: --
4563: END IF;
4564: --
4565: END IF;
4580: and l_per_system_status <> 'ACCEPTED'
4581: and l_per_system_status <> 'INTERVIEW1'
4582: and l_per_system_status <> 'INTERVIEW2'
4583: then
4584: hr_utility.set_message(801, 'HR_51232_ASG_INV_AASG_AST');
4585: hr_multi_message.add
4586: (p_associated_column1 =>
4587: 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4588: );
4588: );
4589: --
4590: end if;
4591: if g_debug then
4592: hr_utility.set_location(l_proc, 170);
4593: end if;
4594: --
4595: end if;
4596: --
4597: end if;
4598: --
4599: end if;
4600: if g_debug then
4601: hr_utility.set_location(' Leaving:'|| l_proc, 220);
4602: end if;
4603: --
4604: end chk_assignment_status_type_id;
4605: --
4633: --
4634: begin
4635: --
4636: if g_debug then
4637: hr_utility.set_location('Entering:'|| l_proc, 10);
4638: end if;
4639: --
4640: -- Check mandatory parameters have been set
4641: --
4645:
4646: ,p_argument_value => p_assignment_type
4647: );
4648: if g_debug then
4649: hr_utility.set_location(l_proc, 20);
4650: end if;
4651: --
4652: -- Check if inserting or updating the assignment
4653: --
4656: ,p_effective_date => p_effective_date
4657: ,p_object_version_number => p_object_version_number
4658: );
4659: if g_debug then
4660: hr_utility.set_location(l_proc, 30);
4661: end if;
4662: --
4663: -- Check if inserting or assignment type has changed
4664: --
4668: or
4669: (NOT l_api_updating))
4670: then
4671: if g_debug then
4672: hr_utility.set_location(l_proc, 40);
4673: end if;
4674: --
4675: -- Check that assignment type is either 'E' or 'A'
4676: --
4684: (p_constraint_name => 'PER_ASS_ASSIGNMENT_TYPE_CHK');
4685: --
4686: end if;
4687: if g_debug then
4688: hr_utility.set_location(l_proc, 50);
4689: end if;
4690: --
4691: open csr_get_sys_per_typ;
4692: fetch csr_get_sys_per_typ into l_system_person_type;
4691: open csr_get_sys_per_typ;
4692: fetch csr_get_sys_per_typ into l_system_person_type;
4693: close csr_get_sys_per_typ;
4694: if g_debug then
4695: hr_utility.set_location(l_proc, 60);
4696: end if;
4697: --
4698: -- Check for an applicant or offer assignment
4699: --
4706: if l_system_person_type
4707: not in ('APL', 'APL_EX_APL', 'EMP_APL', 'EX_EMP_APL')
4708: then
4709: --
4710: hr_utility.set_message(801, 'HR_51294_ASG_INV_AASG_PET');
4711: hr_utility.raise_error;
4712: --
4713:
4714: end if;
4707: not in ('APL', 'APL_EX_APL', 'EMP_APL', 'EX_EMP_APL')
4708: then
4709: --
4710: hr_utility.set_message(801, 'HR_51294_ASG_INV_AASG_PET');
4711: hr_utility.raise_error;
4712: --
4713:
4714: end if;
4715: if g_debug then
4712: --
4713:
4714: end if;
4715: if g_debug then
4716: hr_utility.set_location(l_proc, 70);
4717: end if;
4718: --
4719: elsif p_assignment_type = 'B' then -- benefit assignments
4720: --
4727: --
4728: ELSIF p_assignment_type = 'C' THEN
4729: --
4730: if g_debug then
4731: hr_utility.set_location(l_proc, 75);
4732: end if;
4733: --
4734: -- If the person is not a contractor then raise an error
4735: --
4734: -- If the person is not a contractor then raise an error
4735: --
4736: IF NOT hr_general2.is_person_type(p_person_id,'CWK',p_effective_date) THEN
4737: --
4738: hr_utility.set_message(801, 'HR_289646_PER_TYPE_NOT_CWK');
4739: hr_utility.raise_error;
4740: --
4741: END IF;
4742: --
4735: --
4736: IF NOT hr_general2.is_person_type(p_person_id,'CWK',p_effective_date) THEN
4737: --
4738: hr_utility.set_message(801, 'HR_289646_PER_TYPE_NOT_CWK');
4739: hr_utility.raise_error;
4740: --
4741: END IF;
4742: --
4743: else -- employee assignments
4748: if l_system_person_type
4749: not in ('EMP', 'EMP_APL', 'EX_EMP')
4750: then
4751: --
4752: hr_utility.set_message(801, 'HR_51329_ASG_INV_EASG_PET');
4753:
4754: hr_utility.raise_error;
4755: --
4756: end if;
4750: then
4751: --
4752: hr_utility.set_message(801, 'HR_51329_ASG_INV_EASG_PET');
4753:
4754: hr_utility.raise_error;
4755: --
4756: end if;
4757: if g_debug then
4758: hr_utility.set_location(l_proc, 80);
4754: hr_utility.raise_error;
4755: --
4756: end if;
4757: if g_debug then
4758: hr_utility.set_location(l_proc, 80);
4759: end if;
4760: --
4761: end if;
4762: if g_debug then
4759: end if;
4760: --
4761: end if;
4762: if g_debug then
4763: hr_utility.set_location(l_proc, 90);
4764: end if;
4765: --
4766: end if;
4767: if g_debug then
4764: end if;
4765: --
4766: end if;
4767: if g_debug then
4768: hr_utility.set_location(' Leaving:'|| l_proc, 100);
4769: end if;
4770: exception
4771: when app_exception.application_exception then
4772: if hr_multi_message.exception_add
4774: 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4775: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
4776: ) then
4777: if g_debug then
4778: hr_utility.set_location(' Leaving:'|| l_proc, 110);
4779: end if;
4780: raise;
4781: end if;
4782: if g_debug then
4779: end if;
4780: raise;
4781: end if;
4782: if g_debug then
4783: hr_utility.set_location(' Leaving:'|| l_proc, 120);
4784: end if;
4785: --
4786: end chk_assignment_type;
4787: --
4804: l_proc varchar2(72) := g_package||'chk_change_reason';
4805: --
4806: begin
4807: if g_debug then
4808: hr_utility.set_location('Entering:'|| l_proc, 10);
4809: end if;
4810: --
4811: -- Check mandatory arguments
4812: --
4827: ,p_argument => 'validation_end_date'
4828: ,p_argument_value => p_validation_end_date
4829: );
4830: if g_debug then
4831: hr_utility.set_location(l_proc, 20);
4832: end if;
4833: --
4834: l_api_updating := per_asg_shd.api_updating
4835: (p_assignment_id => p_assignment_id
4836: ,p_effective_date => p_effective_date
4837: ,p_object_version_number => p_object_version_number
4838: );
4839: if g_debug then
4840: hr_utility.set_location(l_proc, 30);
4841: end if;
4842: --
4843: if ((l_api_updating and
4844: nvl(per_asg_shd.g_old_rec.change_reason, hr_api.g_varchar2) <>
4846: or
4847: (NOT l_api_updating))
4848: then
4849: if g_debug then
4850: hr_utility.set_location(l_proc, 40);
4851: end if;
4852: --
4853: -- Check if the change reason is set
4854: --
4871: ,p_lookup_code => p_change_reason
4872: )
4873: then
4874: --
4875: hr_utility.set_message(801, 'HR_51228_ASG_INV_EASG_CH_REAS');
4876: hr_utility.raise_error;
4877: --
4878: end if;
4879: if g_debug then
4872: )
4873: then
4874: --
4875: hr_utility.set_message(801, 'HR_51228_ASG_INV_EASG_CH_REAS');
4876: hr_utility.raise_error;
4877: --
4878: end if;
4879: if g_debug then
4880: hr_utility.set_location(l_proc, 50);
4876: hr_utility.raise_error;
4877: --
4878: end if;
4879: if g_debug then
4880: hr_utility.set_location(l_proc, 50);
4881: end if;
4882: --
4883: ELSIF p_assignment_type = 'C' THEN
4884: --
4882: --
4883: ELSIF p_assignment_type = 'C' THEN
4884: --
4885: if g_debug then
4886: hr_utility.set_location(l_proc, 50);
4887: end if;
4888: --
4889: -- Check that the change reason exists in hr_lookups for the
4890: -- lookup type 'CWK_ASSIGN_REASON' with an enabled flag set to 'Y'
4898: ,p_lookup_type => 'CWK_ASSIGN_REASON'
4899: ,p_lookup_code => p_change_reason) THEN
4900: --
4901: if g_debug then
4902: hr_utility.set_location(l_proc, 52);
4903: end if;
4904: --
4905: hr_utility.set_message(800, 'HR_289647_INV_CWK_CH_REASON');
4906: hr_utility.raise_error;
4901: if g_debug then
4902: hr_utility.set_location(l_proc, 52);
4903: end if;
4904: --
4905: hr_utility.set_message(800, 'HR_289647_INV_CWK_CH_REASON');
4906: hr_utility.raise_error;
4907: --
4908: END IF;
4909: --
4902: hr_utility.set_location(l_proc, 52);
4903: end if;
4904: --
4905: hr_utility.set_message(800, 'HR_289647_INV_CWK_CH_REASON');
4906: hr_utility.raise_error;
4907: --
4908: END IF;
4909: --
4910: else -- applicant assignment
4922: ,p_lookup_code => p_change_reason
4923: )
4924: then
4925: --
4926: hr_utility.set_message(801, 'HR_51229_ASG_INV_AASG_CH_REAS');
4927: hr_utility.raise_error;
4928: --
4929: end if;
4930: if g_debug then
4923: )
4924: then
4925: --
4926: hr_utility.set_message(801, 'HR_51229_ASG_INV_AASG_CH_REAS');
4927: hr_utility.raise_error;
4928: --
4929: end if;
4930: if g_debug then
4931: hr_utility.set_location(l_proc, 60);
4927: hr_utility.raise_error;
4928: --
4929: end if;
4930: if g_debug then
4931: hr_utility.set_location(l_proc, 60);
4932: end if;
4933: --
4934: end if;
4935: if g_debug then
4932: end if;
4933: --
4934: end if;
4935: if g_debug then
4936: hr_utility.set_location(l_proc, 70);
4937: end if;
4938: end if;
4939: end if;
4940: --
4938: end if;
4939: end if;
4940: --
4941: if g_debug then
4942: hr_utility.set_location(' Leaving:'|| l_proc, 80);
4943: end if;
4944: exception
4945: when app_exception.application_exception then
4946: if hr_multi_message.exception_add
4946: if hr_multi_message.exception_add
4947: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.CHANGE_REASON'
4948: ) then
4949: if g_debug then
4950: hr_utility.set_location(' Leaving:'|| l_proc, 90);
4951: end if;
4952: raise;
4953: end if;
4954: if g_debug then
4951: end if;
4952: raise;
4953: end if;
4954: if g_debug then
4955: hr_utility.set_location(' Leaving:'|| l_proc, 100);
4956: end if;
4957: --
4958: end chk_change_reason;
4959: --
5017: and pas2.period_of_service_id = ppos2.period_of_service_id ))); -- Added this last filter for Bug 4300591.
5018: --
5019: begin
5020: if g_debug then
5021: hr_utility.set_location('Entering:'|| l_proc, 1);
5022: end if;
5023: --
5024: -- Check mandatory parameters have been set
5025: --
5029: ,p_argument_value => p_primary_flag
5030: );
5031: --
5032: if g_debug then
5033: hr_utility.set_location(l_proc, 2);
5034: end if;
5035: --
5036: -- Check that contiguous non-primary assignment exists
5037: --
5039: open csr_chk_contig_ass;
5040: fetch csr_chk_contig_ass into l_exists;
5041: if csr_chk_contig_ass%notfound then
5042: close csr_chk_contig_ass;
5043: hr_utility.set_message(801, 'HR_7392_ASG_INV_DEL_OF_ASS');
5044: hr_utility.raise_error;
5045: end if;
5046: close csr_chk_contig_ass;
5047: end if;
5040: fetch csr_chk_contig_ass into l_exists;
5041: if csr_chk_contig_ass%notfound then
5042: close csr_chk_contig_ass;
5043: hr_utility.set_message(801, 'HR_7392_ASG_INV_DEL_OF_ASS');
5044: hr_utility.raise_error;
5045: end if;
5046: close csr_chk_contig_ass;
5047: end if;
5048: --
5046: close csr_chk_contig_ass;
5047: end if;
5048: --
5049: if g_debug then
5050: hr_utility.set_location(' Leaving:'|| l_proc, 3);
5051: end if;
5052: exception
5053: when app_exception.application_exception then
5054: if hr_multi_message.exception_add
5055: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
5056: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
5057: ) then
5058: if g_debug then
5059: hr_utility.set_location(' Leaving:'|| l_proc, 4);
5060: end if;
5061: raise;
5062: end if;
5063: if g_debug then
5060: end if;
5061: raise;
5062: end if;
5063: if g_debug then
5064: hr_utility.set_location(' Leaving:'|| l_proc, 5);
5065: end if;
5066: end chk_contig_ass;
5067: --
5068: -- ---------------------------------------------------------------------------
5092: where assignment_id = p_assignment_id;
5093: --
5094: begin
5095: if g_debug then
5096: hr_utility.set_location('Entering:'|| l_proc, 10);
5097: end if;
5098: --
5099: -- Check mandatory parameters have been set
5100: --
5115: ,p_argument => 'effective_date'
5116: ,p_argument_value => p_effective_date
5117: );
5118: if g_debug then
5119: hr_utility.set_location(l_proc, 20);
5120: end if;
5121: --
5122: -- Only proceed with validation if :
5123: -- a) The current g_old_rec is current and
5134: or
5135: (NOT l_api_updating))
5136: then
5137: if g_debug then
5138: hr_utility.set_location(l_proc, 30);
5139: end if;
5140: --
5141: -- Check if date probation end is not null
5142: --
5153: open csr_get_min_asg_esd;
5154: fetch csr_get_min_asg_esd into l_min_effective_start_date;
5155: close csr_get_min_asg_esd;
5156: if g_debug then
5157: hr_utility.set_location(l_proc, 40);
5158: end if;
5159: --
5160: if p_date_probation_end < l_min_effective_start_date then
5161: --
5158: end if;
5159: --
5160: if p_date_probation_end < l_min_effective_start_date then
5161: --
5162: hr_utility.set_message(801, 'HR_51147_ASG_DPE_BEF_MIN_ESD');
5163: hr_multi_message.add
5164: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.DATE_PROBATION_END'
5165: );
5166: --
5165: );
5166: --
5167: end if;
5168: if g_debug then
5169: hr_utility.set_location(l_proc, 50);
5170: end if;
5171: --
5172: else
5173: --
5175: -- validation start date on insert.
5176: --
5177: if p_date_probation_end < p_validation_start_date then
5178: --
5179: hr_utility.set_message(801, 'HR_51147_ASG_DPE_BEF_MIN_ESD');
5180: hr_multi_message.add
5181: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.DATE_PROBATION_END'
5182: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
5183: );
5183: );
5184: --
5185: end if;
5186: if g_debug then
5187: hr_utility.set_location(l_proc, 60);
5188: end if;
5189: --
5190: end if;
5191: if g_debug then
5188: end if;
5189: --
5190: end if;
5191: if g_debug then
5192: hr_utility.set_location(l_proc, 70);
5193: end if;
5194: --
5195: end if;
5196: if g_debug then
5193: end if;
5194: --
5195: end if;
5196: if g_debug then
5197: hr_utility.set_location(l_proc, 80);
5198: end if;
5199: --
5200: end if;
5201: --
5199: --
5200: end if;
5201: --
5202: if g_debug then
5203: hr_utility.set_location(' Leaving:'|| l_proc, 90);
5204: end if;
5205: --
5206: end chk_date_probation_end;
5207: --
5233: and nvl(end_date_active,hr_api.g_eot);
5234: --
5235: begin
5236: if g_debug then
5237: hr_utility.set_location('Entering:'|| l_proc, 10);
5238: end if;
5239: --
5240: -- Check mandatory parameters have been set
5241: --
5244: ,p_argument => 'effective_date'
5245: ,p_argument_value => p_effective_date
5246: );
5247: if g_debug then
5248: hr_utility.set_location(l_proc, 20);
5249: end if;
5250: --
5251: -- Only proceed with validation if :
5252: -- a) The current g_old_rec is current and
5257: ,p_effective_date => p_effective_date
5258: ,p_object_version_number => p_object_version_number
5259: );
5260: if g_debug then
5261: hr_utility.set_location(l_proc, 30);
5262: end if;
5263: --
5264: if ((l_api_updating and
5265: nvl(per_asg_shd.g_old_rec.default_code_comb_id, hr_api.g_number) <>
5266: nvl(p_default_code_comb_id, hr_api.g_number)) or
5267: (NOT l_api_updating))
5268: then
5269: if g_debug then
5270: hr_utility.set_location(l_proc, 40);
5271: end if;
5272: --
5273: -- Check if default code comb is not null
5274: --
5283: -- modified to allow offer to have this set
5284: --
5285: if p_assignment_type not in ('E','A','B','C','O') then
5286: --
5287: hr_utility.set_message(801, 'HR_51177_ASG_INV_ASG_TYP_DCC');
5288: hr_multi_message.add
5289: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.DEFAULT_CODE_COMB_ID'
5290: );
5291: --
5290: );
5291: --
5292: end if;
5293: if g_debug then
5294: hr_utility.set_location(l_proc, 50);
5295: end if;
5296: --
5297: -- Check that the default code comb exists in GL_CODE_COMBINATIONS
5298: --
5299: open csr_valid_def_cod_comb;
5300: fetch csr_valid_def_cod_comb into l_exists;
5301: if csr_valid_def_cod_comb%notfound then
5302: close csr_valid_def_cod_comb;
5303: hr_utility.set_message(801, 'HR_51148_ASG_INV_DEF_COD_COM');
5304: hr_multi_message.add
5305: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.DEFAULT_CODE_COMB_ID'
5306: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
5307: );
5309: else
5310: close csr_valid_def_cod_comb;
5311: end if;
5312: if g_debug then
5313: hr_utility.set_location(l_proc, 60);
5314: end if;
5315: --
5316: end if;
5317: --
5316: end if;
5317: --
5318: end if;
5319: if g_debug then
5320: hr_utility.set_location(' Leaving:'|| l_proc, 70);
5321: end if;
5322: end chk_default_code_comb_id;
5323: --
5324: -- ---------------------------------------------------------------------------
5364: --
5365: begin
5366: if g_debug then
5367: l_proc := g_package||'chk_del_organization_id';
5368: hr_utility.set_location('Entering:'|| l_proc, 1);
5369: end if;
5370: --
5371: if p_manager_flag = 'Y' then
5372: --
5380: )
5381: then
5382: --
5383: if g_debug then
5384: hr_utility.set_location(l_proc, 3);
5385: end if;
5386: --
5387: p_org_now_no_manager_warning := TRUE;
5388: end if;
5388: end if;
5389: end if;
5390: --
5391: if g_debug then
5392: hr_utility.set_location(' Leaving:'|| l_proc, 4);
5393: end if;
5394: end chk_del_organization_id;
5395: --
5396: -- ---------------------------------------------------------------------------
5413: l_api_updating boolean;
5414: --
5415: begin
5416: if g_debug then
5417: hr_utility.set_location('Entering:'|| l_proc, 10);
5418: end if;
5419: --
5420: -- Check mandatory parameters have been set
5421: --
5436: ,p_argument => 'validation_end_date'
5437: ,p_argument_value => p_validation_end_date
5438: );
5439: if g_debug then
5440: hr_utility.set_location(l_proc, 20);
5441: end if;
5442: --
5443: l_api_updating := per_asg_shd.api_updating
5444: (p_assignment_id => p_assignment_id
5445: ,p_effective_date => p_effective_date
5446: ,p_object_version_number => p_object_version_number
5447: );
5448: if g_debug then
5449: hr_utility.set_location(l_proc, 30);
5450: end if;
5451: --
5452: if ((l_api_updating and
5453: nvl(per_asg_shd.g_old_rec.employment_category, hr_api.g_varchar2) <>
5454: nvl(p_employment_category, hr_api.g_varchar2))
5455: or (NOT l_api_updating))
5456: then
5457: if g_debug then
5458: hr_utility.set_location(l_proc, 40);
5459: end if;
5460: --
5461: if p_employment_category is not null then
5462: --
5463: -- Check that the assignment is of a valid type.
5464: --
5465: if p_assignment_type not in ('E','A','B','C','O') then
5466: --
5467: hr_utility.set_message(801, 'HR_51217_ASG_INV_ASG_TYP_ECAT');
5468: hr_utility.raise_error;
5469: --
5470: end if;
5471: if g_debug then
5464: --
5465: if p_assignment_type not in ('E','A','B','C','O') then
5466: --
5467: hr_utility.set_message(801, 'HR_51217_ASG_INV_ASG_TYP_ECAT');
5468: hr_utility.raise_error;
5469: --
5470: end if;
5471: if g_debug then
5472: hr_utility.set_location(l_proc, 50);
5468: hr_utility.raise_error;
5469: --
5470: end if;
5471: if g_debug then
5472: hr_utility.set_location(l_proc, 50);
5473: end if;
5474: --
5475: -- Check that the employment category exists in hr_lookups for the
5476: -- lookup type 'EMP_CAT' with an enabled flag set to 'Y' and that
5493: --
5494: -- Use the employment category for non-contingent worker assignments.
5495: --
5496: if g_debug then
5497: hr_utility.set_location(l_proc, 60);
5498: end if;
5499:
5500: if hr_api.not_exists_in_leg_lookups
5501: (p_effective_date => p_effective_date
5503: ,p_lookup_code => p_employment_category
5504: )
5505: then
5506: --
5507: hr_utility.set_message(801, 'HR_51028_ASG_INV_EMP_CATEGORY');
5508: hr_utility.raise_error;
5509: --
5510: end if;
5511:
5504: )
5505: then
5506: --
5507: hr_utility.set_message(801, 'HR_51028_ASG_INV_EMP_CATEGORY');
5508: hr_utility.raise_error;
5509: --
5510: end if;
5511:
5512: elsif p_assignment_type = 'C' then
5519: -- Here the assignment category chk procedure is called to validate
5520: -- for contingent workers.
5521: --
5522: if g_debug then
5523: hr_utility.set_location(l_proc, 65);
5524: end if;
5525:
5526: per_asg_bus1.chk_assignment_category
5527: (p_assignment_id => p_assignment_id
5535: end if;
5536: --
5537: end if;
5538: if g_debug then
5539: hr_utility.set_location(l_proc, 70);
5540: end if;
5541: --
5542: end if;
5543: --
5541: --
5542: end if;
5543: --
5544: if g_debug then
5545: hr_utility.set_location(' Leaving:'|| l_proc, 80);
5546: end if;
5547: exception
5548: when app_exception.application_exception then
5549: if hr_multi_message.exception_add
5549: if hr_multi_message.exception_add
5550: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EMPLOYMENT_CATEGORY'
5551: ) then
5552: if g_debug then
5553: hr_utility.set_location(' Leaving:'|| l_proc, 90);
5554: end if;
5555: raise;
5556: end if;
5557: if g_debug then
5554: end if;
5555: raise;
5556: end if;
5557: if g_debug then
5558: hr_utility.set_location(' Leaving:'|| l_proc, 100);
5559: end if;
5560: end chk_employment_category;
5561: --
5562: -- ---------------------------------------------------------------------------
5578: l_proc varchar2(72) := g_package||'chk_frequency';
5579: --
5580: begin
5581: if g_debug then
5582: hr_utility.set_location('Entering:'|| l_proc, 10);
5583: end if;
5584: --
5585: -- Check mandatory parameters
5586: --
5601: ,p_argument => 'validation_end_date'
5602: ,p_argument_value => p_validation_end_date
5603: );
5604: if g_debug then
5605: hr_utility.set_location(l_proc, 20);
5606: end if;
5607: --
5608: -- Only proceed with validation if :
5609: -- a) The current g_old_rec is current and
5614: ,p_effective_date => p_effective_date
5615: ,p_object_version_number => p_object_version_number
5616: );
5617: if g_debug then
5618: hr_utility.set_location(l_proc, 30);
5619: end if;
5620: --
5621: if ((l_api_updating and
5622: nvl(per_asg_shd.g_old_rec.frequency, hr_api.g_varchar2) <>
5623: nvl(p_frequency, hr_api.g_varchar2)) or
5624: (NOT l_api_updating))
5625: then
5626: if g_debug then
5627: hr_utility.set_location(l_proc||' '||p_frequency, 40);
5628: end if;
5629: --
5630: -- Check if frequency is set.
5631: --
5644: ,p_lookup_code => p_frequency
5645: )
5646: then
5647: --
5648: hr_utility.set_message(801, 'HR_7388_ASG_INVALID_FREQUENCY');
5649: hr_utility.raise_error;
5650: --
5651: end if;
5652: if g_debug then
5645: )
5646: then
5647: --
5648: hr_utility.set_message(801, 'HR_7388_ASG_INVALID_FREQUENCY');
5649: hr_utility.raise_error;
5650: --
5651: end if;
5652: if g_debug then
5653: hr_utility.set_location(l_proc, 60);
5649: hr_utility.raise_error;
5650: --
5651: end if;
5652: if g_debug then
5653: hr_utility.set_location(l_proc, 60);
5654: end if;
5655: --
5656: end if;
5657: if g_debug then
5654: end if;
5655: --
5656: end if;
5657: if g_debug then
5658: hr_utility.set_location(l_proc, 70);
5659: end if;
5660: --
5661: end if;
5662: --
5660: --
5661: end if;
5662: --
5663: if g_debug then
5664: hr_utility.set_location(' Leaving:'|| l_proc, 80);
5665: end if;
5666: exception
5667: when app_exception.application_exception then
5668: if hr_multi_message.exception_add
5668: if hr_multi_message.exception_add
5669: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.FREQUENCY'
5670: ) then
5671: if g_debug then
5672: hr_utility.set_location(' Leaving:'|| l_proc, 90);
5673: end if;
5674: raise;
5675: end if;
5676: if g_debug then
5673: end if;
5674: raise;
5675: end if;
5676: if g_debug then
5677: hr_utility.set_location(' Leaving:'|| l_proc, 100);
5678: end if;
5679: end chk_frequency;
5680: --
5681: -- ---------------------------------------------------------------------------
5724: and primary_flag = 'Y';
5725: --
5726: begin
5727: if g_debug then
5728: hr_utility.set_location('Entering:'|| l_proc, 1);
5729: end if;
5730: --
5731: -- Check mandatory parameters have been set
5732: --
5736: ,p_argument_value => p_primary_flag
5737: );
5738: --
5739: if g_debug then
5740: hr_utility.set_location(l_proc, 2);
5741: end if;
5742: --
5743: if p_datetrack_mode = 'DELETE' and
5744: p_primary_flag = 'N' then
5745: open csr_chk_fut_prim;
5746: fetch csr_chk_fut_prim into l_exists;
5747: if csr_chk_fut_prim%found then
5748: close csr_chk_fut_prim;
5749: hr_utility.set_message(801, 'HR_7399_ASG_NO_DEL_NON_PRIM');
5750: hr_utility.raise_error;
5751: end if;
5752: close csr_chk_fut_prim;
5753: end if;
5746: fetch csr_chk_fut_prim into l_exists;
5747: if csr_chk_fut_prim%found then
5748: close csr_chk_fut_prim;
5749: hr_utility.set_message(801, 'HR_7399_ASG_NO_DEL_NON_PRIM');
5750: hr_utility.raise_error;
5751: end if;
5752: close csr_chk_fut_prim;
5753: end if;
5754: --
5752: close csr_chk_fut_prim;
5753: end if;
5754: --
5755: if g_debug then
5756: hr_utility.set_location(' Leaving:'|| l_proc, 3);
5757: end if;
5758: exception
5759: when app_exception.application_exception then
5760: if hr_multi_message.exception_add
5760: if hr_multi_message.exception_add
5761: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID'
5762: ) then
5763: if g_debug then
5764: hr_utility.set_location(' Leaving:'|| l_proc, 4);
5765: end if;
5766: raise;
5767: end if;
5768: if g_debug then
5765: end if;
5766: raise;
5767: end if;
5768: if g_debug then
5769: hr_utility.set_location(' Leaving:'|| l_proc, 5);
5770: end if;
5771: end chk_future_primary;
5772: --
5773: -- ---------------------------------------------------------------------------
5802: between date_from and nvl(date_to, hr_api.g_eot);
5803: --
5804: begin
5805: if g_debug then
5806: hr_utility.set_location('Entering:'|| l_proc, 10);
5807: end if;
5808: --
5809: --
5810: -- Check mandatory parameters have been set
5832: ,p_argument => 'business_group_id'
5833: ,p_argument_value => p_business_group_id
5834: );
5835: if g_debug then
5836: hr_utility.set_location(l_proc, 20);
5837: end if;
5838: --
5839: -- Only proceed with validation if :
5840: -- a) The current g_old_rec is current and
5845: ,p_effective_date => p_effective_date
5846: ,p_object_version_number => p_object_version_number
5847: );
5848: if g_debug then
5849: hr_utility.set_location(l_proc, 30);
5850: end if;
5851: --
5852: if ((l_api_updating and
5853: nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>
5853: nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>
5854: nvl(p_grade_id, hr_api.g_number)) or
5855: (NOT l_api_updating)) then
5856: if g_debug then
5857: hr_utility.set_location(l_proc, 40);
5858: end if;
5859: --
5860: -- Check if the grade is set.
5861: --
5867: open csr_valid_grade;
5868: fetch csr_valid_grade into l_business_group_id;
5869: if csr_valid_grade%notfound then
5870: close csr_valid_grade;
5871: hr_utility.set_message(801, 'HR_7393_ASG_INVALID_GRADE');
5872: hr_multi_message.add
5873: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
5874: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
5875: );
5877: else
5878: close csr_valid_grade;
5879: end if;
5880: if g_debug then
5881: hr_utility.set_location(l_proc, 50);
5882: end if;
5883: --
5884: -- Check that the business group for the grade is the same
5885: -- as that of the assignment
5885: -- as that of the assignment
5886: --
5887: if l_business_group_id <> p_business_group_id then
5888: --
5889: hr_utility.set_message(801, 'HR_7371_ASG_INVALID_BG_GRADE');
5890: hr_multi_message.add
5891: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
5892: );
5893: --
5892: );
5893: --
5894: end if;
5895: if g_debug then
5896: hr_utility.set_location(l_proc, 60);
5897: end if;
5898: --
5899: elsif p_special_ceiling_step_id is not null then
5900: -- When grade is null special ceiling step should be null
5898: --
5899: elsif p_special_ceiling_step_id is not null then
5900: -- When grade is null special ceiling step should be null
5901: --
5902: hr_utility.set_message(801, 'HR_7434_ASG_GRADE_REQUIRED');
5903: hr_multi_message.add
5904: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
5905: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'
5906: );
5906: );
5907: --
5908: end if;
5909: if g_debug then
5910: hr_utility.set_location(l_proc, 80);
5911: end if;
5912: --
5913: end if;
5914: if g_debug then
5911: end if;
5912: --
5913: end if;
5914: if g_debug then
5915: hr_utility.set_location(' Leaving:'|| l_proc, 110);
5916: end if;
5917: --
5918: end chk_grade_id;
5919: --
5968: -- Bug 33552211 End Here
5969: --
5970: begin
5971: if g_debug then
5972: hr_utility.set_location('Entering:'|| l_proc, 10);
5973: end if;
5974: --
5975: --
5976: -- Check mandatory arguments
5992: ,p_argument => 'validation_end_date'
5993: ,p_argument_value => p_validation_end_date
5994: );
5995: if g_debug then
5996: hr_utility.set_location(l_proc, 20);
5997: end if;
5998: --
5999: -- Check if the assignment is being updated.
6000: --
6003: ,p_effective_date => p_effective_date
6004: ,p_object_version_number => p_object_version_number
6005: );
6006: if g_debug then
6007: hr_utility.set_location(l_proc, 30);
6008: end if;
6009: --
6010: -- Only proceed with validation if :
6011: -- a) The current g_old_rec is current and
6016: hr_api.g_number) <> nvl(p_job_id, hr_api.g_number))
6017: or
6018: NOT l_api_updating) then
6019: if g_debug then
6020: hr_utility.set_location(l_proc, 40);
6021: end if;
6022: --
6023: -- Check if job is set
6024: --
6030: open csr_valid_job;
6031: fetch csr_valid_job into l_business_group_id;
6032: if csr_valid_job%notfound then
6033: close csr_valid_job;
6034: hr_utility.set_message(801, 'HR_51172_ASG_INV_DT_JOB');
6035: hr_multi_message.add
6036: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
6037: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
6038: );
6040: else
6041: close csr_valid_job;
6042: end if;
6043: if g_debug then
6044: hr_utility.set_location(l_proc, 50);
6045: end if;
6046: --
6047: -- Check that the job is in the same business group as the job of the
6048: -- assignment date effectively.
6048: -- assignment date effectively.
6049: --
6050: If p_business_group_id <> l_business_group_id then
6051: --
6052: hr_utility.set_message(801, 'HR_51173_ASG_INV_DT_JOB_BG');
6053: hr_multi_message.add
6054: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
6055: );
6056: --
6055: );
6056: --
6057: end if;
6058: if g_debug then
6059: hr_utility.set_location(l_proc, 60);
6060: end if;
6061: --
6062: end if;
6063: if g_debug then
6060: end if;
6061: --
6062: end if;
6063: if g_debug then
6064: hr_utility.set_location(l_proc, 70);
6065: end if;
6066: --
6067: end if;
6068: if g_debug then
6065: end if;
6066: --
6067: end if;
6068: if g_debug then
6069: hr_utility.set_location(' Leaving:'|| l_proc, 100);
6070: end if;
6071: --
6072: end chk_job_id;
6073: --
6117: and nvl(date_to, hr_api.g_eot);
6118: --
6119: begin
6120: if g_debug then
6121: hr_utility.set_location('Entering:'|| l_proc, 10);
6122: end if;
6123: --
6124: if hr_multi_message.no_exclusive_error
6125: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
6145: ,p_argument => 'validation_end_date'
6146: ,p_argument_value => p_validation_end_date
6147: );
6148: if g_debug then
6149: hr_utility.set_location(l_proc, 20);
6150: end if;
6151: --
6152: -- Check if the assignment is being updated.
6153: --
6156: ,p_effective_date => p_effective_date
6157: ,p_object_version_number => p_object_version_number
6158: );
6159: if g_debug then
6160: hr_utility.set_location(l_proc, 30);
6161: end if;
6162: --
6163: -- Only proceed with validation if :
6164: -- a) The current g_old_rec is current and
6173: <> nvl(p_grade_id, hr_api.g_number))))
6174: or
6175: NOT l_api_updating then
6176: if g_debug then
6177: hr_utility.set_location(l_proc, 40);
6178: end if;
6179: --
6180: -- Check that both job and grade are set.
6181: --
6207: --
6208: -- Bug 3566686 Ends Here
6209: --
6210: if g_debug then
6211: hr_utility.set_location(l_proc, 50);
6212: end if;
6213: --
6214: end if;
6215: if g_debug then
6212: end if;
6213: --
6214: end if;
6215: if g_debug then
6216: hr_utility.set_location(l_proc, 60);
6217: end if;
6218: --
6219: end if;
6220: end if;
6219: end if;
6220: end if;
6221: --
6222: if g_debug then
6223: hr_utility.set_location(' Leaving:'|| l_proc, 70);
6224: end if;
6225: end chk_job_id_grade_id;
6226: --
6227: -- ---------------------------------------------------------------------------
6271: -- Bug 4116879 Ends
6272: --
6273: begin
6274: if g_debug then
6275: hr_utility.set_location('Entering:'|| l_proc, 10);
6276: end if;
6277: --
6278: --
6279: -- Check mandatory parameters have been set
6295: ,p_argument => 'validation_end_date'
6296: ,p_argument_value => p_validation_end_date
6297: );
6298: if g_debug then
6299: hr_utility.set_location('Entering:'|| l_proc, 20);
6300: end if;
6301: --
6302: -- Only proceed with validation if :
6303: -- a) The current g_old_rec is current and
6308: ,p_effective_date => p_effective_date
6309: ,p_object_version_number => p_object_version_number
6310: );
6311: if g_debug then
6312: hr_utility.set_location('Entering:'|| l_proc, 30);
6313: end if;
6314: --
6315: if ((l_api_updating and
6316: nvl(per_asg_shd.g_old_rec.location_id, hr_api.g_number) <>
6318: (NOT l_api_updating))
6319: then
6320: --
6321: if g_debug then
6322: hr_utility.set_location('Entering:'|| l_proc, 40);
6323: end if;
6324: --
6325: if p_location_id is not null then
6326: --
6331: open csr_valid_location_upd;
6332: fetch csr_valid_location_upd into l_inactive_date;
6333: if csr_valid_location_upd%notfound then
6334: close csr_valid_location_upd;
6335: hr_utility.set_message(801, 'HR_7382_ASG_NON_EXIST_LOCATION');
6336: hr_multi_message.add
6337: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.LOCATION_ID');
6338: --
6339: else
6343: open csr_valid_location_ins;
6344: fetch csr_valid_location_ins into l_inactive_date;
6345: if csr_valid_location_ins%notfound then
6346: close csr_valid_location_ins;
6347: hr_utility.set_message(801, 'HR_7382_ASG_NON_EXIST_LOCATION');
6348: hr_multi_message.add
6349: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.LOCATION_ID');
6350: --
6351: else
6354: end if;
6355: -- Bug 4116879 Ends
6356: --
6357: if g_debug then
6358: hr_utility.set_location('Entering:'|| l_proc, 50);
6359: end if;
6360: --
6361: -- Check if the assignment ESD is before the location inactive date
6362: -- on insert
6363: --
6364: if p_validation_start_date >= nvl(l_inactive_date,hr_api.g_eot)
6365: then
6366: --
6367: hr_utility.set_message(801, 'HR_51215_ASG_INACT_LOCATION');
6368: hr_multi_message.add
6369: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.LOCATION_ID'
6370: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
6371: );
6371: );
6372: --
6373: end if;
6374: if g_debug then
6375: hr_utility.set_location('Entering:'|| l_proc, 60);
6376: end if;
6377: --
6378: end if;
6379: --
6379: --
6380: end if;
6381: --
6382: if g_debug then
6383: hr_utility.set_location('Entering:'|| l_proc, 90);
6384: end if;
6385: end chk_location_id;
6386: --
6387: -- ---------------------------------------------------------------------------
6404: l_api_updating boolean;
6405: --
6406: begin
6407: if g_debug then
6408: hr_utility.set_location('Entering:'|| l_proc, 10);
6409: end if;
6410: --
6411: -- Check mandatory parameters have been set
6412: --
6421: ,p_argument => 'organization_id'
6422: ,p_argument_value => p_organization_id
6423: );
6424: if g_debug then
6425: hr_utility.set_location(l_proc, 20);
6426: end if;
6427: --
6428: -- Only proceed with validation if :
6429: -- a) The current g_old_rec is current and
6434: ,p_effective_date => p_effective_date
6435: ,p_object_version_number => p_object_version_number
6436: );
6437: if g_debug then
6438: hr_utility.set_location(l_proc, 30);
6439: end if;
6440: --
6441: if ((l_api_updating and
6442: nvl(per_asg_shd.g_old_rec.manager_flag, hr_api.g_varchar2) <>
6444: or
6445: (NOT l_api_updating))
6446: then
6447: if g_debug then
6448: hr_utility.set_location(l_proc, 40);
6449: end if;
6450: --
6451: -- Check if manager flag is set and is either 'Y' or 'N'.
6452: --
6456: --
6457: per_asg_shd.constraint_error
6458: (p_constraint_name => 'PER_ASS_MANAGER_FLAG_CHK');
6459: if g_debug then
6460: hr_utility.set_location(l_proc, 50);
6461: end if;
6462: --
6463: end if;
6464: if g_debug then
6461: end if;
6462: --
6463: end if;
6464: if g_debug then
6465: hr_utility.set_location(l_proc, 60);
6466: end if;
6467: --
6468: -- Check if the assignment is an employee assignment.
6469: --
6545: --
6546: end if;
6547: --
6548: if g_debug then
6549: hr_utility.set_location(' Leaving:'|| l_proc, 110);
6550: end if;
6551: --
6552: end chk_manager_flag;
6553: --
6568: l_proc varchar2(72) := g_package||'chk_frequency_normal_hours';
6569: --
6570: begin
6571: if g_debug then
6572: hr_utility.set_location('Entering:'|| l_proc, 10);
6573: end if;
6574: --
6575: if hr_multi_message.no_all_inclusive_error
6576: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.FREQUENCY'
6583: ,p_argument => 'effective_date'
6584: ,p_argument_value => p_effective_date
6585: );
6586: if g_debug then
6587: hr_utility.set_location(l_proc, 20);
6588: end if;
6589: --
6590: -- Only proceed with validation if :
6591: -- a) The current g_old_rec is current and
6596: ,p_effective_date => p_effective_date
6597: ,p_object_version_number => p_object_version_number
6598: );
6599: if g_debug then
6600: hr_utility.set_location(l_proc, 30);
6601: end if;
6602: --
6603: if (l_api_updating and
6604: ((nvl(per_asg_shd.g_old_rec.frequency, hr_api.g_varchar2) <>
6609: or
6610: (NOT l_api_updating)
6611: then
6612: if g_debug then
6613: hr_utility.set_location(l_proc, 40);
6614: end if;
6615: --
6616: -- Check if normal hours is set
6617: --
6616: -- Check if normal hours is set
6617: --
6618: If p_frequency is not null and p_normal_hours is null then
6619: --
6620: hr_utility.set_message(801, 'HR_7387_ASG_NORMAL_HOURS_REQD');
6621: hr_utility.raise_error;
6622: --
6623: elsif p_normal_hours is not null and p_frequency is null then
6624: --
6617: --
6618: If p_frequency is not null and p_normal_hours is null then
6619: --
6620: hr_utility.set_message(801, 'HR_7387_ASG_NORMAL_HOURS_REQD');
6621: hr_utility.raise_error;
6622: --
6623: elsif p_normal_hours is not null and p_frequency is null then
6624: --
6625: hr_utility.set_message(801, 'HR_7396_ASG_FREQUENCY_REQD');
6621: hr_utility.raise_error;
6622: --
6623: elsif p_normal_hours is not null and p_frequency is null then
6624: --
6625: hr_utility.set_message(801, 'HR_7396_ASG_FREQUENCY_REQD');
6626: hr_utility.raise_error;
6627: --
6628: elsif p_frequency is not null and p_normal_hours is not null then
6629: --
6622: --
6623: elsif p_normal_hours is not null and p_frequency is null then
6624: --
6625: hr_utility.set_message(801, 'HR_7396_ASG_FREQUENCY_REQD');
6626: hr_utility.raise_error;
6627: --
6628: elsif p_frequency is not null and p_normal_hours is not null then
6629: --
6630: -- Check that value for working_hours does not
6634: (p_frequency => p_frequency
6635: ,p_normal_hours => p_normal_hours
6636: );
6637: if g_debug then
6638: hr_utility.set_location(l_proc, 50);
6639: end if;
6640: --
6641: end if;
6642: if g_debug then
6639: end if;
6640: --
6641: end if;
6642: if g_debug then
6643: hr_utility.set_location(l_proc, 60);
6644: end if;
6645: --
6646: end if;
6647: end if;
6646: end if;
6647: end if;
6648: --
6649: if g_debug then
6650: hr_utility.set_location(' Leaving:'|| l_proc, 70);
6651: end if;
6652: exception
6653: when app_exception.application_exception then
6654: if hr_multi_message.exception_add
6655: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.FREQUENCY'
6656: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.NORMAL_HOURS'
6657: ) then
6658: if g_debug then
6659: hr_utility.set_location(' Leaving:'|| l_proc, 80);
6660: end if;
6661: raise;
6662: end if;
6663: if g_debug then
6660: end if;
6661: raise;
6662: end if;
6663: if g_debug then
6664: hr_utility.set_location(' Leaving:'|| l_proc, 90);
6665: end if;
6666: end chk_frequency_normal_hours;
6667: --
6668: -- ---------------------------------------------------------------------------
6706: where organization_id = p_organization_id;
6707: --
6708: begin
6709: if g_debug then
6710: hr_utility.set_location('Entering:'|| l_proc, 10);
6711: end if;
6712: --
6713: --
6714: -- Check mandatory parameters have been set
6742: ,p_argument => 'validation_end_date'
6743: ,p_argument_value => p_validation_end_date
6744: );
6745: if g_debug then
6746: hr_utility.set_location(l_proc, 20);
6747: end if;
6748: --
6749: -- Only proceed with validation if :
6750: -- a) The current g_old_rec is current and
6755: ,p_effective_date => p_effective_date
6756: ,p_object_version_number => p_object_version_number
6757: );
6758: if g_debug then
6759: hr_utility.set_location(l_proc, 30);
6760: end if;
6761: --
6762: if (l_api_updating and
6763: per_asg_shd.g_old_rec.organization_id <> p_organization_id)
6764: or
6765: NOT l_api_updating
6766: then
6767: if g_debug then
6768: hr_utility.set_location(l_proc, 40);
6769: end if;
6770:
6771: --
6772: -- Check that organization exists and is date effective
6776: fetch csr_valid_int_hr_org into l_business_group_id;
6777: --
6778: if csr_valid_int_hr_org%notfound then
6779: close csr_valid_int_hr_org;
6780: hr_utility.set_message(801, 'HR_34983_ASG_INVALID_ORG');
6781: hr_multi_message.add
6782: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID'
6783: );
6784: --
6785: else
6786: close csr_valid_int_hr_org;
6787: end if;
6788: if g_debug then
6789: hr_utility.set_location(l_proc, 50);
6790: end if;
6791: --
6792: -- Check that the organization is in the same business group
6793: -- as the business group of the assignment.
6793: -- as the business group of the assignment.
6794: --
6795: If p_business_group_id <> l_business_group_id then
6796: --
6797: hr_utility.set_message(801, 'HR_7376_ASG_INVALID_BG_ORG');
6798: hr_multi_message.add
6799: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID'
6800: );
6801: --
6800: );
6801: --
6802: end if;
6803: if g_debug then
6804: hr_utility.set_location(l_proc, 60);
6805: end if;
6806: --
6807: -- Check if an insert is taking place.
6808: --
6820: open csr_valid_per_org;
6821: fetch csr_valid_per_org into l_exists;
6822: if csr_valid_per_org%notfound then
6823: close csr_valid_per_org;
6824: hr_utility.set_message(801, 'HR_51277_ASG_INV_HR_ORG');
6825: hr_multi_message.add
6826: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID'
6827: );
6828: --
6829: else
6830: close csr_valid_per_org;
6831: end if;
6832: if g_debug then
6833: hr_utility.set_location(l_proc, 70);
6834: end if;
6835: --
6836: end if;
6837: --
6859: )
6860: then
6861: --
6862: if g_debug then
6863: hr_utility.set_location(l_proc, 100);
6864: end if;
6865: --
6866: p_other_manager_warning := TRUE;
6867: else
6866: p_other_manager_warning := TRUE;
6867: else
6868: --
6869: if g_debug then
6870: hr_utility.set_location(l_proc, 110);
6871: end if;
6872: --
6873: p_org_now_no_manager_warning := TRUE;
6874: end if;
6877: end if; -- no exclusive error
6878: --
6879: end if; -- p_assignment_type = 'E'
6880: if g_debug then
6881: hr_utility.set_location(l_proc, 130);
6882: end if;
6883: --
6884: end if;
6885: --
6884: end if;
6885: --
6886: --
6887: if g_debug then
6888: hr_utility.set_location(' Leaving:'|| l_proc, 140);
6889: end if;
6890: end chk_organization_id;
6891: --
6892: --
6935: l_bargaining_unit_code varchar2(72);
6936: --
6937: begin
6938: if g_debug then
6939: hr_utility.set_location('Entering:'|| l_proc, 10);
6940: end if;
6941: --
6942: -- Check mandatory parameters have been set
6943: --
6946: ,p_argument => 'effective_date'
6947: ,p_argument_value => p_effective_date
6948: );
6949: if g_debug then
6950: hr_utility.set_location(l_proc, 20);
6951: end if;
6952: --
6953: if p_bargaining_unit_code is NOT NULL then
6954: if hr_api.not_exists_in_dt_hr_lookups
6958: ,p_lookup_type => 'BARGAINING_UNIT_CODE'
6959: ,p_lookup_code => p_bargaining_unit_code
6960: )
6961: then
6962: hr_utility.set_message(800, 'PER_52383_ASG_BARG_UNIT_CODE');
6963: hr_utility.raise_error;
6964: end if;
6965: end if;
6966: --
6959: ,p_lookup_code => p_bargaining_unit_code
6960: )
6961: then
6962: hr_utility.set_message(800, 'PER_52383_ASG_BARG_UNIT_CODE');
6963: hr_utility.raise_error;
6964: end if;
6965: end if;
6966: --
6967: if g_debug then
6964: end if;
6965: end if;
6966: --
6967: if g_debug then
6968: hr_utility.set_location(' Leaving:'||l_proc, 30);
6969: end if;
6970: exception
6971: when app_exception.application_exception then
6972: if hr_multi_message.exception_add
6972: if hr_multi_message.exception_add
6973: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.BARGAINING_UNIT_CODE'
6974: ) then
6975: if g_debug then
6976: hr_utility.set_location(' Leaving:'|| l_proc, 40);
6977: end if;
6978: raise;
6979: end if;
6980: if g_debug then
6977: end if;
6978: raise;
6979: end if;
6980: if g_debug then
6981: hr_utility.set_location(' Leaving:'|| l_proc, 50);
6982: end if;
6983: --
6984: end chk_bargaining_unit_code;
6985: --
7039: where pay.pay_basis_id = p_pay_basis_id;
7040:
7041: begin
7042: if g_debug then
7043: hr_utility.set_location('Entering:'|| l_proc, 10);
7044: end if;
7045: --
7046: --
7047: -- Check mandatory parameters have been set
7051: ,p_argument => 'effective_date'
7052: ,p_argument_value => p_effective_date
7053: );
7054: if g_debug then
7055: hr_utility.set_location(l_proc, 20);
7056: end if;
7057: --
7058: -- If the assignment is a CWK and the hourly salary
7059: -- code has been set then raise an error.
7060: --
7061: IF p_assignment_type = 'C' AND
7062: p_hourly_salaried_code IS NOT NULL THEN
7063: --
7064: hr_utility.set_message(800,'HR_289648_CWK_HR_CODE_NOT_NULL');
7065: hr_utility.raise_error;
7066: --
7067: END IF;
7068: --
7061: IF p_assignment_type = 'C' AND
7062: p_hourly_salaried_code IS NOT NULL THEN
7063: --
7064: hr_utility.set_message(800,'HR_289648_CWK_HR_CODE_NOT_NULL');
7065: hr_utility.raise_error;
7066: --
7067: END IF;
7068: --
7069: if p_hourly_salaried_code is NOT NULL then
7074: ,p_lookup_type => 'HOURLY_SALARIED_CODE'
7075: ,p_lookup_code => p_hourly_salaried_code
7076: )
7077: then
7078: hr_utility.set_message(800,'PER_52407_HOUR_SAL_CODE');
7079: hr_multi_message.add
7080: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.HOURLY_SALARIED_CODE'
7081: );
7082: else
7095:
7096: p_hourly_salaried_warning := TRUE;
7097: -- updated for bug 2033513
7098:
7099: -- hr_utility.set_message(800,'PER_6997_HOUR_SAL_BASIS');
7100: -- hr_utility.raise_error;
7101:
7102: else null;
7103: end if;
7096: p_hourly_salaried_warning := TRUE;
7097: -- updated for bug 2033513
7098:
7099: -- hr_utility.set_message(800,'PER_6997_HOUR_SAL_BASIS');
7100: -- hr_utility.raise_error;
7101:
7102: else null;
7103: end if;
7104: end if;
7107: end if; -- no exclusive error
7108: end if;
7109: --
7110: if g_debug then
7111: hr_utility.set_location(' Leaving:'||l_proc, 30);
7112: end if;
7113: --
7114: end chk_hourly_salaried_code;
7115: --
7137: l_legislation_code varchar2(150);
7138: l_proc varchar2(72) := g_package||'return_legislation_code';
7139: begin
7140: if g_debug then
7141: hr_utility.set_location('Entering:'|| l_proc, 10);
7142: end if;
7143: --
7144: -- Ensure that all the mandatory parameter are not null
7145: --
7155: -- variable.
7156: --
7157: l_legislation_code := g_legislation_code;
7158: if g_debug then
7159: hr_utility.set_location(l_proc, 20);
7160: end if;
7161: else
7162: --
7163: -- The ID is different to the last call to this function
7169: close csr_leg_code;
7170: --
7171: -- The primary key is invalid therefore we must error
7172: --
7173: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
7174: hr_utility.raise_error;
7175: end if;
7176: --
7177: close csr_leg_code;
7170: --
7171: -- The primary key is invalid therefore we must error
7172: --
7173: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
7174: hr_utility.raise_error;
7175: end if;
7176: --
7177: close csr_leg_code;
7178: if g_debug then
7175: end if;
7176: --
7177: close csr_leg_code;
7178: if g_debug then
7179: hr_utility.set_location(' Leaving:'|| l_proc, 20);
7180: end if;
7181: --
7182: g_assignment_id := p_assignment_id;
7183: g_legislation_code := l_legislation_code;
7182: g_assignment_id := p_assignment_id;
7183: g_legislation_code := l_legislation_code;
7184: end if;
7185: if g_debug then
7186: hr_utility.set_location(' Leaving:'|| l_proc, 30);
7187: end if;
7188: return l_legislation_code;
7189: end return_legislation_code;
7190: --
7219: and information_type = 'PER_OVERLAP';
7220: --
7221: begin
7222: if g_debug then
7223: hr_utility.set_location('Entering:'|| l_proc, 10);
7224: end if;
7225: if p_position_id is not null and p_assignment_start_date is not null then
7226:
7227: /*- Start Change open cursor c1 added for the bug 5840410 --*/
7224: end if;
7225: if p_position_id is not null and p_assignment_start_date is not null then
7226:
7227: /*- Start Change open cursor c1 added for the bug 5840410 --*/
7228: hr_utility.set_location('Pos id and assg start date is not null ', 20);
7229: open c1;
7230: fetch c1 into l_dummy;--l_position_id; commented for 6331872
7231: if c1%found then
7232: hr_utility.set_location('Records found for cursor c1 ', 20);
7228: hr_utility.set_location('Pos id and assg start date is not null ', 20);
7229: open c1;
7230: fetch c1 into l_dummy;--l_position_id; commented for 6331872
7231: if c1%found then
7232: hr_utility.set_location('Records found for cursor c1 ', 20);
7233:
7234: open c2(l_position_id);
7235: /*- End changes for the bug 5840410 --*/
7236: fetch c2 into l_dummy;
7234: open c2(l_position_id);
7235: /*- End changes for the bug 5840410 --*/
7236: fetch c2 into l_dummy;
7237: if c2%found then
7238: hr_utility.set_location('Records found for cursor c2 ', 30);
7239: close c2;
7240: return(true);
7241: else
7242: hr_utility.set_location('No Records found for cursor c2 ', 40);
7238: hr_utility.set_location('Records found for cursor c2 ', 30);
7239: close c2;
7240: return(true);
7241: else
7242: hr_utility.set_location('No Records found for cursor c2 ', 40);
7243: close c2;
7244: return(false);
7245: end if; -- c2
7246: /*- Start Change open cursor c1 added for the bug 5840410 --*/
7244: return(false);
7245: end if; -- c2
7246: /*- Start Change open cursor c1 added for the bug 5840410 --*/
7247: else
7248: hr_utility.set_location('No Records found for cursor c1 ', 50);
7249: close c1;
7250: return(false);
7251: end if; -- c1
7252: /*- End changes for the bug 5840410 --*/
7305: and p_effective_date between effective_start_date and effective_end_date;
7306: --
7307: begin
7308: if g_debug then
7309: hr_utility.set_location('Entering:'|| l_proc, 10);
7310: end if;
7311: --
7312: -- Check mandatory parameters have been set
7313: --
7316: ,p_argument => 'effective_date'
7317: ,p_argument_value => p_effective_date
7318: );
7319: if g_debug then
7320: hr_utility.set_location(l_proc, 20);
7321: end if;
7322: --
7323: if p_position_id is NOT NULL then
7324: open c_position_type(p_position_id, p_effective_date);
7326: close c_position_type;
7327: -- Check that the currne position is not Frozen
7328: if hr_psf_shd.get_availability_status(l_availability_status_id,l_business_group_id) ='FROZEN'
7329: then
7330: hr_utility.set_message(800, 'PER_NO_ASG_FOR_FROZEN_POS');
7331: hr_multi_message.add
7332: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
7333: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
7334: );
7341: /*---- Start change for the bug 5854568 ----(modified for the bug 6331872)*/
7342: if (per_asg_bus1.pos_assignments_exists(p_position_id, p_effective_date, p_assignment_id) and p_assignment_type in ('E','C'))
7343: /*---- End change for the bug 5854568 ----(modified for the bug 6331872)*/
7344: then
7345: hr_utility.set_message(800, 'PER_ASG_EXISTS_FOR_SINGLE_POS');
7346: hr_multi_message.add
7347: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
7348: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
7349: );
7353: end if;
7354: end if;
7355: --
7356: if g_debug then
7357: hr_utility.set_location(' Leaving:'||l_proc, 30);
7358: end if;
7359: --
7360: end chk_frozen_single_pos;
7361: --
7372: l_api_updating boolean;
7373: --
7374: begin
7375: if g_debug then
7376: hr_utility.set_location('Entering:'|| l_proc, 10);
7377: end if;
7378: --
7379: if hr_multi_message.no_exclusive_error
7380: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
7387: ,p_argument => 'effective_date'
7388: ,p_argument_value => p_effective_date
7389: );
7390: if g_debug then
7391: hr_utility.set_location(l_proc, 20);
7392: end if;
7393: --
7394: l_api_updating := per_asg_shd.api_updating
7395: (p_assignment_id => p_assignment_id
7396: ,p_effective_date => p_effective_date
7397: ,p_object_version_number => p_object_version_number
7398: );
7399: if g_debug then
7400: hr_utility.set_location(l_proc, 30);
7401: end if;
7402: --
7403: if (l_api_updating and
7404: (nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
7414: );
7415: end if;
7416: --
7417: if g_debug then
7418: hr_utility.set_location(' Leaving:'||l_proc, 30);
7419: end if;
7420:
7421: end if;
7422: --