DBA Data[Home] [Help]

APPS.CSFW_DEBRIEF_PUB dependencies on CSFW_TIMEZONE_PUB

Line 348: FND_MESSAGE.Set_Token('P_SR_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(l_sr_date), l_dt_format||' HH24:MI'));

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;

Line 349: FND_MESSAGE.Set_Token('P_SYSTEM_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), l_dt_format||' HH24:MI'));

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:

Line 364: FND_MESSAGE.Set_Token('P_SR_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(l_sr_date), l_dt_format||' HH24:MI'));

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;

Line 365: FND_MESSAGE.Set_Token('P_SYSTEM_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), l_dt_format||' HH24:MI'));

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:

Line 2120: if(to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), l_dt_format) = l_serviceDate)

2116:
2117: -- bug # 5351199
2118: -- Save service line with 23:59 time
2119: -- bug # 5519603
2120: if(to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), l_dt_format) = l_serviceDate)
2121: then
2122: lp_servicedate := to_date(l_serviceDate || ' ' || to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), 'HH24:MI'), l_dt_format || ' HH24:MI');
2123: else
2124: lp_servicedate := to_date(l_serviceDate || ' 23:59', l_dt_format || ' HH24:MI');

Line 2122: lp_servicedate := to_date(l_serviceDate || ' ' || to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), 'HH24:MI'), l_dt_format || ' HH24:MI');

2118: -- Save service line with 23:59 time
2119: -- bug # 5519603
2120: if(to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), l_dt_format) = l_serviceDate)
2121: then
2122: lp_servicedate := to_date(l_serviceDate || ' ' || to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), 'HH24:MI'), l_dt_format || ' HH24:MI');
2123: else
2124: lp_servicedate := to_date(l_serviceDate || ' 23:59', l_dt_format || ' HH24:MI');
2125: end if;
2126: -- add the return date

Line 2145: FND_MESSAGE.Set_Token('P_SR_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(l_sr_date), l_dt_format||' HH24:MI'));

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;

Line 2146: FND_MESSAGE.Set_Token('P_SYSTEM_DATE', to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), l_dt_format||' HH24:MI'));

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;