343: THEN
344: null;
345: ELSE
346: --convert the Server to Client time zone
347: FND_MESSAGE.Set_Name('CSF', 'CSFW_SERVICE_DATE');
348: FND_MESSAGE.Set_Token('P_SR_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(l_sr_date), l_dt_format||' HH24:MI'));
349: FND_MESSAGE.Set_Token('P_SYSTEM_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), l_dt_format||' HH24:MI'));
350:
351: p_error := -21;
344: null;
345: ELSE
346: --convert the Server to Client time zone
347: FND_MESSAGE.Set_Name('CSF', 'CSFW_SERVICE_DATE');
348: FND_MESSAGE.Set_Token('P_SR_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(l_sr_date), l_dt_format||' HH24:MI'));
349: FND_MESSAGE.Set_Token('P_SYSTEM_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), l_dt_format||' HH24:MI'));
350:
351: p_error := -21;
352: p_error := FND_MESSAGE.Get;
345: ELSE
346: --convert the Server to Client time zone
347: FND_MESSAGE.Set_Name('CSF', 'CSFW_SERVICE_DATE');
348: FND_MESSAGE.Set_Token('P_SR_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(l_sr_date), l_dt_format||' HH24:MI'));
349: FND_MESSAGE.Set_Token('P_SYSTEM_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), l_dt_format||' HH24:MI'));
350:
351: p_error := -21;
352: p_error := FND_MESSAGE.Get;
353:
348: FND_MESSAGE.Set_Token('P_SR_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(l_sr_date), l_dt_format||' HH24:MI'));
349: FND_MESSAGE.Set_Token('P_SYSTEM_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), l_dt_format||' HH24:MI'));
350:
351: p_error := -21;
352: p_error := FND_MESSAGE.Get;
353:
354: RETURN ;
355: END IF;
356:
359: THEN
360: null;
361: ELSE
362: --convert the Server to Client time zone
363: FND_MESSAGE.Set_Name('CSF', 'CSFW_SERVICE_DATE_END');
364: FND_MESSAGE.Set_Token('P_SR_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(l_sr_date), l_dt_format||' HH24:MI'));
365: FND_MESSAGE.Set_Token('P_SYSTEM_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), l_dt_format||' HH24:MI'));
366:
367: p_error := -21;
360: null;
361: ELSE
362: --convert the Server to Client time zone
363: FND_MESSAGE.Set_Name('CSF', 'CSFW_SERVICE_DATE_END');
364: FND_MESSAGE.Set_Token('P_SR_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(l_sr_date), l_dt_format||' HH24:MI'));
365: FND_MESSAGE.Set_Token('P_SYSTEM_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), l_dt_format||' HH24:MI'));
366:
367: p_error := -21;
368: p_error := FND_MESSAGE.Get;
361: ELSE
362: --convert the Server to Client time zone
363: FND_MESSAGE.Set_Name('CSF', 'CSFW_SERVICE_DATE_END');
364: FND_MESSAGE.Set_Token('P_SR_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(l_sr_date), l_dt_format||' HH24:MI'));
365: FND_MESSAGE.Set_Token('P_SYSTEM_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), l_dt_format||' HH24:MI'));
366:
367: p_error := -21;
368: p_error := FND_MESSAGE.Get;
369:
364: FND_MESSAGE.Set_Token('P_SR_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(l_sr_date), l_dt_format||' HH24:MI'));
365: FND_MESSAGE.Set_Token('P_SYSTEM_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), l_dt_format||' HH24:MI'));
366:
367: p_error := -21;
368: p_error := FND_MESSAGE.Get;
369:
370: RETURN ;
371: END IF;
372: */
371: END IF;
372: */
373:
374: IF (p_labor_start_date >= p_labor_end_date) THEN
375: FND_MESSAGE.Set_Name('CSF', 'CSFW_START_END_DATE_SAME');
376: p_error := -30;
377: p_error := FND_MESSAGE.Get;
378: RETURN;
379: END IF;
373:
374: IF (p_labor_start_date >= p_labor_end_date) THEN
375: FND_MESSAGE.Set_Name('CSF', 'CSFW_START_END_DATE_SAME');
376: p_error := -30;
377: p_error := FND_MESSAGE.Get;
378: RETURN;
379: END IF;
380:
381: -- CALL THE VALIDATE FUNCTION
1311: IF p_service_date between l_sr_date and sysdate
1312: THEN
1313: null;
1314: ELSE
1315: FND_MESSAGE.Set_Name('CSF', 'CSFW_SERVICE_DATE');
1316: FND_MESSAGE.Set_Token('P_SR_DATE', to_char(l_sr_date, l_dt_format));
1317: FND_MESSAGE.Set_Token('P_SYSTEM_DATE', to_char(sysdate, l_dt_format));
1318: p_error := -21;
1319: p_error := FND_MESSAGE.Get;
1312: THEN
1313: null;
1314: ELSE
1315: FND_MESSAGE.Set_Name('CSF', 'CSFW_SERVICE_DATE');
1316: FND_MESSAGE.Set_Token('P_SR_DATE', to_char(l_sr_date, l_dt_format));
1317: FND_MESSAGE.Set_Token('P_SYSTEM_DATE', to_char(sysdate, l_dt_format));
1318: p_error := -21;
1319: p_error := FND_MESSAGE.Get;
1320: return;
1313: null;
1314: ELSE
1315: FND_MESSAGE.Set_Name('CSF', 'CSFW_SERVICE_DATE');
1316: FND_MESSAGE.Set_Token('P_SR_DATE', to_char(l_sr_date, l_dt_format));
1317: FND_MESSAGE.Set_Token('P_SYSTEM_DATE', to_char(sysdate, l_dt_format));
1318: p_error := -21;
1319: p_error := FND_MESSAGE.Get;
1320: return;
1321:
1315: FND_MESSAGE.Set_Name('CSF', 'CSFW_SERVICE_DATE');
1316: FND_MESSAGE.Set_Token('P_SR_DATE', to_char(l_sr_date, l_dt_format));
1317: FND_MESSAGE.Set_Token('P_SYSTEM_DATE', to_char(sysdate, l_dt_format));
1318: p_error := -21;
1319: p_error := FND_MESSAGE.Get;
1320: return;
1321:
1322: END IF;
1323: */
1321:
1322: END IF;
1323: */
1324: IF (p_labor_start_date >= p_labor_end_date) THEN
1325: FND_MESSAGE.Set_Name('CSF', 'CSFW_START_END_DATE_SAME');
1326: p_error := -30;
1327: p_error := FND_MESSAGE.Get;
1328: RETURN;
1329: END IF;
1323: */
1324: IF (p_labor_start_date >= p_labor_end_date) THEN
1325: FND_MESSAGE.Set_Name('CSF', 'CSFW_START_END_DATE_SAME');
1326: p_error := -30;
1327: p_error := FND_MESSAGE.Get;
1328: RETURN;
1329: END IF;
1330:
1331: -- CALL THE VALIDATE FUNCTION
2140:
2141: /* check in JSP only
2142: IF lp_servicedate not between l_sr_date and sysdate
2143: THEN
2144: FND_MESSAGE.Set_Name('CSF', 'CSFW_SERVICE_DATE');
2145: FND_MESSAGE.Set_Token('P_SR_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(l_sr_date), l_dt_format||' HH24:MI'));
2146: FND_MESSAGE.Set_Token('P_SYSTEM_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), l_dt_format||' HH24:MI'));
2147:
2148:
2141: /* check in JSP only
2142: IF lp_servicedate not between l_sr_date and sysdate
2143: THEN
2144: FND_MESSAGE.Set_Name('CSF', 'CSFW_SERVICE_DATE');
2145: FND_MESSAGE.Set_Token('P_SR_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(l_sr_date), l_dt_format||' HH24:MI'));
2146: FND_MESSAGE.Set_Token('P_SYSTEM_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), l_dt_format||' HH24:MI'));
2147:
2148:
2149: p_error := -21;
2142: IF lp_servicedate not between l_sr_date and sysdate
2143: THEN
2144: FND_MESSAGE.Set_Name('CSF', 'CSFW_SERVICE_DATE');
2145: FND_MESSAGE.Set_Token('P_SR_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(l_sr_date), l_dt_format||' HH24:MI'));
2146: FND_MESSAGE.Set_Token('P_SYSTEM_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), l_dt_format||' HH24:MI'));
2147:
2148:
2149: p_error := -21;
2150: p_error := FND_MESSAGE.Get;
2146: FND_MESSAGE.Set_Token('P_SYSTEM_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), l_dt_format||' HH24:MI'));
2147:
2148:
2149: p_error := -21;
2150: p_error := FND_MESSAGE.Get;
2151: RETURN ;
2152: END IF;
2153:
2154: */