eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_FND_MENUS_PUB dependencies on FND_MSG_PUB

Line 38: fnd_msg_pub.initialize;

34: l_user_menu_name VARCHAR2(80);
35:
36: begin
37:
38: fnd_msg_pub.initialize;
39:
40: begin
41: select menu_name, user_menu_name
42: into l_menu_name, l_user_menu_name

Line 52: FND_MSG_PUB.ADD;

48: end;
49:
50: if l_menu_name = p_menu_name then
51: FND_MESSAGE.SET_NAME('BIS','BIS_NAME_UNIQUE_ERR');
52: FND_MSG_PUB.ADD;
53: RAISE FND_API.G_EXC_ERROR;
54: end if;
55:
56: if l_user_menu_name = p_user_menu_name then

Line 58: FND_MSG_PUB.ADD;

54: end if;
55:
56: if l_user_menu_name = p_user_menu_name then
57: FND_MESSAGE.SET_NAME('BIS','BIS_DISPLAY_NAME_UNIQUE_ERR');
58: FND_MSG_PUB.ADD;
59: RAISE FND_API.G_EXC_ERROR;
60: end if;
61:
62: if X_MENU_ID IS NULL then

Line 88: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

84:
85: EXCEPTION
86: WHEN FND_API.G_EXC_ERROR THEN
87: x_return_status := FND_API.G_RET_STS_ERROR;
88: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
89: ,p_data => x_msg_data);
90:
91: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
92: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 93: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

89: ,p_data => x_msg_data);
90:
91: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
92: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
93: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
94: ,p_data => x_msg_data);
95:
96: WHEN NO_DATA_FOUND THEN
97: x_return_status := FND_API.G_RET_STS_ERROR;

Line 98: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

94: ,p_data => x_msg_data);
95:
96: WHEN NO_DATA_FOUND THEN
97: x_return_status := FND_API.G_RET_STS_ERROR;
98: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
99: ,p_data => x_msg_data);
100: WHEN OTHERS THEN
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
102: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

Line 102: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

98: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
99: ,p_data => x_msg_data);
100: WHEN OTHERS THEN
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
102: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
103: ,p_data => x_msg_data);
104: if (x_msg_data is null) then
105: x_msg_data := SQLERRM;
106: end if;

Line 131: fnd_msg_pub.initialize;

127: where menu_id = p_MENU_ID;
128:
129: l_count NUMBER;
130: begin
131: fnd_msg_pub.initialize;
132:
133: if cFndMenu%ISOPEN then
134: CLOSE cFndMenu;
135: end if;

Line 156: FND_MSG_PUB.ADD;

152: and user_menu_name = p_user_menu_name;
153:
154: if l_count > 0 then
155: FND_MESSAGE.SET_NAME('BIS','BIS_DISPLAY_NAME_UNIQUE_ERR');
156: FND_MSG_PUB.ADD;
157: RAISE FND_API.G_EXC_ERROR;
158: end if;
159: end if;
160:

Line 181: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

177: if cFndMenu%ISOPEN then
178: CLOSE cFndMenu;
179: end if;
180: x_return_status := FND_API.G_RET_STS_ERROR;
181: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
182: ,p_data => x_msg_data);
183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
184: if cFndMenu%ISOPEN then
185: CLOSE cFndMenu;

Line 188: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

184: if cFndMenu%ISOPEN then
185: CLOSE cFndMenu;
186: end if;
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
188: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
189: ,p_data => x_msg_data);
190: WHEN NO_DATA_FOUND THEN
191: if cFndMenu%ISOPEN then
192: CLOSE cFndMenu;

Line 195: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

191: if cFndMenu%ISOPEN then
192: CLOSE cFndMenu;
193: end if;
194: x_return_status := FND_API.G_RET_STS_ERROR;
195: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
196: ,p_data => x_msg_data);
197: WHEN OTHERS THEN
198: if cFndMenu%ISOPEN then
199: CLOSE cFndMenu;

Line 202: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

198: if cFndMenu%ISOPEN then
199: CLOSE cFndMenu;
200: end if;
201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
202: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
203: ,p_data => x_msg_data);
204: if (x_msg_data is null) then
205: x_msg_data := SQLERRM;
206: end if;

Line 230: fnd_msg_pub.initialize;

226: from fnd_responsibility_vl
227: where menu_id = p_menu_id;
228:
229: BEGIN
230: fnd_msg_pub.initialize;
231:
232: if cr_menu_usage%ISOPEN then
233: CLOSE cr_menu_usage;
234: end if;

Line 242: FND_MSG_PUB.ADD;

238:
239: for c in cr_menu_usage loop
240: FND_MESSAGE.SET_NAME('FND','MENU-USED BY MENUS');
241: FND_MESSAGE.SET_TOKEN('MENU', c.user_menu_name);
242: FND_MSG_PUB.ADD;
243: RAISE FND_API.G_EXC_ERROR;
244: end loop;
245:
246: for c in cr_resp_usage loop

Line 249: FND_MSG_PUB.ADD;

245:
246: for c in cr_resp_usage loop
247: FND_MESSAGE.SET_NAME('FND','FND-RESP CALLS MENU');
248: FND_MESSAGE.SET_TOKEN('RESPONSIBILITY', c.responsibility_name);
249: FND_MSG_PUB.ADD;
250: RAISE FND_API.G_EXC_ERROR;
251: end loop;
252:
253: if cr_menu_usage%ISOPEN then

Line 269: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

265: if cr_resp_usage%ISOPEN then
266: CLOSE cr_resp_usage;
267: end if;
268: x_return_status := FND_API.G_RET_STS_ERROR;
269: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
270: ,p_data => x_msg_data);
271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
272: if cr_menu_usage%ISOPEN then
273: CLOSE cr_menu_usage;

Line 279: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

275: if cr_resp_usage%ISOPEN then
276: CLOSE cr_resp_usage;
277: end if;
278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
279: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
280: ,p_data => x_msg_data);
281: WHEN NO_DATA_FOUND THEN
282: if cr_menu_usage%ISOPEN then
283: CLOSE cr_menu_usage;

Line 289: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

285: if cr_resp_usage%ISOPEN then
286: CLOSE cr_resp_usage;
287: end if;
288: x_return_status := FND_API.G_RET_STS_ERROR;
289: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
290: ,p_data => x_msg_data);
291: WHEN OTHERS THEN
292: if cr_menu_usage%ISOPEN then
293: CLOSE cr_menu_usage;

Line 299: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

295: if cr_resp_usage%ISOPEN then
296: CLOSE cr_resp_usage;
297: end if;
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
299: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
300: ,p_data => x_msg_data);
301: if (x_msg_data is null) then
302: x_msg_data := SQLERRM;
303: end if;

Line 317: fnd_msg_pub.initialize;

313: ) IS
314:
315: l_menu_id number;
316: BEGIN
317: fnd_msg_pub.initialize;
318:
319: validate_delete(p_menu_id, x_return_status, x_msg_count, x_msg_data);
320:
321: if (x_return_status is null) then

Line 328: FND_MSG_PUB.ADD;

324: FND_MENUS_PKG.DELETE_ROW(X_MENU_ID => p_MENU_ID);
325: exception
326: when others then
327: FND_MESSAGE.SET_NAME('BIS','BIS_MENU_DELETED_ERROR');
328: FND_MSG_PUB.ADD;
329: RAISE FND_API.G_EXC_ERROR;
330: end;
331: end if;
332:

Line 336: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

332:
333: EXCEPTION
334: WHEN FND_API.G_EXC_ERROR THEN
335: x_return_status := FND_API.G_RET_STS_ERROR;
336: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
337: ,p_data => x_msg_data);
338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
340: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

Line 340: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

336: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
337: ,p_data => x_msg_data);
338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
340: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
341: ,p_data => x_msg_data);
342: WHEN NO_DATA_FOUND THEN
343: x_return_status := FND_API.G_RET_STS_ERROR;
344: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

Line 344: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

340: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
341: ,p_data => x_msg_data);
342: WHEN NO_DATA_FOUND THEN
343: x_return_status := FND_API.G_RET_STS_ERROR;
344: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
345: ,p_data => x_msg_data);
346: WHEN OTHERS THEN
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
348: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

Line 348: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

344: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
345: ,p_data => x_msg_data);
346: WHEN OTHERS THEN
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
348: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
349: ,p_data => x_msg_data);
350: if (x_msg_data is null) then
351: x_msg_data := SQLERRM;
352: end if;

Line 370: fnd_msg_pub.initialize;

366: l_menu_id NUMBER;
367:
368: BEGIN
369:
370: fnd_msg_pub.initialize;
371:
372: validate_delete(p_menu_id, x_return_status, x_msg_count, x_msg_data);
373:
374: if (x_return_status is null) then

Line 386: FND_MSG_PUB.ADD;

382: FND_MENUS_PKG.DELETE_ROW(X_MENU_ID => p_MENU_ID);
383: exception
384: when no_data_found then
385: FND_MESSAGE.SET_NAME('BIS','BIS_MENU_DELETED_ERROR');
386: FND_MSG_PUB.ADD;
387: RAISE FND_API.G_EXC_ERROR;
388: end;
389: end if;
390:

Line 394: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

390:
391: EXCEPTION
392: WHEN FND_API.G_EXC_ERROR THEN
393: x_return_status := FND_API.G_RET_STS_ERROR;
394: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
395: ,p_data => x_msg_data);
396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
398: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

Line 398: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

394: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
395: ,p_data => x_msg_data);
396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
398: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
399: ,p_data => x_msg_data);
400: WHEN NO_DATA_FOUND THEN
401: x_return_status := FND_API.G_RET_STS_ERROR;
402: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

Line 402: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

398: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
399: ,p_data => x_msg_data);
400: WHEN NO_DATA_FOUND THEN
401: x_return_status := FND_API.G_RET_STS_ERROR;
402: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
403: ,p_data => x_msg_data);
404: WHEN OTHERS THEN
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
406: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

Line 406: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

402: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
403: ,p_data => x_msg_data);
404: WHEN OTHERS THEN
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
406: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
407: ,p_data => x_msg_data);
408: if (x_msg_data is null) then
409: x_msg_data := SQLERRM;
410: end if;

Line 429: fnd_msg_pub.initialize;

425: for update of menu_id nowait;
426:
427: BEGIN
428:
429: fnd_msg_pub.initialize;
430:
431: SAVEPOINT SP_LOCK_ROW;
432:
433: IF cMenu%ISOPEN THEN

Line 441: FND_MSG_PUB.ADD;

437: FETCH cMenu INTO l_last_update_date;
438:
439: if (cMenu%notfound) then
440: FND_MESSAGE.SET_NAME('BIS','BIS_MENU_DELETED_ERROR');
441: FND_MSG_PUB.ADD;
442: RAISE FND_API.G_EXC_ERROR;
443: end if;
444:
445: if p_last_update_date is not null then

Line 448: FND_MSG_PUB.ADD;

444:
445: if p_last_update_date is not null then
446: if p_last_update_date <> l_last_update_date then
447: FND_MESSAGE.SET_NAME('BIS','BIS_MENU_CHANGED_ERROR');
448: FND_MSG_PUB.ADD;
449: RAISE FND_API.G_EXC_ERROR;
450: end if;
451: end if;
452:

Line 462: FND_MSG_PUB.ADD;

458: WHEN OTHERS THEN
459: close cMenu;
460: rollback to SP_LOCK_ROW;
461: FND_MESSAGE.SET_NAME('BIS','BIS_MENU_LOCKED_ERROR');
462: FND_MSG_PUB.ADD;
463: RAISE FND_API.G_EXC_ERROR;
464: END LOCK_ROW;
465:
466: