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 FND_DATE

Line 969: if (fnd_date.canonical_to_date(p_rec.poei_information3)

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
972: hr_utility.set_message(800, 'HR_INV_POI_SEASONAL_DATES');
973: hr_utility.raise_error;

Line 970: > fnd_date.canonical_to_date(p_rec.poei_information4)) then

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
972: hr_utility.set_message(800, 'HR_INV_POI_SEASONAL_DATES');
973: hr_utility.raise_error;
974: end if;

Line 986: if (fnd_date.canonical_to_date(p_rec.poei_information3) < l_position_start_date) then

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
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;

Line 992: if (fnd_date.canonical_to_date(p_rec.poei_information3)

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
995: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP_DATES');
996: hr_utility.raise_error;

Line 993: > fnd_date.canonical_to_date(p_rec.poei_information4)) then

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
995: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP_DATES');
996: hr_utility.raise_error;
997: end if;

Line 1005: if (fnd_date.canonical_to_date(p_rec.poei_information3) < l_position_start_date) then

1001: -- Validate Reservation Info for PTX Extra Info
1002: --
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;

Line 1011: if (fnd_date.canonical_to_date(p_rec.poei_information3)

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
1014: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_DATES');
1015: hr_utility.raise_error;

Line 1012: > fnd_date.canonical_to_date(p_rec.poei_information4)) then

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
1014: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_DATES');
1015: hr_utility.raise_error;
1016: end if;

Line 1027: fnd_date.canonical_to_date(p_rec.poei_information3),

1023: -- check whether reserved fte is available
1024: --
1025: pqh_psf_bus.pqh_poei_validate(p_rec.position_id,
1026: p_rec.position_extra_info_id, p_rec.poei_information5,
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);

Line 1028: fnd_date.canonical_to_date(p_rec.poei_information4) , p_rec.poei_information6);

1024: --
1025: pqh_psf_bus.pqh_poei_validate(p_rec.position_id,
1026: p_rec.position_extra_info_id, p_rec.poei_information5,
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: --

Line 1097: if (fnd_date.canonical_to_date(p_rec.poei_information3)

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
1100: hr_utility.set_message(800, 'HR_INV_POI_SEASONAL_DATES');
1101: hr_utility.raise_error;

Line 1098: > fnd_date.canonical_to_date(p_rec.poei_information4)) then

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
1100: hr_utility.set_message(800, 'HR_INV_POI_SEASONAL_DATES');
1101: hr_utility.raise_error;
1102: end if;

Line 1114: if (fnd_date.canonical_to_date(p_rec.poei_information3) < l_position_start_date) then

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
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;

Line 1120: if (fnd_date.canonical_to_date(p_rec.poei_information3)

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
1123: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP_DATES');
1124: hr_utility.raise_error;

Line 1121: > fnd_date.canonical_to_date(p_rec.poei_information4)) then

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
1123: hr_utility.set_message(800, 'HR_INV_POI_OVERLAP_DATES');
1124: hr_utility.raise_error;
1125: end if;

Line 1130: if (fnd_date.canonical_to_date(p_rec.poei_information3) < l_position_start_date) then

1126: end if;
1127: --
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;

Line 1136: if (fnd_date.canonical_to_date(p_rec.poei_information3)

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
1139: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_DATES');
1140: hr_utility.raise_error;

Line 1137: > fnd_date.canonical_to_date(p_rec.poei_information4)) then

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
1139: hr_utility.set_message(800, 'HR_INV_POI_RESERVED_DATES');
1140: hr_utility.raise_error;
1141: end if;

Line 1152: fnd_date.canonical_to_date(p_rec.poei_information3),

1148: -- check whether reserved fte is available
1149: --
1150: pqh_psf_bus.pqh_poei_validate(p_rec.position_id,
1151: p_rec.position_extra_info_id, p_rec.poei_information5,
1152: fnd_date.canonical_to_date(p_rec.poei_information3),
1153: fnd_date.canonical_to_date(p_rec.poei_information4) , p_rec.poei_information6);
1154: --
1155: elsif (p_rec.information_type = 'PER_FAMILY') then
1156: -- Validate Position Family for Position Extra Info

Line 1153: fnd_date.canonical_to_date(p_rec.poei_information4) , p_rec.poei_information6);

1149: --
1150: pqh_psf_bus.pqh_poei_validate(p_rec.position_id,
1151: p_rec.position_extra_info_id, p_rec.poei_information5,
1152: fnd_date.canonical_to_date(p_rec.poei_information3),
1153: fnd_date.canonical_to_date(p_rec.poei_information4) , p_rec.poei_information6);
1154: --
1155: elsif (p_rec.information_type = 'PER_FAMILY') then
1156: -- Validate Position Family for Position Extra Info
1157: chk_position_family(l_position_rec.work_period_type_cd, p_rec);