[Home] [Help]
85: AND PREFERENCE_CODE = G_PREFERENCE_CODE
86: AND PARTY_ID = p_party_id;
87:
88: IF l_bookmark_num < l_bookmark_limit THEN
89: HZ_PREFERENCE_PUB.Add(
90: p_party_id,
91: l_category,
92: G_PREFERENCE_CODE,
93: FND_API.G_MISS_CHAR,
116: p_data => x_msg_data);
117: END IF;
118:
119: EXCEPTION
120: /* Exceptions may be raised from HZ_PREFERENCE_PUB */
121: WHEN FND_API.G_EXC_ERROR THEN
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: FND_MSG_PUB.Count_And_Get(
124: p_encoded => FND_API.G_FALSE,
212: x_return_status := l_return_status;
213: END IF;
214:
215: EXCEPTION
216: /* Exceptions may be raised from HZ_PREFERENCE_PUB */
217: WHEN FND_API.G_EXC_ERROR THEN
218: x_return_status := FND_API.G_RET_STS_ERROR;
219: FND_MSG_PUB.Count_And_Get(
220: p_encoded => FND_API.G_FALSE,
285: where user_id = p_party_id;
286: END IF;
287:
288:
289: HZ_PREFERENCE_PUB.Remove(
290: l_user_id,
291: l_category,
292: G_PREFERENCE_CODE,
293: FND_API.G_MISS_CHAR,
303:
304: END IF;
305:
306: EXCEPTION
307: /* Exceptions may be raised from HZ_PREFERENCE_PUB */
308: WHEN FND_API.G_EXC_ERROR THEN
309: x_return_status := FND_API.G_RET_STS_ERROR;
310: FND_MSG_PUB.Count_And_Get(
311: p_encoded => FND_API.G_FALSE,
439: from fnd_user
440: where user_id = p_party_id;
441: END IF;
442:
443: l_ret := HZ_PREFERENCE_PUB.Contains_Value(
444: l_user_id,
445: l_category,
446: G_PREFERENCE_CODE,
447: p_bookmarked_party_id);
448:
449: RETURN l_ret;
450:
451: EXCEPTION
452: /* Exceptions may be raised from HZ_PREFERENCE_PUB */
453: WHEN FND_API.G_EXC_ERROR THEN
454: RETURN FND_API.G_RET_STS_ERROR;
455:
456: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN