APPS.CS_KB_SET_TYPES_PKG dependencies on FND_MESSAGE

Line 187: fnd_message.set_name('CS', 'CS_KB_C_INVALID_SET_TYPE_ID');

183: l_ret number;
184: l_count pls_integer;
185: begin
186: if p_set_type_id is null or p_set_type_id <= 0 then
187: fnd_message.set_name('CS', 'CS_KB_C_INVALID_SET_TYPE_ID');
188: return ERROR_STATUS;
189: end if;
190:
191: --

Line 197: fnd_message.set_name('CS', 'CS_KB_C_INVALID_SET_TYPE_ID');

193: select count(*) into l_count
194: from cs_kb_set_types_b
195: where set_type_id = p_set_type_id;
196: if(l_count <= 0) then
197: fnd_message.set_name('CS', 'CS_KB_C_INVALID_SET_TYPE_ID');
198: return ERROR_STATUS;
199: end if;
200:
201: -- Check element links

Line 207: fnd_message.set_name('CS', 'CS_KB_C_SET_TYPE_WITH_ELE_TYPE');

203: select count(*) into l_count
204: from cs_kb_set_ele_types
205: where set_type_id = p_set_type_id;
206: if(l_count > 0) then
207: fnd_message.set_name('CS', 'CS_KB_C_SET_TYPE_WITH_ELE_TYPE');
208: return ERROR_STATUS; end if;
209:
210: -- Check external links
211: --

Line 216: fnd_message.set_name('CS', 'CS_KB_C_SET_TYPE_WITH_LINK');

212: select count(*) into l_count
213: from cs_kb_set_type_links
214: where set_type_id = p_set_type_id;
215: if(l_count > 0) then
216: fnd_message.set_name('CS', 'CS_KB_C_SET_TYPE_WITH_LINK');
217: return ERROR_STATUS; end if;
218:
219: -- Check sets with defined set type
220: --

Line 226: -- fnd_message.set_name('CS', 'CS_KB_C_SET_TYPE_WITH_SET');

222: -- select count(*) into l_count
223: -- from cs_kb_sets_vl
224: -- where set_type_id = p_set_type_id;
225: -- if(l_count > 0) then
226: -- fnd_message.set_name('CS', 'CS_KB_C_SET_TYPE_WITH_SET');
227: -- return ERROR_STATUS; end if;
228:
229: select /*+ INDEX(s) */ count(*) into l_count
230: from cs_kb_sets_b s

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

231: where s.set_type_id = p_set_type_id
232: and (s.latest_version_flag = 'Y' OR s.viewable_version_flag = 'Y')
233: and s.status <> 'OBS';
234: if(l_count > 0) then
235: fnd_message.set_name('CS', 'CS_KB_C_SET_TYPE_WITH_SET');
236: return ERROR_STATUS; end if;
237:
238:
239: CS_KB_SET_TYPES_PKG.Delete_Row(

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

439: open c;
440: fetch c into recinfo;
441: if (c%notfound) then
442: close c;
443: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
444: app_exception.raise_exception;
445: end if;
446: close c;
447: if (

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

487: OR ((recinfo.END_DATE_ACTIVE is null) AND (X_END_DATE is null)))
488: ) then
489: null;
490: else
491: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
492: app_exception.raise_exception;
493: end if;
494:
495: for tlinfo in c1 loop

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

500: OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)))
501: ) then
502: null;
503: else
504: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
505: app_exception.raise_exception;
506: end if;
507: end if;
508: end loop;