eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSF_DEBRIEF_PVT dependencies on FND_TIMEZONES

Line 59: and trunc(fnd_timezones_pvt.adjust_datetime(p_labor_start_time,

55: END IF;
56: END IF;
57: If p_labor_start_time IS NOT NULL
58: and p_labor_start_time <> FND_API.g_miss_date
59: and trunc(fnd_timezones_pvt.adjust_datetime(p_labor_start_time,
60: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
61: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
62: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
63: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),

Line 60: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),

56: END IF;
57: If p_labor_start_time IS NOT NULL
58: and p_labor_start_time <> FND_API.g_miss_date
59: and trunc(fnd_timezones_pvt.adjust_datetime(p_labor_start_time,
60: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
61: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
62: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
63: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
64: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN

Line 61: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))

57: If p_labor_start_time IS NOT NULL
58: and p_labor_start_time <> FND_API.g_miss_date
59: and trunc(fnd_timezones_pvt.adjust_datetime(p_labor_start_time,
60: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
61: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
62: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
63: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
64: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
65: X_Return_Status := FND_API.G_RET_STS_ERROR;

Line 62: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,

58: and p_labor_start_time <> FND_API.g_miss_date
59: and trunc(fnd_timezones_pvt.adjust_datetime(p_labor_start_time,
60: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
61: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
62: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
63: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
64: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
65: X_Return_Status := FND_API.G_RET_STS_ERROR;
66: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 63: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),

59: and trunc(fnd_timezones_pvt.adjust_datetime(p_labor_start_time,
60: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
61: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
62: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
63: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
64: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
65: X_Return_Status := FND_API.G_RET_STS_ERROR;
66: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
67: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE');

Line 64: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN

60: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
61: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
62: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
63: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
64: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
65: X_Return_Status := FND_API.G_RET_STS_ERROR;
66: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
67: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE');
68: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,

Line 68: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,

64: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
65: X_Return_Status := FND_API.G_RET_STS_ERROR;
66: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
67: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE');
68: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
69: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
70: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
71: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
72: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),

Line 69: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),

65: X_Return_Status := FND_API.G_RET_STS_ERROR;
66: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
67: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE');
68: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
69: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
70: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
71: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
72: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
73: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');

Line 70: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));

66: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
67: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE');
68: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
69: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
70: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
71: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
72: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
73: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
74: FND_MSG_PUB.ADD;

Line 71: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,

67: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE');
68: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
69: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
70: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
71: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
72: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
73: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
74: FND_MSG_PUB.ADD;
75: END IF;

Line 72: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),

68: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
69: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
70: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
71: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
72: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
73: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
74: FND_MSG_PUB.ADD;
75: END IF;
76: END IF;

Line 73: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');

69: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
70: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
71: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
72: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
73: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
74: FND_MSG_PUB.ADD;
75: END IF;
76: END IF;
77: If p_labor_end_time IS NOT NULL

Line 79: and trunc(fnd_timezones_pvt.adjust_datetime(p_labor_end_time,

75: END IF;
76: END IF;
77: If p_labor_end_time IS NOT NULL
78: and p_labor_end_time <> FND_API.g_miss_date
79: and trunc(fnd_timezones_pvt.adjust_datetime(p_labor_end_time,
80: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
81: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))))
82: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
83: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),

Line 80: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),

76: END IF;
77: If p_labor_end_time IS NOT NULL
78: and p_labor_end_time <> FND_API.g_miss_date
79: and trunc(fnd_timezones_pvt.adjust_datetime(p_labor_end_time,
80: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
81: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))))
82: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
83: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
84: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))) THEN

Line 81: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))))

77: If p_labor_end_time IS NOT NULL
78: and p_labor_end_time <> FND_API.g_miss_date
79: and trunc(fnd_timezones_pvt.adjust_datetime(p_labor_end_time,
80: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
81: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))))
82: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
83: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
84: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))) THEN
85: X_Return_Status := FND_API.G_RET_STS_ERROR;

Line 82: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,

78: and p_labor_end_time <> FND_API.g_miss_date
79: and trunc(fnd_timezones_pvt.adjust_datetime(p_labor_end_time,
80: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
81: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))))
82: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
83: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
84: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))) THEN
85: X_Return_Status := FND_API.G_RET_STS_ERROR;
86: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 83: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),

79: and trunc(fnd_timezones_pvt.adjust_datetime(p_labor_end_time,
80: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
81: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))))
82: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
83: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
84: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))) THEN
85: X_Return_Status := FND_API.G_RET_STS_ERROR;
86: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
87: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE_END');

Line 84: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))) THEN

80: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
81: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))))
82: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
83: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
84: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))) THEN
85: X_Return_Status := FND_API.G_RET_STS_ERROR;
86: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
87: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE_END');
88: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,

Line 88: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,

84: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))) THEN
85: X_Return_Status := FND_API.G_RET_STS_ERROR;
86: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
87: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE_END');
88: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
89: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
90: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
91: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
92: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),

Line 89: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),

85: X_Return_Status := FND_API.G_RET_STS_ERROR;
86: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
87: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE_END');
88: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
89: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
90: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
91: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
92: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
93: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');

Line 90: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));

86: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
87: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE_END');
88: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
89: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
90: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
91: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
92: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
93: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
94: FND_MSG_PUB.ADD;

Line 91: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,

87: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE_END');
88: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
89: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
90: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
91: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
92: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
93: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
94: FND_MSG_PUB.ADD;
95: END IF;

Line 92: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),

88: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
89: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
90: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
91: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
92: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
93: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
94: FND_MSG_PUB.ADD;
95: END IF;
96: END IF;

Line 93: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');

89: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
90: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
91: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
92: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
93: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
94: FND_MSG_PUB.ADD;
95: END IF;
96: END IF;
97:

Line 104: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,

100: and p_labor_start_time < l_service_request_date) THEN
101: X_Return_Status := FND_API.G_RET_STS_ERROR;
102: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
103: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE');
104: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
105: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
106: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
107: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
108: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),

Line 105: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),

101: X_Return_Status := FND_API.G_RET_STS_ERROR;
102: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
103: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE');
104: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
105: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
106: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
107: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
108: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
109: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');

Line 106: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));

102: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
103: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE');
104: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
105: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
106: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
107: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
108: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
109: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
110: FND_MSG_PUB.ADD;

Line 107: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,

103: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE');
104: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
105: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
106: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
107: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
108: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
109: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
110: FND_MSG_PUB.ADD;
111: END IF;

Line 108: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),

104: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
105: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
106: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
107: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
108: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
109: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
110: FND_MSG_PUB.ADD;
111: END IF;
112: END IF;

Line 109: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');

105: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
106: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
107: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
108: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
109: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
110: FND_MSG_PUB.ADD;
111: END IF;
112: END IF;
113: If (p_labor_end_time IS NOT NULL

Line 119: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,

115: and p_labor_end_time < l_service_request_date) THEN
116: X_Return_Status := FND_API.G_RET_STS_ERROR;
117: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
118: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE_END');
119: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
120: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
121: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
122: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
123: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),

Line 120: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),

116: X_Return_Status := FND_API.G_RET_STS_ERROR;
117: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
118: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE_END');
119: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
120: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
121: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
122: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
123: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
124: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');

Line 121: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));

117: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
118: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE_END');
119: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
120: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
121: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
122: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
123: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
124: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
125: FND_MSG_PUB.ADD;

Line 122: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,

118: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE_END');
119: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
120: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
121: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
122: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
123: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
124: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
125: FND_MSG_PUB.ADD;
126: END IF;

Line 123: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),

119: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
120: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
121: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
122: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
123: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
124: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
125: FND_MSG_PUB.ADD;
126: END IF;
127: END IF;

Line 124: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');

120: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
121: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
122: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
123: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
124: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
125: FND_MSG_PUB.ADD;
126: END IF;
127: END IF;
128: END;

Line 3850: and trunc(fnd_timezones_pvt.adjust_datetime(p_actual_travel_start_time,

3846: END IF;
3847:
3848: If p_actual_travel_start_time IS NOT NULL
3849: and p_actual_travel_start_time <> FND_API.g_miss_date
3850: and trunc(fnd_timezones_pvt.adjust_datetime(p_actual_travel_start_time,
3851: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
3852: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
3853: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
3854: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),

Line 3851: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),

3847:
3848: If p_actual_travel_start_time IS NOT NULL
3849: and p_actual_travel_start_time <> FND_API.g_miss_date
3850: and trunc(fnd_timezones_pvt.adjust_datetime(p_actual_travel_start_time,
3851: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
3852: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
3853: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
3854: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
3855: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN

Line 3852: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))

3848: If p_actual_travel_start_time IS NOT NULL
3849: and p_actual_travel_start_time <> FND_API.g_miss_date
3850: and trunc(fnd_timezones_pvt.adjust_datetime(p_actual_travel_start_time,
3851: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
3852: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
3853: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
3854: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
3855: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
3856: X_Return_Status := FND_API.G_RET_STS_ERROR;

Line 3853: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,

3849: and p_actual_travel_start_time <> FND_API.g_miss_date
3850: and trunc(fnd_timezones_pvt.adjust_datetime(p_actual_travel_start_time,
3851: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
3852: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
3853: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
3854: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
3855: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
3856: X_Return_Status := FND_API.G_RET_STS_ERROR;
3857: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 3854: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),

3850: and trunc(fnd_timezones_pvt.adjust_datetime(p_actual_travel_start_time,
3851: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
3852: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
3853: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
3854: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
3855: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
3856: X_Return_Status := FND_API.G_RET_STS_ERROR;
3857: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3858: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_START_CURR_DATE');

Line 3855: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN

3851: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
3852: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
3853: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
3854: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
3855: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
3856: X_Return_Status := FND_API.G_RET_STS_ERROR;
3857: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3858: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_START_CURR_DATE');
3859: FND_MSG_PUB.ADD;

Line 3864: and trunc(fnd_timezones_pvt.adjust_datetime(p_actual_travel_end_time,

3860: END IF;
3861: END IF;
3862: If p_actual_travel_end_time IS NOT NULL
3863: and p_actual_travel_end_time <> FND_API.g_miss_date
3864: and trunc(fnd_timezones_pvt.adjust_datetime(p_actual_travel_end_time,
3865: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
3866: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
3867: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
3868: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),

Line 3865: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),

3861: END IF;
3862: If p_actual_travel_end_time IS NOT NULL
3863: and p_actual_travel_end_time <> FND_API.g_miss_date
3864: and trunc(fnd_timezones_pvt.adjust_datetime(p_actual_travel_end_time,
3865: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
3866: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
3867: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
3868: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
3869: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN

Line 3866: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))

3862: If p_actual_travel_end_time IS NOT NULL
3863: and p_actual_travel_end_time <> FND_API.g_miss_date
3864: and trunc(fnd_timezones_pvt.adjust_datetime(p_actual_travel_end_time,
3865: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
3866: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
3867: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
3868: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
3869: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
3870: X_Return_Status := FND_API.G_RET_STS_ERROR;

Line 3867: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,

3863: and p_actual_travel_end_time <> FND_API.g_miss_date
3864: and trunc(fnd_timezones_pvt.adjust_datetime(p_actual_travel_end_time,
3865: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
3866: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
3867: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
3868: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
3869: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
3870: X_Return_Status := FND_API.G_RET_STS_ERROR;
3871: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 3868: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),

3864: and trunc(fnd_timezones_pvt.adjust_datetime(p_actual_travel_end_time,
3865: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
3866: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
3867: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
3868: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
3869: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
3870: X_Return_Status := FND_API.G_RET_STS_ERROR;
3871: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3872: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_END_CURR_DATE');

Line 3869: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN

3865: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
3866: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
3867: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
3868: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
3869: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
3870: X_Return_Status := FND_API.G_RET_STS_ERROR;
3871: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3872: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_END_CURR_DATE');
3873: FND_MSG_PUB.ADD;