DBA Data[Home] [Help]

APPS.IBC_CITEM_PREVIEW_GRP dependencies on FND_API

Line 24: l_latest_component_versions VARCHAR2(1) := FND_API.G_TRUE;

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 ********

Line 31: IF NOT FND_API.Compatible_API_Call (

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)

Line 37: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 40: IF FND_API.to_Boolean( p_init_msg_list )

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:

Line 46: x_return_status := FND_API.G_RET_STS_SUCCESS;

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);

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

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 *********************

Line 71: RAISE FND_API.G_EXC_ERROR;

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:

Line 80: WHEN FND_API.G_EXC_ERROR THEN

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

Line 81: x_return_status := FND_API.G_RET_STS_ERROR;

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;

Line 84: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 85: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;

Line 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;

Line 123: IF NOT FND_API.Compatible_API_Call (

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)

Line 129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 132: IF FND_API.to_Boolean( p_init_msg_list )

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:

Line 138: x_return_status := FND_API.G_RET_STS_SUCCESS;

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);

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

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 *********************

Line 167: RAISE FND_API.G_EXC_ERROR;

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:

Line 176: WHEN FND_API.G_EXC_ERROR THEN

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

Line 177: x_return_status := FND_API.G_RET_STS_ERROR;

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;

Line 180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;

Line 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;