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