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

Line 45: fnd_msg_pub.initialize;

41: l_app_short_name VARCHAR2(30);
42: l_type VARCHAR2(30);
43: begin
44:
45: fnd_msg_pub.initialize;
46:
47: begin
48: select BIS_COMMON_UTILS.getParameterValue(parameters, c_SOURCE_TYPE) into l_type
49: from fnd_form_functions

Line 81: FND_MSG_PUB.ADD;

77: end if;
78:
79: if (l_count > 0) then
80: FND_MESSAGE.SET_NAME('BIS','BIS_PD_UNIQUE_PGE_ERR');
81: FND_MSG_PUB.ADD;
82: RAISE FND_API.G_EXC_ERROR;
83: end if;
84:
85: -- Insert new Region

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

118:
119: EXCEPTION
120: WHEN FND_API.G_EXC_ERROR THEN
121: x_return_status := FND_API.G_RET_STS_ERROR;
122: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
123: ,p_data => x_msg_data);
124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
126: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

122: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
123: ,p_data => x_msg_data);
124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
126: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
127: ,p_data => x_msg_data);
128: WHEN NO_DATA_FOUND 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

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

126: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
127: ,p_data => x_msg_data);
128: WHEN NO_DATA_FOUND 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 OTHERS 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 OTHERS 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: if (x_msg_data is null) then
137: x_msg_data := SQLERRM;
138: end if;

Line 162: fnd_msg_pub.initialize;

158: l_new_application_id NUMBER;
159:
160: begin
161:
162: fnd_msg_pub.initialize;
163:
164: if p_new_internal_name is null then
165: l_new_internal_name := p_internal_name;
166: else

Line 214: FND_MSG_PUB.ADD;

210: end if;
211:
212: if (l_count > 0) then
213: FND_MESSAGE.SET_NAME('BIS','BIS_PD_UNIQUE_PGE_ERR');
214: FND_MSG_PUB.ADD;
215: RAISE FND_API.G_EXC_ERROR;
216: end if;
217:
218: -- Delete existing region

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

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

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

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

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

281: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
282: ,p_data => x_msg_data);
283: WHEN NO_DATA_FOUND THEN
284: x_return_status := FND_API.G_RET_STS_ERROR;
285: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
286: ,p_data => x_msg_data);
287: WHEN OTHERS THEN
288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
289: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

285: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
286: ,p_data => x_msg_data);
287: WHEN OTHERS THEN
288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
289: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
290: ,p_data => x_msg_data);
291: if (x_msg_data is null) then
292: x_msg_data := SQLERRM;
293: end if;

Line 307: fnd_msg_pub.initialize;

303: ,x_msg_data OUT NOCOPY VARCHAR2
304: ) is
305:
306: begin
307: fnd_msg_pub.initialize;
308:
309: -- Delete Page Racks and Rack Items
310: Delete_Page_Racks(
311: p_internal_name => p_internal_name,

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

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

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

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

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

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

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

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

Line 364: fnd_msg_pub.initialize;

360: ) is
361:
362: begin
363:
364: fnd_msg_pub.initialize;
365:
366: -- Insert new Region
367: BIS_AK_REGION_PUB.INSERT_REGION_ROW (
368: p_REGION_CODE => p_internal_name,

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

378:
379: EXCEPTION
380: WHEN FND_API.G_EXC_ERROR THEN
381: x_return_status := FND_API.G_RET_STS_ERROR;
382: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
383: ,p_data => x_msg_data);
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

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

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

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

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

390: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
391: ,p_data => x_msg_data);
392: WHEN OTHERS THEN
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
395: ,p_data => x_msg_data);
396: if (x_msg_data is null) then
397: x_msg_data := SQLERRM;
398: end if;

Line 412: fnd_msg_pub.initialize;

408: ,x_msg_data OUT NOCOPY VARCHAR2
409: ) is
410: begin
411:
412: fnd_msg_pub.initialize;
413:
414: delete_region_items(
415: p_internal_name => p_internal_name,
416: p_application_id => p_application_id,

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

427:
428: EXCEPTION
429: WHEN FND_API.G_EXC_ERROR THEN
430: x_return_status := FND_API.G_RET_STS_ERROR;
431: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
432: ,p_data => x_msg_data);
433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

431: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
432: ,p_data => x_msg_data);
433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
436: ,p_data => x_msg_data);
437: WHEN NO_DATA_FOUND THEN
438: x_return_status := FND_API.G_RET_STS_ERROR;
439: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

435: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
436: ,p_data => x_msg_data);
437: WHEN NO_DATA_FOUND THEN
438: x_return_status := FND_API.G_RET_STS_ERROR;
439: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
440: ,p_data => x_msg_data);
441: WHEN OTHERS THEN
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

439: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
440: ,p_data => x_msg_data);
441: WHEN OTHERS THEN
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
444: ,p_data => x_msg_data);
445: if (x_msg_data is null) then
446: x_msg_data := SQLERRM;
447: end if;

Line 465: fnd_msg_pub.initialize;

461: ) is
462:
463: begin
464:
465: fnd_msg_pub.initialize;
466:
467: -- Insert the Rack Region Item
468:
469: BIS_AK_REGION_PUB.INSERT_REGION_ITEM_ROW (

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

482:
483: EXCEPTION
484: WHEN FND_API.G_EXC_ERROR THEN
485: x_return_status := FND_API.G_RET_STS_ERROR;
486: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
487: ,p_data => x_msg_data);
488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
490: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

486: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
487: ,p_data => x_msg_data);
488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
490: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
491: ,p_data => x_msg_data);
492: WHEN NO_DATA_FOUND THEN
493: x_return_status := FND_API.G_RET_STS_ERROR;
494: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

490: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
491: ,p_data => x_msg_data);
492: WHEN NO_DATA_FOUND THEN
493: x_return_status := FND_API.G_RET_STS_ERROR;
494: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
495: ,p_data => x_msg_data);
496: WHEN OTHERS THEN
497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
498: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

494: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
495: ,p_data => x_msg_data);
496: WHEN OTHERS THEN
497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
498: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
499: ,p_data => x_msg_data);
500: if (x_msg_data is null) then
501: x_msg_data := SQLERRM;
502: end if;

Line 516: fnd_msg_pub.initialize;

512: ,x_msg_data OUT NOCOPY VARCHAR2
513: ) is
514: begin
515:
516: fnd_msg_pub.initialize;
517:
518: BIS_AK_REGION_PUB.DELETE_REGION_ITEM_ROW(
519: p_REGION_CODE => p_internal_name,
520: p_REGION_APPLICATION_ID => p_application_id,

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

527:
528: EXCEPTION
529: WHEN FND_API.G_EXC_ERROR THEN
530: x_return_status := FND_API.G_RET_STS_ERROR;
531: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
532: ,p_data => x_msg_data);
533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

531: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
532: ,p_data => x_msg_data);
533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
536: ,p_data => x_msg_data);
537: WHEN NO_DATA_FOUND THEN
538: x_return_status := FND_API.G_RET_STS_ERROR;
539: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

535: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
536: ,p_data => x_msg_data);
537: WHEN NO_DATA_FOUND THEN
538: x_return_status := FND_API.G_RET_STS_ERROR;
539: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
540: ,p_data => x_msg_data);
541: WHEN OTHERS THEN
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

539: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
540: ,p_data => x_msg_data);
541: WHEN OTHERS THEN
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
544: ,p_data => x_msg_data);
545: if (x_msg_data is null) then
546: x_msg_data := SQLERRM;
547: end if;

Line 565: fnd_msg_pub.initialize;

561: ) is
562:
563: begin
564:
565: fnd_msg_pub.initialize;
566:
567: -- Insert the Portlet Region Item
568:
569: BIS_AK_REGION_PUB.INSERT_REGION_ITEM_ROW (

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

582:
583: EXCEPTION
584: WHEN FND_API.G_EXC_ERROR THEN
585: x_return_status := FND_API.G_RET_STS_ERROR;
586: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
587: ,p_data => x_msg_data);
588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
590: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

586: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
587: ,p_data => x_msg_data);
588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
590: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
591: ,p_data => x_msg_data);
592: WHEN NO_DATA_FOUND THEN
593: x_return_status := FND_API.G_RET_STS_ERROR;
594: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

590: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
591: ,p_data => x_msg_data);
592: WHEN NO_DATA_FOUND THEN
593: x_return_status := FND_API.G_RET_STS_ERROR;
594: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
595: ,p_data => x_msg_data);
596: WHEN OTHERS THEN
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
598: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

594: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
595: ,p_data => x_msg_data);
596: WHEN OTHERS THEN
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
598: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
599: ,p_data => x_msg_data);
600: if (x_msg_data is null) then
601: x_msg_data := SQLERRM;
602: end if;

Line 616: fnd_msg_pub.initialize;

612: ,x_msg_data OUT NOCOPY VARCHAR2
613: ) is
614: begin
615:
616: fnd_msg_pub.initialize;
617:
618: BIS_AK_REGION_PUB.DELETE_REGION_ITEM_ROW(
619: p_REGION_CODE => p_internal_name,
620: p_REGION_APPLICATION_ID => p_application_id,

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

626:
627: EXCEPTION
628: WHEN FND_API.G_EXC_ERROR THEN
629: x_return_status := FND_API.G_RET_STS_ERROR;
630: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
631: ,p_data => x_msg_data);
632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
634: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

630: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
631: ,p_data => x_msg_data);
632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
634: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
635: ,p_data => x_msg_data);
636: WHEN NO_DATA_FOUND THEN
637: x_return_status := FND_API.G_RET_STS_ERROR;
638: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

634: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
635: ,p_data => x_msg_data);
636: WHEN NO_DATA_FOUND THEN
637: x_return_status := FND_API.G_RET_STS_ERROR;
638: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
639: ,p_data => x_msg_data);
640: WHEN OTHERS THEN
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
642: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

638: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
639: ,p_data => x_msg_data);
640: WHEN OTHERS THEN
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
642: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
643: ,p_data => x_msg_data);
644: if (x_msg_data is null) then
645: x_msg_data := SQLERRM;
646: end if;

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

689:
690: EXCEPTION
691: WHEN FND_API.G_EXC_ERROR THEN
692: x_return_status := FND_API.G_RET_STS_ERROR;
693: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
694: ,p_data => x_msg_data);
695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
697: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

693: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
694: ,p_data => x_msg_data);
695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
697: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
698: ,p_data => x_msg_data);
699: WHEN NO_DATA_FOUND THEN
700: x_return_status := FND_API.G_RET_STS_ERROR;
701: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

697: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
698: ,p_data => x_msg_data);
699: WHEN NO_DATA_FOUND THEN
700: x_return_status := FND_API.G_RET_STS_ERROR;
701: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
702: ,p_data => x_msg_data);
703: WHEN OTHERS THEN
704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
705: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

701: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
702: ,p_data => x_msg_data);
703: WHEN OTHERS THEN
704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
705: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
706: ,p_data => x_msg_data);
707: if (x_msg_data is null) then
708: x_msg_data := SQLERRM;
709: end if;

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

747:
748: EXCEPTION
749: WHEN FND_API.G_EXC_ERROR THEN
750: x_return_status := FND_API.G_RET_STS_ERROR;
751: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
752: ,p_data => x_msg_data);
753: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
755: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

751: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
752: ,p_data => x_msg_data);
753: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
755: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
756: ,p_data => x_msg_data);
757: WHEN NO_DATA_FOUND THEN
758: x_return_status := FND_API.G_RET_STS_ERROR;
759: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

755: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
756: ,p_data => x_msg_data);
757: WHEN NO_DATA_FOUND THEN
758: x_return_status := FND_API.G_RET_STS_ERROR;
759: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
760: ,p_data => x_msg_data);
761: WHEN OTHERS THEN
762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
763: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

759: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
760: ,p_data => x_msg_data);
761: WHEN OTHERS THEN
762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
763: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
764: ,p_data => x_msg_data);
765: if (x_msg_data is null) then
766: x_msg_data := SQLERRM;
767: end if;

Line 886: FND_MSG_PUB.ADD;

882: x_msg_count => x_msg_count,
883: x_msg_data =>x_msg_data);
884: else
885: FND_MESSAGE.SET_NAME('BIS','BIS_PD_UNIQUE_PGE_ERR');
886: FND_MSG_PUB.ADD;
887: RAISE FND_API.G_EXC_ERROR;
888: end if;
889: end if;
890:

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

937:
938: EXCEPTION
939: WHEN FND_API.G_EXC_ERROR THEN
940: x_return_status := FND_API.G_RET_STS_ERROR;
941: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
942: ,p_data => x_msg_data);
943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
945: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

941: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
942: ,p_data => x_msg_data);
943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
945: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
946: ,p_data => x_msg_data);
947: WHEN NO_DATA_FOUND THEN
948: x_return_status := FND_API.G_RET_STS_ERROR;
949: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

945: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
946: ,p_data => x_msg_data);
947: WHEN NO_DATA_FOUND THEN
948: x_return_status := FND_API.G_RET_STS_ERROR;
949: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
950: ,p_data => x_msg_data);
951: WHEN OTHERS THEN
952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
953: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

949: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
950: ,p_data => x_msg_data);
951: WHEN OTHERS THEN
952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
953: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
954: ,p_data => x_msg_data);
955: if (x_msg_data is null) then
956: x_msg_data := SQLERRM;
957: end if;

Line 979: fnd_msg_pub.initialize;

975: l_parameters FND_FORM_FUNCTIONS.Parameters%Type;
976: l_app_short_name VARCHAR2(30);
977: l_page_xml_name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE;
978: begin
979: fnd_msg_pub.initialize;
980:
981: select count(1) into l_count
982: from fnd_form_functions
983: where function_name = p_page_function_name;

Line 988: FND_MSG_PUB.ADD;

984:
985: if (l_count > 0) then
986: -- Trying to update a non-page function.
987: FND_MESSAGE.SET_NAME('BIS','BIS_PD_UNIQUE_PGE_ERR');
988: FND_MSG_PUB.ADD;
989: RAISE FND_API.G_EXC_ERROR;
990: else
991:
992: select lower(application_short_name) into l_app_short_name

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

1020:
1021: EXCEPTION
1022: WHEN FND_API.G_EXC_ERROR THEN
1023: x_return_status := FND_API.G_RET_STS_ERROR;
1024: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1025: ,p_data => x_msg_data);
1026: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1028: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

1024: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1025: ,p_data => x_msg_data);
1026: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1028: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1029: ,p_data => x_msg_data);
1030: WHEN NO_DATA_FOUND THEN
1031: x_return_status := FND_API.G_RET_STS_ERROR;
1032: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

1028: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1029: ,p_data => x_msg_data);
1030: WHEN NO_DATA_FOUND THEN
1031: x_return_status := FND_API.G_RET_STS_ERROR;
1032: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1033: ,p_data => x_msg_data);
1034: WHEN OTHERS THEN
1035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1036: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

1032: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1033: ,p_data => x_msg_data);
1034: WHEN OTHERS THEN
1035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1036: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1037: ,p_data => x_msg_data);
1038: if (x_msg_data is null) then
1039: x_msg_data := SQLERRM;
1040: end if;

Line 1069: fnd_msg_pub.initialize;

1065: l_application_id NUMBER;
1066: l_menu_name FND_MENUS.Menu_Name%Type := NULL;
1067: l_page_xml_name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE;
1068: begin
1069: fnd_msg_pub.initialize;
1070:
1071: begin
1072: select BIS_COMMON_UTILS.getParameterValue(parameters, c_SOURCE_TYPE),
1073: function_id,

Line 1124: FND_MSG_PUB.ADD;

1120:
1121: if (l_count > 0) then
1122: -- Duplicate function name
1123: FND_MESSAGE.SET_NAME('BIS','BIS_PD_UNIQUE_PGE_ERR');
1124: FND_MSG_PUB.ADD;
1125: RAISE FND_API.G_EXC_ERROR;
1126: end if;
1127:
1128: UPDATE fnd_form_functions

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

1141:
1142: EXCEPTION
1143: WHEN FND_API.G_EXC_ERROR THEN
1144: x_return_status := FND_API.G_RET_STS_ERROR;
1145: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1146: ,p_data => x_msg_data);
1147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1149: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

1145: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1146: ,p_data => x_msg_data);
1147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1149: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1150: ,p_data => x_msg_data);
1151: WHEN NO_DATA_FOUND THEN
1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

1149: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1150: ,p_data => x_msg_data);
1151: WHEN NO_DATA_FOUND THEN
1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1154: ,p_data => x_msg_data);
1155: WHEN OTHERS THEN
1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1157: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

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

1153: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1154: ,p_data => x_msg_data);
1155: WHEN OTHERS THEN
1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1157: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1158: ,p_data => x_msg_data);
1159: if (x_msg_data is null) then
1160: x_msg_data := SQLERRM;
1161: end if;