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_PROFILE

Line 37: l_date_val varchar2(30) := nvl(fnd_profile.value('CSF_DEBRIEF_SERVICE_DATE'),'B');

33: X_Msg_Count OUT NOCOPY NUMBER,
34: X_Msg_Data OUT NOCOPY VARCHAR2) IS
35:
36: l_service_request_date date;
37: l_date_val varchar2(30) := nvl(fnd_profile.value('CSF_DEBRIEF_SERVICE_DATE'),'B');
38:
39: Cursor get_service_request_date IS
40: select nvl(incident_occurred_date,incident_date)
41: from jtf_task_assignments jta , cs_incidents_all cia, jtf_tasks_b jtb,

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 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 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 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 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 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 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 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 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 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 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 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 356: l_unit_of_measure_for_hr := fnd_profile.value('CSF_UOM_HOURS');

352: l_resource_type_code,
353: l_resource_id;
354: CLOSE c_task_assgin_object_version ;
355:
356: l_unit_of_measure_for_hr := fnd_profile.value('CSF_UOM_HOURS');
357: IF (p_debrief_rec.TRAVEL_START_TIME IS NOT NULL AND p_debrief_rec.TRAVEL_START_TIME <> FND_API.G_MISS_DATE)
358: AND (p_debrief_rec.TRAVEL_END_TIME IS NOT NULL AND p_debrief_rec.TRAVEL_END_TIME <> FND_API.G_MISS_DATE)
359: THEN
360: l_actual_travel_duration := round ((p_debrief_rec.TRAVEL_END_TIME - p_debrief_rec.TRAVEL_START_TIME) * 24,4);

Line 644: l_unit_of_measure_for_hr := fnd_profile.value('CSF_UOM_HOURS');

640: IF (p_debrief_rec.TRAVEL_START_TIME IS NOT NULL AND p_debrief_rec.TRAVEL_START_TIME <> FND_API.G_MISS_DATE)
641: AND (p_debrief_rec.TRAVEL_END_TIME IS NOT NULL AND p_debrief_rec.TRAVEL_END_TIME <> FND_API.G_MISS_DATE)
642: THEN
643: l_actual_travel_duration := round ((p_debrief_rec.TRAVEL_END_TIME - p_debrief_rec.TRAVEL_START_TIME) * 24,4);
644: l_unit_of_measure_for_hr := fnd_profile.value('CSF_UOM_HOURS');
645: END IF;
646:
647:
648: if (p_debrief_rec.TRAVEL_DISTANCE_IN_KM IS NOT NULL AND p_debrief_rec.TRAVEL_DISTANCE_IN_KM<> FND_API.G_MISS_NUM)

Line 852: l_valid_org number := fnd_profile.value('CS_INV_VALIDATION_ORG');

848: Function debrief_type(p_debrief_line_rec debrief_line_rec_type)
849: return varchar2 is
850:
851: l_debrief_type varchar2(3);
852: l_valid_org number := fnd_profile.value('CS_INV_VALIDATION_ORG');
853:
854: cursor c_debrief_type is
855: select billing_category
856: from cs_billing_type_categories cbtc,

Line 988: l_hr_uom varchar2(100) := fnd_profile.value('CSF_UOM_HOURS');

984: xx_labor_end_date date;
985: l_cp_status_id number;
986: l_cp_status varchar2(30);
987: l_return_reason_code varchar2(30) ;
988: l_hr_uom varchar2(100) := fnd_profile.value('CSF_UOM_HOURS');
989: l_quantity number;
990: l_line_order_category_code varchar2(30);
991: l_transaction_type_id number;
992: l_debrief_type varchar2(1);

Line 1206: Then l_return_reason_code := fnd_profile.value('CSF_RETURN_REASON');

1202: --------------------------------------------------------------
1203: if nvl(l_billing_type, fnd_api.g_miss_char) <>'M'
1204: Then l_return_reason_code := fnd_api.g_miss_char;
1205: else if l_line_order_category_code = 'RETURN'
1206: Then l_return_reason_code := fnd_profile.value('CSF_RETURN_REASON');
1207: Else l_return_reason_code := fnd_api.g_miss_char;
1208: End If;
1209: End If;
1210: --------------------------------------------------------------

Line 1257: p_debrief_line_rec.uom_code := fnd_profile.value('CSF_LABOR_DEBRIEF_DEFAULT_UOM');

1253: --we should calculate quantity based on start time and end time
1254:
1255: if nvl(p_debrief_line_rec.uom_code,fnd_api.g_miss_char) = fnd_api.g_miss_char then
1256:
1257: p_debrief_line_rec.uom_code := fnd_profile.value('CSF_LABOR_DEBRIEF_DEFAULT_UOM');
1258: end if;
1259: if nvl(p_DEBRIEF_LINE_rec.quantity,fnd_api.g_miss_num) = fnd_api.g_miss_num then
1260:
1261: l_quantity := (p_debrief_line_rec.LABOR_END_DATE - p_debrief_line_rec.LABOR_START_DATE);

Line 1857: l_hr_uom varchar2(100) := fnd_profile.value('CSF_UOM_HOURS');

1853: IS
1854:
1855: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
1856: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1857: l_hr_uom varchar2(100) := fnd_profile.value('CSF_UOM_HOURS');
1858: l_quantity number;
1859: l_cp_status_id number;
1860: l_cp_status varchar2(30);
1861: l_request_id number;

Line 2110: -- p_debrief_line_rec.uom_code := fnd_profile.value('CSF_LABOR_DEBRIEF_DEFAULT_UOM');

2106: if nvl(p_debrief_line_rec.uom_code,fnd_api.g_miss_char) = fnd_api.g_miss_char then
2107: open c_uom_code;
2108: fetch c_uom_code into l_uom_code;
2109: close c_uom_code;
2110: -- p_debrief_line_rec.uom_code := fnd_profile.value('CSF_LABOR_DEBRIEF_DEFAULT_UOM');
2111: end if;
2112: if nvl(p_DEBRIEF_LINE_rec.quantity,fnd_api.g_miss_num) = fnd_api.g_miss_num then
2113: l_quantity := (p_debrief_line_rec.LABOR_END_DATE - p_debrief_line_rec.LABOR_START_DATE);
2114: if l_uom_code <> l_hr_uom and l_quantity is not null then

Line 2182: p_debrief_line_rec.uom_code := fnd_profile.value('CSF_LABOR_DEBRIEF_DEFAULT_UOM');

2178: raise fnd_api.g_exc_unexpected_error;
2179: end if;
2180: end if;
2181: if nvl(l_uom_code,fnd_api.g_miss_char) = fnd_api.g_miss_char then
2182: p_debrief_line_rec.uom_code := fnd_profile.value('CSF_LABOR_DEBRIEF_DEFAULT_UOM');
2183: end if;
2184: end if;
2185:
2186: ----

Line 2552: where msib.organization_id = nvl(p_organization_id,fnd_profile.value('CS_INV_VALIDATION_ORG'))

2548: l_inventory_item_id number;
2549: cursor c_inventory_item is
2550: select msib.inventory_item_id
2551: from mtl_system_items_b msib,cs_billing_type_categories cbtc
2552: where msib.organization_id = nvl(p_organization_id,fnd_profile.value('CS_INV_VALIDATION_ORG'))
2553: and msib.inventory_item_id = p_inventory_item_id
2554: and msib.material_billable_flag = cbtc.billing_type;
2555:
2556: BEGIN

Line 3223: l_profile varchar2(10) := fnd_profile.value('CSF_DEBRIEF_OVERLAPPING_LABOR');

3219:
3220:
3221: l_labor_start_date date;
3222: l_labor_end_date date;
3223: l_profile varchar2(10) := fnd_profile.value('CSF_DEBRIEF_OVERLAPPING_LABOR');
3224:
3225: cursor c_val is
3226: Select cdh.debrief_number,
3227: cdl.labor_start_date,

Line 3531: fnd_profile.value('CSF_DEFAULT_LABOR_DEBRIEF_DATETIME'));

3527: end if;
3528: end if;
3529:
3530: log('task_assignment_post_update','profile CSF_DEFAULT_LABOR_DEBRIEF_DATETIME'||
3531: fnd_profile.value('CSF_DEFAULT_LABOR_DEBRIEF_DATETIME'));
3532: if fnd_profile.value('CSF_DEFAULT_LABOR_DEBRIEF_DATETIME') = 'STATUS'
3533: and csf_debrief_pub.g_auto_debrief then
3534: open c_travel_exists(l_task_assignment_id);
3535: fetch c_travel_exists into l_travel_exists;

Line 3532: if fnd_profile.value('CSF_DEFAULT_LABOR_DEBRIEF_DATETIME') = 'STATUS'

3528: end if;
3529:
3530: log('task_assignment_post_update','profile CSF_DEFAULT_LABOR_DEBRIEF_DATETIME'||
3531: fnd_profile.value('CSF_DEFAULT_LABOR_DEBRIEF_DATETIME'));
3532: if fnd_profile.value('CSF_DEFAULT_LABOR_DEBRIEF_DATETIME') = 'STATUS'
3533: and csf_debrief_pub.g_auto_debrief then
3534: open c_travel_exists(l_task_assignment_id);
3535: fetch c_travel_exists into l_travel_exists;
3536: log('task_assignment_post_update','l_travel_exists: '||l_travel_exists);

Line 3589: fnd_profile.value('CSF:DEFAULT DEBRIEF BUSINESS PROCESS');

3585:
3586: if l_travel_start_date is not null and l_travel_end_date is not null then
3587: log('task_assignment_post_update','l_record_counter: '||l_record_counter);
3588: l_business_process_id :=
3589: fnd_profile.value('CSF:DEFAULT DEBRIEF BUSINESS PROCESS');
3590: log('task_assignment_post_update','l_business_process_id: '||l_business_process_id);
3591: l_transaction_type_id :=
3592: fnd_profile.value('CSF_DEBRIEF_TRAVEL_SAC');
3593: log('task_assignment_post_update','l_transaction_type_id: '||l_transaction_type_id);

Line 3592: fnd_profile.value('CSF_DEBRIEF_TRAVEL_SAC');

3588: l_business_process_id :=
3589: fnd_profile.value('CSF:DEFAULT DEBRIEF BUSINESS PROCESS');
3590: log('task_assignment_post_update','l_business_process_id: '||l_business_process_id);
3591: l_transaction_type_id :=
3592: fnd_profile.value('CSF_DEBRIEF_TRAVEL_SAC');
3593: log('task_assignment_post_update','l_transaction_type_id: '||l_transaction_type_id);
3594: l_debrief_line(l_record_counter).debrief_header_id := l_debrief_header_id;
3595: l_debrief_line(l_record_counter).service_date := l_travel_end_date;
3596: l_debrief_line(l_record_counter).labor_start_date := l_travel_start_date;

Line 3611: fnd_profile.value('CSF:DEFAULT DEBRIEF BUSINESS PROCESS');

3607: l_record_counter := l_record_counter + 1;
3608: end if;
3609: if l_working_start_date is not null and l_working_end_date is not null then
3610: l_business_process_id :=
3611: fnd_profile.value('CSF:DEFAULT DEBRIEF BUSINESS PROCESS');
3612: log('task_assignment_post_update','l_business_process_id: '||l_business_process_id);
3613: l_transaction_type_id :=
3614: fnd_profile.value('CSF_DEBRIEF_LABOR_SAC');
3615: log('task_assignment_post_update','l_transaction_type_id: '||l_transaction_type_id);

Line 3614: fnd_profile.value('CSF_DEBRIEF_LABOR_SAC');

3610: l_business_process_id :=
3611: fnd_profile.value('CSF:DEFAULT DEBRIEF BUSINESS PROCESS');
3612: log('task_assignment_post_update','l_business_process_id: '||l_business_process_id);
3613: l_transaction_type_id :=
3614: fnd_profile.value('CSF_DEBRIEF_LABOR_SAC');
3615: log('task_assignment_post_update','l_transaction_type_id: '||l_transaction_type_id);
3616: l_debrief_line(l_record_counter).debrief_header_id := l_debrief_header_id;
3617: l_debrief_line(l_record_counter).service_date := l_working_end_date;
3618: l_debrief_line(l_record_counter).labor_start_date := l_working_start_date;

Line 3673: select decode(fnd_profile.value('CSF_DEFAULT_LABOR_DEBRIEF_DATETIME'),

3669: p_task_assignment_id in number)
3670: return varchar2 is
3671:
3672: cursor c_labor_auto_create is
3673: select decode(fnd_profile.value('CSF_DEFAULT_LABOR_DEBRIEF_DATETIME'),
3674: 'STATUS',jtsb.working_flag,'N')
3675: from jtf_task_assignments_audit_b jtaab,
3676: jtf_task_statuses_b jtsb
3677: where jtsb.task_status_id = jtaab.new_assignment_status_id

Line 3985: select fnd_profile.value('CSF_UOM_HOURS')

3981: l_duration_sum number := 0;
3982:
3983:
3984: cursor c_hours_uom is
3985: select fnd_profile.value('CSF_UOM_HOURS')
3986: from dual;
3987:
3988: l_uom varchar2(3);
3989: l_t_uom varchar2(3);

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