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.HR_NO_VALIDATE_PKG dependencies on FND_DATE

Line 306: AND ( (fnd_date.canonical_to_date(hoi.org_information1) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)

302: FROM hr_organization_information hoi
303: WHERE hoi.organization_id = p_organization_id
304: AND hoi.org_information_context = 'NO_PENSION_PROVIDER'
305: AND hoi.org_information3 = p_org_information3
306: AND ( (fnd_date.canonical_to_date(hoi.org_information1) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
307: AND fnd_date.canonical_to_date(hoi.org_information2) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
308: )
309: OR fnd_date.canonical_to_date(hoi.org_information1) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
310: OR fnd_date.canonical_to_date(hoi.org_information2) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)

Line 307: AND fnd_date.canonical_to_date(hoi.org_information2) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)

303: WHERE hoi.organization_id = p_organization_id
304: AND hoi.org_information_context = 'NO_PENSION_PROVIDER'
305: AND hoi.org_information3 = p_org_information3
306: AND ( (fnd_date.canonical_to_date(hoi.org_information1) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
307: AND fnd_date.canonical_to_date(hoi.org_information2) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
308: )
309: OR fnd_date.canonical_to_date(hoi.org_information1) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
310: OR fnd_date.canonical_to_date(hoi.org_information2) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
311: OR (fnd_date.canonical_to_date(p_org_information1) BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND fnd_date.canonical_to_date(hoi.org_information2)

Line 309: OR fnd_date.canonical_to_date(hoi.org_information1) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)

305: AND hoi.org_information3 = p_org_information3
306: AND ( (fnd_date.canonical_to_date(hoi.org_information1) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
307: AND fnd_date.canonical_to_date(hoi.org_information2) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
308: )
309: OR fnd_date.canonical_to_date(hoi.org_information1) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
310: OR fnd_date.canonical_to_date(hoi.org_information2) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
311: OR (fnd_date.canonical_to_date(p_org_information1) BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND fnd_date.canonical_to_date(hoi.org_information2)
312: AND fnd_date.canonical_to_date(p_org_information2) BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND fnd_date.canonical_to_date(hoi.org_information2)
313: )

Line 310: OR fnd_date.canonical_to_date(hoi.org_information2) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)

306: AND ( (fnd_date.canonical_to_date(hoi.org_information1) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
307: AND fnd_date.canonical_to_date(hoi.org_information2) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
308: )
309: OR fnd_date.canonical_to_date(hoi.org_information1) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
310: OR fnd_date.canonical_to_date(hoi.org_information2) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
311: OR (fnd_date.canonical_to_date(p_org_information1) BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND fnd_date.canonical_to_date(hoi.org_information2)
312: AND fnd_date.canonical_to_date(p_org_information2) BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND fnd_date.canonical_to_date(hoi.org_information2)
313: )
314: );

Line 311: OR (fnd_date.canonical_to_date(p_org_information1) BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND fnd_date.canonical_to_date(hoi.org_information2)

307: AND fnd_date.canonical_to_date(hoi.org_information2) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
308: )
309: OR fnd_date.canonical_to_date(hoi.org_information1) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
310: OR fnd_date.canonical_to_date(hoi.org_information2) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
311: OR (fnd_date.canonical_to_date(p_org_information1) BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND fnd_date.canonical_to_date(hoi.org_information2)
312: AND fnd_date.canonical_to_date(p_org_information2) BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND fnd_date.canonical_to_date(hoi.org_information2)
313: )
314: );
315:

Line 312: AND fnd_date.canonical_to_date(p_org_information2) BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND fnd_date.canonical_to_date(hoi.org_information2)

308: )
309: OR fnd_date.canonical_to_date(hoi.org_information1) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
310: OR fnd_date.canonical_to_date(hoi.org_information2) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
311: OR (fnd_date.canonical_to_date(p_org_information1) BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND fnd_date.canonical_to_date(hoi.org_information2)
312: AND fnd_date.canonical_to_date(p_org_information2) BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND fnd_date.canonical_to_date(hoi.org_information2)
313: )
314: );
315:
316: l_csr_pension_type_record csr_pension_type_chk%ROWTYPE;

Line 391: SELECT fnd_date.canonical_to_date(p_org_information2) INTO l_curr_start_date FROM DUAL ;

387: -- Bug Fix 4463101 : check for ORG_INFORMATION_CONTEXT
388: ELSIF p_org_info_type_code = 'NO_NI_EXEMPTION_LIMIT' THEN
389:
390: -- converting ORG_INFORMATION1 and 2 into dates
391: SELECT fnd_date.canonical_to_date(p_org_information2) INTO l_curr_start_date FROM DUAL ;
392: SELECT fnd_date.canonical_to_date(p_org_information3) INTO l_curr_end_date FROM DUAL ;
393:
394:
395: -- checking if start date is greater than the end date

Line 392: SELECT fnd_date.canonical_to_date(p_org_information3) INTO l_curr_end_date FROM DUAL ;

388: ELSIF p_org_info_type_code = 'NO_NI_EXEMPTION_LIMIT' THEN
389:
390: -- converting ORG_INFORMATION1 and 2 into dates
391: SELECT fnd_date.canonical_to_date(p_org_information2) INTO l_curr_start_date FROM DUAL ;
392: SELECT fnd_date.canonical_to_date(p_org_information3) INTO l_curr_end_date FROM DUAL ;
393:
394:
395: -- checking if start date is greater than the end date
396: IF (l_curr_start_date > l_curr_end_date )

Line 409: SELECT fnd_date.canonical_to_date(csr_rec.p_org_info2) INTO l_start_date FROM DUAL ;

405: /* -- now checking with other records of exemption limits entered
406: FOR csr_rec IN csr_get_exemption_lim_details ( p_organization_id ) LOOP
407:
408: -- converting ORG_INFORMATION1 and 2 into dates
409: SELECT fnd_date.canonical_to_date(csr_rec.p_org_info2) INTO l_start_date FROM DUAL ;
410: SELECT fnd_date.canonical_to_date(csr_rec.p_org_info3) INTO l_end_date FROM DUAL ;
411:
412: IF (l_curr_start_date BETWEEN l_start_date AND l_end_date ) OR
413: (l_curr_end_date BETWEEN l_start_date AND l_end_date ) OR

Line 410: SELECT fnd_date.canonical_to_date(csr_rec.p_org_info3) INTO l_end_date FROM DUAL ;

406: FOR csr_rec IN csr_get_exemption_lim_details ( p_organization_id ) LOOP
407:
408: -- converting ORG_INFORMATION1 and 2 into dates
409: SELECT fnd_date.canonical_to_date(csr_rec.p_org_info2) INTO l_start_date FROM DUAL ;
410: SELECT fnd_date.canonical_to_date(csr_rec.p_org_info3) INTO l_end_date FROM DUAL ;
411:
412: IF (l_curr_start_date BETWEEN l_start_date AND l_end_date ) OR
413: (l_curr_end_date BETWEEN l_start_date AND l_end_date ) OR
414: (l_start_date BETWEEN l_curr_start_date AND l_curr_end_date ) OR

Line 556: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) then

552: IF p_org_information8 > p_org_information9 THEN
553: fnd_message.set_name('PER','PER_376920_NO_PEN_AGE_LMT_CHK');
554: fnd_message.RAISE_ERROR;
555: END IF;
556: IF fnd_date.canonical_to_date(p_org_information1) > fnd_date.canonical_to_date(p_org_information2) then
557: fnd_message.set_name('PER','PER_376921_NO_PEN_SD_ED_CHK');
558: fnd_message.RAISE_ERROR;
559: END IF;
560: OPEN csr_pension_type_provider_chk;

Line 773: AND ( (fnd_date.canonical_to_date(hoi.org_information1) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)

769: WHERE hoi1.org_information_id = p_org_information_id
770: )
771: AND hoi.org_information_context = 'NO_PENSION_PROVIDER'
772: AND hoi.org_information3 = p_org_information3
773: AND ( (fnd_date.canonical_to_date(hoi.org_information1) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
774: AND fnd_date.canonical_to_date(hoi.org_information2) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
775: )
776: OR fnd_date.canonical_to_date(hoi.org_information1) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
777: OR fnd_date.canonical_to_date(hoi.org_information2) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)

Line 774: AND fnd_date.canonical_to_date(hoi.org_information2) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)

770: )
771: AND hoi.org_information_context = 'NO_PENSION_PROVIDER'
772: AND hoi.org_information3 = p_org_information3
773: AND ( (fnd_date.canonical_to_date(hoi.org_information1) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
774: AND fnd_date.canonical_to_date(hoi.org_information2) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
775: )
776: OR fnd_date.canonical_to_date(hoi.org_information1) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
777: OR fnd_date.canonical_to_date(hoi.org_information2) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
778: OR (fnd_date.canonical_to_date(p_org_information1) BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND fnd_date.canonical_to_date(hoi.org_information2)

Line 776: OR fnd_date.canonical_to_date(hoi.org_information1) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)

772: AND hoi.org_information3 = p_org_information3
773: AND ( (fnd_date.canonical_to_date(hoi.org_information1) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
774: AND fnd_date.canonical_to_date(hoi.org_information2) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
775: )
776: OR fnd_date.canonical_to_date(hoi.org_information1) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
777: OR fnd_date.canonical_to_date(hoi.org_information2) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
778: OR (fnd_date.canonical_to_date(p_org_information1) BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND fnd_date.canonical_to_date(hoi.org_information2)
779: AND fnd_date.canonical_to_date(p_org_information2) BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND fnd_date.canonical_to_date(hoi.org_information2)
780: )

Line 777: OR fnd_date.canonical_to_date(hoi.org_information2) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)

773: AND ( (fnd_date.canonical_to_date(hoi.org_information1) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
774: AND fnd_date.canonical_to_date(hoi.org_information2) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
775: )
776: OR fnd_date.canonical_to_date(hoi.org_information1) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
777: OR fnd_date.canonical_to_date(hoi.org_information2) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
778: OR (fnd_date.canonical_to_date(p_org_information1) BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND fnd_date.canonical_to_date(hoi.org_information2)
779: AND fnd_date.canonical_to_date(p_org_information2) BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND fnd_date.canonical_to_date(hoi.org_information2)
780: )
781: )

Line 778: OR (fnd_date.canonical_to_date(p_org_information1) BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND fnd_date.canonical_to_date(hoi.org_information2)

774: AND fnd_date.canonical_to_date(hoi.org_information2) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
775: )
776: OR fnd_date.canonical_to_date(hoi.org_information1) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
777: OR fnd_date.canonical_to_date(hoi.org_information2) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
778: OR (fnd_date.canonical_to_date(p_org_information1) BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND fnd_date.canonical_to_date(hoi.org_information2)
779: AND fnd_date.canonical_to_date(p_org_information2) BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND fnd_date.canonical_to_date(hoi.org_information2)
780: )
781: )
782: AND ( fnd_date.canonical_to_date(hoi.org_information1) <> fnd_date.canonical_to_date(p_org_information1)

Line 779: AND fnd_date.canonical_to_date(p_org_information2) BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND fnd_date.canonical_to_date(hoi.org_information2)

775: )
776: OR fnd_date.canonical_to_date(hoi.org_information1) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
777: OR fnd_date.canonical_to_date(hoi.org_information2) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)
778: OR (fnd_date.canonical_to_date(p_org_information1) BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND fnd_date.canonical_to_date(hoi.org_information2)
779: AND fnd_date.canonical_to_date(p_org_information2) BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND fnd_date.canonical_to_date(hoi.org_information2)
780: )
781: )
782: AND ( fnd_date.canonical_to_date(hoi.org_information1) <> fnd_date.canonical_to_date(p_org_information1)
783: OR fnd_date.canonical_to_date(hoi.org_information2) <> fnd_date.canonical_to_date(p_org_information2)

Line 782: AND ( fnd_date.canonical_to_date(hoi.org_information1) <> fnd_date.canonical_to_date(p_org_information1)

778: OR (fnd_date.canonical_to_date(p_org_information1) BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND fnd_date.canonical_to_date(hoi.org_information2)
779: AND fnd_date.canonical_to_date(p_org_information2) BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND fnd_date.canonical_to_date(hoi.org_information2)
780: )
781: )
782: AND ( fnd_date.canonical_to_date(hoi.org_information1) <> fnd_date.canonical_to_date(p_org_information1)
783: OR fnd_date.canonical_to_date(hoi.org_information2) <> fnd_date.canonical_to_date(p_org_information2)
784: );
785:
786: l_csr_pension_type_record csr_pension_type_chk%ROWTYPE;

Line 783: OR fnd_date.canonical_to_date(hoi.org_information2) <> fnd_date.canonical_to_date(p_org_information2)

779: AND fnd_date.canonical_to_date(p_org_information2) BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND fnd_date.canonical_to_date(hoi.org_information2)
780: )
781: )
782: AND ( fnd_date.canonical_to_date(hoi.org_information1) <> fnd_date.canonical_to_date(p_org_information1)
783: OR fnd_date.canonical_to_date(hoi.org_information2) <> fnd_date.canonical_to_date(p_org_information2)
784: );
785:
786: l_csr_pension_type_record csr_pension_type_chk%ROWTYPE;
787: l_csr_org_number_record csr_org_number_chk%ROWTYPE;

Line 873: SELECT fnd_date.canonical_to_date(p_org_information2) INTO l_curr_start_date FROM DUAL ;

869: -- Bug Fix 4463101 : check for ORG_INFORMATION_CONTEXT
870: ELSIF p_org_info_type_code = 'NO_NI_EXEMPTION_LIMIT' THEN
871:
872: -- converting ORG_INFORMATION1 and 2 into dates
873: SELECT fnd_date.canonical_to_date(p_org_information2) INTO l_curr_start_date FROM DUAL ;
874: SELECT fnd_date.canonical_to_date(p_org_information3) INTO l_curr_end_date FROM DUAL ;
875:
876:
877: -- checking if start date is greater than the end date

Line 874: SELECT fnd_date.canonical_to_date(p_org_information3) INTO l_curr_end_date FROM DUAL ;

870: ELSIF p_org_info_type_code = 'NO_NI_EXEMPTION_LIMIT' THEN
871:
872: -- converting ORG_INFORMATION1 and 2 into dates
873: SELECT fnd_date.canonical_to_date(p_org_information2) INTO l_curr_start_date FROM DUAL ;
874: SELECT fnd_date.canonical_to_date(p_org_information3) INTO l_curr_end_date FROM DUAL ;
875:
876:
877: -- checking if start date is greater than the end date
878: IF (l_curr_start_date > l_curr_end_date )

Line 891: SELECT fnd_date.canonical_to_date(csr_rec.p_org_info2) INTO l_start_date FROM DUAL ;

887: -- now checking with other records of exemption limits entered
888: FOR csr_rec IN csr_get_exemption_details ( l_organization_id , p_org_information_id ) LOOP
889:
890: -- converting ORG_INFORMATION1 and 2 into dates
891: SELECT fnd_date.canonical_to_date(csr_rec.p_org_info2) INTO l_start_date FROM DUAL ;
892: SELECT fnd_date.canonical_to_date(csr_rec.p_org_info3) INTO l_end_date FROM DUAL ;
893:
894: IF (l_curr_start_date BETWEEN l_start_date AND l_end_date ) OR
895: (l_curr_end_date BETWEEN l_start_date AND l_end_date ) OR

Line 892: SELECT fnd_date.canonical_to_date(csr_rec.p_org_info3) INTO l_end_date FROM DUAL ;

888: FOR csr_rec IN csr_get_exemption_details ( l_organization_id , p_org_information_id ) LOOP
889:
890: -- converting ORG_INFORMATION1 and 2 into dates
891: SELECT fnd_date.canonical_to_date(csr_rec.p_org_info2) INTO l_start_date FROM DUAL ;
892: SELECT fnd_date.canonical_to_date(csr_rec.p_org_info3) INTO l_end_date FROM DUAL ;
893:
894: IF (l_curr_start_date BETWEEN l_start_date AND l_end_date ) OR
895: (l_curr_end_date BETWEEN l_start_date AND l_end_date ) OR
896: (l_start_date BETWEEN l_curr_start_date AND l_curr_end_date ) OR

Line 1045: IF fnd_date.canonical_to_date(l_csr_pen_prov_date_chk.org_information1) > fnd_date.canonical_to_date(l_csr_pen_prov_date_chk.org_information2) THEN

1041: OPEN csr_pension_provider_date_chk;
1042: LOOP
1043: FETCH csr_pension_provider_date_chk INTO l_csr_pen_prov_date_chk;
1044: EXIT WHEN csr_pension_provider_date_chk%NOTFOUND;
1045: IF fnd_date.canonical_to_date(l_csr_pen_prov_date_chk.org_information1) > fnd_date.canonical_to_date(l_csr_pen_prov_date_chk.org_information2) THEN
1046: CLOSE csr_pension_provider_date_chk;
1047: fnd_message.set_name('PER','PER_376921_NO_PEN_SD_ED_CHK');
1048: fnd_message.RAISE_ERROR;
1049: END IF;

Line 1282: IF (fnd_date.canonical_to_date(p_ctr_information1) < p_effective_date) THEN

1278: --
1279: IF p_status = 'A-ACTIVE' THEN
1280: IF (p_ctr_information1 IS NOT NULL AND p_ctr_information_category ='NO') THEN
1281:
1282: IF (fnd_date.canonical_to_date(p_ctr_information1) < p_effective_date) THEN
1283: --
1284: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1285: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','CED'));
1286: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ASD'));

Line 1316: IF (fnd_date.canonical_to_date(p_ctr_information1) < l_active_start_date) THEN

1312: IF (p_ctr_information1 IS NOT NULL AND p_ctr_information_category ='NO') THEN
1313:
1314: l_active_start_date := hr_contract_api.get_active_start_date (p_contract_id,p_effective_date,p_status);
1315:
1316: IF (fnd_date.canonical_to_date(p_ctr_information1) < l_active_start_date) THEN
1317: --
1318: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1319: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','CED'));
1320: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ASD'));

Line 1349: IF (fnd_date.canonical_to_date(p_inc_information1) < p_incident_date)

1345: --
1346: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN
1347: --
1348: IF (p_inc_information1 IS NOT NULL AND p_inc_information_category ='NO' )THEN
1349: IF (fnd_date.canonical_to_date(p_inc_information1) < p_incident_date)
1350: THEN
1351: --
1352: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1353: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','DATE_REPORTED_TO_SSO'));

Line 1361: IF (fnd_date.canonical_to_date(p_inc_information2) < p_incident_date)

1357: END IF;
1358: END IF;
1359:
1360: IF (p_inc_information2 IS NOT NULL AND p_inc_information_category ='NO') THEN
1361: IF (fnd_date.canonical_to_date(p_inc_information2) < p_incident_date)
1362: THEN
1363: --
1364: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1365: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','DATE_REPORTED_TO_LIA'));