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.IBC_CITEM_PREVIEW_PVT dependencies on FND_API

Line 35: IF FND_API.to_Boolean( p_init_msg_list ) THEN

31: and CITEM_VERSION_STATUS = IBC_UTILITIES_PUB.G_STV_APPROVED);
32:
33: BEGIN
34: -- Initialize message list if p_init_msg_list is set to TRUE.
35: IF FND_API.to_Boolean( p_init_msg_list ) THEN
36: FND_MSG_PUB.initialize;
37: END IF;
38: -- Initialize API return status to success
39: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 39: x_return_status := FND_API.G_RET_STS_SUCCESS;

35: IF FND_API.to_Boolean( p_init_msg_list ) THEN
36: FND_MSG_PUB.initialize;
37: END IF;
38: -- Initialize API return status to success
39: x_return_status := FND_API.G_RET_STS_SUCCESS;
40:
41: IF (p_latest_component_versions = FND_API.G_TRUE) THEN
42: OPEN Get_Latest_Version;
43: FETCH Get_Latest_Version INTO x_citem_version_id, x_version_number,

Line 41: IF (p_latest_component_versions = FND_API.G_TRUE) THEN

37: END IF;
38: -- Initialize API return status to success
39: x_return_status := FND_API.G_RET_STS_SUCCESS;
40:
41: IF (p_latest_component_versions = FND_API.G_TRUE) THEN
42: OPEN Get_Latest_Version;
43: FETCH Get_Latest_Version INTO x_citem_version_id, x_version_number,
44: x_start_date, x_end_date;
45: CLOSE Get_Latest_Version;

Line 54: WHEN FND_API.G_EXC_ERROR THEN

50: CLOSE Get_Latest_Approved_Version;
51: END IF;
52:
53: EXCEPTION
54: WHEN FND_API.G_EXC_ERROR THEN
55: x_return_status := FND_API.G_RET_STS_ERROR;
56: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
57: p_data => x_msg_data);
58: END Get_Citem_Version;

Line 55: x_return_status := FND_API.G_RET_STS_ERROR;

51: END IF;
52:
53: EXCEPTION
54: WHEN FND_API.G_EXC_ERROR THEN
55: x_return_status := FND_API.G_RET_STS_ERROR;
56: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
57: p_data => x_msg_data);
58: END Get_Citem_Version;
59:

Line 103: l_has_component_items VARCHAR2(1) := FND_API.g_false;

99: l_comp_citem_version_number NUMBER;
100: l_comp_citem_start_date DATE;
101: l_comp_citem_end_date DATE;
102: l_tmp_num_levels NUMBER;
103: l_has_component_items VARCHAR2(1) := FND_API.g_false;
104: l_max_num_levels_loaded NUMBER := 0;
105: --
106: CURSOR Get_Citem IS
107: select CONTENT_TYPE_CODE, ITEM_REFERENCE_CODE, ENCRYPT_FLAG

Line 134: IF FND_API.to_Boolean( p_init_msg_list ) THEN

130: order by r.SORT_ORDER;
131:
132: BEGIN
133: -- Initialize message list if p_init_msg_list is set to TRUE.
134: IF FND_API.to_Boolean( p_init_msg_list ) THEN
135: FND_MSG_PUB.initialize;
136: END IF;
137: -- Initialize API return status to success
138: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 138: x_return_status := FND_API.G_RET_STS_SUCCESS;

134: IF FND_API.to_Boolean( p_init_msg_list ) THEN
135: FND_MSG_PUB.initialize;
136: END IF;
137: -- Initialize API return status to success
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139:
140: -- **************** Real Logic Starts *****************
141:
142: -- Retrieve Content Item

Line 152: RAISE FND_API.G_EXC_ERROR;

148: FND_MESSAGE.Set_Name('IBC', 'INVALID_CITEM_ID');
149: FND_MESSAGE.Set_token('CITEM_ID', p_content_item_id);
150: FND_MSG_PUB.ADD;
151: END IF;
152: RAISE FND_API.G_EXC_ERROR;
153: END IF;
154: CLOSE Get_Citem;
155:
156: -- Retrieve Meta Data

Line 170: RAISE FND_API.G_EXC_ERROR;

166: FND_MESSAGE.Set_Name('IBC', 'INVALID_CITEM_VERSION_ID');
167: FND_MESSAGE.Set_token('CITEM_VERSION_ID', p_citem_version_id);
168: FND_MSG_PUB.ADD;
169: END IF;
170: RAISE FND_API.G_EXC_ERROR;
171: END IF;
172: CLOSE Get_Citem_Meta_Csr;
173:
174: IF (p_version_number is NULL) THEN

Line 202: p_is_preview => FND_API.G_TRUE,

198: p_attachment_attribute_code => l_attachment_attribute_code,
199: p_attachment_file_id => l_attachment_file_id,
200: p_attachment_file_name => l_attachment_file_name,
201: p_default_mime_type => l_default_mime_type,
202: p_is_preview => FND_API.G_TRUE,
203: p_xml_clob_loc => p_xml_clob_loc
204: );
205: -- User defined primitive attributes
206: IBC_UTILITIES_PVT.Build_Attribute_Bundle (

Line 216: l_has_component_items := FND_API.g_true;

212:
213: -- compound items expanded
214: FOR compound_item_rec IN Get_Compound_Item_Ref LOOP
215:
216: l_has_component_items := FND_API.g_true;
217: l_comp_content_item_id := compound_item_rec.content_item_id;
218: l_comp_citem_version_id := compound_item_rec.subitem_version_id;
219:
220: IF (p_preview_mode = IBC_CITEM_PREVIEW_GRP.G_LATEST_COMP_VERSIONS OR

Line 228: p_latest_component_versions => FND_API.G_TRUE,

224: -- if default versions specified, but value not set, also use latest versions.
225: Get_Citem_Version (
226: p_init_msg_list => p_init_msg_list,
227: p_content_item_id => l_comp_content_item_id,
228: p_latest_component_versions => FND_API.G_TRUE,
229: x_citem_version_id => l_comp_citem_version_id,
230: x_version_number => l_comp_citem_version_number,
231: x_start_date => l_comp_citem_start_date,
232: x_end_date => l_comp_citem_end_date,

Line 240: p_latest_component_versions => FND_API.G_FALSE,

236: ELSIF (p_preview_mode = IBC_CITEM_PREVIEW_GRP.G_LIVE_COMP_VERSIONS) THEN
237: Get_Citem_Version (
238: p_init_msg_list => p_init_msg_list,
239: p_content_item_id => l_comp_content_item_id,
240: p_latest_component_versions => FND_API.G_FALSE,
241: x_citem_version_id => l_comp_citem_version_id,
242: x_version_number => l_comp_citem_version_number,
243: x_start_date => l_comp_citem_start_date,
244: x_end_date => l_comp_citem_end_date,

Line 292: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

288: ,x_msg_count
289: ,x_msg_data
290: );
291: -- nested compounded items not valid
292: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
293: RAISE FND_API.G_EXC_ERROR;
294: END IF;
295:
296: IBC_UTILITIES_PVT.Build_Close_Tag (

Line 293: RAISE FND_API.G_EXC_ERROR;

289: ,x_msg_data
290: );
291: -- nested compounded items not valid
292: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
293: RAISE FND_API.G_EXC_ERROR;
294: END IF;
295:
296: IBC_UTILITIES_PVT.Build_Close_Tag (
297: compound_item_rec.attribute_type_code,

Line 312: IF (l_has_component_items = FND_API.g_false) THEN

308:
309: END LOOP;
310:
311: -- set number of levels loaded
312: IF (l_has_component_items = FND_API.g_false) THEN
313: x_num_levels_loaded := 0;
314: ELSE
315: x_num_levels_loaded := l_max_num_levels_loaded + 1;
316: END IF;

Line 338: WHEN FND_API.G_EXC_ERROR THEN

334: );
335: -- **************** Real Logic Ends *****************
336:
337: EXCEPTION
338: WHEN FND_API.G_EXC_ERROR THEN
339: x_return_status := FND_API.G_RET_STS_ERROR;
340: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
341: p_data => x_msg_data);
342: END Preview_Citem_Xml;

Line 339: x_return_status := FND_API.G_RET_STS_ERROR;

335: -- **************** Real Logic Ends *****************
336:
337: EXCEPTION
338: WHEN FND_API.G_EXC_ERROR THEN
339: x_return_status := FND_API.G_RET_STS_ERROR;
340: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
341: p_data => x_msg_data);
342: END Preview_Citem_Xml;
343: