DBA Data[Home] [Help]

APPS.CS_KB_ELEMENT_TYPES_PKG dependencies on FND_MESSAGE

Line 203: fnd_message.set_name('CS', 'CS_KB_C_INVALID_ELE_TYPE_ID');

199: l_ret number;
200: l_count pls_integer;
201: begin
202: if p_element_type_id is null or p_element_type_id <= 0 then
203: fnd_message.set_name('CS', 'CS_KB_C_INVALID_ELE_TYPE_ID');
204: return ERROR_STATUS; end if;
205:
206: select count(*) into l_count
207: from cs_kb_element_types_b

Line 210: fnd_message.set_name('CS', 'CS_KB_C_INVALID_ELE_TYPE_ID');

206: select count(*) into l_count
207: from cs_kb_element_types_b
208: where element_type_id = p_element_type_id;
209: if(l_count <= 0) then
210: fnd_message.set_name('CS', 'CS_KB_C_INVALID_ELE_TYPE_ID');
211: return ERROR_STATUS; end if;
212:
213: select count(*) into l_count
214: from cs_kb_set_ele_types

Line 217: fnd_message.set_name('CS', 'CS_KB_C_ELE_TYPE_WITH_SET_TYPE');

213: select count(*) into l_count
214: from cs_kb_set_ele_types
215: where element_type_id = p_element_type_id;
216: if(l_count > 0) then
217: fnd_message.set_name('CS', 'CS_KB_C_ELE_TYPE_WITH_SET_TYPE');
218: return ERROR_STATUS; end if;
219:
220: select count(*) into l_count
221: from cs_kb_ele_type_links

Line 224: fnd_message.set_name('CS', 'CS_KB_C_ELE_TYPE_WITH_LINK');

220: select count(*) into l_count
221: from cs_kb_ele_type_links
222: where element_type_id = p_element_type_id;
223: if(l_count > 0) then
224: fnd_message.set_name('CS', 'CS_KB_C_ELE_TYPE_WITH_LINK');
225: return ERROR_STATUS; end if;
226:
227: -- Check elements with defined element type
228: --

Line 235: fnd_message.set_name('CS', 'CS_KB_C_ELE_TYPE_WITH_ELE');

231: where e.element_type_id = p_element_type_id
232: and e.status <> 'OBS';
233:
234: if(l_count > 0) then
235: fnd_message.set_name('CS', 'CS_KB_C_ELE_TYPE_WITH_ELE');
236: return ERROR_STATUS; end if;
237:
238: /* Commented 30-Sep-2003 - Code Duplicated with above statement
239: select count(*) into l_count

Line 243: fnd_message.set_name('CS', 'CS_KB_C_ELE_TYPE_WITH_ELE');

239: select count(*) into l_count
240: from cs_kb_elements_b
241: where element_type_id = p_element_type_id;
242: if(l_count > 0) then
243: fnd_message.set_name('CS', 'CS_KB_C_ELE_TYPE_WITH_ELE');
244: return ERROR_STATUS;
245: end if;
246: */
247:

Line 452: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

448: open c;
449: fetch c into recinfo;
450: if (c%notfound) then
451: close c;
452: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
453: app_exception.raise_exception;
454: end if;
455: close c;
456: if (

Line 500: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

496: OR ((recinfo.END_DATE_ACTIVE is null) AND (X_END_DATE is null)))
497: ) then
498: null;
499: else
500: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
501: app_exception.raise_exception;
502: end if;
503:
504: for tlinfo in c1 loop

Line 513: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

509: OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)))
510: ) then
511: null;
512: else
513: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
514: app_exception.raise_exception;
515: end if;
516: end if;
517: end loop;