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_API

Line 31: x_ret_status := FND_API.G_RET_STS_ERROR;

27: l_set_rec_id_prev number;
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,

Line 47: x_ret_status := FND_API.G_RET_STS_ERROR;

43: select set_order into l_order from cs_kb_set_recs
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,

Line 70: x_ret_status := FND_API.G_RET_STS_ERROR;

66: and sv.viewable_version_flag = 'Y'
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,

Line 81: x_ret_status := FND_API.G_RET_STS_SUCCESS;

77: end if;
78:
79: Swap_Recommendation_Order(l_set_rec_id_prev, p_set_rec_id);
80:
81: x_ret_status := FND_API.G_RET_STS_SUCCESS;
82: x_msg_count := 0;
83: x_msg_data := null;
84: return;
85: end Move_Up_Solution_Rec;

Line 103: x_ret_status := FND_API.G_RET_STS_ERROR;

99: l_set_rec_id_next number;
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,

Line 119: x_ret_status := FND_API.G_RET_STS_ERROR;

115: select set_order into l_order from cs_kb_set_recs
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,

Line 142: x_ret_status := FND_API.G_RET_STS_ERROR;

138: and sv.viewable_version_flag = 'Y'
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,

Line 153: x_ret_status := FND_API.G_RET_STS_SUCCESS;

149: end if;
150:
151: Swap_Recommendation_Order(l_set_rec_id_next, p_set_rec_id);
152:
153: x_ret_status := FND_API.G_RET_STS_SUCCESS;
154: x_msg_count := 0;
155: x_msg_data := null;
156: return;
157: end Move_Down_Solution_Rec;

Line 200: x_ret_status := FND_API.G_RET_STS_ERROR;

196: l_order_seq_val number;
197: BEGIN
198: -- initialize default outputs to error
199: x_set_rec_id := 0;
200: x_ret_status := FND_API.G_RET_STS_ERROR;
201:
202: -- Check params
203: if(p_set_rec_id is not null ) then
204: select count(*) into l_count

Line 334: x_ret_status := FND_API.G_RET_STS_SUCCESS;

330: P_ATTRIBUTE11, P_ATTRIBUTE12, P_ATTRIBUTE13, P_ATTRIBUTE14, P_ATTRIBUTE15);
331:
332: -- return success
333: x_set_rec_id := l_set_rec_id;
334: x_ret_status := FND_API.G_RET_STS_SUCCESS;
335: x_msg_count := 0;
336: x_msg_data := null;
337: return;
338: exception

Line 340: x_ret_status := FND_API.G_RET_STS_ERROR;

336: x_msg_data := null;
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,

Line 459: x_ret_status := FND_API.G_RET_STS_ERROR;

455: is
456: l_count number;
457: begin
458: -- initialize default outputs to error
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');

Line 488: x_ret_status := FND_API.G_RET_STS_SUCCESS;

484: delete from CS_KB_SET_RECS
485: where SET_REC_ID = p_set_rec_id;
486:
487: -- return success
488: x_ret_status := FND_API.G_RET_STS_SUCCESS;
489: x_msg_count := 0;
490: x_msg_data := null;
491: return;
492: