DBA Data[Home] [Help]

APPS.CS_KB_SET_RECS_PKG dependencies on FND_MESSAGE

Line 32: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');

28: begin
29: -- Validate params
30: if(P_SET_REC_ID is null ) then
31: x_ret_status := FND_API.G_RET_STS_ERROR;
32: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
33: fnd_msg_pub.add;
34: FND_MSG_PUB.Count_And_Get(
35: p_count => x_msg_count,
36: p_data => x_msg_data );

Line 48: fnd_message.set_name('CS', 'CS_KB_C_INVALID_SET_ID');

44: where set_rec_id = p_set_rec_id;
45: exception
46: when no_data_found then
47: x_ret_status := FND_API.G_RET_STS_ERROR;
48: fnd_message.set_name('CS', 'CS_KB_C_INVALID_SET_ID');
49: fnd_msg_pub.add;
50: FND_MSG_PUB.Count_And_Get(
51: p_count => x_msg_count,
52: p_data => x_msg_data );

Line 71: fnd_message.set_name('CS', 'CS_KB_C_REC_SET_NO_HIGHER');

67: and sv.status = 'PUB'
68: and sr.set_order < l_order );
69: if(l_prev_order is null) then
70: x_ret_status := FND_API.G_RET_STS_ERROR;
71: fnd_message.set_name('CS', 'CS_KB_C_REC_SET_NO_HIGHER');
72: fnd_msg_pub.add;
73: FND_MSG_PUB.Count_And_Get(
74: p_count => x_msg_count,
75: p_data => x_msg_data );

Line 104: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');

100: begin
101: -- Validate params
102: if(P_SET_REC_ID is null ) then
103: x_ret_status := FND_API.G_RET_STS_ERROR;
104: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
105: fnd_msg_pub.add;
106: FND_MSG_PUB.Count_And_Get(
107: p_count => x_msg_count,
108: p_data => x_msg_data );

Line 120: fnd_message.set_name('CS', 'CS_KB_C_INVALID_SET_ID');

116: where set_rec_id = p_set_rec_id;
117: exception
118: when no_data_found then
119: x_ret_status := FND_API.G_RET_STS_ERROR;
120: fnd_message.set_name('CS', 'CS_KB_C_INVALID_SET_ID');
121: fnd_msg_pub.add;
122: FND_MSG_PUB.Count_And_Get(
123: p_count => x_msg_count,
124: p_data => x_msg_data );

Line 143: fnd_message.set_name('CS', 'CS_KB_C_REC_SET_NO_LOWER');

139: and sv.status = 'PUB'
140: and sr.set_order > l_order );
141: if(l_next_order is null) then
142: x_ret_status := FND_API.G_RET_STS_ERROR;
143: fnd_message.set_name('CS', 'CS_KB_C_REC_SET_NO_LOWER');
144: fnd_msg_pub.add;
145: FND_MSG_PUB.Count_And_Get(
146: p_count => x_msg_count,
147: p_data => x_msg_data );

Line 208: fnd_message.set_name('CS', 'CS_KB_C_REC_SET_ERR');

204: select count(*) into l_count
205: from cs_kb_set_recs
206: where set_rec_id = p_set_rec_id;
207: if( l_count > 0 ) then
208: fnd_message.set_name('CS', 'CS_KB_C_REC_SET_ERR');
209: fnd_msg_pub.add;
210: FND_MSG_PUB.Count_And_Get(
211: p_count => x_msg_count,
212: p_data => x_msg_data );

Line 230: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');

226: select cs_kb_set_recs_s.nextval into l_set_rec_id from dual;
227: end if;
228:
229: if(P_SET_NUMBER is null) then
230: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
231: fnd_msg_pub.add;
232: FND_MSG_PUB.Count_And_Get(
233: p_count => x_msg_count,
234: p_data => x_msg_data );

Line 248: fnd_message.set_name('CS', 'CS_KB_C_INVALID_SET_ID');

244: and viewable_version_flag = 'Y'
245: and status = 'PUB';
246: exception
247: when no_data_found then
248: fnd_message.set_name('CS', 'CS_KB_C_INVALID_SET_ID');
249: fnd_msg_pub.add;
250: FND_MSG_PUB.Count_And_Get(
251: p_count => x_msg_count,
252: p_data => x_msg_data );

Line 262: fnd_message.set_name('CS', 'CS_KB_C_REC_SET_EXIST');

258: select count(*) into l_count
259: from cs_kb_set_recs
260: where set_number = p_set_number;
261: if(l_count>0) then
262: fnd_message.set_name('CS', 'CS_KB_C_REC_SET_EXIST');
263: fnd_msg_pub.add;
264: FND_MSG_PUB.Count_And_Get(
265: p_count => x_msg_count,
266: p_data => x_msg_data );

Line 281: fnd_message.set_name('CS', 'CS_KB_C_REC_SET_INVALID_ORDER');

277: l_set_order := p_set_order;
278: select count(*) into l_count from cs_kb_set_recs
279: where set_order = l_set_order;
280: if( l_count > 0 ) then
281: fnd_message.set_name('CS', 'CS_KB_C_REC_SET_INVALID_ORDER');
282: fnd_msg_pub.add;
283: FND_MSG_PUB.Count_And_Get(
284: p_count => x_msg_count,
285: p_data => x_msg_data );

Line 341: fnd_message.set_name('CS', 'CS_KB_C_REC_SET_ERR');

337: return;
338: exception
339: when others then
340: x_ret_status := FND_API.G_RET_STS_ERROR;
341: fnd_message.set_name('CS', 'CS_KB_C_REC_SET_ERR');
342: fnd_msg_pub.add;
343: FND_MSG_PUB.Count_And_Get(
344: p_count => x_msg_count,
345: p_data => x_msg_data );

Line 387: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');

383: begin
384:
385: -- validate params
386: if(P_SET_NUMBER is null OR P_SET_ORDER is null) then
387: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
388: fnd_msg_pub.add;
389: FND_MSG_PUB.Count_And_Get(
390: p_count => x_msg_count,
391: p_data => x_msg_data );

Line 463: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');

459: x_ret_status := FND_API.G_RET_STS_ERROR;
460:
461: -- check params
462: if (p_set_rec_id is null) then
463: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
464: fnd_msg_pub.add;
465: FND_MSG_PUB.Count_And_Get(
466: p_count => x_msg_count,
467: p_data => x_msg_data );

Line 475: fnd_message.set_name('CS', 'CS_KB_C_INVALID_SET_ID');

471: -- validate params
472: select count(*) into l_count from cs_kb_set_recs
473: where set_rec_id = p_set_rec_id;
474: if(l_count = 0 ) then
475: fnd_message.set_name('CS', 'CS_KB_C_INVALID_SET_ID');
476: fnd_msg_pub.add;
477: FND_MSG_PUB.Count_And_Get(
478: p_count => x_msg_count,
479: p_data => x_msg_data );