108: x_return_status := l_return_status;
109: ELSE
110: x_return_status := G_MAX_REACHED_ERROR;
111: FND_MESSAGE.SET_NAME('IMC', 'IMC_MAX_BOOKMARKS_REACHED');
112: FND_MSG_PUB.ADD;
113: FND_MSG_PUB.Count_And_Get(
114: p_encoded => FND_API.G_FALSE,
115: p_count => x_msg_count,
116: p_data => x_msg_data);
109: ELSE
110: x_return_status := G_MAX_REACHED_ERROR;
111: FND_MESSAGE.SET_NAME('IMC', 'IMC_MAX_BOOKMARKS_REACHED');
112: FND_MSG_PUB.ADD;
113: FND_MSG_PUB.Count_And_Get(
114: p_encoded => FND_API.G_FALSE,
115: p_count => x_msg_count,
116: p_data => x_msg_data);
117: END IF;
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,
125: p_count => x_msg_count,
126: p_data => x_msg_data);
127:
126: p_data => x_msg_data);
127:
128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
130: FND_MSG_PUB.Count_And_Get(
131: p_encoded => FND_API.G_FALSE,
132: p_count => x_msg_count,
133: p_data => x_msg_data);
134:
135: WHEN NO_DATA_FOUND THEN
136: /* party ID of user does not exist */
137: x_return_status := FND_API.G_RET_STS_ERROR;
138: FND_MESSAGE.SET_NAME('IMC', 'IMC_INVALID_BOOKMARK_ID');
139: FND_MSG_PUB.ADD;
140: FND_MSG_PUB.Count_And_Get(
141: p_encoded => FND_API.G_FALSE,
142: p_count => x_msg_count,
143: p_data => x_msg_data);
136: /* party ID of user does not exist */
137: x_return_status := FND_API.G_RET_STS_ERROR;
138: FND_MESSAGE.SET_NAME('IMC', 'IMC_INVALID_BOOKMARK_ID');
139: FND_MSG_PUB.ADD;
140: FND_MSG_PUB.Count_And_Get(
141: p_encoded => FND_API.G_FALSE,
142: p_count => x_msg_count,
143: p_data => x_msg_data);
144:
181: IF l_hz_return_status <> FND_API.G_RET_STS_SUCCESS THEN
182: /* problem creating party for FND user */
183: x_return_status := FND_API.G_RET_STS_ERROR;
184: FND_MESSAGE.SET_NAME('IMC', 'HZ_API_OTHERS_EXCEP');
185: FND_MSG_PUB.ADD;
186: FND_MSG_PUB.Count_And_Get(
187: p_encoded => FND_API.G_FALSE,
188: p_count => x_msg_count,
189: p_data => x_msg_data);
182: /* problem creating party for FND user */
183: x_return_status := FND_API.G_RET_STS_ERROR;
184: FND_MESSAGE.SET_NAME('IMC', 'HZ_API_OTHERS_EXCEP');
185: FND_MSG_PUB.ADD;
186: FND_MSG_PUB.Count_And_Get(
187: p_encoded => FND_API.G_FALSE,
188: p_count => x_msg_count,
189: p_data => x_msg_data);
190: END IF;
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,
221: p_count => x_msg_count,
222: p_data => x_msg_data);
223:
222: p_data => x_msg_data);
223:
224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: FND_MSG_PUB.Count_And_Get(
227: p_encoded => FND_API.G_FALSE,
228: p_count => x_msg_count,
229: p_data => x_msg_data);
230:
231: WHEN NO_DATA_FOUND THEN
232: /* FND user ID does not exist */
233: x_return_status := FND_API.G_RET_STS_ERROR;
234: FND_MESSAGE.SET_NAME('IMC', 'IMC_FND_USER_NOT_EXIST');
235: FND_MSG_PUB.ADD;
236: FND_MSG_PUB.Count_And_Get(
237: p_encoded => FND_API.G_FALSE,
238: p_count => x_msg_count,
239: p_data => x_msg_data);
232: /* FND user ID does not exist */
233: x_return_status := FND_API.G_RET_STS_ERROR;
234: FND_MESSAGE.SET_NAME('IMC', 'IMC_FND_USER_NOT_EXIST');
235: FND_MSG_PUB.ADD;
236: FND_MSG_PUB.Count_And_Get(
237: p_encoded => FND_API.G_FALSE,
238: p_count => x_msg_count,
239: p_data => x_msg_data);
240: END Add_Bookmark;
259: IF l_category IS NULL THEN
260: /* bookmark ID is invalid */
261: x_return_status := FND_API.G_RET_STS_ERROR;
262: FND_MESSAGE.SET_NAME('IMC', 'IMC_INVALID_BOOKMARK_ID');
263: FND_MSG_PUB.ADD;
264: FND_MSG_PUB.Count_And_Get(
265: p_encoded => FND_API.G_FALSE,
266: p_count => x_msg_count,
267: p_data => x_msg_data);
260: /* bookmark ID is invalid */
261: x_return_status := FND_API.G_RET_STS_ERROR;
262: FND_MESSAGE.SET_NAME('IMC', 'IMC_INVALID_BOOKMARK_ID');
263: FND_MSG_PUB.ADD;
264: FND_MSG_PUB.Count_And_Get(
265: p_encoded => FND_API.G_FALSE,
266: p_count => x_msg_count,
267: p_data => x_msg_data);
268: ELSE
268: ELSE
269: IF p_user_type NOT IN (G_PARTY_USER_TYPE, G_FND_USER_TYPE) THEN
270: x_return_status := FND_API.G_RET_STS_ERROR;
271: FND_MESSAGE.SET_NAME('IMC', 'IMC_INVALID_USER_TYPE');
272: FND_MSG_PUB.ADD;
273: FND_MSG_PUB.Count_And_Get(
274: p_encoded => FND_API.G_FALSE,
275: p_count => x_msg_count,
276: p_data => x_msg_data);
269: IF p_user_type NOT IN (G_PARTY_USER_TYPE, G_FND_USER_TYPE) THEN
270: x_return_status := FND_API.G_RET_STS_ERROR;
271: FND_MESSAGE.SET_NAME('IMC', 'IMC_INVALID_USER_TYPE');
272: FND_MSG_PUB.ADD;
273: FND_MSG_PUB.Count_And_Get(
274: p_encoded => FND_API.G_FALSE,
275: p_count => x_msg_count,
276: p_data => x_msg_data);
277: END IF;
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,
312: p_count => x_msg_count,
313: p_data => x_msg_data);
314:
313: p_data => x_msg_data);
314:
315: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
317: FND_MSG_PUB.Count_And_Get(
318: p_encoded => FND_API.G_FALSE,
319: p_count => x_msg_count,
320: p_data => x_msg_data);
321:
322: WHEN OTHERS THEN
323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
324: FND_MESSAGE.SET_NAME('IMC', 'HZ_API_OTHERS_EXCEP');
325: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
326: FND_MSG_PUB.ADD;
327: FND_MSG_PUB.Count_And_Get(
328: p_encoded => FND_API.G_FALSE,
329: p_count => x_msg_count,
330: p_data => x_msg_data);
323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
324: FND_MESSAGE.SET_NAME('IMC', 'HZ_API_OTHERS_EXCEP');
325: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
326: FND_MSG_PUB.ADD;
327: FND_MSG_PUB.Count_And_Get(
328: p_encoded => FND_API.G_FALSE,
329: p_count => x_msg_count,
330: p_data => x_msg_data);
331:
368: ELSE
369: x_return_status := FND_API.G_RET_STS_ERROR;
370: /* bookmark type is invalid */
371: FND_MESSAGE.SET_NAME('IMC', 'IMC_INVALID_BOOKMARK_TYPE');
372: FND_MSG_PUB.ADD;
373: FND_MSG_PUB.Count_And_Get(
374: p_encoded => FND_API.G_FALSE,
375: p_count => x_msg_count,
376: p_data => x_msg_data);
369: x_return_status := FND_API.G_RET_STS_ERROR;
370: /* bookmark type is invalid */
371: FND_MESSAGE.SET_NAME('IMC', 'IMC_INVALID_BOOKMARK_TYPE');
372: FND_MSG_PUB.ADD;
373: FND_MSG_PUB.Count_And_Get(
374: p_encoded => FND_API.G_FALSE,
375: p_count => x_msg_count,
376: p_data => x_msg_data);
377: END IF;
391: WHEN NO_DATA_FOUND THEN
392: /* party id is invalid */
393: x_return_status := FND_API.G_RET_STS_ERROR;
394: FND_MESSAGE.SET_NAME('IMC', 'IMC_INVALID_PARTY_ID');
395: FND_MSG_PUB.ADD;
396: FND_MSG_PUB.Count_And_Get(
397: p_encoded => FND_API.G_FALSE,
398: p_count => x_msg_count,
399: p_data => x_msg_data);
392: /* party id is invalid */
393: x_return_status := FND_API.G_RET_STS_ERROR;
394: FND_MESSAGE.SET_NAME('IMC', 'IMC_INVALID_PARTY_ID');
395: FND_MSG_PUB.ADD;
396: FND_MSG_PUB.Count_And_Get(
397: p_encoded => FND_API.G_FALSE,
398: p_count => x_msg_count,
399: p_data => x_msg_data);
400: WHEN OTHERS THEN
400: WHEN OTHERS THEN
401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
402: FND_MESSAGE.SET_NAME('IMC', 'HZ_API_OTHERS_EXCEP');
403: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
404: FND_MSG_PUB.ADD;
405: FND_MSG_PUB.Count_And_Get(
406: p_encoded => FND_API.G_FALSE,
407: p_count => x_msg_count,
408: p_data => x_msg_data);
401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
402: FND_MESSAGE.SET_NAME('IMC', 'HZ_API_OTHERS_EXCEP');
403: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
404: FND_MSG_PUB.ADD;
405: FND_MSG_PUB.Count_And_Get(
406: p_encoded => FND_API.G_FALSE,
407: p_count => x_msg_count,
408: p_data => x_msg_data);
409: