29: )
30: IS
31: l_commit VARCHAR2(30);
32: BEGIN
33: FND_MSG_PUB.Initialize;
34: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
35: IF p_Commit IS NULL THEN
36: l_commit := FND_API.G_FALSE;
37: ELSE
96:
97: EXCEPTION
98: WHEN FND_API.G_EXC_ERROR THEN
99: x_return_status := FND_API.G_RET_STS_ERROR;
100: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
101: ,p_data => x_msg_data);
102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
104: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
100: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
101: ,p_data => x_msg_data);
102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
104: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
105: ,p_data => x_msg_data);
106: WHEN NO_DATA_FOUND THEN
107: x_return_status := FND_API.G_RET_STS_ERROR;
108: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
104: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
105: ,p_data => x_msg_data);
106: WHEN NO_DATA_FOUND THEN
107: x_return_status := FND_API.G_RET_STS_ERROR;
108: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
109: ,p_data => x_msg_data);
110: WHEN OTHERS THEN
111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
112: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
108: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
109: ,p_data => x_msg_data);
110: WHEN OTHERS THEN
111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
112: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
113: ,p_data => x_msg_data);
114: if (x_msg_data is null) then
115: x_msg_data := SQLERRM;
116: end if;
125: ) IS
126:
127: BEGIN
128:
129: FND_MSG_PUB.Initialize;
130: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
131:
132: IF p_Rss_Portlet_Rec.Portlet_Short_Name IS NOT NULL THEN
133: BEGIN
154:
155: EXCEPTION
156: WHEN FND_API.G_EXC_ERROR THEN
157: x_return_status := FND_API.G_RET_STS_ERROR;
158: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
159: ,p_data => x_msg_data);
160: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
162: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
158: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
159: ,p_data => x_msg_data);
160: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
162: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
163: ,p_data => x_msg_data);
164: WHEN NO_DATA_FOUND THEN
165: x_return_status := FND_API.G_RET_STS_ERROR;
166: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
162: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
163: ,p_data => x_msg_data);
164: WHEN NO_DATA_FOUND THEN
165: x_return_status := FND_API.G_RET_STS_ERROR;
166: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
167: ,p_data => x_msg_data);
168: WHEN OTHERS THEN
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
170: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
166: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
167: ,p_data => x_msg_data);
168: WHEN OTHERS THEN
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
170: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
171: ,p_data => x_msg_data);
172: IF (x_msg_data IS NULL) THEN
173: x_msg_data := SQLERRM;
174: END IF;