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_MESSAGE

Line 53: FND_MESSAGE.Set_Name('CSF','CSF_LABOR_START_DATE_ERR');

49: and p_labor_end_time <> FND_API.g_miss_date
50: AND p_labor_start_time > p_labor_end_time) THEN
51: X_Return_Status := FND_API.G_RET_STS_ERROR;
52: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
53: FND_MESSAGE.Set_Name('CSF','CSF_LABOR_START_DATE_ERR');
54: FND_MSG_PUB.ADD;
55: END IF;
56: END IF;
57: If p_labor_start_time IS NOT NULL

Line 67: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE');

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

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

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

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

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

Line 87: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE_END');

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

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

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

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

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

Line 103: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE');

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

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

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

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

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

Line 118: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE_END');

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

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

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

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

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

Line 216: FND_MESSAGE.Set_Name('CSF', l_api_name);

212:
213: -- Debug Message
214: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
215: THEN
216: FND_MESSAGE.Set_Name('CSF', l_api_name);
217: FND_MESSAGE.Set_Token ('INFO', G_PKG_NAME, FALSE);
218: FND_MSG_PUB.Add;
219:
220: END IF;

Line 217: FND_MESSAGE.Set_Token ('INFO', G_PKG_NAME, FALSE);

213: -- Debug Message
214: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
215: THEN
216: FND_MESSAGE.Set_Name('CSF', l_api_name);
217: FND_MESSAGE.Set_Token ('INFO', G_PKG_NAME, FALSE);
218: FND_MSG_PUB.Add;
219:
220: END IF;
221:

Line 237: fnd_message.set_name('CSF', 'CSF_DEBRIEF_MISSING_HEADER');

233: if IS_DEBRIEF_HEADER_REC_MISSING(P_DEBRIEF_REC) then
234:
235: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
236: THEN
237: fnd_message.set_name('CSF', 'CSF_DEBRIEF_MISSING_HEADER');
238: fnd_msg_pub.add;
239: x_return_status := fnd_api.g_ret_sts_unexp_error;
240: RAISE fnd_api.g_exc_unexpected_error;
241: END IF;

Line 274: FND_MESSAGE.Set_Name('CSF', l_api_name);

270: END IF;
271: -- Debug Message
272: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
273: THEN
274: FND_MESSAGE.Set_Name('CSF', l_api_name);
275: FND_MESSAGE.Set_Token ('INFO', G_PKG_NAME, FALSE);
276: FND_MSG_PUB.Add;
277: END IF;
278:

Line 275: FND_MESSAGE.Set_Token ('INFO', G_PKG_NAME, FALSE);

271: -- Debug Message
272: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
273: THEN
274: FND_MESSAGE.Set_Name('CSF', l_api_name);
275: FND_MESSAGE.Set_Token ('INFO', G_PKG_NAME, FALSE);
276: FND_MSG_PUB.Add;
277: END IF;
278:
279: -- Invoke table handler(debrief_Insert_Row)

Line 291: fnd_message.set_name('CSF', 'CSF_DEBRIEF_INVALID_HEADER');

287: select 1 into x
288: from CSF_DEBRIEF_HEADERS
289: where DEBRIEF_HEADER_ID = l_DEBRIEF_HEADER_ID ;
290:
291: fnd_message.set_name('CSF', 'CSF_DEBRIEF_INVALID_HEADER');
292: fnd_msg_pub.add;
293: x_return_status := fnd_api.g_ret_sts_unexp_error;
294: RAISE fnd_api.g_exc_unexpected_error;
295: exception

Line 299: fnd_message.set_name('CSF', 'CSF_DEBRIEF_INVALID_HEADER');

295: exception
296: when no_data_found then
297: null ;
298: when too_many_rows then
299: fnd_message.set_name('CSF', 'CSF_DEBRIEF_INVALID_HEADER');
300: fnd_msg_pub.add;
301: x_return_status := fnd_api.g_ret_sts_unexp_error;
302: RAISE fnd_api.g_exc_unexpected_error;
303: end ;

Line 568: fnd_message.set_name('CSF', 'CSF_DEBRIEF_MISSING_HEADER');

564: -- Virendra Singh 03/27/2000 check whether Debrief_Header_ID is not null or missging
565: if (l_debrief_header_id =FND_API.G_MISS_NUM) or (l_debrief_header_id is NULL ) then
566: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
567: THEN
568: fnd_message.set_name('CSF', 'CSF_DEBRIEF_MISSING_HEADER');
569: fnd_msg_pub.add;
570: x_return_status := fnd_api.g_ret_sts_unexp_error;
571: RAISE fnd_api.g_exc_unexpected_error;
572: END IF;

Line 772: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_INVALID_TA_ID');

768: IF (p_task_assignment_id is NULL OR p_task_assignment_id = FND_API.G_MISS_NUM) THEN
769: x_return_status := FND_API.G_RET_STS_ERROR;
770: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
771: THEN
772: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_INVALID_TA_ID');
773: FND_MSG_PUB.ADD;
774: END IF;
775: ELSE
776: open c;

Line 783: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_INVALID_TA_ID');

779: close c;
780: x_return_status := FND_API.G_RET_STS_ERROR;
781: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
782: THEN
783: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_INVALID_TA_ID');
784: FND_MSG_PUB.ADD;
785: END IF;
786: else
787: close c;

Line 823: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_DEBRIEF_DATE');

819: IF (p_debrief_date is NULL OR p_debrief_date = FND_API.G_MISS_DATE) THEN
820: x_return_status := FND_API.G_RET_STS_ERROR;
821: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
822: THEN
823: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_DEBRIEF_DATE');
824: FND_MSG_PUB.ADD;
825: END IF;
826: END IF;
827:

Line 1355: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_LABOR_DATES_ITEM');

1351: if nvl(p_debrief_line_rec.labor_start_date,fnd_api.g_miss_date) = fnd_api.g_miss_date and
1352: nvl(p_debrief_line_rec.labor_end_date,fnd_api.g_miss_date) = fnd_api.g_miss_date then
1353: x_return_status := FND_API.G_RET_STS_ERROR;
1354: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1355: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_LABOR_DATES_ITEM');
1356: FND_MSG_PUB.ADD;
1357: END IF;
1358: RAISE fnd_api.g_exc_error;
1359: end if;

Line 1427: fnd_message.set_name('CSF', 'CSF_DEBRIEF_INVALID_LINE_ID');

1423: select 1 into x
1424: from CSF_DEBRIEF_LINES
1425: where DEBRIEF_LINE_ID = l_DEBRIEF_LINE_ID ;
1426:
1427: fnd_message.set_name('CSF', 'CSF_DEBRIEF_INVALID_LINE_ID');
1428: fnd_msg_pub.add;
1429: x_return_status := fnd_api.g_ret_sts_unexp_error;
1430: RAISE fnd_api.g_exc_unexpected_error;
1431: exception

Line 1435: fnd_message.set_name('CSF', 'CSF_DEBRIEF_INVALID_LINE_ID');

1431: exception
1432: when no_data_found then
1433: null ;
1434: when too_many_rows then
1435: fnd_message.set_name('CSF', 'CSF_DEBRIEF_INVALID_LINE_ID');
1436: fnd_msg_pub.add;
1437: x_return_status := fnd_api.g_ret_sts_unexp_error;
1438: RAISE fnd_api.g_exc_unexpected_error;
1439: end ;

Line 1549: FND_MESSAGE.Set_Name('CSF', 'CSF_OVERLAP_LABOR_LINE');

1545: x_debrief_number => l_debrief_number,
1546: x_task_number => l_task_number
1547: );
1548: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1549: FND_MESSAGE.Set_Name('CSF', 'CSF_OVERLAP_LABOR_LINE');
1550: FND_MSG_PUB.ADD;
1551: RAISE fnd_api.g_exc_error;
1552: END IF;
1553: END IF;

Line 1666: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_UPDATE_TASK_ASSIGNMENT');

1662:
1663: EXCEPTION
1664: WHEN OTHERS THEN
1665: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1666: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_UPDATE_TASK_ASSIGNMENT');
1667: FND_MSG_PUB.ADD;
1668: END IF;
1669: RAISE FND_API.G_EXC_ERROR;
1670: END;

Line 1763: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_TA_STATUS');

1759: x_return_status := FND_API.G_RET_STS_SUCCESS;
1760: IF (P_Task_Assignment_status is NULL OR P_Task_Assignment_status = FND_API.G_MISS_CHAR) THEN
1761: x_return_status := FND_API.G_RET_STS_ERROR;
1762: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1763: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_TA_STATUS');
1764: FND_MSG_PUB.ADD;
1765: END IF;
1766: ELSE
1767: open validate_ta_status;

Line 1773: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_TAvalvav_STATUS');

1769: if validate_ta_status%notfound then
1770: close validate_ta_status ;
1771: x_return_status := FND_API.G_RET_STS_ERROR;
1772: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1773: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_TAvalvav_STATUS');
1774: FND_MSG_PUB.ADD;
1775: END IF;
1776: end if;
1777: close validate_ta_status ;

Line 1935: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_INVALID_LINE_ID');

1931: if GET_CHARGE_UPLOAD_STATUS%notfound then
1932: close GET_CHARGE_UPLOAD_STATUS;
1933: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1934: THEN
1935: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_INVALID_LINE_ID');
1936: FND_MSG_PUB.Add;
1937:
1938: END IF;
1939: raise FND_API.G_EXC_ERROR;

Line 1957: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_CHARGE_UPLOADED');

1953: l_ib_upload_status ='SUCCEEDED' or
1954: l_spare_upload_status ='SUCCEEDED' then
1955: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1956: THEN
1957: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_CHARGE_UPLOADED');
1958: FND_MSG_PUB.Add;
1959: x_return_status := 'E';
1960: END IF;
1961: ELSE

Line 1981: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_LABOR_DATES_ITEM');

1977: if nvl(p_debrief_line_rec.labor_start_date,fnd_api.g_miss_date) = fnd_api.g_miss_date and
1978: nvl(p_debrief_line_rec.labor_end_date,fnd_api.g_miss_date) = fnd_api.g_miss_date then
1979: x_return_status := FND_API.G_RET_STS_ERROR;
1980: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1981: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_LABOR_DATES_ITEM');
1982: FND_MSG_PUB.ADD;
1983: END IF;
1984: RAISE fnd_api.g_exc_error;
1985: end if;

Line 2316: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_UPDATE_TASK_ASSIGNMENT');

2312:
2313: EXCEPTION
2314: WHEN OTHERS THEN
2315: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2316: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_UPDATE_TASK_ASSIGNMENT');
2317: FND_MSG_PUB.ADD;
2318: END IF;
2319: RAISE FND_API.G_EXC_ERROR;
2320: END;

Line 2347: FND_MESSAGE.Set_Name('CSF', l_api_name);

2343:
2344: -- Debug Message
2345: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2346: THEN
2347: FND_MESSAGE.Set_Name('CSF', l_api_name);
2348: FND_MESSAGE.Set_Token ('INFO', G_PKG_NAME, FALSE);
2349: FND_MSG_PUB.Add;
2350: END IF;
2351:

Line 2348: FND_MESSAGE.Set_Token ('INFO', G_PKG_NAME, FALSE);

2344: -- Debug Message
2345: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2346: THEN
2347: FND_MESSAGE.Set_Name('CSF', l_api_name);
2348: FND_MESSAGE.Set_Token ('INFO', G_PKG_NAME, FALSE);
2349: FND_MSG_PUB.Add;
2350: END IF;
2351:
2352: -- Standard call to get message count and if count is 1, get message info.

Line 2409: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_SERVICE_DATE');

2405: x_return_status := FND_API.G_RET_STS_SUCCESS;
2406: IF (p_service_date is NULL OR p_service_date = FND_API.G_MISS_DATE) THEN
2407: x_return_status := FND_API.G_RET_STS_ERROR;
2408: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2409: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_SERVICE_DATE');
2410: FND_MSG_PUB.ADD;
2411: END IF;
2412: END IF;
2413:

Line 2458: FND_MESSAGE.Set_Name('CSP', 'CSP_INVALID_ORG_SUBINV');

2454: close c_subinventory_code;
2455: IF l_subinventory_code is NULL THEN
2456: x_return_status := FND_API.G_RET_STS_ERROR;
2457: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2458: FND_MESSAGE.Set_Name('CSP', 'CSP_INVALID_ORG_SUBINV');
2459: FND_MESSAGE.set_token('ORG',l_organization_code,TRUE);
2460: FND_MESSAGE.set_token('SUBINV',l_subinventory_code,TRUE);
2461: FND_MSG_PUB.ADD;
2462: END IF;

Line 2459: FND_MESSAGE.set_token('ORG',l_organization_code,TRUE);

2455: IF l_subinventory_code is NULL THEN
2456: x_return_status := FND_API.G_RET_STS_ERROR;
2457: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2458: FND_MESSAGE.Set_Name('CSP', 'CSP_INVALID_ORG_SUBINV');
2459: FND_MESSAGE.set_token('ORG',l_organization_code,TRUE);
2460: FND_MESSAGE.set_token('SUBINV',l_subinventory_code,TRUE);
2461: FND_MSG_PUB.ADD;
2462: END IF;
2463: END IF;

Line 2460: FND_MESSAGE.set_token('SUBINV',l_subinventory_code,TRUE);

2456: x_return_status := FND_API.G_RET_STS_ERROR;
2457: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2458: FND_MESSAGE.Set_Name('CSP', 'CSP_INVALID_ORG_SUBINV');
2459: FND_MESSAGE.set_token('ORG',l_organization_code,TRUE);
2460: FND_MESSAGE.set_token('SUBINV',l_subinventory_code,TRUE);
2461: FND_MSG_PUB.ADD;
2462: END IF;
2463: END IF;
2464:

Line 2504: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_INVENTORY_ITEM_ID');

2500: close c_inventory_item;
2501: IF l_inventory_item_id is null THEN
2502: x_return_status := FND_API.G_RET_STS_ERROR;
2503: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2504: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_INVENTORY_ITEM_ID');
2505: FND_MSG_PUB.ADD;
2506: END IF;
2507: END IF;
2508: -- Standard call to get message count and if count is 1, get message info.

Line 2548: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_INSTANCE_ID');

2544: if get_instance_id%notfound then
2545: close get_instance_id;
2546: x_return_status := FND_API.G_RET_STS_ERROR;
2547: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2548: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_INSTANCE_ID');
2549: FND_MSG_PUB.ADD;
2550: END IF;
2551: end if;
2552: close get_instance_id;

Line 2588: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_HEADER_ID');

2584: x_return_status := FND_API.G_RET_STS_SUCCESS;
2585: IF (P_DEBRIEF_HEADER_ID is NULL OR P_DEBRIEF_HEADER_ID = FND_API.G_MISS_NUM) THEN
2586: x_return_status := FND_API.G_RET_STS_ERROR;
2587: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2588: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_HEADER_ID');
2589: FND_MSG_PUB.ADD;
2590: END IF;
2591: ELSE
2592: open validate_header_id;

Line 2598: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_HEADER_ID');

2594: if validate_header_id%notfound then
2595: -- close validate_header_id;
2596: x_return_status := FND_API.G_RET_STS_ERROR;
2597: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2598: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_HEADER_ID');
2599: FND_MSG_PUB.ADD;
2600: END IF;
2601: end if;
2602: close validate_header_id ;

Line 2638: FND_MESSAGE.Set_Name('CSF', l_api_name);

2634: IF (p_debrief_line_number is NULL OR p_debrief_line_number = FND_API.G_MISS_NUM ) THEN
2635: x_return_status := FND_API.G_RET_STS_ERROR;
2636: ELSIF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2637: THEN
2638: FND_MESSAGE.Set_Name('CSF', l_api_name);
2639: FND_MESSAGE.Set_Token('COLUMN', 'DEBRIEF_LINE_NUMBER', FALSE);
2640: FND_MSG_PUB.ADD;
2641: END IF;
2642: END IF;

Line 2639: FND_MESSAGE.Set_Token('COLUMN', 'DEBRIEF_LINE_NUMBER', FALSE);

2635: x_return_status := FND_API.G_RET_STS_ERROR;
2636: ELSIF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2637: THEN
2638: FND_MESSAGE.Set_Name('CSF', l_api_name);
2639: FND_MESSAGE.Set_Token('COLUMN', 'DEBRIEF_LINE_NUMBER', FALSE);
2640: FND_MSG_PUB.ADD;
2641: END IF;
2642: END IF;
2643:

Line 2677: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_BUS_PROCESS_ID');

2673: x_return_status := FND_API.G_RET_STS_SUCCESS;
2674: IF (p_business_process_id is NULL OR p_business_process_id = FND_API.G_MISS_NUM ) THEN
2675: x_return_status := FND_API.G_RET_STS_ERROR;
2676: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2677: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_BUS_PROCESS_ID');
2678: FND_MSG_PUB.ADD;
2679: END IF;
2680: ELSE
2681: open get_business_process_id;

Line 2687: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_BUS_PROCESS_ID');

2683: if get_business_process_id%notfound then
2684: close get_business_process_id;
2685: x_return_status := FND_API.G_RET_STS_ERROR;
2686: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2687: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_BUS_PROCESS_ID');
2688: FND_MSG_PUB.ADD;
2689: END IF;
2690: end if;
2691: close get_business_process_id;

Line 2725: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_TXN_BILLING_TYP_ID');

2721: x_return_status := FND_API.G_RET_STS_SUCCESS;
2722: IF (p_transaction_type_id is NULL OR p_transaction_type_id = FND_API.G_MISS_NUM ) THEN
2723: x_return_status := FND_API.G_RET_STS_ERROR;
2724: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2725: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_TXN_BILLING_TYP_ID');
2726: FND_MSG_PUB.ADD;
2727: END IF;
2728: ELSE
2729: open get_transaction_type_id;

Line 2735: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_TXN_BILLING_TYP_ID');

2731: if get_transaction_type_id%notfound then
2732: close get_transaction_type_id;
2733: x_return_status := FND_API.G_RET_STS_ERROR;
2734: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2735: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_TXN_BILLING_TYP_ID');
2736: FND_MSG_PUB.ADD;
2737: END IF;
2738: end if;
2739: close get_transaction_type_id;

Line 3237: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_EXISTS');

3233: where task_assignment_id = l_task_assignment_id;
3234:
3235: if l_debrief_header_id is not null then
3236: x_return_status := FND_API.G_RET_STS_ERROR;
3237: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_EXISTS');
3238: FND_MSG_PUB.ADD;
3239: end if;
3240:
3241: exception

Line 3272: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_PENDING');

3268: if nvl(l_processed_flag,'COMPLETED') = 'COMPLETED' THEN
3269: x_return_status := FND_API.G_RET_STS_SUCCESS;
3270: else
3271: x_return_status := FND_API.G_RET_STS_ERROR;
3272: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_PENDING');
3273: FND_MSG_PUB.ADD;
3274: end if;
3275: -- Standard call to get message count and if count is 1, get message info.
3276: FND_MSG_PUB.Count_And_Get

Line 3831: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_START_TIME');

3827: and (p_actual_travel_end_time <> FND_API.g_miss_date
3828: and p_actual_travel_end_time IS NOT NULL) THEN
3829: X_Return_Status := FND_API.G_RET_STS_ERROR;
3830: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3831: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_START_TIME');
3832: FND_MSG_PUB.ADD;
3833: END IF;
3834: END IF;
3835:

Line 3843: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_START_AFTER_END');

3839: and p_actual_travel_end_time <> FND_API.g_miss_date
3840: AND p_actual_travel_start_time > p_actual_travel_end_time) THEN
3841: X_Return_Status := FND_API.G_RET_STS_ERROR;
3842: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3843: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_START_AFTER_END');
3844: FND_MSG_PUB.ADD;
3845: END IF;
3846: END IF;
3847:

Line 3858: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_START_CURR_DATE');

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;
3860: END IF;
3861: END IF;
3862: If p_actual_travel_end_time IS NOT NULL

Line 3872: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_END_CURR_DATE');

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;
3874: END IF;
3875: END IF;
3876:

Line 3882: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_START_SR_DATE');

3878: and p_actual_travel_start_time <> FND_API.g_miss_date
3879: and p_actual_travel_start_time < l_service_request_date) THEN
3880: X_Return_Status := FND_API.G_RET_STS_ERROR;
3881: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3882: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_START_SR_DATE');
3883: FND_MSG_PUB.ADD;
3884: END IF;
3885: END IF;
3886: If (p_actual_travel_end_time IS NOT NULL

Line 3891: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_END_SR_DATE');

3887: and p_actual_travel_end_time <> FND_API.g_miss_date
3888: and p_actual_travel_end_time < l_service_request_date) THEN
3889: X_Return_Status := FND_API.G_RET_STS_ERROR;
3890: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3891: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_END_SR_DATE');
3892: FND_MSG_PUB.ADD;
3893: END IF;
3894: END IF;
3895: END;