600: END IF;
601: ELSE
602: l_return_date := l_transaction_date;
603: END IF;
604: -- l_util_start_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY'); /* commenting for For Bug 7304151 */
605: l_util_start_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY', 'NLS_DATE_LANGUAGE=AMERICAN'); /*Adding For Bug 7304151 */
606: IF( l_util_start_date IS NOT NULL ) THEN
607: IF ( l_util_start_date >= l_return_date ) THEN
608: l_return_date := l_util_start_date ;
601: ELSE
602: l_return_date := l_transaction_date;
603: END IF;
604: -- l_util_start_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY'); /* commenting for For Bug 7304151 */
605: l_util_start_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY', 'NLS_DATE_LANGUAGE=AMERICAN'); /*Adding For Bug 7304151 */
606: IF( l_util_start_date IS NOT NULL ) THEN
607: IF ( l_util_start_date >= l_return_date ) THEN
608: l_return_date := l_util_start_date ;
609: END IF;
631: l_util_start_date DATE;
632:
633: BEGIN
634:
635: -- l_util_start_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY'); /* commenting for For Bug 7304151 */
636: l_util_start_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY', 'NLS_DATE_LANGUAGE=AMERICAN'); /*Adding For Bug 7304151 */
637: IF( l_util_start_date IS NOT NULL ) THEN
638: l_result_date := l_util_start_date ;
639: END IF;
632:
633: BEGIN
634:
635: -- l_util_start_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY'); /* commenting for For Bug 7304151 */
636: l_util_start_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY', 'NLS_DATE_LANGUAGE=AMERICAN'); /*Adding For Bug 7304151 */
637: IF( l_util_start_date IS NOT NULL ) THEN
638: l_result_date := l_util_start_date ;
639: END IF;
640: IF ( l_util_start_date IS NOT NULL ) THEN
919: OPEN l_res_dt_minmax_csr(p_project_id);
920: FETCH l_res_dt_minmax_csr INTO l_res_min_date, l_res_max_date;
921: CLOSE l_res_dt_minmax_csr;
922:
923: x_validate := FND_PROFILE.value('PA_VALIDATE_ASSIGN_DATES');
924: x_start_date_status := 'V';
925: x_end_date_status := 'V';
926:
927: IF NVL(x_validate,'N') in ('Y','W') THEN
1078: p_res_max_date:=l_res_max_date;
1079:
1080:
1081:
1082: x_validate := FND_PROFILE.value('PA_VALIDATE_ASSIGN_DATES');
1083: x_start_date_status := 'V';
1084: x_end_date_status := 'V';
1085:
1086: IF NVL(x_validate,'N') in ('Y','W') THEN
1139: OPEN l_prj_dt_minmax_csr(p_project_id);
1140: FETCH l_prj_dt_minmax_csr INTO l_prj_min_date, l_prj_max_date;
1141: CLOSE l_prj_dt_minmax_csr;
1142:
1143: x_validate := FND_PROFILE.value('PA_VALIDATE_ASSIGN_DATES');
1144: x_start_date_status := 'V';
1145: x_end_date_status := 'V';
1146:
1147: IF NVL(x_validate,'N') in ('Y','W') THEN
1206: BEGIN
1207:
1208:
1209: fnd_msg_pub.initialize;
1210: l_validate := FND_PROFILE.Value('PA_VALIDATE_ASSIGN_DATES'); -- This profile option is for only validating the assignment dates against project dates
1211:
1212: FOR i IN p_project_id_tbl.first .. p_project_id_tbl.last LOOP
1213:
1214: l_validate_tbl(i) := NULL ;
1360: BEGIN
1361:
1362:
1363: fnd_msg_pub.initialize; -- bug 8233045
1364: l_validate := FND_PROFILE.value('PA_VALIDATE_ASSIGN_DATES');
1365:
1366: for i in p_project_id_tbl.first .. p_project_id_tbl.last loop
1367: l_validate_tbl(i) := null;
1368: l_start_date_status_tbl(i) := null;
1533: FETCH get_team_start_date INTO l_team_start_date;
1534: CLOSE get_team_start_date ;
1535: /*Fix for Bug 6856082 ends*/
1536:
1537: l_validate := FND_PROFILE.value('PA_VALIDATE_ASSIGN_DATES');
1538: --l_validate := 'Y';
1539: x_validate := l_validate;
1540: x_start_date_status := 'V';
1541: x_end_date_status := 'V';