20: --******** local variable for standards **********
21: l_api_name CONSTANT VARCHAR2(30) := 'Preview_Citem_Basic_Xml';
22: l_api_version CONSTANT NUMBER := 1.0;
23: --
24: l_latest_component_versions VARCHAR2(1) := FND_API.G_TRUE;
25: x_num_levels_loaded NUMBER;
26: l_xml_encoding VARCHAR2(50);
27: BEGIN
28: -- ******* Standard Begins ********
27: BEGIN
28: -- ******* Standard Begins ********
29:
30: -- Standard call to check for call compatibility.
31: IF NOT FND_API.Compatible_API_Call (
32: l_api_version,
33: p_api_version,
34: l_api_name,
35: G_PKG_NAME)
33: p_api_version,
34: l_api_name,
35: G_PKG_NAME)
36: THEN
37: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
38: END IF;
39: -- Initialize message list if p_init_msg_list is set to TRUE.
40: IF FND_API.to_Boolean( p_init_msg_list )
41: THEN
36: THEN
37: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
38: END IF;
39: -- Initialize message list if p_init_msg_list is set to TRUE.
40: IF FND_API.to_Boolean( p_init_msg_list )
41: THEN
42: FND_MSG_PUB.initialize;
43: END IF;
44:
42: FND_MSG_PUB.initialize;
43: END IF;
44:
45: -- Initialize API return status to success
46: x_return_status := FND_API.G_RET_STS_SUCCESS;
47:
48: --******************* Real Logic Start *********************
49:
50: DBMS_LOB.CREATETEMPORARY(x_content_item_xml, TRUE);
66: x_msg_count => x_msg_count,
67: x_msg_data => x_msg_data
68: );
69: -- Content Item is not valid
70: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
71: RAISE FND_API.G_EXC_ERROR;
72: END IF;
73:
74: --******************* Real Logic End *********************
67: x_msg_data => x_msg_data
68: );
69: -- Content Item is not valid
70: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
71: RAISE FND_API.G_EXC_ERROR;
72: END IF;
73:
74: --******************* Real Logic End *********************
75:
76: -- Standard call to get message count and if count=1, get the message
77: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
78: p_data => x_msg_data);
79: EXCEPTION
80: WHEN FND_API.G_EXC_ERROR THEN
81: x_return_status := FND_API.G_RET_STS_ERROR;
82: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
83: p_data => x_msg_data);
84: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
77: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
78: p_data => x_msg_data);
79: EXCEPTION
80: WHEN FND_API.G_EXC_ERROR THEN
81: x_return_status := FND_API.G_RET_STS_ERROR;
82: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
83: p_data => x_msg_data);
84: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
85: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
80: WHEN FND_API.G_EXC_ERROR THEN
81: x_return_status := FND_API.G_RET_STS_ERROR;
82: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
83: p_data => x_msg_data);
84: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
85: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
86: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
87: p_data => x_msg_data);
88: WHEN OTHERS THEN
81: x_return_status := FND_API.G_RET_STS_ERROR;
82: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
83: p_data => x_msg_data);
84: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
85: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
86: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
87: p_data => x_msg_data);
88: WHEN OTHERS THEN
89: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
85: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
86: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
87: p_data => x_msg_data);
88: WHEN OTHERS THEN
89: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
90: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
91: THEN
92: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
93: END IF;
119: BEGIN
120: -- ******* Standard Begins ********
121:
122: -- Standard call to check for call compatibility.
123: IF NOT FND_API.Compatible_API_Call (
124: l_api_version,
125: p_api_version,
126: l_api_name,
127: G_PKG_NAME)
125: p_api_version,
126: l_api_name,
127: G_PKG_NAME)
128: THEN
129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
130: END IF;
131: -- Initialize message list if p_init_msg_list is set to TRUE.
132: IF FND_API.to_Boolean( p_init_msg_list )
133: THEN
128: THEN
129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
130: END IF;
131: -- Initialize message list if p_init_msg_list is set to TRUE.
132: IF FND_API.to_Boolean( p_init_msg_list )
133: THEN
134: FND_MSG_PUB.initialize;
135: END IF;
136:
134: FND_MSG_PUB.initialize;
135: END IF;
136:
137: -- Initialize API return status to success
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139:
140: --******************* Real Logic Start *********************
141:
142: DBMS_LOB.CREATETEMPORARY(x_content_item_xml, TRUE);
162: x_msg_count => x_msg_count,
163: x_msg_data => x_msg_data
164: );
165: -- Content Item is not valid
166: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
167: RAISE FND_API.G_EXC_ERROR;
168: END IF;
169:
170: --******************* Real Logic End *********************
163: x_msg_data => x_msg_data
164: );
165: -- Content Item is not valid
166: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
167: RAISE FND_API.G_EXC_ERROR;
168: END IF;
169:
170: --******************* Real Logic End *********************
171:
172: -- Standard call to get message count and if count=1, get the message
173: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
174: p_data => x_msg_data);
175: EXCEPTION
176: WHEN FND_API.G_EXC_ERROR THEN
177: x_return_status := FND_API.G_RET_STS_ERROR;
178: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
179: p_data => x_msg_data);
180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
173: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
174: p_data => x_msg_data);
175: EXCEPTION
176: WHEN FND_API.G_EXC_ERROR THEN
177: x_return_status := FND_API.G_RET_STS_ERROR;
178: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
179: p_data => x_msg_data);
180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176: WHEN FND_API.G_EXC_ERROR THEN
177: x_return_status := FND_API.G_RET_STS_ERROR;
178: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
179: p_data => x_msg_data);
180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
183: p_data => x_msg_data);
184: WHEN OTHERS THEN
177: x_return_status := FND_API.G_RET_STS_ERROR;
178: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
179: p_data => x_msg_data);
180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
183: p_data => x_msg_data);
184: WHEN OTHERS THEN
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
183: p_data => x_msg_data);
184: WHEN OTHERS THEN
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
186: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
187: THEN
188: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
189: END IF;