89: END IF;
90: -- Initialize message list if p_init_msg_list is set to TRUE.
91: IF FND_API.to_Boolean( p_init_msg_list )
92: THEN
93: FND_MSG_PUB.initialize;
94: END IF;
95:
96: -- Initialize API return status to success
97: x_return_status := FND_API.G_RET_STS_SUCCESS;
129: THEN
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
132: FND_MESSAGE.Set_Token('INPUT', 'p_content_item_id/p_citem_ver_id', FALSE);
133: FND_MSG_PUB.ADD;
134: RAISE FND_API.G_EXC_ERROR;
135: END IF;
136:
137: IF IBC_VALIDATE_PVT.isvalidlanguage(l_language) = FND_API.g_false THEN
137: IF IBC_VALIDATE_PVT.isvalidlanguage(l_language) = FND_API.g_false THEN
138: x_return_status := FND_API.G_RET_STS_ERROR;
139: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
140: FND_MESSAGE.Set_Token('INPUT', 'p_language', FALSE);
141: FND_MSG_PUB.ADD;
142: RAISE FND_API.G_EXC_ERROR;
143: END IF;
144:
145: OPEN Get_File_Id(l_citem_ver_id, l_language, l_mime_type);
148: IF Get_File_Id%NOTFOUND THEN
149: x_return_status := FND_API.G_RET_STS_ERROR;
150: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
151: FND_MESSAGE.Set_Token('INPUT', 'p_language/p_mime_type', FALSE);
152: FND_MSG_PUB.ADD;
153: CLOSE Get_File_id;
154: RAISE FND_API.G_EXC_ERROR;
155: END IF;
156: CLOSE Get_File_Id;
159:
160: --******************* Real Logic End ***********************
161:
162: -- Standard call to get message count and if count=1, get the message
163: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
164: p_data => x_msg_data);
165: EXCEPTION
166: WHEN FND_API.G_EXC_ERROR THEN
167: x_return_status := FND_API.G_RET_STS_ERROR;
164: p_data => x_msg_data);
165: EXCEPTION
166: WHEN FND_API.G_EXC_ERROR THEN
167: x_return_status := FND_API.G_RET_STS_ERROR;
168: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
169: p_data => x_msg_data);
170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
168: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
169: p_data => x_msg_data);
170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
173: p_data => x_msg_data);
174: WHEN OTHERS THEN
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
172: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
173: p_data => x_msg_data);
174: WHEN OTHERS THEN
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
177: THEN
178: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
179: END IF;
180: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
174: WHEN OTHERS THEN
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
177: THEN
178: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
179: END IF;
180: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
181: p_data => x_msg_data);
182: END Get_Rendition_File_Id;
176: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
177: THEN
178: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
179: END IF;
180: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
181: p_data => x_msg_data);
182: END Get_Rendition_File_Id;
183:
184: -- --------------------------------------------------------------
260: END IF;
261: -- Initialize message list if p_init_msg_list is set to TRUE.
262: IF FND_API.to_Boolean( p_init_msg_list )
263: THEN
264: FND_MSG_PUB.initialize;
265: END IF;
266:
267: -- Initialize API return status to success
268: x_return_status := FND_API.G_RET_STS_SUCCESS;
282: IF c_dirpath%NOTFOUND THEN
283: x_return_status := FND_API.G_RET_STS_ERROR;
284: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
285: FND_MESSAGE.Set_Token('INPUT', 'p_content_item_id', FALSE);
286: FND_MSG_PUB.ADD;
287: RAISE FND_API.G_EXC_ERROR;
288: END IF;
289: CLOSE c_dirpath;
290: ELSE
320: END IF;
321:
322: --******************* Real Logic End ***********************
323: -- Standard call to get message count and if count=1, get the message
324: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
325: p_data => x_msg_data);
326: EXCEPTION
327: WHEN FND_API.G_EXC_ERROR THEN
328: x_return_status := FND_API.G_RET_STS_ERROR;
325: p_data => x_msg_data);
326: EXCEPTION
327: WHEN FND_API.G_EXC_ERROR THEN
328: x_return_status := FND_API.G_RET_STS_ERROR;
329: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
330: p_data => x_msg_data);
331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
333: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
329: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
330: p_data => x_msg_data);
331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
333: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
334: p_data => x_msg_data);
335: WHEN OTHERS THEN
336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
337: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
333: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
334: p_data => x_msg_data);
335: WHEN OTHERS THEN
336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
337: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
338: THEN
339: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
340: END IF;
341: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
335: WHEN OTHERS THEN
336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
337: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
338: THEN
339: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
340: END IF;
341: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
342: p_data => x_msg_data);
343: END Get_Accessible_Content_Items;
337: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
338: THEN
339: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
340: END IF;
341: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
342: p_data => x_msg_data);
343: END Get_Accessible_Content_Items;
344:
345: -- --------------------------------------------------------------
403: END IF;
404: -- Initialize message list if p_init_msg_list is set to TRUE.
405: IF FND_API.to_Boolean( p_init_msg_list )
406: THEN
407: FND_MSG_PUB.initialize;
408: END IF;
409:
410: -- Initialize API return status to success
411: x_return_status := FND_API.G_RET_STS_SUCCESS;
432: END IF;
433:
434: --******************* Real Logic End ***********************
435: -- Standard call to get message count and if count=1, get the message
436: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
437: p_data => x_msg_data);
438: EXCEPTION
439: WHEN FND_API.G_EXC_ERROR THEN
440: x_return_status := FND_API.G_RET_STS_ERROR;
437: p_data => x_msg_data);
438: EXCEPTION
439: WHEN FND_API.G_EXC_ERROR THEN
440: x_return_status := FND_API.G_RET_STS_ERROR;
441: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
442: p_data => x_msg_data);
443: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
445: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
441: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
442: p_data => x_msg_data);
443: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
445: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
446: p_data => x_msg_data);
447: WHEN OTHERS THEN
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
449: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
445: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
446: p_data => x_msg_data);
447: WHEN OTHERS THEN
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
449: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
450: THEN
451: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
452: END IF;
453: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
447: WHEN OTHERS THEN
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
449: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
450: THEN
451: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
452: END IF;
453: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
454: p_data => x_msg_data);
455: END Get_citem_Stylesheets;
449: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
450: THEN
451: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
452: END IF;
453: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
454: p_data => x_msg_data);
455: END Get_citem_Stylesheets;
456:
457: