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.CS_KB_SET_RECS_PKG dependencies on FND_MSG_PUB

Line 33: fnd_msg_pub.add;

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 );
37: return;

Line 34: FND_MSG_PUB.Count_And_Get(

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 );
37: return;
38: end if;

Line 49: fnd_msg_pub.add;

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 );
53: return;

Line 50: FND_MSG_PUB.Count_And_Get(

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 );
53: return;
54: end;

Line 72: fnd_msg_pub.add;

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 );
76: return;

Line 73: FND_MSG_PUB.Count_And_Get(

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 );
76: return;
77: end if;

Line 105: fnd_msg_pub.add;

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 );
109: return;

Line 106: FND_MSG_PUB.Count_And_Get(

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 );
109: return;
110: end if;

Line 121: fnd_msg_pub.add;

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 );
125: return;

Line 122: FND_MSG_PUB.Count_And_Get(

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 );
125: return;
126: end;

Line 144: fnd_msg_pub.add;

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 );
148: return;

Line 145: FND_MSG_PUB.Count_And_Get(

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 );
148: return;
149: end if;

Line 209: fnd_msg_pub.add;

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 );
213: return;

Line 210: FND_MSG_PUB.Count_And_Get(

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 );
213: return;
214: end if;

Line 231: fnd_msg_pub.add;

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 );
235: return;

Line 232: FND_MSG_PUB.Count_And_Get(

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 );
235: return;
236: end if;

Line 249: fnd_msg_pub.add;

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 );
253: return;

Line 250: FND_MSG_PUB.Count_And_Get(

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 );
253: return;
254: end;

Line 263: fnd_msg_pub.add;

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 );
267: return;

Line 264: FND_MSG_PUB.Count_And_Get(

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 );
267: return;
268: end if;

Line 282: fnd_msg_pub.add;

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 );
286: return;

Line 283: FND_MSG_PUB.Count_And_Get(

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 );
286: return;
287: end if;

Line 342: fnd_msg_pub.add;

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 );
346: return;

Line 343: FND_MSG_PUB.Count_And_Get(

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 );
346: return;
347: END Create_Set_Rec;

Line 388: fnd_msg_pub.add;

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 );
392: goto error_found;

Line 389: FND_MSG_PUB.Count_And_Get(

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 );
392: goto error_found;
393: end if;

Line 464: fnd_msg_pub.add;

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 );
468: return;

Line 465: FND_MSG_PUB.Count_And_Get(

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 );
468: return;
469: end if;

Line 476: fnd_msg_pub.add;

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 );
480: return;

Line 477: FND_MSG_PUB.Count_And_Get(

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 );
480: return;
481: end if;