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 69: and trunc(fnd_timezones_pvt.adjust_datetime(p_labor_start_time,

65: END IF;
66: If p_labor_start_time IS NOT NULL
67: and l_date_val in ('N','P')
68: and p_labor_start_time <> FND_API.g_miss_date
69: and trunc(fnd_timezones_pvt.adjust_datetime(p_labor_start_time,
70: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
71: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
72: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
73: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),

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

66: If p_labor_start_time IS NOT NULL
67: and l_date_val in ('N','P')
68: and p_labor_start_time <> FND_API.g_miss_date
69: and trunc(fnd_timezones_pvt.adjust_datetime(p_labor_start_time,
70: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
71: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
72: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
73: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
74: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN

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

67: and l_date_val in ('N','P')
68: and p_labor_start_time <> FND_API.g_miss_date
69: and trunc(fnd_timezones_pvt.adjust_datetime(p_labor_start_time,
70: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
71: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
72: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
73: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
74: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
75: X_Return_Status := FND_API.G_RET_STS_ERROR;

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

68: and p_labor_start_time <> FND_API.g_miss_date
69: and trunc(fnd_timezones_pvt.adjust_datetime(p_labor_start_time,
70: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
71: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
72: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
73: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
74: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
75: X_Return_Status := FND_API.G_RET_STS_ERROR;
76: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

69: and trunc(fnd_timezones_pvt.adjust_datetime(p_labor_start_time,
70: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
71: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
72: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
73: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
74: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
75: X_Return_Status := FND_API.G_RET_STS_ERROR;
76: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
77: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE');

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

70: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
71: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
72: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
73: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
74: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
75: X_Return_Status := FND_API.G_RET_STS_ERROR;
76: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
77: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE');
78: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,

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

74: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
75: X_Return_Status := FND_API.G_RET_STS_ERROR;
76: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
77: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE');
78: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
79: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
80: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
81: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
82: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),

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

75: X_Return_Status := FND_API.G_RET_STS_ERROR;
76: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
77: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE');
78: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
79: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
80: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
81: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
82: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
83: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');

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

76: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
77: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE');
78: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
79: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
80: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
81: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
82: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
83: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
84: FND_MSG_PUB.ADD;

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

77: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE');
78: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
79: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
80: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
81: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
82: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
83: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
84: FND_MSG_PUB.ADD;
85: END IF;

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

78: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
79: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
80: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
81: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
82: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
83: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
84: FND_MSG_PUB.ADD;
85: END IF;
86: END IF;

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

79: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
80: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
81: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
82: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
83: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
84: FND_MSG_PUB.ADD;
85: END IF;
86: END IF;
87: If p_labor_end_time IS NOT NULL

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

86: END IF;
87: If p_labor_end_time IS NOT NULL
88: and l_date_val in ('N','P')
89: and p_labor_end_time <> FND_API.g_miss_date
90: and trunc(fnd_timezones_pvt.adjust_datetime(p_labor_end_time,
91: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
92: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
93: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
94: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),

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

87: If p_labor_end_time IS NOT NULL
88: and l_date_val in ('N','P')
89: and p_labor_end_time <> FND_API.g_miss_date
90: and trunc(fnd_timezones_pvt.adjust_datetime(p_labor_end_time,
91: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
92: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
93: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
94: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
95: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN

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

88: and l_date_val in ('N','P')
89: and p_labor_end_time <> FND_API.g_miss_date
90: and trunc(fnd_timezones_pvt.adjust_datetime(p_labor_end_time,
91: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
92: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
93: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
94: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
95: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
96: X_Return_Status := FND_API.G_RET_STS_ERROR;

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

89: and p_labor_end_time <> FND_API.g_miss_date
90: and trunc(fnd_timezones_pvt.adjust_datetime(p_labor_end_time,
91: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
92: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
93: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
94: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
95: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
96: X_Return_Status := FND_API.G_RET_STS_ERROR;
97: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

90: and trunc(fnd_timezones_pvt.adjust_datetime(p_labor_end_time,
91: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
92: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
93: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
94: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
95: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
96: X_Return_Status := FND_API.G_RET_STS_ERROR;
97: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
98: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE_END');

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

91: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
92: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
93: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
94: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
95: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
96: X_Return_Status := FND_API.G_RET_STS_ERROR;
97: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
98: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE_END');
99: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,

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

95: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
96: X_Return_Status := FND_API.G_RET_STS_ERROR;
97: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
98: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE_END');
99: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
100: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
101: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
102: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
103: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),

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

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

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

97: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
98: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE_END');
99: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
100: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
101: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
102: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
103: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
104: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
105: FND_MSG_PUB.ADD;

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

98: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE_END');
99: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
100: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
101: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
102: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
103: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
104: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
105: FND_MSG_PUB.ADD;
106: END IF;

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

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

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

100: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
101: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
102: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
103: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
104: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
105: FND_MSG_PUB.ADD;
106: END IF;
107: END IF;
108:

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

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

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

113: X_Return_Status := FND_API.G_RET_STS_ERROR;
114: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
115: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE');
116: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
117: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
118: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
119: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
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')||' 23:59');

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

114: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
115: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE');
116: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
117: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
118: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
119: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
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')||' 23:59');
122: FND_MSG_PUB.ADD;

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

115: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE');
116: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
117: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
118: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
119: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
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')||' 23:59');
122: FND_MSG_PUB.ADD;
123: END IF;

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

116: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
117: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
118: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
119: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
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')||' 23:59');
122: FND_MSG_PUB.ADD;
123: END IF;
124: END IF;

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

117: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
118: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
119: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
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')||' 23:59');
122: FND_MSG_PUB.ADD;
123: END IF;
124: END IF;
125: If (p_labor_end_time IS NOT NULL

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

128: and p_labor_end_time < l_service_request_date) THEN
129: X_Return_Status := FND_API.G_RET_STS_ERROR;
130: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
131: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE_END');
132: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
133: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
134: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
135: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
136: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),

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

129: X_Return_Status := FND_API.G_RET_STS_ERROR;
130: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
131: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE_END');
132: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
133: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
134: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
135: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
136: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
137: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');

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

130: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
131: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE_END');
132: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
133: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
134: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
135: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
136: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
137: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
138: FND_MSG_PUB.ADD;

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

131: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE_END');
132: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
133: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
134: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
135: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
136: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
137: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
138: FND_MSG_PUB.ADD;
139: END IF;

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

132: fnd_message.set_token('P_SR_DATE',to_char(fnd_timezones_pvt.adjust_datetime(l_service_request_date,
133: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
134: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
135: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
136: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
137: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
138: FND_MSG_PUB.ADD;
139: END IF;
140: END IF;

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

133: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
134: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID'))),'DD-Mon-RRRR HH24:MI'));
135: fnd_message.set_token('P_SYSTEM_DATE',to_char(trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
136: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')),
137: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')))),'DD-Mon-RRRR')||' 23:59');
138: FND_MSG_PUB.ADD;
139: END IF;
140: END IF;
141: END;

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

4290: END IF;
4291:
4292: If p_actual_travel_start_time IS NOT NULL
4293: and p_actual_travel_start_time <> FND_API.g_miss_date
4294: and trunc(fnd_timezones_pvt.adjust_datetime(p_actual_travel_start_time,
4295: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
4296: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
4297: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
4298: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),

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

4291:
4292: If p_actual_travel_start_time IS NOT NULL
4293: and p_actual_travel_start_time <> FND_API.g_miss_date
4294: and trunc(fnd_timezones_pvt.adjust_datetime(p_actual_travel_start_time,
4295: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
4296: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
4297: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
4298: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
4299: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN

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

4292: If p_actual_travel_start_time IS NOT NULL
4293: and p_actual_travel_start_time <> FND_API.g_miss_date
4294: and trunc(fnd_timezones_pvt.adjust_datetime(p_actual_travel_start_time,
4295: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
4296: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
4297: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
4298: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
4299: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
4300: X_Return_Status := FND_API.G_RET_STS_ERROR;

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

4293: and p_actual_travel_start_time <> FND_API.g_miss_date
4294: and trunc(fnd_timezones_pvt.adjust_datetime(p_actual_travel_start_time,
4295: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
4296: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
4297: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
4298: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
4299: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
4300: X_Return_Status := FND_API.G_RET_STS_ERROR;
4301: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

4294: and trunc(fnd_timezones_pvt.adjust_datetime(p_actual_travel_start_time,
4295: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
4296: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
4297: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
4298: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
4299: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
4300: X_Return_Status := FND_API.G_RET_STS_ERROR;
4301: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4302: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_START_CURR_DATE');

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

4295: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
4296: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
4297: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
4298: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
4299: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
4300: X_Return_Status := FND_API.G_RET_STS_ERROR;
4301: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4302: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_START_CURR_DATE');
4303: FND_MSG_PUB.ADD;

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

4304: END IF;
4305: END IF;
4306: If p_actual_travel_end_time IS NOT NULL
4307: and p_actual_travel_end_time <> FND_API.g_miss_date
4308: and trunc(fnd_timezones_pvt.adjust_datetime(p_actual_travel_end_time,
4309: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
4310: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
4311: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
4312: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),

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

4305: END IF;
4306: If p_actual_travel_end_time IS NOT NULL
4307: and p_actual_travel_end_time <> FND_API.g_miss_date
4308: and trunc(fnd_timezones_pvt.adjust_datetime(p_actual_travel_end_time,
4309: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
4310: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
4311: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
4312: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
4313: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN

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

4306: If p_actual_travel_end_time IS NOT NULL
4307: and p_actual_travel_end_time <> FND_API.g_miss_date
4308: and trunc(fnd_timezones_pvt.adjust_datetime(p_actual_travel_end_time,
4309: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
4310: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
4311: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
4312: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
4313: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
4314: X_Return_Status := FND_API.G_RET_STS_ERROR;

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

4307: and p_actual_travel_end_time <> FND_API.g_miss_date
4308: and trunc(fnd_timezones_pvt.adjust_datetime(p_actual_travel_end_time,
4309: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
4310: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
4311: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
4312: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
4313: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
4314: X_Return_Status := FND_API.G_RET_STS_ERROR;
4315: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

4308: and trunc(fnd_timezones_pvt.adjust_datetime(p_actual_travel_end_time,
4309: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
4310: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
4311: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
4312: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
4313: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
4314: X_Return_Status := FND_API.G_RET_STS_ERROR;
4315: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4316: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_END_CURR_DATE');

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

4309: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
4310: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID'))))
4311: > trunc(fnd_timezones_pvt.adjust_datetime(sysdate,
4312: fnd_timezones.get_code(fnd_profile.value('SERVER_TIMEZONE_ID')),
4313: fnd_timezones.get_code(fnd_profile.value('CLIENT_TIMEZONE_ID')))) THEN
4314: X_Return_Status := FND_API.G_RET_STS_ERROR;
4315: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4316: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_END_CURR_DATE');
4317: FND_MSG_PUB.ADD;