eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PE_POI_BUS dependencies on HR_UTILITY

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

46: l_proc varchar2(72) := g_package||'set_security_group_id';
47: --
48: begin
49: --
50: hr_utility.set_location('Entering:'|| l_proc, 10);
51: --
52: -- Ensure that all the mandatory parameter are not null
53: --
54: hr_api.mandatory_arg_error

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

77: hr_api.set_security_group_id
78: (p_security_group_id => l_security_group_id
79: );
80: --
81: hr_utility.set_location(' Leaving:'|| l_proc, 20);
82: --
83: end set_security_group_id;
84: --
85:

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

114: l_proc varchar2(72) := g_package||'return_legislation_code';
115: --
116: Begin
117: --
118: hr_utility.set_location('Entering:'|| l_proc, 10);
119: --
120: --
121: -- Ensure that all the mandatory parameter are not null
122: --

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

133: -- call to this function. Just return the value in the global
134: -- variable.
135: --
136: l_legislation_code := pe_poi_bus.g_legislation_code;
137: hr_utility.set_location(l_proc, 20);
138: else
139: --
140: -- The ID is different to the last call to this function
141: -- or this is the first call to this function.

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

150: close csr_leg_code;
151: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
152: fnd_message.raise_error;
153: end if;
154: hr_utility.set_location(l_proc,30);
155: --
156: -- Set the global variables so the values are
157: -- available for the next call to this function.
158: --

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

160: close csr_leg_code;
161: pe_poi_bus.g_position_extra_info_id := p_position_extra_info_id;
162: pe_poi_bus.g_legislation_code := l_legislation_code;
163: end if;
164: hr_utility.set_location(' Leaving:'|| l_proc, 40);
165: return l_legislation_code;
166: end return_legislation_code;
167:
168: --

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

210: from per_position_info_types poit
211: where poit.information_type = code;
212: --
213: Begin
214: hr_utility.set_location('Entering:'||l_proc, 1);
215: --
216: -- Check mandatory parameters have been set
217: --
218: hr_api.mandatory_arg_error

Line 225: hr_utility.set_location(l_proc, 2);

221: p_argument => 'information_type',
222: p_argument_value => p_information_type
223: );
224: --
225: hr_utility.set_location(l_proc, 2);
226: --
227: -- Check that the ACTIVE_INACTIVE_FLAG of Position
228: -- Information type is active.
229: --

Line 234: hr_utility.set_message(800, 'HR_INV_INFO_TYPE');

230: open c_pos_info_type (p_information_type);
231: fetch c_pos_info_type into l_flag;
232: if c_pos_info_type%notfound then
233: close c_pos_info_type;
234: hr_utility.set_message(800, 'HR_INV_INFO_TYPE');
235: hr_utility.raise_error;
236: end if;
237: close c_pos_info_type;
238: --

Line 235: hr_utility.raise_error;

231: fetch c_pos_info_type into l_flag;
232: if c_pos_info_type%notfound then
233: close c_pos_info_type;
234: hr_utility.set_message(800, 'HR_INV_INFO_TYPE');
235: hr_utility.raise_error;
236: end if;
237: close c_pos_info_type;
238: --
239: if l_flag = 'N' then

Line 240: hr_utility.set_message(800, 'HR_INACTIVE_INFO_TYPE');

236: end if;
237: close c_pos_info_type;
238: --
239: if l_flag = 'N' then
240: hr_utility.set_message(800, 'HR_INACTIVE_INFO_TYPE');
241: hr_utility.raise_error;
242: end if;
243: --
244: hr_utility.set_location(' Leaving:'||l_proc, 3);

Line 241: hr_utility.raise_error;

237: close c_pos_info_type;
238: --
239: if l_flag = 'N' then
240: hr_utility.set_message(800, 'HR_INACTIVE_INFO_TYPE');
241: hr_utility.raise_error;
242: end if;
243: --
244: hr_utility.set_location(' Leaving:'||l_proc, 3);
245: --

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

240: hr_utility.set_message(800, 'HR_INACTIVE_INFO_TYPE');
241: hr_utility.raise_error;
242: end if;
243: --
244: hr_utility.set_location(' Leaving:'||l_proc, 3);
245: --
246: End chk_position_info_type;
247: --
248: -- ----------------------------------------------------------------------------

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

291: from hr_all_positions_f
292: where position_id = id;
293: --
294: Begin
295: hr_utility.set_location('Entering:'||l_proc, 1);
296: --
297: -- Check mandatory parameters have been set
298: --
299: hr_api.mandatory_arg_error

Line 305: hr_utility.set_location(l_proc, 2);

301: p_api_name => l_proc,
302: p_argument => 'position_id',
303: p_argument_value => p_position_id
304: );
305: hr_utility.set_location(l_proc, 2);
306: --
307: -- Check that the position_id is in the hr_positions table.
308: --
309: open c_valid_pos (p_position_id);

Line 313: hr_utility.set_message(800, 'HR_INV_POS_ID');

309: open c_valid_pos (p_position_id);
310: fetch c_valid_pos into l_dummy;
311: if c_valid_pos%notfound then
312: close c_valid_pos;
313: hr_utility.set_message(800, 'HR_INV_POS_ID');
314: hr_utility.raise_error;
315: end if;
316: close c_valid_pos;
317: --

Line 314: hr_utility.raise_error;

310: fetch c_valid_pos into l_dummy;
311: if c_valid_pos%notfound then
312: close c_valid_pos;
313: hr_utility.set_message(800, 'HR_INV_POS_ID');
314: hr_utility.raise_error;
315: end if;
316: close c_valid_pos;
317: --
318: hr_utility.set_location(' Leaving:'||l_proc, 3);

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

314: hr_utility.raise_error;
315: end if;
316: close c_valid_pos;
317: --
318: hr_utility.set_location(' Leaving:'||l_proc, 3);
319: --
320: End chk_position_id;
321: --
322: -- ----------------------------------------------------------------------------

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

372: where information_type = code
373: and position_id = id;
374: --
375: Begin
376: hr_utility.set_location('Entering:'||l_proc, 5);
377: --
378: open c_multi_occur_flag (p_information_type);
379: fetch c_multi_occur_flag into l_multi_occur_flag;
380: --

Line 386: hr_utility.set_message(800, 'HR_INV_INFO_TYPE');

382: -- chk_information_type should capture this error.
383: --
384: if c_multi_occur_flag%notfound then
385: close c_multi_occur_flag;
386: hr_utility.set_message(800, 'HR_INV_INFO_TYPE');
387: hr_utility.raise_error;
388: end if;
389: --
390: close c_multi_occur_flag;

Line 387: hr_utility.raise_error;

383: --
384: if c_multi_occur_flag%notfound then
385: close c_multi_occur_flag;
386: hr_utility.set_message(800, 'HR_INV_INFO_TYPE');
387: hr_utility.raise_error;
388: end if;
389: --
390: close c_multi_occur_flag;
391: --

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

388: end if;
389: --
390: close c_multi_occur_flag;
391: --
392: hr_utility.set_location(l_proc, 10);
393: --
394: open c_get_row(p_information_type, p_position_id);
395: fetch c_get_row into l_dummy;
396: if c_get_row%notfound then

Line 404: hr_utility.set_message(800, 'HR_MORE_THAN_1_EXTRA_INFO');

400: end if;
401: close c_get_row;
402: --
403: if l_found_poi and l_multi_occur_flag = 'N' then
404: hr_utility.set_message(800, 'HR_MORE_THAN_1_EXTRA_INFO');
405: hr_utility.raise_error;
406: end if;
407: --
408: hr_utility.set_location(' Leaving:'||l_proc, 15);

Line 405: hr_utility.raise_error;

401: close c_get_row;
402: --
403: if l_found_poi and l_multi_occur_flag = 'N' then
404: hr_utility.set_message(800, 'HR_MORE_THAN_1_EXTRA_INFO');
405: hr_utility.raise_error;
406: end if;
407: --
408: hr_utility.set_location(' Leaving:'||l_proc, 15);
409: --

Line 408: hr_utility.set_location(' Leaving:'||l_proc, 15);

404: hr_utility.set_message(800, 'HR_MORE_THAN_1_EXTRA_INFO');
405: hr_utility.raise_error;
406: end if;
407: --
408: hr_utility.set_location(' Leaving:'||l_proc, 15);
409: --
410: End chk_multiple_occurences_flag;
411: --
412: -- ----------------------------------------------------------------------------

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

445: l_error exception;
446: l_argument varchar2(30);
447: --
448: Begin
449: hr_utility.set_location('Entering:'||l_proc, 10);
450: --
451: -- Only proceed with validation if a row exists for
452: -- the current record in the HR Schema
453: --

Line 457: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

453: --
454: if not pe_poi_shd.api_updating
455: (p_position_extra_info_id => p_rec.position_extra_info_id
456: ,p_object_version_number => p_rec.object_version_number) then
457: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
458: hr_utility.set_message_token('PROCEDURE', l_proc);
459: hr_utility.set_message_token('STEP', '20');
460: end if;
461: --

Line 458: hr_utility.set_message_token('PROCEDURE', l_proc);

454: if not pe_poi_shd.api_updating
455: (p_position_extra_info_id => p_rec.position_extra_info_id
456: ,p_object_version_number => p_rec.object_version_number) then
457: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
458: hr_utility.set_message_token('PROCEDURE', l_proc);
459: hr_utility.set_message_token('STEP', '20');
460: end if;
461: --
462: hr_utility.set_location(l_proc, 30);

Line 459: hr_utility.set_message_token('STEP', '20');

455: (p_position_extra_info_id => p_rec.position_extra_info_id
456: ,p_object_version_number => p_rec.object_version_number) then
457: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
458: hr_utility.set_message_token('PROCEDURE', l_proc);
459: hr_utility.set_message_token('STEP', '20');
460: end if;
461: --
462: hr_utility.set_location(l_proc, 30);
463: --

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

458: hr_utility.set_message_token('PROCEDURE', l_proc);
459: hr_utility.set_message_token('STEP', '20');
460: end if;
461: --
462: hr_utility.set_location(l_proc, 30);
463: --
464: if nvl(p_rec.information_type, hr_api.g_varchar2) <>
465: nvl(pe_poi_shd.g_old_rec.information_type, hr_api.g_varchar2) then
466: l_argument := 'information_type';

Line 470: hr_utility.set_location(l_proc, 40);

466: l_argument := 'information_type';
467: raise l_error;
468: end if;
469: --
470: hr_utility.set_location(l_proc, 40);
471: --
472: if nvl(p_rec.position_id, hr_api.g_number) <>
473: nvl(pe_poi_shd.g_old_rec.position_id, hr_api.g_number) then
474: l_argument := 'position_id';

Line 478: hr_utility.set_location(' Leaving:'||l_proc, 50);

474: l_argument := 'position_id';
475: raise l_error;
476: end if;
477: --
478: hr_utility.set_location(' Leaving:'||l_proc, 50);
479: exception
480: when l_error then
481: hr_api.argument_changed_error
482: (p_api_name => l_proc

Line 485: hr_utility.set_location(l_proc, 60);

481: hr_api.argument_changed_error
482: (p_api_name => l_proc
483: ,p_argument => l_argument
484: );
485: hr_utility.set_location(l_proc, 60);
486: when others then
487: hr_utility.set_location(l_proc, 70);
488: raise;
489: end chk_non_updateable_args;

Line 487: hr_utility.set_location(l_proc, 70);

483: ,p_argument => l_argument
484: );
485: hr_utility.set_location(l_proc, 60);
486: when others then
487: hr_utility.set_location(l_proc, 70);
488: raise;
489: end chk_non_updateable_args;
490: --
491: -- -----------------------------------------------------------------------

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

520: --
521: l_proc varchar2(72) := g_package||'chk_df';
522: --
523: begin
524: hr_utility.set_location('Entering:'||l_proc, 10);
525: --
526: if ((p_rec.position_extra_info_id is not null) and (
527: nvl(pe_poi_shd.g_old_rec.poei_attribute_category, hr_api.g_varchar2) <>
528: nvl(p_rec.poei_attribute_category, hr_api.g_varchar2) or

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

619: ,p_attribute20_name => 'POEI_ATTRIBUTE20'
620: ,p_attribute20_value => p_rec.poei_attribute20);
621: end if;
622: --
623: hr_utility.set_location(' Leaving:'||l_proc, 20);
624: end chk_df;
625: --
626: -- -----------------------------------------------------------------------
627: -- |------------------------------< chk_ddf >----------------------------|

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

660: l_proc varchar2(72) := g_package||'chk_ddf';
661: l_error exception;
662: --
663: Begin
664: hr_utility.set_location('Entering:'||l_proc, 5);
665: --
666: -- Check if the row is being inserted or updated and a
667: -- value has changed
668: --

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

800: );
801: --
802: end if;
803: --
804: hr_utility.set_location(' Leaving:'||l_proc, 10);
805: end chk_ddf;
806: --
807: -- --------------------------------------------------------------------------------
808: -- |---------------------------< permit_extended_pay_poi >----------------------------|

Line 874: hr_utility.set_message(800, 'HR_INV_POI_FAMILY');

870: if ( nvl(p_work_period_type_cd,'N') = 'Y' ) then
871: if (not permit_extended_pay_poi(p_rec)) then
872: -- Cannot change Position Family of Position Extra Info
873: -- to Others if extended pay is permitted
874: hr_utility.set_message(800, 'HR_INV_POI_FAMILY');
875: hr_utility.raise_error;
876: end if;
877: end if;
878: end;

Line 875: hr_utility.raise_error;

871: if (not permit_extended_pay_poi(p_rec)) then
872: -- Cannot change Position Family of Position Extra Info
873: -- to Others if extended pay is permitted
874: hr_utility.set_message(800, 'HR_INV_POI_FAMILY');
875: hr_utility.raise_error;
876: end if;
877: end if;
878: end;
879: --

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

898: where position_id = p_position_id
899: and p_effective_date between effective_start_date and effective_end_date;
900: --
901: Begin
902: hr_utility.set_location('Entering:'||l_proc, 5);
903: --
904: open c_effective_date;
905: fetch c_effective_date into l_effective_date;
906: close c_effective_date;

Line 915: hr_utility.set_message(800, 'HR_INV_POS_ID');

911: -- Validate Position Id
912: --
913: if c_position%notfound then
914: close c_position;
915: hr_utility.set_message(800, 'HR_INV_POS_ID');
916: hr_utility.raise_error;
917: end if;
918: --
919: close c_position;

Line 916: hr_utility.raise_error;

912: --
913: if c_position%notfound then
914: close c_position;
915: hr_utility.set_message(800, 'HR_INV_POS_ID');
916: hr_utility.raise_error;
917: end if;
918: --
919: close c_position;
920: --

Line 930: hr_utility.set_location('Entering:'||l_proc, 7);

926: hr_psf_bus.set_security_group_id
927: (p_position_id => p_rec.position_id
928: );
929: --
930: hr_utility.set_location('Entering:'||l_proc, 7);
931: --
932: -- Validate Position Info Type
933: --
934: chk_position_info_type

Line 966: hr_utility.set_message(800, 'HR_INV_POI_SEASONAL');

962: --
963: if (p_rec.information_type = 'PER_SEASONAL') then
964: if (nvl(l_position_rec.seasonal_flag,'N') = 'N' )then
965: -- Cannot add Seasonal dates to Position Extra Info if seasonal_flag<>'Y'
966: hr_utility.set_message(800, 'HR_INV_POI_SEASONAL');
967: hr_utility.raise_error;
968: end if;
969: if (fnd_date.canonical_to_date(p_rec.poei_information3)
970: > fnd_date.canonical_to_date(p_rec.poei_information4)) then

Line 967: hr_utility.raise_error;

963: if (p_rec.information_type = 'PER_SEASONAL') then
964: if (nvl(l_position_rec.seasonal_flag,'N') = 'N' )then
965: -- Cannot add Seasonal dates to Position Extra Info if seasonal_flag<>'Y'
966: hr_utility.set_message(800, 'HR_INV_POI_SEASONAL');
967: hr_utility.raise_error;
968: end if;
969: if (fnd_date.canonical_to_date(p_rec.poei_information3)
970: > fnd_date.canonical_to_date(p_rec.poei_information4)) then
971: -- Seasonal end date should be later than seasonal start date

Line 972: hr_utility.set_message(800, 'HR_INV_POI_SEASONAL_DATES');

968: end if;
969: if (fnd_date.canonical_to_date(p_rec.poei_information3)
970: > fnd_date.canonical_to_date(p_rec.poei_information4)) then
971: -- Seasonal end date should be later than seasonal start date
972: hr_utility.set_message(800, 'HR_INV_POI_SEASONAL_DATES');
973: hr_utility.raise_error;
974: end if;
975: end if;
976: --

Line 973: hr_utility.raise_error;

969: if (fnd_date.canonical_to_date(p_rec.poei_information3)
970: > fnd_date.canonical_to_date(p_rec.poei_information4)) then
971: -- Seasonal end date should be later than seasonal start date
972: hr_utility.set_message(800, 'HR_INV_POI_SEASONAL_DATES');
973: hr_utility.raise_error;
974: end if;
975: end if;
976: --
977: -- Validate Overlap Dates for Position Extra Info

Line 982: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP');

978: --
979: if (p_rec.information_type = 'PER_OVERLAP') then
980: if ( l_position_rec.overlap_period is null )then
981: -- Cannot add Overlap dates to Position Extra Info if overlap_period is null
982: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP');
983: hr_utility.raise_error;
984: end if;
985: l_position_start_date := pqh_utility.position_start_date(p_rec.position_id);
986: if (fnd_date.canonical_to_date(p_rec.poei_information3) < l_position_start_date) then

Line 983: hr_utility.raise_error;

979: if (p_rec.information_type = 'PER_OVERLAP') then
980: if ( l_position_rec.overlap_period is null )then
981: -- Cannot add Overlap dates to Position Extra Info if overlap_period is null
982: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP');
983: hr_utility.raise_error;
984: end if;
985: l_position_start_date := pqh_utility.position_start_date(p_rec.position_id);
986: if (fnd_date.canonical_to_date(p_rec.poei_information3) < l_position_start_date) then
987: -- Overlap start date should be greater than or equal to position start date

Line 988: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP_ST_DT');

984: end if;
985: l_position_start_date := pqh_utility.position_start_date(p_rec.position_id);
986: if (fnd_date.canonical_to_date(p_rec.poei_information3) < l_position_start_date) then
987: -- Overlap start date should be greater than or equal to position start date
988: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP_ST_DT');
989: hr_utility.set_message_token('POSITION_START_DATE', l_position_start_date);
990: hr_utility.raise_error;
991: end if;
992: if (fnd_date.canonical_to_date(p_rec.poei_information3)

Line 989: hr_utility.set_message_token('POSITION_START_DATE', l_position_start_date);

985: l_position_start_date := pqh_utility.position_start_date(p_rec.position_id);
986: if (fnd_date.canonical_to_date(p_rec.poei_information3) < l_position_start_date) then
987: -- Overlap start date should be greater than or equal to position start date
988: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP_ST_DT');
989: hr_utility.set_message_token('POSITION_START_DATE', l_position_start_date);
990: hr_utility.raise_error;
991: end if;
992: if (fnd_date.canonical_to_date(p_rec.poei_information3)
993: > fnd_date.canonical_to_date(p_rec.poei_information4)) then

Line 990: hr_utility.raise_error;

986: if (fnd_date.canonical_to_date(p_rec.poei_information3) < l_position_start_date) then
987: -- Overlap start date should be greater than or equal to position start date
988: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP_ST_DT');
989: hr_utility.set_message_token('POSITION_START_DATE', l_position_start_date);
990: hr_utility.raise_error;
991: end if;
992: if (fnd_date.canonical_to_date(p_rec.poei_information3)
993: > fnd_date.canonical_to_date(p_rec.poei_information4)) then
994: -- Overlap end date should be later than overlap start date

Line 995: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP_DATES');

991: end if;
992: if (fnd_date.canonical_to_date(p_rec.poei_information3)
993: > fnd_date.canonical_to_date(p_rec.poei_information4)) then
994: -- Overlap end date should be later than overlap start date
995: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP_DATES');
996: hr_utility.raise_error;
997: end if;
998: end if;
999: --

Line 996: hr_utility.raise_error;

992: if (fnd_date.canonical_to_date(p_rec.poei_information3)
993: > fnd_date.canonical_to_date(p_rec.poei_information4)) then
994: -- Overlap end date should be later than overlap start date
995: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP_DATES');
996: hr_utility.raise_error;
997: end if;
998: end if;
999: --
1000: --

Line 1007: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_ST_DT');

1003: if (p_rec.information_type = 'PER_RESERVED') then
1004: l_position_start_date := pqh_utility.position_start_date(p_rec.position_id);
1005: if (fnd_date.canonical_to_date(p_rec.poei_information3) < l_position_start_date) then
1006: -- Reservation start date should be greater than or equal to position start date
1007: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_ST_DT');
1008: hr_utility.set_message_token('POSITION_START_DATE', l_position_start_date);
1009: hr_utility.raise_error;
1010: end if;
1011: if (fnd_date.canonical_to_date(p_rec.poei_information3)

Line 1008: hr_utility.set_message_token('POSITION_START_DATE', l_position_start_date);

1004: l_position_start_date := pqh_utility.position_start_date(p_rec.position_id);
1005: if (fnd_date.canonical_to_date(p_rec.poei_information3) < l_position_start_date) then
1006: -- Reservation start date should be greater than or equal to position start date
1007: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_ST_DT');
1008: hr_utility.set_message_token('POSITION_START_DATE', l_position_start_date);
1009: hr_utility.raise_error;
1010: end if;
1011: if (fnd_date.canonical_to_date(p_rec.poei_information3)
1012: > fnd_date.canonical_to_date(p_rec.poei_information4)) then

Line 1009: hr_utility.raise_error;

1005: if (fnd_date.canonical_to_date(p_rec.poei_information3) < l_position_start_date) then
1006: -- Reservation start date should be greater than or equal to position start date
1007: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_ST_DT');
1008: hr_utility.set_message_token('POSITION_START_DATE', l_position_start_date);
1009: hr_utility.raise_error;
1010: end if;
1011: if (fnd_date.canonical_to_date(p_rec.poei_information3)
1012: > fnd_date.canonical_to_date(p_rec.poei_information4)) then
1013: -- Reservation end date should be later than reservation start date

Line 1014: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_DATES');

1010: end if;
1011: if (fnd_date.canonical_to_date(p_rec.poei_information3)
1012: > fnd_date.canonical_to_date(p_rec.poei_information4)) then
1013: -- Reservation end date should be later than reservation start date
1014: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_DATES');
1015: hr_utility.raise_error;
1016: end if;
1017: if (p_rec.poei_information6 <= 0) then
1018: -- FTE should be greater than 0

Line 1015: hr_utility.raise_error;

1011: if (fnd_date.canonical_to_date(p_rec.poei_information3)
1012: > fnd_date.canonical_to_date(p_rec.poei_information4)) then
1013: -- Reservation end date should be later than reservation start date
1014: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_DATES');
1015: hr_utility.raise_error;
1016: end if;
1017: if (p_rec.poei_information6 <= 0) then
1018: -- FTE should be greater than 0
1019: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_FTE');

Line 1019: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_FTE');

1015: hr_utility.raise_error;
1016: end if;
1017: if (p_rec.poei_information6 <= 0) then
1018: -- FTE should be greater than 0
1019: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_FTE');
1020: hr_utility.raise_error;
1021: end if;
1022: --
1023: -- check whether reserved fte is available

Line 1020: hr_utility.raise_error;

1016: end if;
1017: if (p_rec.poei_information6 <= 0) then
1018: -- FTE should be greater than 0
1019: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_FTE');
1020: hr_utility.raise_error;
1021: end if;
1022: --
1023: -- check whether reserved fte is available
1024: --

Line 1031: hr_utility.set_location(' Leaving:'||l_proc, 30);

1027: fnd_date.canonical_to_date(p_rec.poei_information3),
1028: fnd_date.canonical_to_date(p_rec.poei_information4) , p_rec.poei_information6);
1029: end if;
1030: --
1031: hr_utility.set_location(' Leaving:'||l_proc, 30);
1032: --
1033: End insert_validate;
1034: --
1035: -- ----------------------------------------------------------------------------

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

1053: where position_id = p_position_id
1054: and p_effective_date between effective_start_date and effective_end_date;
1055: --
1056: Begin
1057: hr_utility.set_location('Entering:'||l_proc, 5);
1058: --
1059: open c_effective_date;
1060: fetch c_effective_date into l_effective_date;
1061: close c_effective_date;

Line 1076: hr_utility.set_location('Entering:'||l_proc, 7);

1072: hr_psf_bus.set_security_group_id
1073: (p_position_id => p_rec.position_id
1074: );
1075: --
1076: hr_utility.set_location('Entering:'||l_proc, 7);
1077: --
1078: -- Validate Non-Updateable Fields
1079: --
1080: chk_non_updateable_args (p_rec => p_rec);

Line 1094: hr_utility.set_message(800, 'HR_INV_POI_SEASONAL');

1090: --
1091: if (p_rec.information_type = 'PER_SEASONAL') then
1092: if (nvl(l_position_rec.seasonal_flag,'N') = 'N' )then
1093: -- Cannot add Seasonal dates to Position Extra Info if seasonal_flag<>'Y'
1094: hr_utility.set_message(800, 'HR_INV_POI_SEASONAL');
1095: hr_utility.raise_error;
1096: end if;
1097: if (fnd_date.canonical_to_date(p_rec.poei_information3)
1098: > fnd_date.canonical_to_date(p_rec.poei_information4)) then

Line 1095: hr_utility.raise_error;

1091: if (p_rec.information_type = 'PER_SEASONAL') then
1092: if (nvl(l_position_rec.seasonal_flag,'N') = 'N' )then
1093: -- Cannot add Seasonal dates to Position Extra Info if seasonal_flag<>'Y'
1094: hr_utility.set_message(800, 'HR_INV_POI_SEASONAL');
1095: hr_utility.raise_error;
1096: end if;
1097: if (fnd_date.canonical_to_date(p_rec.poei_information3)
1098: > fnd_date.canonical_to_date(p_rec.poei_information4)) then
1099: -- Seasonal end date should be later than seasonal start date

Line 1100: hr_utility.set_message(800, 'HR_INV_POI_SEASONAL_DATES');

1096: end if;
1097: if (fnd_date.canonical_to_date(p_rec.poei_information3)
1098: > fnd_date.canonical_to_date(p_rec.poei_information4)) then
1099: -- Seasonal end date should be later than seasonal start date
1100: hr_utility.set_message(800, 'HR_INV_POI_SEASONAL_DATES');
1101: hr_utility.raise_error;
1102: end if;
1103: end if;
1104: --

Line 1101: hr_utility.raise_error;

1097: if (fnd_date.canonical_to_date(p_rec.poei_information3)
1098: > fnd_date.canonical_to_date(p_rec.poei_information4)) then
1099: -- Seasonal end date should be later than seasonal start date
1100: hr_utility.set_message(800, 'HR_INV_POI_SEASONAL_DATES');
1101: hr_utility.raise_error;
1102: end if;
1103: end if;
1104: --
1105: -- Validate Overlap Dates for Position Extra Info

Line 1110: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP');

1106: --
1107: if (p_rec.information_type = 'PER_OVERLAP') then
1108: if ( l_position_rec.overlap_period is null )then
1109: -- Cannot add Overlap dates to Position Extra Info if overlap_period is null
1110: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP');
1111: hr_utility.raise_error;
1112: end if;
1113: l_position_start_date := pqh_utility.position_start_date(p_rec.position_id);
1114: if (fnd_date.canonical_to_date(p_rec.poei_information3) < l_position_start_date) then

Line 1111: hr_utility.raise_error;

1107: if (p_rec.information_type = 'PER_OVERLAP') then
1108: if ( l_position_rec.overlap_period is null )then
1109: -- Cannot add Overlap dates to Position Extra Info if overlap_period is null
1110: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP');
1111: hr_utility.raise_error;
1112: end if;
1113: l_position_start_date := pqh_utility.position_start_date(p_rec.position_id);
1114: if (fnd_date.canonical_to_date(p_rec.poei_information3) < l_position_start_date) then
1115: -- Overlap start date should be greater than or equal to position start date

Line 1116: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP_ST_DT');

1112: end if;
1113: l_position_start_date := pqh_utility.position_start_date(p_rec.position_id);
1114: if (fnd_date.canonical_to_date(p_rec.poei_information3) < l_position_start_date) then
1115: -- Overlap start date should be greater than or equal to position start date
1116: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP_ST_DT');
1117: hr_utility.set_message_token('POSITION_START_DATE', l_position_start_date);
1118: hr_utility.raise_error;
1119: end if;
1120: if (fnd_date.canonical_to_date(p_rec.poei_information3)

Line 1117: hr_utility.set_message_token('POSITION_START_DATE', l_position_start_date);

1113: l_position_start_date := pqh_utility.position_start_date(p_rec.position_id);
1114: if (fnd_date.canonical_to_date(p_rec.poei_information3) < l_position_start_date) then
1115: -- Overlap start date should be greater than or equal to position start date
1116: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP_ST_DT');
1117: hr_utility.set_message_token('POSITION_START_DATE', l_position_start_date);
1118: hr_utility.raise_error;
1119: end if;
1120: if (fnd_date.canonical_to_date(p_rec.poei_information3)
1121: > fnd_date.canonical_to_date(p_rec.poei_information4)) then

Line 1118: hr_utility.raise_error;

1114: if (fnd_date.canonical_to_date(p_rec.poei_information3) < l_position_start_date) then
1115: -- Overlap start date should be greater than or equal to position start date
1116: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP_ST_DT');
1117: hr_utility.set_message_token('POSITION_START_DATE', l_position_start_date);
1118: hr_utility.raise_error;
1119: end if;
1120: if (fnd_date.canonical_to_date(p_rec.poei_information3)
1121: > fnd_date.canonical_to_date(p_rec.poei_information4)) then
1122: -- Overlap end date should be later than overlap start date

Line 1123: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP_DATES');

1119: end if;
1120: if (fnd_date.canonical_to_date(p_rec.poei_information3)
1121: > fnd_date.canonical_to_date(p_rec.poei_information4)) then
1122: -- Overlap end date should be later than overlap start date
1123: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP_DATES');
1124: hr_utility.raise_error;
1125: end if;
1126: end if;
1127: --

Line 1124: hr_utility.raise_error;

1120: if (fnd_date.canonical_to_date(p_rec.poei_information3)
1121: > fnd_date.canonical_to_date(p_rec.poei_information4)) then
1122: -- Overlap end date should be later than overlap start date
1123: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP_DATES');
1124: hr_utility.raise_error;
1125: end if;
1126: end if;
1127: --
1128: if (p_rec.information_type = 'PER_RESERVED') then

Line 1132: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_ST_DT');

1128: if (p_rec.information_type = 'PER_RESERVED') then
1129: l_position_start_date := pqh_utility.position_start_date(p_rec.position_id);
1130: if (fnd_date.canonical_to_date(p_rec.poei_information3) < l_position_start_date) then
1131: -- Reservation start date should be greater than or equal to position start date
1132: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_ST_DT');
1133: hr_utility.set_message_token('POSITION_START_DATE', l_position_start_date);
1134: hr_utility.raise_error;
1135: end if;
1136: if (fnd_date.canonical_to_date(p_rec.poei_information3)

Line 1133: hr_utility.set_message_token('POSITION_START_DATE', l_position_start_date);

1129: l_position_start_date := pqh_utility.position_start_date(p_rec.position_id);
1130: if (fnd_date.canonical_to_date(p_rec.poei_information3) < l_position_start_date) then
1131: -- Reservation start date should be greater than or equal to position start date
1132: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_ST_DT');
1133: hr_utility.set_message_token('POSITION_START_DATE', l_position_start_date);
1134: hr_utility.raise_error;
1135: end if;
1136: if (fnd_date.canonical_to_date(p_rec.poei_information3)
1137: > fnd_date.canonical_to_date(p_rec.poei_information4)) then

Line 1134: hr_utility.raise_error;

1130: if (fnd_date.canonical_to_date(p_rec.poei_information3) < l_position_start_date) then
1131: -- Reservation start date should be greater than or equal to position start date
1132: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_ST_DT');
1133: hr_utility.set_message_token('POSITION_START_DATE', l_position_start_date);
1134: hr_utility.raise_error;
1135: end if;
1136: if (fnd_date.canonical_to_date(p_rec.poei_information3)
1137: > fnd_date.canonical_to_date(p_rec.poei_information4)) then
1138: -- Reservation end date should be later than reservation start date

Line 1139: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_DATES');

1135: end if;
1136: if (fnd_date.canonical_to_date(p_rec.poei_information3)
1137: > fnd_date.canonical_to_date(p_rec.poei_information4)) then
1138: -- Reservation end date should be later than reservation start date
1139: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_DATES');
1140: hr_utility.raise_error;
1141: end if;
1142: if (p_rec.poei_information6 <= 0) then
1143: -- FTE should be greater than 0

Line 1140: hr_utility.raise_error;

1136: if (fnd_date.canonical_to_date(p_rec.poei_information3)
1137: > fnd_date.canonical_to_date(p_rec.poei_information4)) then
1138: -- Reservation end date should be later than reservation start date
1139: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_DATES');
1140: hr_utility.raise_error;
1141: end if;
1142: if (p_rec.poei_information6 <= 0) then
1143: -- FTE should be greater than 0
1144: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_FTE');

Line 1144: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_FTE');

1140: hr_utility.raise_error;
1141: end if;
1142: if (p_rec.poei_information6 <= 0) then
1143: -- FTE should be greater than 0
1144: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_FTE');
1145: hr_utility.raise_error;
1146: end if;
1147: --
1148: -- check whether reserved fte is available

Line 1145: hr_utility.raise_error;

1141: end if;
1142: if (p_rec.poei_information6 <= 0) then
1143: -- FTE should be greater than 0
1144: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_FTE');
1145: hr_utility.raise_error;
1146: end if;
1147: --
1148: -- check whether reserved fte is available
1149: --

Line 1160: hr_utility.set_location(' Leaving:'||l_proc, 30);

1156: -- Validate Position Family for Position Extra Info
1157: chk_position_family(l_position_rec.work_period_type_cd, p_rec);
1158: end if;
1159: --
1160: hr_utility.set_location(' Leaving:'||l_proc, 30);
1161: --
1162: End update_validate;
1163: --
1164: -- ----------------------------------------------------------------------------

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

1181: where position_id = p_position_id
1182: and p_effective_date between effective_start_date and effective_end_date;
1183: --
1184: Begin
1185: hr_utility.set_location('Entering:'||l_proc, 5);
1186: --
1187: open c_effective_date;
1188: fetch c_effective_date into l_effective_date;
1189: close c_effective_date;

Line 1204: hr_utility.set_message(800, 'HR_INV_POI_FAMILY_DEL');

1200: if (p_rec.information_type = 'PER_FAMILY') then
1201: if (l_position_rec.work_period_type_cd = 'Y') then
1202: -- Cannot delete Position Family of Position Extra Info
1203: -- if extended pay is permitted
1204: hr_utility.set_message(800, 'HR_INV_POI_FAMILY_DEL');
1205: hr_utility.raise_error;
1206: end if;
1207: end if;
1208: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 1205: hr_utility.raise_error;

1201: if (l_position_rec.work_period_type_cd = 'Y') then
1202: -- Cannot delete Position Family of Position Extra Info
1203: -- if extended pay is permitted
1204: hr_utility.set_message(800, 'HR_INV_POI_FAMILY_DEL');
1205: hr_utility.raise_error;
1206: end if;
1207: end if;
1208: hr_utility.set_location(' Leaving:'||l_proc, 10);
1209: --

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

1204: hr_utility.set_message(800, 'HR_INV_POI_FAMILY_DEL');
1205: hr_utility.raise_error;
1206: end if;
1207: end if;
1208: hr_utility.set_location(' Leaving:'||l_proc, 10);
1209: --
1210: End delete_validate;
1211: --
1212: end pe_poi_bus;