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 62: FND_MESSAGE.Set_Name('CSF','CSF_LABOR_START_DATE_ERR');

58: and p_labor_end_time <> FND_API.g_miss_date
59: AND p_labor_start_time > p_labor_end_time) THEN
60: X_Return_Status := FND_API.G_RET_STS_ERROR;
61: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
62: FND_MESSAGE.Set_Name('CSF','CSF_LABOR_START_DATE_ERR');
63: FND_MSG_PUB.ADD;
64: END IF;
65: END IF;
66: If p_labor_start_time IS NOT NULL

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

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

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 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 98: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE_END');

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

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 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 115: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE');

111: and p_labor_start_time <> FND_API.g_miss_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,

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 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 131: FND_MESSAGE.Set_Name('CSF','CSFW_SERVICE_DATE_END');

127: and p_labor_end_time <> FND_API.g_miss_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,

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 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 229: FND_MESSAGE.Set_Name('CSF', l_api_name);

225:
226: -- Debug Message
227: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
228: THEN
229: FND_MESSAGE.Set_Name('CSF', l_api_name);
230: FND_MESSAGE.Set_Token ('INFO', G_PKG_NAME, FALSE);
231: FND_MSG_PUB.Add;
232:
233: END IF;

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

226: -- Debug Message
227: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
228: THEN
229: FND_MESSAGE.Set_Name('CSF', l_api_name);
230: FND_MESSAGE.Set_Token ('INFO', G_PKG_NAME, FALSE);
231: FND_MSG_PUB.Add;
232:
233: END IF;
234:

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

246: if IS_DEBRIEF_HEADER_REC_MISSING(P_DEBRIEF_REC) then
247:
248: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
249: THEN
250: fnd_message.set_name('CSF', 'CSF_DEBRIEF_MISSING_HEADER');
251: fnd_msg_pub.add;
252: x_return_status := fnd_api.g_ret_sts_unexp_error;
253: RAISE fnd_api.g_exc_unexpected_error;
254: END IF;

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

283: END IF;
284: -- Debug Message
285: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
286: THEN
287: FND_MESSAGE.Set_Name('CSF', l_api_name);
288: FND_MESSAGE.Set_Token ('INFO', G_PKG_NAME, FALSE);
289: FND_MSG_PUB.Add;
290: END IF;
291:

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

284: -- Debug Message
285: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
286: THEN
287: FND_MESSAGE.Set_Name('CSF', l_api_name);
288: FND_MESSAGE.Set_Token ('INFO', G_PKG_NAME, FALSE);
289: FND_MSG_PUB.Add;
290: END IF;
291:
292: -- Invoke table handler(debrief_Insert_Row)

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

300: select 1 into x
301: from CSF_DEBRIEF_HEADERS
302: where DEBRIEF_HEADER_ID = l_DEBRIEF_HEADER_ID ;
303:
304: fnd_message.set_name('CSF', 'CSF_DEBRIEF_INVALID_HEADER');
305: fnd_msg_pub.add;
306: x_return_status := fnd_api.g_ret_sts_unexp_error;
307: RAISE fnd_api.g_exc_unexpected_error;
308: exception

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

308: exception
309: when no_data_found then
310: null ;
311: when too_many_rows then
312: fnd_message.set_name('CSF', 'CSF_DEBRIEF_INVALID_HEADER');
313: fnd_msg_pub.add;
314: x_return_status := fnd_api.g_ret_sts_unexp_error;
315: RAISE fnd_api.g_exc_unexpected_error;
316: end ;

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

577: -- Virendra Singh 03/27/2000 check whether Debrief_Header_ID is not null or missging
578: if (l_debrief_header_id =FND_API.G_MISS_NUM) or (l_debrief_header_id is NULL ) then
579: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
580: THEN
581: fnd_message.set_name('CSF', 'CSF_DEBRIEF_MISSING_HEADER');
582: fnd_msg_pub.add;
583: x_return_status := fnd_api.g_ret_sts_unexp_error;
584: RAISE fnd_api.g_exc_unexpected_error;
585: END IF;

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

781: IF (p_task_assignment_id is NULL OR p_task_assignment_id = FND_API.G_MISS_NUM) THEN
782: x_return_status := FND_API.G_RET_STS_ERROR;
783: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
784: THEN
785: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_INVALID_TA_ID');
786: FND_MSG_PUB.ADD;
787: END IF;
788: ELSE
789: open c;

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

792: close c;
793: x_return_status := FND_API.G_RET_STS_ERROR;
794: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
795: THEN
796: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_INVALID_TA_ID');
797: FND_MSG_PUB.ADD;
798: END IF;
799: else
800: close c;

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

832: IF (p_debrief_date is NULL OR p_debrief_date = FND_API.G_MISS_DATE) THEN
833: x_return_status := FND_API.G_RET_STS_ERROR;
834: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
835: THEN
836: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_DEBRIEF_DATE');
837: FND_MSG_PUB.ADD;
838: END IF;
839: END IF;
840:

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

1380: if nvl(p_debrief_line_rec.labor_start_date,fnd_api.g_miss_date) = fnd_api.g_miss_date and
1381: nvl(p_debrief_line_rec.labor_end_date,fnd_api.g_miss_date) = fnd_api.g_miss_date then
1382: x_return_status := FND_API.G_RET_STS_ERROR;
1383: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1384: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_LABOR_DATES_ITEM');
1385: FND_MSG_PUB.ADD;
1386: END IF;
1387: RAISE fnd_api.g_exc_error;
1388: end if;

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

1456: select 1 into x
1457: from CSF_DEBRIEF_LINES
1458: where DEBRIEF_LINE_ID = l_DEBRIEF_LINE_ID ;
1459:
1460: fnd_message.set_name('CSF', 'CSF_DEBRIEF_INVALID_LINE_ID');
1461: fnd_msg_pub.add;
1462: x_return_status := fnd_api.g_ret_sts_unexp_error;
1463: RAISE fnd_api.g_exc_unexpected_error;
1464: exception

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

1464: exception
1465: when no_data_found then
1466: null ;
1467: when too_many_rows then
1468: fnd_message.set_name('CSF', 'CSF_DEBRIEF_INVALID_LINE_ID');
1469: fnd_msg_pub.add;
1470: x_return_status := fnd_api.g_ret_sts_unexp_error;
1471: RAISE fnd_api.g_exc_unexpected_error;
1472: end ;

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

1594: x_debrief_number => l_debrief_number,
1595: x_task_number => l_task_number
1596: );
1597: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1598: FND_MESSAGE.Set_Name('CSF', 'CSF_OVERLAP_LABOR_LINE');
1599: FND_MESSAGE.SET_TOKEN ('TASK_NUMBER', l_task_number);
1600: FND_MSG_PUB.ADD;
1601: RAISE fnd_api.g_exc_error;
1602: END IF;

Line 1599: FND_MESSAGE.SET_TOKEN ('TASK_NUMBER', l_task_number);

1595: x_task_number => l_task_number
1596: );
1597: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1598: FND_MESSAGE.Set_Name('CSF', 'CSF_OVERLAP_LABOR_LINE');
1599: FND_MESSAGE.SET_TOKEN ('TASK_NUMBER', l_task_number);
1600: FND_MSG_PUB.ADD;
1601: RAISE fnd_api.g_exc_error;
1602: END IF;
1603: END IF;

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

1712:
1713: EXCEPTION
1714: WHEN OTHERS THEN
1715: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1716: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_UPDATE_TASK_ASSIGNMENT');
1717: FND_MSG_PUB.ADD;
1718: END IF;
1719: RAISE FND_API.G_EXC_ERROR;
1720: END;

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

1812: x_return_status := FND_API.G_RET_STS_SUCCESS;
1813: IF (P_Task_Assignment_status is NULL OR P_Task_Assignment_status = FND_API.G_MISS_CHAR) THEN
1814: x_return_status := FND_API.G_RET_STS_ERROR;
1815: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1816: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_TA_STATUS');
1817: FND_MSG_PUB.ADD;
1818: END IF;
1819: ELSE
1820: open validate_ta_status;

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

1822: if validate_ta_status%notfound then
1823: close validate_ta_status ;
1824: x_return_status := FND_API.G_RET_STS_ERROR;
1825: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1826: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_TAvalvav_STATUS');
1827: FND_MSG_PUB.ADD;
1828: END IF;
1829: end if;
1830: close validate_ta_status ;

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

1984: if GET_CHARGE_UPLOAD_STATUS%notfound then
1985: close GET_CHARGE_UPLOAD_STATUS;
1986: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1987: THEN
1988: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_INVALID_LINE_ID');
1989: FND_MSG_PUB.Add;
1990:
1991: END IF;
1992: raise FND_API.G_EXC_ERROR;

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

2006: l_ib_upload_status ='SUCCEEDED' or
2007: l_spare_upload_status ='SUCCEEDED' then
2008: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2009: THEN
2010: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_CHARGE_UPLOADED');
2011: FND_MSG_PUB.Add;
2012: x_return_status := 'E';
2013: END IF;
2014: ELSE

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

2030: if nvl(p_debrief_line_rec.labor_start_date,fnd_api.g_miss_date) = fnd_api.g_miss_date and
2031: nvl(p_debrief_line_rec.labor_end_date,fnd_api.g_miss_date) = fnd_api.g_miss_date then
2032: x_return_status := FND_API.G_RET_STS_ERROR;
2033: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2034: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_LABOR_DATES_ITEM');
2035: FND_MSG_PUB.ADD;
2036: END IF;
2037: RAISE fnd_api.g_exc_error;
2038: end if;

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

2379:
2380: EXCEPTION
2381: WHEN OTHERS THEN
2382: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2383: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_UPDATE_TASK_ASSIGNMENT');
2384: FND_MSG_PUB.ADD;
2385: END IF;
2386: RAISE FND_API.G_EXC_ERROR;
2387: END;

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

2410:
2411: -- Debug Message
2412: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2413: THEN
2414: FND_MESSAGE.Set_Name('CSF', l_api_name);
2415: FND_MESSAGE.Set_Token ('INFO', G_PKG_NAME, FALSE);
2416: FND_MSG_PUB.Add;
2417: END IF;
2418:

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

2411: -- Debug Message
2412: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2413: THEN
2414: FND_MESSAGE.Set_Name('CSF', l_api_name);
2415: FND_MESSAGE.Set_Token ('INFO', G_PKG_NAME, FALSE);
2416: FND_MSG_PUB.Add;
2417: END IF;
2418:
2419: -- Standard call to get message count and if count is 1, get message info.

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

2473: x_return_status := FND_API.G_RET_STS_SUCCESS;
2474: IF (p_service_date is NULL OR p_service_date = FND_API.G_MISS_DATE) THEN
2475: x_return_status := FND_API.G_RET_STS_ERROR;
2476: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2477: FND_MESSAGE.Set_Name('CSF', 'CSF_DEBRIEF_SERVICE_DATE');
2478: FND_MSG_PUB.ADD;
2479: END IF;
2480: END IF;
2481:

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

2522: close c_subinventory_code;
2523: IF l_subinventory_code is NULL THEN
2524: x_return_status := FND_API.G_RET_STS_ERROR;
2525: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2526: FND_MESSAGE.Set_Name('CSP', 'CSP_INVALID_ORG_SUBINV');
2527: FND_MESSAGE.set_token('ORG',l_organization_code,TRUE);
2528: FND_MESSAGE.set_token('SUBINV',l_subinventory_code,TRUE);
2529: FND_MSG_PUB.ADD;
2530: END IF;

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

2523: IF l_subinventory_code is NULL THEN
2524: x_return_status := FND_API.G_RET_STS_ERROR;
2525: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2526: FND_MESSAGE.Set_Name('CSP', 'CSP_INVALID_ORG_SUBINV');
2527: FND_MESSAGE.set_token('ORG',l_organization_code,TRUE);
2528: FND_MESSAGE.set_token('SUBINV',l_subinventory_code,TRUE);
2529: FND_MSG_PUB.ADD;
2530: END IF;
2531: END IF;

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

2524: x_return_status := FND_API.G_RET_STS_ERROR;
2525: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2526: FND_MESSAGE.Set_Name('CSP', 'CSP_INVALID_ORG_SUBINV');
2527: FND_MESSAGE.set_token('ORG',l_organization_code,TRUE);
2528: FND_MESSAGE.set_token('SUBINV',l_subinventory_code,TRUE);
2529: FND_MSG_PUB.ADD;
2530: END IF;
2531: END IF;
2532:

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

2568: close c_inventory_item;
2569: IF l_inventory_item_id is null THEN
2570: x_return_status := FND_API.G_RET_STS_ERROR;
2571: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2572: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_INVENTORY_ITEM_ID');
2573: FND_MSG_PUB.ADD;
2574: END IF;
2575: END IF;
2576: -- Standard call to get message count and if count is 1, get message info.

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

2612: if get_instance_id%notfound then
2613: close get_instance_id;
2614: x_return_status := FND_API.G_RET_STS_ERROR;
2615: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2616: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_INSTANCE_ID');
2617: FND_MSG_PUB.ADD;
2618: END IF;
2619: end if;
2620: close get_instance_id;

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

2652: x_return_status := FND_API.G_RET_STS_SUCCESS;
2653: IF (P_DEBRIEF_HEADER_ID is NULL OR P_DEBRIEF_HEADER_ID = FND_API.G_MISS_NUM) THEN
2654: x_return_status := FND_API.G_RET_STS_ERROR;
2655: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2656: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_HEADER_ID');
2657: FND_MSG_PUB.ADD;
2658: END IF;
2659: ELSE
2660: open validate_header_id;

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

2662: if validate_header_id%notfound then
2663: -- close validate_header_id;
2664: x_return_status := FND_API.G_RET_STS_ERROR;
2665: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2666: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_HEADER_ID');
2667: FND_MSG_PUB.ADD;
2668: END IF;
2669: end if;
2670: close validate_header_id ;

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

2702: IF (p_debrief_line_number is NULL OR p_debrief_line_number = FND_API.G_MISS_NUM ) THEN
2703: x_return_status := FND_API.G_RET_STS_ERROR;
2704: ELSIF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2705: THEN
2706: FND_MESSAGE.Set_Name('CSF', l_api_name);
2707: FND_MESSAGE.Set_Token('COLUMN', 'DEBRIEF_LINE_NUMBER', FALSE);
2708: FND_MSG_PUB.ADD;
2709: END IF;
2710: END IF;

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

2703: x_return_status := FND_API.G_RET_STS_ERROR;
2704: ELSIF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2705: THEN
2706: FND_MESSAGE.Set_Name('CSF', l_api_name);
2707: FND_MESSAGE.Set_Token('COLUMN', 'DEBRIEF_LINE_NUMBER', FALSE);
2708: FND_MSG_PUB.ADD;
2709: END IF;
2710: END IF;
2711:

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

2741: x_return_status := FND_API.G_RET_STS_SUCCESS;
2742: IF (p_business_process_id is NULL OR p_business_process_id = FND_API.G_MISS_NUM ) THEN
2743: x_return_status := FND_API.G_RET_STS_ERROR;
2744: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2745: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_BUS_PROCESS_ID');
2746: FND_MSG_PUB.ADD;
2747: END IF;
2748: ELSE
2749: open get_business_process_id;

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

2751: if get_business_process_id%notfound then
2752: close get_business_process_id;
2753: x_return_status := FND_API.G_RET_STS_ERROR;
2754: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2755: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_BUS_PROCESS_ID');
2756: FND_MSG_PUB.ADD;
2757: END IF;
2758: end if;
2759: close get_business_process_id;

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

2789: x_return_status := FND_API.G_RET_STS_SUCCESS;
2790: IF (p_transaction_type_id is NULL OR p_transaction_type_id = FND_API.G_MISS_NUM ) THEN
2791: x_return_status := FND_API.G_RET_STS_ERROR;
2792: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2793: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_TXN_BILLING_TYP_ID');
2794: FND_MSG_PUB.ADD;
2795: END IF;
2796: ELSE
2797: open get_transaction_type_id;

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

2799: if get_transaction_type_id%notfound then
2800: close get_transaction_type_id;
2801: x_return_status := FND_API.G_RET_STS_ERROR;
2802: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2803: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_TXN_BILLING_TYP_ID');
2804: FND_MSG_PUB.ADD;
2805: END IF;
2806: end if;
2807: close get_transaction_type_id;

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

3298: if l_debrief_header_id is not null then
3299: if l_old_resource_type <> l_new_resource_type or
3300: l_old_resource_id <> l_new_resource_id then
3301: x_return_status := FND_API.G_RET_STS_ERROR;
3302: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_EXISTS');
3303: FND_MSG_PUB.ADD;
3304: end if;
3305: end if;
3306:

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

3321: where task_assignment_id = l_task_assignment_id;
3322:
3323: if l_debrief_header_id is not null then
3324: x_return_status := FND_API.G_RET_STS_ERROR;
3325: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_EXISTS');
3326: FND_MSG_PUB.ADD;
3327: end if;
3328:
3329: exception

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

3712: if nvl(l_processed_flag,'COMPLETED') = 'COMPLETED' THEN
3713: x_return_status := FND_API.G_RET_STS_SUCCESS;
3714: else
3715: x_return_status := FND_API.G_RET_STS_ERROR;
3716: FND_MESSAGE.Set_Name('CSF','CSF_DEBRIEF_PENDING');
3717: FND_MSG_PUB.ADD;
3718: end if;
3719: -- Standard call to get message count and if count is 1, get message info.
3720: FND_MSG_PUB.Count_And_Get

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

4271: and (p_actual_travel_end_time <> FND_API.g_miss_date
4272: and p_actual_travel_end_time IS NOT NULL) THEN
4273: X_Return_Status := FND_API.G_RET_STS_ERROR;
4274: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4275: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_START_TIME');
4276: FND_MSG_PUB.ADD;
4277: END IF;
4278: END IF;
4279:

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

4283: and p_actual_travel_end_time <> FND_API.g_miss_date
4284: AND p_actual_travel_start_time > p_actual_travel_end_time) THEN
4285: X_Return_Status := FND_API.G_RET_STS_ERROR;
4286: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4287: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_START_AFTER_END');
4288: FND_MSG_PUB.ADD;
4289: END IF;
4290: END IF;
4291:

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

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;
4304: END IF;
4305: END IF;
4306: If p_actual_travel_end_time IS NOT NULL

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

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;
4318: END IF;
4319: END IF;
4320:

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

4322: and p_actual_travel_start_time <> FND_API.g_miss_date
4323: and p_actual_travel_start_time < l_service_request_date) THEN
4324: X_Return_Status := FND_API.G_RET_STS_ERROR;
4325: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4326: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_START_SR_DATE');
4327: FND_MSG_PUB.ADD;
4328: END IF;
4329: END IF;
4330: If (p_actual_travel_end_time IS NOT NULL

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

4331: and p_actual_travel_end_time <> FND_API.g_miss_date
4332: and p_actual_travel_end_time < l_service_request_date) THEN
4333: X_Return_Status := FND_API.G_RET_STS_ERROR;
4334: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4335: FND_MESSAGE.Set_Name('CSF','CSF_TRAVEL_END_SR_DATE');
4336: FND_MSG_PUB.ADD;
4337: END IF;
4338: END IF;
4339: END;