DBA Data[Home] [Help]

APPS.CSFW_DEBRIEF_PUB dependencies on CSFW_TIMEZONE_PUB

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

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;

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

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:

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

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;

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

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:

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

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');

Line 1306: lp_servicedate := to_date(l_serviceDate || ' ' || to_char(CSFW_TIMEZONE_PUB.GET_CLIENT_TIME(sysdate), 'HH24:MI'), 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

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

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;

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

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;