DBA Data[Home] [Help]

APPS.BIS_PMV_PARAMETERS_PUB dependencies on FND_API

Line 29: WHEN FND_API.G_EXC_ERROR THEN

25: WHERE attribute_name = p_parameter_rec.parameter_name
26: AND user_id = p_page_session_rec.user_id
27: AND page_id = p_page_session_rec.page_id;
28: EXCEPTION
29: WHEN FND_API.G_EXC_ERROR THEN
30: x_return_status := FND_API.G_RET_STS_ERROR;
31: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
32: x_msg_data);
33: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 30: x_return_status := FND_API.G_RET_STS_ERROR;

26: AND user_id = p_page_session_rec.user_id
27: AND page_id = p_page_session_rec.page_id;
28: EXCEPTION
29: WHEN FND_API.G_EXC_ERROR THEN
30: x_return_status := FND_API.G_RET_STS_ERROR;
31: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
32: x_msg_data);
33: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
34: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 33: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

29: WHEN FND_API.G_EXC_ERROR THEN
30: x_return_status := FND_API.G_RET_STS_ERROR;
31: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
32: x_msg_data);
33: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
34: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
35: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
36: x_msg_data);
37: WHEN OTHERS THEN

Line 34: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

30: x_return_status := FND_API.G_RET_STS_ERROR;
31: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
32: x_msg_data);
33: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
34: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
35: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
36: x_msg_data);
37: WHEN OTHERS THEN
38: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 38: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

34: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
35: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
36: x_msg_data);
37: WHEN OTHERS THEN
38: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
39: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
40: x_msg_data);
41: END RETRIEVE_PAGE_PARAMETER;
42:

Line 76: WHEN FND_API.G_EXC_ERROR THEN

72: x_page_param_tbl(l_index) := l_parameter_rec;
73: l_index := l_index + 1;
74: END LOOP;
75: EXCEPTION
76: WHEN FND_API.G_EXC_ERROR THEN
77: x_return_status := FND_API.G_RET_STS_ERROR;
78: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
79: x_msg_data);
80: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 77: x_return_status := FND_API.G_RET_STS_ERROR;

73: l_index := l_index + 1;
74: END LOOP;
75: EXCEPTION
76: WHEN FND_API.G_EXC_ERROR THEN
77: x_return_status := FND_API.G_RET_STS_ERROR;
78: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
79: x_msg_data);
80: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
81: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 80: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

76: WHEN FND_API.G_EXC_ERROR THEN
77: x_return_status := FND_API.G_RET_STS_ERROR;
78: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
79: x_msg_data);
80: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
81: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
82: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
83: x_msg_data);
84: WHEN OTHERS THEN

Line 81: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

77: x_return_status := FND_API.G_RET_STS_ERROR;
78: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
79: x_msg_data);
80: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
81: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
82: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
83: x_msg_data);
84: WHEN OTHERS THEN
85: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 85: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

81: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
82: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
83: x_msg_data);
84: WHEN OTHERS THEN
85: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
86: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
87: x_msg_data);
88: END RETRIEVE_PAGE_PARAMETERS;
89: FUNCTION INITIALIZE_QUERY_TYPE

Line 135: x_return_status := FND_API.G_RET_STS_SUCCESS;

131: bookmark.property_name='BOOKMARK_URL';
132:
133: BEGIN
134: FND_MSG_PUB.Initialize;
135: x_return_status := FND_API.G_RET_STS_SUCCESS;
136:
137: IF c_custom_code_cursor%ISOPEN THEN
138: CLOSE c_custom_code_cursor;
139: END IF;

Line 213: WHEN FND_API.G_EXC_ERROR THEN

209: CLOSE c_custom_code_cursor;
210: END IF;
211:
212: EXCEPTION
213: WHEN FND_API.G_EXC_ERROR THEN
214: x_return_status := FND_API.G_RET_STS_ERROR;
215: IF c_custom_code_cursor%ISOPEN THEN
216: CLOSE c_custom_code_cursor;
217: END IF;

Line 214: x_return_status := FND_API.G_RET_STS_ERROR;

210: END IF;
211:
212: EXCEPTION
213: WHEN FND_API.G_EXC_ERROR THEN
214: x_return_status := FND_API.G_RET_STS_ERROR;
215: IF c_custom_code_cursor%ISOPEN THEN
216: CLOSE c_custom_code_cursor;
217: END IF;
218: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

215: IF c_custom_code_cursor%ISOPEN THEN
216: CLOSE c_custom_code_cursor;
217: END IF;
218: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
221: IF c_custom_code_cursor%ISOPEN THEN
222: CLOSE c_custom_code_cursor;
223: END IF;

Line 220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

216: CLOSE c_custom_code_cursor;
217: END IF;
218: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
221: IF c_custom_code_cursor%ISOPEN THEN
222: CLOSE c_custom_code_cursor;
223: END IF;
224: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

222: CLOSE c_custom_code_cursor;
223: END IF;
224: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
225: WHEN OTHERS THEN
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
227: IF c_custom_code_cursor%ISOPEN THEN
228: CLOSE c_custom_code_cursor;
229: END IF;
230: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);