APPS.PER_RO_AEI_INFO dependencies on FND_DATE

Line 50: hr_utility.set_location('Contract Signed date=> ' || fnd_date.canonical_to_date(p_aei_information1), 20);

46: end if;
47:
48: close csr_get_contract_id;
49:
50: hr_utility.set_location('Contract Signed date=> ' || fnd_date.canonical_to_date(p_aei_information1), 20);
51: hr_utility.set_location('Assignment Start Date=> ' || l_assignment_start_date , 30);
52: hr_utility.set_location('Contract_id=> ' || l_contract_id, 40);
53: -- date of signing the contract should be atleast 1 day less than the assignment start date
54: if fnd_date.canonical_to_date(p_aei_information1) >= l_assignment_start_date then

Line 54: if fnd_date.canonical_to_date(p_aei_information1) >= l_assignment_start_date then

50: hr_utility.set_location('Contract Signed date=> ' || fnd_date.canonical_to_date(p_aei_information1), 20);
51: hr_utility.set_location('Assignment Start Date=> ' || l_assignment_start_date , 30);
52: hr_utility.set_location('Contract_id=> ' || l_contract_id, 40);
53: -- date of signing the contract should be atleast 1 day less than the assignment start date
54: if fnd_date.canonical_to_date(p_aei_information1) >= l_assignment_start_date then
55: hr_utility.set_message('800','HR_520042_INV_CONRACT_SIGND_DT');
56: hr_utility.raise_error;
57: end if;
58:

Line 67: if fnd_date.canonical_to_date(P_AEI_INFORMATION1) > l_contract_start_date then

63: close csr_contract_start_date;
64: hr_utility.set_location('Contract Start Date=> ' || l_contract_start_date, 30);
65:
66: --contarct start date should not be less than the contract signing date
67: if fnd_date.canonical_to_date(P_AEI_INFORMATION1) > l_contract_start_date then
68: hr_utility.set_message('800','HR_520043_INV_CONRACT_SIGND_DT');
69: hr_utility.raise_error;
70: end if;
71: end if;