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_MENU_ENTRIES_PUB dependencies on FND_MSG_PUB

Line 102: fnd_msg_pub.initialize;

98: l_rowid varchar2(240);
99: l_result VARCHAR2(1);
100: begin
101:
102: fnd_msg_pub.initialize;
103:
104: FND_MENU_ENTRIES_PKG.INSERT_ROW(
105: X_ROWID => l_ROWID,
106: X_MENU_ID => X_MENU_ID,

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

126:
127: EXCEPTION
128: WHEN FND_API.G_EXC_ERROR THEN
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
131: ,p_data => x_msg_data);
132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

130: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
131: ,p_data => x_msg_data);
132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
135: ,p_data => x_msg_data);
136: WHEN NO_DATA_FOUND THEN
137: x_return_status := FND_API.G_RET_STS_ERROR;
138: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

134: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
135: ,p_data => x_msg_data);
136: WHEN NO_DATA_FOUND THEN
137: x_return_status := FND_API.G_RET_STS_ERROR;
138: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
139: ,p_data => x_msg_data);
140: WHEN OTHERS THEN
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
142: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

138: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
139: ,p_data => x_msg_data);
140: WHEN OTHERS THEN
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
142: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
143: ,p_data => x_msg_data);
144: if (x_msg_data is null) then
145: x_msg_data := SQLERRM;
146: end if;

Line 165: fnd_msg_pub.initialize;

161:
162: l_result VARCHAR2(1);
163: begin
164:
165: fnd_msg_pub.initialize;
166:
167: FND_MENU_ENTRIES_PKG.UPDATE_ROW(
168: X_MENU_ID => X_MENU_ID,
169: X_ENTRY_SEQUENCE => X_ENTRY_SEQUENCE,

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

186:
187: EXCEPTION
188: WHEN FND_API.G_EXC_ERROR THEN
189: x_return_status := FND_API.G_RET_STS_ERROR;
190: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
191: ,p_data => x_msg_data);
192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

190: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
191: ,p_data => x_msg_data);
192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
195: ,p_data => x_msg_data);
196: WHEN NO_DATA_FOUND THEN
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

194: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
195: ,p_data => x_msg_data);
196: WHEN NO_DATA_FOUND THEN
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
199: ,p_data => x_msg_data);
200: WHEN OTHERS THEN
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

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

198: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
199: ,p_data => x_msg_data);
200: WHEN OTHERS THEN
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 255: fnd_msg_pub.initialize;

251:
252: l_result VARCHAR2(1);
253: begin
254:
255: fnd_msg_pub.initialize;
256:
257: FND_MENU_ENTRIES_PKG.DELETE_ROW(
258: X_MENU_ID => X_MENU_ID,
259: X_ENTRY_SEQUENCE => X_ENTRY_SEQUENCE);

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

268:
269: EXCEPTION
270: WHEN FND_API.G_EXC_ERROR THEN
271: x_return_status := FND_API.G_RET_STS_ERROR;
272: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
273: ,p_data => x_msg_data);
274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

272: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
273: ,p_data => x_msg_data);
274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
277: ,p_data => x_msg_data);
278: WHEN NO_DATA_FOUND THEN
279: x_return_status := FND_API.G_RET_STS_ERROR;
280: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

276: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
277: ,p_data => x_msg_data);
278: WHEN NO_DATA_FOUND THEN
279: x_return_status := FND_API.G_RET_STS_ERROR;
280: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
281: ,p_data => x_msg_data);
282: WHEN OTHERS THEN
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

280: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
281: ,p_data => x_msg_data);
282: WHEN OTHERS THEN
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
285: ,p_data => x_msg_data);
286: if (x_msg_data is null) then
287: x_msg_data := SQLERRM;
288: end if;

Line 304: fnd_msg_pub.initialize;

300: where menu_id = X_MENU_ID;
301: l_result VARCHAR2(1);
302: begin
303:
304: fnd_msg_pub.initialize;
305:
306: for entry_seq_cursor in entry_sequence_cursor loop
307:
308: FND_MENU_ENTRIES_PKG.DELETE_ROW(

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

320:
321: EXCEPTION
322: WHEN FND_API.G_EXC_ERROR THEN
323: x_return_status := FND_API.G_RET_STS_ERROR;
324: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
325: ,p_data => x_msg_data);
326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
328: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

324: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
325: ,p_data => x_msg_data);
326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
328: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
329: ,p_data => x_msg_data);
330: WHEN NO_DATA_FOUND THEN
331: x_return_status := FND_API.G_RET_STS_ERROR;
332: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

328: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
329: ,p_data => x_msg_data);
330: WHEN NO_DATA_FOUND THEN
331: x_return_status := FND_API.G_RET_STS_ERROR;
332: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
333: ,p_data => x_msg_data);
334: WHEN OTHERS THEN
335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
336: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

332: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
333: ,p_data => x_msg_data);
334: WHEN OTHERS THEN
335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
336: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
337: ,p_data => x_msg_data);
338: if (x_msg_data is null) then
339: x_msg_data := SQLERRM;
340: end if;

Line 357: fnd_msg_pub.initialize;

353: l_prompt VARCHAR2(80);
354: l_row_id VARCHAR2(30);
355: begin
356:
357: fnd_msg_pub.initialize;
358:
359: for i in 1..p_menu_ids.count loop
360: -- Check if menu attachment already exists, then leave it alone
361: select count(1) into l_count

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

383:
384: EXCEPTION
385: WHEN FND_API.G_EXC_ERROR THEN
386: x_return_status := FND_API.G_RET_STS_ERROR;
387: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
388: ,p_data => x_msg_data);
389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
391: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

387: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
388: ,p_data => x_msg_data);
389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
391: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
392: ,p_data => x_msg_data);
393: WHEN NO_DATA_FOUND THEN
394: x_return_status := FND_API.G_RET_STS_ERROR;
395: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

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

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

395: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
396: ,p_data => x_msg_data);
397: WHEN OTHERS THEN
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
400: ,p_data => x_msg_data);
401: if (x_msg_data is null) then
402: x_msg_data := SQLERRM;
403: end if;

Line 420: fnd_msg_pub.initialize;

416: l_prompt VARCHAR2(80);
417: l_row_id VARCHAR2(30);
418: begin
419:
420: fnd_msg_pub.initialize;
421:
422: for i in 1..p_function_ids.count loop
423: -- Check if function is added to the menu, then leave it alone
424: select count(1) into l_count

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

446:
447: EXCEPTION
448: WHEN FND_API.G_EXC_ERROR THEN
449: x_return_status := FND_API.G_RET_STS_ERROR;
450: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
451: ,p_data => x_msg_data);
452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
454: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

450: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
451: ,p_data => x_msg_data);
452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
454: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
455: ,p_data => x_msg_data);
456: WHEN NO_DATA_FOUND THEN
457: x_return_status := FND_API.G_RET_STS_ERROR;
458: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

454: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
455: ,p_data => x_msg_data);
456: WHEN NO_DATA_FOUND THEN
457: x_return_status := FND_API.G_RET_STS_ERROR;
458: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
459: ,p_data => x_msg_data);
460: WHEN OTHERS THEN
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

458: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
459: ,p_data => x_msg_data);
460: WHEN OTHERS THEN
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
463: ,p_data => x_msg_data);
464: if (x_msg_data is null) then
465: x_msg_data := SQLERRM;
466: end if;

Line 491: fnd_msg_pub.initialize;

487: p_msg_data VARCHAR2(40);
488:
489: begin
490:
491: fnd_msg_pub.initialize;
492:
493: for i in 1..p_function_ids.count loop
494:
495: for ent_seq_cur in entry_seq_cursor(p_function_ids(i)) loop

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

506:
507: EXCEPTION
508: WHEN FND_API.G_EXC_ERROR THEN
509: x_return_status := FND_API.G_RET_STS_ERROR;
510: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
511: ,p_data => x_msg_data);
512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
514: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

510: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
511: ,p_data => x_msg_data);
512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
514: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
515: ,p_data => x_msg_data);
516: WHEN NO_DATA_FOUND THEN
517: x_return_status := FND_API.G_RET_STS_ERROR;
518: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

514: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
515: ,p_data => x_msg_data);
516: WHEN NO_DATA_FOUND THEN
517: x_return_status := FND_API.G_RET_STS_ERROR;
518: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
519: ,p_data => x_msg_data);
520: WHEN OTHERS THEN
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

518: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
519: ,p_data => x_msg_data);
520: WHEN OTHERS THEN
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
523: ,p_data => x_msg_data);
524: if (x_msg_data is null) then
525: x_msg_data := SQLERRM;
526: end if;

Line 549: fnd_msg_pub.initialize;

545: p_msg_data VARCHAR2(40);
546:
547: begin
548:
549: fnd_msg_pub.initialize;
550:
551: for i in 1..p_menu_ids.count loop
552:
553: for ent_seq_cur in entry_seq_cursor(p_menu_ids(i)) loop

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

564:
565: EXCEPTION
566: WHEN FND_API.G_EXC_ERROR THEN
567: x_return_status := FND_API.G_RET_STS_ERROR;
568: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
569: ,p_data => x_msg_data);
570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
572: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

568: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
569: ,p_data => x_msg_data);
570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
572: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
573: ,p_data => x_msg_data);
574: WHEN NO_DATA_FOUND THEN
575: x_return_status := FND_API.G_RET_STS_ERROR;
576: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

572: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
573: ,p_data => x_msg_data);
574: WHEN NO_DATA_FOUND THEN
575: x_return_status := FND_API.G_RET_STS_ERROR;
576: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
577: ,p_data => x_msg_data);
578: WHEN OTHERS THEN
579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
580: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

576: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
577: ,p_data => x_msg_data);
578: WHEN OTHERS THEN
579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
580: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
581: ,p_data => x_msg_data);
582: if (x_msg_data is null) then
583: x_msg_data := SQLERRM;
584: end if;

Line 605: fnd_msg_pub.initialize;

601: for update of menu_id, entry_sequence nowait;
602:
603: BEGIN
604:
605: fnd_msg_pub.initialize;
606:
607: SAVEPOINT SP_LOCK_ROW;
608:
609: IF cMenuEntry%ISOPEN THEN

Line 617: FND_MSG_PUB.ADD;

613: FETCH cMenuEntry INTO l_last_update_date;
614:
615: if (cMenuEntry%notfound) then
616: FND_MESSAGE.SET_NAME('BIS','BIS_MENU_ENTRY_DELETED_ERROR');
617: FND_MSG_PUB.ADD;
618: RAISE FND_API.G_EXC_ERROR;
619: end if;
620:
621: if p_last_update_date is not null then

Line 624: FND_MSG_PUB.ADD;

620:
621: if p_last_update_date is not null then
622: if p_last_update_date <> l_last_update_date then
623: FND_MESSAGE.SET_NAME('BIS','BIS_MENU_ENTRY_CHANGED_ERROR');
624: FND_MSG_PUB.ADD;
625: RAISE FND_API.G_EXC_ERROR;
626: end if;
627: end if;
628:

Line 638: FND_MSG_PUB.ADD;

634: WHEN OTHERS THEN
635: close cMenuEntry;
636: rollback to SP_LOCK_ROW;
637: FND_MESSAGE.SET_NAME('BIS','BIS_MENU_ENTRY_LOCKED_ERROR');
638: FND_MSG_PUB.ADD;
639: RAISE FND_API.G_EXC_ERROR;
640: END LOCK_ROW;
641:
642: