DBA Data[Home] [Help]

APPS.BIS_RSS_PORTLETS_PUB dependencies on FND_API

Line 34: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

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
38: l_commit := p_Commit;

Line 36: l_commit := FND_API.G_FALSE;

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
38: l_commit := p_Commit;
39: END IF;
40:

Line 93: IF (l_commit = FND_API.G_TRUE) THEN

89: FROM bis_rss_portlets_tl
90: WHERE portlet_short_name = p_Rss_Portlet_Rec.Portlet_Short_Name
91: AND language = l.language_code);
92:
93: IF (l_commit = FND_API.G_TRUE) THEN
94: COMMIT;
95: END IF;
96:
97: EXCEPTION

Line 98: WHEN FND_API.G_EXC_ERROR THEN

94: COMMIT;
95: END IF;
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

Line 99: x_return_status := FND_API.G_RET_STS_ERROR;

95: END IF;
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;

Line 102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
105: ,p_data => x_msg_data);
106: WHEN NO_DATA_FOUND THEN

Line 103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
105: ,p_data => x_msg_data);
106: WHEN NO_DATA_FOUND THEN
107: x_return_status := FND_API.G_RET_STS_ERROR;

Line 107: x_return_status := FND_API.G_RET_STS_ERROR;

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
109: ,p_data => x_msg_data);
110: WHEN OTHERS THEN
111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
113: ,p_data => x_msg_data);
114: if (x_msg_data is null) then
115: x_msg_data := SQLERRM;

Line 130: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

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
134: UPDATE bis_rss_portlets_tl

Line 150: IF (p_Commit = FND_API.G_TRUE) THEN

146: WHEN OTHERS THEN NULL;
147: END;
148: END IF;
149:
150: IF (p_Commit = FND_API.G_TRUE) THEN
151: COMMIT;
152: END IF;
153:
154:

Line 156: WHEN FND_API.G_EXC_ERROR THEN

152: END IF;
153:
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

Line 157: x_return_status := FND_API.G_RET_STS_ERROR;

153:
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;

Line 160: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
163: ,p_data => x_msg_data);
164: WHEN NO_DATA_FOUND THEN

Line 161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
163: ,p_data => x_msg_data);
164: WHEN NO_DATA_FOUND THEN
165: x_return_status := FND_API.G_RET_STS_ERROR;

Line 165: x_return_status := FND_API.G_RET_STS_ERROR;

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
167: ,p_data => x_msg_data);
168: WHEN OTHERS THEN
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
171: ,p_data => x_msg_data);
172: IF (x_msg_data IS NULL) THEN
173: x_msg_data := SQLERRM;