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

339: l_resource_type_code,
340: l_resource_id;
341: CLOSE c_task_assgin_object_version ;
342:
343: l_unit_of_measure_for_hr := fnd_profile.value('CSF_UOM_HOURS');
344: IF (p_debrief_rec.TRAVEL_START_TIME IS NOT NULL AND p_debrief_rec.TRAVEL_START_TIME <> FND_API.G_MISS_DATE)
345: AND (p_debrief_rec.TRAVEL_END_TIME IS NOT NULL AND p_debrief_rec.TRAVEL_END_TIME <> FND_API.G_MISS_DATE)
346: THEN
347: l_actual_travel_duration := round ((p_debrief_rec.TRAVEL_END_TIME - p_debrief_rec.TRAVEL_START_TIME) * 24,2);

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

627: IF (p_debrief_rec.TRAVEL_START_TIME IS NOT NULL AND p_debrief_rec.TRAVEL_START_TIME <> FND_API.G_MISS_DATE)
628: AND (p_debrief_rec.TRAVEL_END_TIME IS NOT NULL AND p_debrief_rec.TRAVEL_END_TIME <> FND_API.G_MISS_DATE)
629: THEN
630: l_actual_travel_duration := round ((p_debrief_rec.TRAVEL_END_TIME - p_debrief_rec.TRAVEL_START_TIME) * 24,2);
631: l_unit_of_measure_for_hr := fnd_profile.value('CSF_UOM_HOURS');
632: END IF;
633:
634:
635: 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 839: l_valid_org number := fnd_profile.value('CS_INV_VALIDATION_ORG');

835: Function debrief_type(p_debrief_line_rec debrief_line_rec_type)
836: return varchar2 is
837:
838: l_debrief_type varchar2(3);
839: l_valid_org number := fnd_profile.value('CS_INV_VALIDATION_ORG');
840:
841: cursor c_debrief_type is
842: select billing_category
843: from cs_billing_type_categories cbtc,

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

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

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

1184: --------------------------------------------------------------
1185: if nvl(l_billing_type, fnd_api.g_miss_char) <>'M'
1186: Then l_return_reason_code := fnd_api.g_miss_char;
1187: else if l_line_order_category_code = 'RETURN'
1188: Then l_return_reason_code := fnd_profile.value('CSF_RETURN_REASON');
1189: Else l_return_reason_code := fnd_api.g_miss_char;
1190: End If;
1191: End If;
1192: --------------------------------------------------------------

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

1233: --we should calculate quantity based on start time and end time
1234:
1235: if nvl(p_debrief_line_rec.uom_code,fnd_api.g_miss_char) = fnd_api.g_miss_char then
1236:
1237: p_debrief_line_rec.uom_code := fnd_profile.value('CSF_LABOR_DEBRIEF_DEFAULT_UOM');
1238: end if;
1239: if nvl(p_DEBRIEF_LINE_rec.quantity,fnd_api.g_miss_num) = fnd_api.g_miss_num then
1240:
1241: l_quantity := (p_debrief_line_rec.LABOR_END_DATE - p_debrief_line_rec.LABOR_START_DATE);

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

1800: IS
1801:
1802: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
1803: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1804: l_hr_uom varchar2(100) := fnd_profile.value('CSF_UOM_HOURS');
1805: l_quantity number;
1806: l_cp_status_id number;
1807: l_cp_status varchar2(30);
1808: l_request_id number;

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

2051: if nvl(p_debrief_line_rec.uom_code,fnd_api.g_miss_char) = fnd_api.g_miss_char then
2052: open c_uom_code;
2053: fetch c_uom_code into l_uom_code;
2054: close c_uom_code;
2055: -- p_debrief_line_rec.uom_code := fnd_profile.value('CSF_LABOR_DEBRIEF_DEFAULT_UOM');
2056: end if;
2057: if nvl(p_DEBRIEF_LINE_rec.quantity,fnd_api.g_miss_num) = fnd_api.g_miss_num then
2058: l_quantity := (p_debrief_line_rec.LABOR_END_DATE - p_debrief_line_rec.LABOR_START_DATE);
2059: if l_uom_code <> l_hr_uom and l_quantity is not null then

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

2123: raise fnd_api.g_exc_unexpected_error;
2124: end if;
2125: end if;
2126: if nvl(l_uom_code,fnd_api.g_miss_char) = fnd_api.g_miss_char then
2127: p_debrief_line_rec.uom_code := fnd_profile.value('CSF_LABOR_DEBRIEF_DEFAULT_UOM');
2128: end if;
2129: end if;
2130:
2131: ----

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

2480: l_inventory_item_id number;
2481: cursor c_inventory_item is
2482: select msib.inventory_item_id
2483: from mtl_system_items_b msib,cs_billing_type_categories cbtc
2484: where msib.organization_id = nvl(p_organization_id,fnd_profile.value('CS_INV_VALIDATION_ORG'))
2485: and msib.inventory_item_id = p_inventory_item_id
2486: and msib.material_billable_flag = cbtc.billing_type;
2487:
2488: BEGIN

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

3170:
3171:
3172: l_labor_start_date date;
3173: l_labor_end_date date;
3174: l_profile varchar2(10) := fnd_profile.value('CSF_DEBRIEF_OVERLAPPING_LABOR');
3175:
3176: cursor c_val is
3177: Select cdh.debrief_number,
3178: cdl.labor_start_date,

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

3537: l_duration_sum number := 0;
3538:
3539:
3540: cursor c_hours_uom is
3541: select fnd_profile.value('CSF_UOM_HOURS')
3542: from dual;
3543:
3544: l_uom varchar2(3);
3545: l_t_uom varchar2(3);

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