DBA Data[Home] [Help]

APPS.CSP_TO_FORM_MOLINES dependencies on CS_INCIDENTS_ALL

Line 251: FROM cs_incidents_all

247: IF nvl(p_incident_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
248: -- validate the incident id
249: BEGIN
250: SELECT incident_id INTO l_check_existence
251: FROM cs_incidents_all
252: WHERE incident_id = p_incident_id;
253: EXCEPTION
254: WHEN NO_DATA_FOUND THEN
255: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_INCIDENT_ID');

Line 263: fnd_message.set_token('TABLE', 'CS_INCIDENTS_ALL', FALSE);

259: WHEN OTHERS THEN
260: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
261: fnd_message.set_token('ERR_FIELD', 'p_incident_id', FALSE);
262: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
263: fnd_message.set_token('TABLE', 'CS_INCIDENTS_ALL', FALSE);
264: FND_MSG_PUB.ADD;
265: RAISE EXCP_USER_DEFINED;
266: END;
267: END IF;

Line 447: FROM cs_incidents_all

443: IF nvl(p_incident_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
444: -- validate the incident id
445: BEGIN
446: SELECT incident_id INTO l_check_existence
447: FROM cs_incidents_all
448: WHERE incident_id = p_incident_id;
449: EXCEPTION
450: WHEN NO_DATA_FOUND THEN
451: FND_MESSAGE.SET_NAME('CSP', 'CSP_INVALID_INCIDENT_ID');

Line 459: fnd_message.set_token('TABLE', 'CS_INCIDENTS_ALL', FALSE);

455: WHEN OTHERS THEN
456: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
457: fnd_message.set_token('ERR_FIELD', 'p_incident_id', FALSE);
458: fnd_message.set_token('ROUTINE', l_pkg_api_name, FALSE);
459: fnd_message.set_token('TABLE', 'CS_INCIDENTS_ALL', FALSE);
460: FND_MSG_PUB.ADD;
461: RAISE EXCP_USER_DEFINED;
462: END;
463: END IF;