206: null;
207: ELSE
208: --convert the Server to Client time zone
209: FND_MESSAGE.Set_Name('CSF', 'CSFW_SERVICE_DATE');
210: FND_MESSAGE.Set_Token('P_SR_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(l_sr_date), l_dt_format||' HH24:MI'));
211: FND_MESSAGE.Set_Token('P_SYSTEM_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), l_dt_format||' HH24:MI'));
212:
213: p_error := -21;
214: p_error := FND_MESSAGE.Get;
207: ELSE
208: --convert the Server to Client time zone
209: FND_MESSAGE.Set_Name('CSF', 'CSFW_SERVICE_DATE');
210: FND_MESSAGE.Set_Token('P_SR_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(l_sr_date), l_dt_format||' HH24:MI'));
211: FND_MESSAGE.Set_Token('P_SYSTEM_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), l_dt_format||' HH24:MI'));
212:
213: p_error := -21;
214: p_error := FND_MESSAGE.Get;
215:
222: null;
223: ELSE
224: --convert the Server to Client time zone
225: FND_MESSAGE.Set_Name('CSF', 'CSFW_SERVICE_DATE_END');
226: FND_MESSAGE.Set_Token('P_SR_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(l_sr_date), l_dt_format||' HH24:MI'));
227: FND_MESSAGE.Set_Token('P_SYSTEM_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), l_dt_format||' HH24:MI'));
228:
229: p_error := -21;
230: p_error := FND_MESSAGE.Get;
223: ELSE
224: --convert the Server to Client time zone
225: FND_MESSAGE.Set_Name('CSF', 'CSFW_SERVICE_DATE_END');
226: FND_MESSAGE.Set_Token('P_SR_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(l_sr_date), l_dt_format||' HH24:MI'));
227: FND_MESSAGE.Set_Token('P_SYSTEM_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), l_dt_format||' HH24:MI'));
228:
229: p_error := -21;
230: p_error := FND_MESSAGE.Get;
231:
1300:
1301: -- bug # 5351199
1302: -- Save service line with 23:59 time
1303: -- bug # 5519603
1304: if(to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), l_dt_format) = l_serviceDate)
1305: then
1306: lp_servicedate := to_date(l_serviceDate || ' ' || to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), 'HH24:MI'), l_dt_format || ' HH24:MI');
1307: else
1308: lp_servicedate := to_date(l_serviceDate || ' 23:59', l_dt_format || ' HH24:MI');
1302: -- Save service line with 23:59 time
1303: -- bug # 5519603
1304: if(to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), l_dt_format) = l_serviceDate)
1305: then
1306: lp_servicedate := to_date(l_serviceDate || ' ' || to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), 'HH24:MI'), l_dt_format || ' HH24:MI');
1307: else
1308: lp_servicedate := to_date(l_serviceDate || ' 23:59', l_dt_format || ' HH24:MI');
1309: end if;
1310: -- add the return date
1325: /* check in JSP only
1326: IF lp_servicedate not between l_sr_date and sysdate
1327: THEN
1328: FND_MESSAGE.Set_Name('CSF', 'CSFW_SERVICE_DATE');
1329: FND_MESSAGE.Set_Token('P_SR_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(l_sr_date), l_dt_format||' HH24:MI'));
1330: FND_MESSAGE.Set_Token('P_SYSTEM_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), l_dt_format||' HH24:MI'));
1331:
1332:
1333: p_error := -21;
1326: IF lp_servicedate not between l_sr_date and sysdate
1327: THEN
1328: FND_MESSAGE.Set_Name('CSF', 'CSFW_SERVICE_DATE');
1329: FND_MESSAGE.Set_Token('P_SR_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(l_sr_date), l_dt_format||' HH24:MI'));
1330: FND_MESSAGE.Set_Token('P_SYSTEM_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), l_dt_format||' HH24:MI'));
1331:
1332:
1333: p_error := -21;
1334: p_error := FND_MESSAGE.Get;