DBA Data[Home] [Help]

APPS.IMC_BOOKMARK_PUB dependencies on FND_MSG_PUB

Line 112: FND_MSG_PUB.ADD;

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

Line 113: FND_MSG_PUB.Count_And_Get(

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;

Line 123: FND_MSG_PUB.Count_And_Get(

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:

Line 130: FND_MSG_PUB.Count_And_Get(

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:

Line 139: FND_MSG_PUB.ADD;

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

Line 140: FND_MSG_PUB.Count_And_Get(

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:

Line 185: FND_MSG_PUB.ADD;

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

Line 186: FND_MSG_PUB.Count_And_Get(

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;

Line 219: FND_MSG_PUB.Count_And_Get(

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:

Line 226: FND_MSG_PUB.Count_And_Get(

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:

Line 235: FND_MSG_PUB.ADD;

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

Line 236: FND_MSG_PUB.Count_And_Get(

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;

Line 263: FND_MSG_PUB.ADD;

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

Line 264: FND_MSG_PUB.Count_And_Get(

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

Line 272: FND_MSG_PUB.ADD;

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

Line 273: FND_MSG_PUB.Count_And_Get(

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;

Line 310: FND_MSG_PUB.Count_And_Get(

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:

Line 317: FND_MSG_PUB.Count_And_Get(

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:

Line 326: FND_MSG_PUB.ADD;

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

Line 327: FND_MSG_PUB.Count_And_Get(

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:

Line 372: FND_MSG_PUB.ADD;

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

Line 373: FND_MSG_PUB.Count_And_Get(

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;

Line 395: FND_MSG_PUB.ADD;

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

Line 396: FND_MSG_PUB.Count_And_Get(

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

Line 404: FND_MSG_PUB.ADD;

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

Line 405: FND_MSG_PUB.Count_And_Get(

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: