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.IBE_DSP_MSITE_SCT_SECT_PVT dependencies on FND_MESSAGE

Line 374: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

370: -- do nothing
371: NULL;
372:
373: WHEN OTHERS THEN
374: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
375: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
376: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
377: FND_MESSAGE.Set_Token('REASON', SQLERRM);
378: FND_MSG_PUB.Add;

Line 375: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

371: NULL;
372:
373: WHEN OTHERS THEN
374: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
375: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
376: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
377: FND_MESSAGE.Set_Token('REASON', SQLERRM);
378: FND_MSG_PUB.Add;
379:

Line 376: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

372:
373: WHEN OTHERS THEN
374: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
375: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
376: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
377: FND_MESSAGE.Set_Token('REASON', SQLERRM);
378: FND_MSG_PUB.Add;
379:
380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 377: FND_MESSAGE.Set_Token('REASON', SQLERRM);

373: WHEN OTHERS THEN
374: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
375: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
376: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
377: FND_MESSAGE.Set_Token('REASON', SQLERRM);
378: FND_MSG_PUB.Add;
379:
380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
381:

Line 404: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

400: p_data => x_msg_data,
401: p_encoded => 'F');
402:
403: WHEN OTHERS THEN
404: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
405: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
406: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
407: FND_MESSAGE.Set_Token('REASON', SQLERRM);
408: FND_MSG_PUB.Add;

Line 405: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

401: p_encoded => 'F');
402:
403: WHEN OTHERS THEN
404: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
405: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
406: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
407: FND_MESSAGE.Set_Token('REASON', SQLERRM);
408: FND_MSG_PUB.Add;
409:

Line 406: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

402:
403: WHEN OTHERS THEN
404: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
405: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
406: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
407: FND_MESSAGE.Set_Token('REASON', SQLERRM);
408: FND_MSG_PUB.Add;
409:
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 407: FND_MESSAGE.Set_Token('REASON', SQLERRM);

403: WHEN OTHERS THEN
404: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
405: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
406: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
407: FND_MESSAGE.Set_Token('REASON', SQLERRM);
408: FND_MSG_PUB.Add;
409:
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
411:

Line 474: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_MSITE_ID');

470: -- mini site id
471: IF ((p_mini_site_id IS NULL) OR
472: (p_mini_site_id = FND_API.G_MISS_NUM))
473: THEN
474: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_MSITE_ID');
475: FND_MSG_PUB.Add;
476: RAISE FND_API.G_EXC_ERROR;
477: END IF;
478:

Line 483: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_CHILD_SCT_ID');

479: -- child section id
480: IF ((p_child_section_id IS NULL) OR
481: (p_child_section_id = FND_API.G_MISS_NUM))
482: THEN
483: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_CHILD_SCT_ID');
484: FND_MSG_PUB.Add;
485: RAISE FND_API.G_EXC_ERROR;
486: END IF;
487:

Line 492: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_START_DATE');

488: -- start_date_active
489: IF ((p_start_date_active IS NULL) OR
490: (p_start_date_active = FND_API.G_MISS_DATE))
491: THEN
492: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_START_DATE');
493: FND_MSG_PUB.Add;
494: RAISE FND_API.G_EXC_ERROR;
495: END IF;
496:

Line 506: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_SCT_LVL_NUM');

502: IF ((p_level_number IS NOT NULL) AND
503: (p_level_number <> FND_API.G_MISS_NUM))
504: THEN
505: IF(p_level_number < 0) THEN
506: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_SCT_LVL_NUM');
507: FND_MSG_PUB.Add;
508: RAISE FND_API.G_EXC_ERROR;
509: END IF;
510: END IF;

Line 517: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_SCT_SORT_ORDER');

513: IF ((p_sort_order IS NOT NULL) AND
514: (p_sort_order <> FND_API.G_MISS_NUM))
515: THEN
516: IF(p_sort_order < 0) THEN
517: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_SCT_SORT_ORDER');
518: FND_MSG_PUB.Add;
519: RAISE FND_API.G_EXC_ERROR;
520: END IF;
521: END IF;

Line 534: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_MSITE_ID');

530: SELECT msite_id INTO l_mini_site_id FROM ibe_msites_b
531: WHERE msite_id = p_mini_site_id and site_type = 'I';
532: EXCEPTION
533: WHEN NO_DATA_FOUND THEN
534: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_MSITE_ID');
535: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
536: FND_MSG_PUB.Add;
537: RAISE FND_API.G_EXC_ERROR;
538: WHEN OTHERS THEN

Line 535: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);

531: WHERE msite_id = p_mini_site_id and site_type = 'I';
532: EXCEPTION
533: WHEN NO_DATA_FOUND THEN
534: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_MSITE_ID');
535: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
536: FND_MSG_PUB.Add;
537: RAISE FND_API.G_EXC_ERROR;
538: WHEN OTHERS THEN
539: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

Line 539: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

535: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
536: FND_MSG_PUB.Add;
537: RAISE FND_API.G_EXC_ERROR;
538: WHEN OTHERS THEN
539: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
540: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
541: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
542: FND_MESSAGE.Set_Token('REASON', SQLERRM);
543: FND_MSG_PUB.Add;

Line 540: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

536: FND_MSG_PUB.Add;
537: RAISE FND_API.G_EXC_ERROR;
538: WHEN OTHERS THEN
539: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
540: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
541: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
542: FND_MESSAGE.Set_Token('REASON', SQLERRM);
543: FND_MSG_PUB.Add;
544:

Line 541: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

537: RAISE FND_API.G_EXC_ERROR;
538: WHEN OTHERS THEN
539: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
540: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
541: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
542: FND_MESSAGE.Set_Token('REASON', SQLERRM);
543: FND_MSG_PUB.Add;
544:
545: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_MSITE_ID');

Line 542: FND_MESSAGE.Set_Token('REASON', SQLERRM);

538: WHEN OTHERS THEN
539: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
540: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
541: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
542: FND_MESSAGE.Set_Token('REASON', SQLERRM);
543: FND_MSG_PUB.Add;
544:
545: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_MSITE_ID');
546: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);

Line 545: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_MSITE_ID');

541: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
542: FND_MESSAGE.Set_Token('REASON', SQLERRM);
543: FND_MSG_PUB.Add;
544:
545: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_MSITE_ID');
546: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
547: FND_MSG_PUB.Add;
548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
549: END;

Line 546: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);

542: FND_MESSAGE.Set_Token('REASON', SQLERRM);
543: FND_MSG_PUB.Add;
544:
545: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_MSITE_ID');
546: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
547: FND_MSG_PUB.Add;
548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
549: END;
550:

Line 560: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_SCT_ID');

556: SELECT section_id INTO l_parent_section_id FROM ibe_dsp_sections_b
557: WHERE section_id = p_parent_section_id;
558: EXCEPTION
559: WHEN NO_DATA_FOUND THEN
560: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_SCT_ID');
561: FND_MESSAGE.Set_Token('SECTION_ID', p_parent_section_id);
562: FND_MSG_PUB.Add;
563: RAISE FND_API.G_EXC_ERROR;
564: WHEN OTHERS THEN

Line 561: FND_MESSAGE.Set_Token('SECTION_ID', p_parent_section_id);

557: WHERE section_id = p_parent_section_id;
558: EXCEPTION
559: WHEN NO_DATA_FOUND THEN
560: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_SCT_ID');
561: FND_MESSAGE.Set_Token('SECTION_ID', p_parent_section_id);
562: FND_MSG_PUB.Add;
563: RAISE FND_API.G_EXC_ERROR;
564: WHEN OTHERS THEN
565: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

Line 565: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

561: FND_MESSAGE.Set_Token('SECTION_ID', p_parent_section_id);
562: FND_MSG_PUB.Add;
563: RAISE FND_API.G_EXC_ERROR;
564: WHEN OTHERS THEN
565: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
566: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
567: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
568: FND_MESSAGE.Set_Token('REASON', SQLERRM);
569: FND_MSG_PUB.Add;

Line 566: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

562: FND_MSG_PUB.Add;
563: RAISE FND_API.G_EXC_ERROR;
564: WHEN OTHERS THEN
565: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
566: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
567: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
568: FND_MESSAGE.Set_Token('REASON', SQLERRM);
569: FND_MSG_PUB.Add;
570:

Line 567: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

563: RAISE FND_API.G_EXC_ERROR;
564: WHEN OTHERS THEN
565: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
566: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
567: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
568: FND_MESSAGE.Set_Token('REASON', SQLERRM);
569: FND_MSG_PUB.Add;
570:
571: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_SCT_ID');

Line 568: FND_MESSAGE.Set_Token('REASON', SQLERRM);

564: WHEN OTHERS THEN
565: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
566: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
567: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
568: FND_MESSAGE.Set_Token('REASON', SQLERRM);
569: FND_MSG_PUB.Add;
570:
571: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_SCT_ID');
572: FND_MESSAGE.Set_Token('SECTION_ID', p_parent_section_id);

Line 571: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_SCT_ID');

567: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
568: FND_MESSAGE.Set_Token('REASON', SQLERRM);
569: FND_MSG_PUB.Add;
570:
571: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_SCT_ID');
572: FND_MESSAGE.Set_Token('SECTION_ID', p_parent_section_id);
573: FND_MSG_PUB.Add;
574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
575: END;

Line 572: FND_MESSAGE.Set_Token('SECTION_ID', p_parent_section_id);

568: FND_MESSAGE.Set_Token('REASON', SQLERRM);
569: FND_MSG_PUB.Add;
570:
571: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_SCT_ID');
572: FND_MESSAGE.Set_Token('SECTION_ID', p_parent_section_id);
573: FND_MSG_PUB.Add;
574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
575: END;
576: END IF;

Line 585: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_SCT_ID');

581: SELECT section_id INTO l_child_section_id FROM ibe_dsp_sections_b
582: WHERE section_id = p_child_section_id;
583: EXCEPTION
584: WHEN NO_DATA_FOUND THEN
585: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_SCT_ID');
586: FND_MESSAGE.Set_Token('SECTION_ID', p_child_section_id);
587: FND_MSG_PUB.Add;
588: RAISE FND_API.G_EXC_ERROR;
589: WHEN OTHERS THEN

Line 586: FND_MESSAGE.Set_Token('SECTION_ID', p_child_section_id);

582: WHERE section_id = p_child_section_id;
583: EXCEPTION
584: WHEN NO_DATA_FOUND THEN
585: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_SCT_ID');
586: FND_MESSAGE.Set_Token('SECTION_ID', p_child_section_id);
587: FND_MSG_PUB.Add;
588: RAISE FND_API.G_EXC_ERROR;
589: WHEN OTHERS THEN
590: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

Line 590: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

586: FND_MESSAGE.Set_Token('SECTION_ID', p_child_section_id);
587: FND_MSG_PUB.Add;
588: RAISE FND_API.G_EXC_ERROR;
589: WHEN OTHERS THEN
590: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
591: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
592: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
593: FND_MESSAGE.Set_Token('REASON', SQLERRM);
594: FND_MSG_PUB.Add;

Line 591: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

587: FND_MSG_PUB.Add;
588: RAISE FND_API.G_EXC_ERROR;
589: WHEN OTHERS THEN
590: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
591: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
592: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
593: FND_MESSAGE.Set_Token('REASON', SQLERRM);
594: FND_MSG_PUB.Add;
595:

Line 592: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

588: RAISE FND_API.G_EXC_ERROR;
589: WHEN OTHERS THEN
590: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
591: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
592: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
593: FND_MESSAGE.Set_Token('REASON', SQLERRM);
594: FND_MSG_PUB.Add;
595:
596: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_SCT_ID');

Line 593: FND_MESSAGE.Set_Token('REASON', SQLERRM);

589: WHEN OTHERS THEN
590: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
591: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
592: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
593: FND_MESSAGE.Set_Token('REASON', SQLERRM);
594: FND_MSG_PUB.Add;
595:
596: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_SCT_ID');
597: FND_MESSAGE.Set_Token('SECTION_ID', p_child_section_id);

Line 596: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_SCT_ID');

592: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
593: FND_MESSAGE.Set_Token('REASON', SQLERRM);
594: FND_MSG_PUB.Add;
595:
596: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_SCT_ID');
597: FND_MESSAGE.Set_Token('SECTION_ID', p_child_section_id);
598: FND_MSG_PUB.Add;
599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
600: END;

Line 597: FND_MESSAGE.Set_Token('SECTION_ID', p_child_section_id);

593: FND_MESSAGE.Set_Token('REASON', SQLERRM);
594: FND_MSG_PUB.Add;
595:
596: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_SCT_ID');
597: FND_MESSAGE.Set_Token('SECTION_ID', p_child_section_id);
598: FND_MSG_PUB.Add;
599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
600: END;
601:

Line 614: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_DUPLICATE_ENTRY');

610:
611: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
613: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
614: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_DUPLICATE_ENTRY');
615: FND_MSG_PUB.Add;
616: RAISE FND_API.G_EXC_ERROR; -- duplicate entry
617: END IF;
618:

Line 634: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

630: p_data => x_msg_data,
631: p_encoded => 'F');
632:
633: WHEN OTHERS THEN
634: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
635: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
636: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
637: FND_MESSAGE.Set_Token('REASON', SQLERRM);
638: FND_MSG_PUB.Add;

Line 635: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

631: p_encoded => 'F');
632:
633: WHEN OTHERS THEN
634: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
635: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
636: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
637: FND_MESSAGE.Set_Token('REASON', SQLERRM);
638: FND_MSG_PUB.Add;
639:

Line 636: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

632:
633: WHEN OTHERS THEN
634: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
635: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
636: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
637: FND_MESSAGE.Set_Token('REASON', SQLERRM);
638: FND_MSG_PUB.Add;
639:
640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 637: FND_MESSAGE.Set_Token('REASON', SQLERRM);

633: WHEN OTHERS THEN
634: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
635: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
636: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
637: FND_MESSAGE.Set_Token('REASON', SQLERRM);
638: FND_MSG_PUB.Add;
639:
640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
641:

Line 703: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NULL_PRIMARY_KEY');

699: --
700:
701: -- mini_site_section_section_id
702: IF (p_mini_site_section_section_id IS NULL) THEN
703: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NULL_PRIMARY_KEY');
704: FND_MSG_PUB.Add;
705: RAISE FND_API.G_EXC_ERROR;
706: END IF;
707:

Line 710: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_START_DATE');

706: END IF;
707:
708: -- start_date_active
709: IF (p_start_date_active IS NULL) THEN
710: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_START_DATE');
711: FND_MSG_PUB.Add;
712: RAISE FND_API.G_EXC_ERROR;
713: END IF;
714:

Line 724: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_SCT_LVL_NUM');

720: IF ((p_level_number IS NOT NULL) AND
721: (p_level_number <> FND_API.G_MISS_NUM))
722: THEN
723: IF(p_level_number < 0) THEN
724: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_SCT_LVL_NUM');
725: FND_MSG_PUB.Add;
726: RAISE FND_API.G_EXC_ERROR;
727: END IF;
728: END IF;

Line 735: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_SCT_SORT_ORDER');

731: IF ((p_sort_order IS NOT NULL) AND
732: (p_sort_order <> FND_API.G_MISS_NUM))
733: THEN
734: IF(p_sort_order < 0) THEN
735: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_SCT_SORT_ORDER');
736: FND_MSG_PUB.Add;
737: RAISE FND_API.G_EXC_ERROR;
738: END IF;
739: END IF;

Line 756: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

752: p_data => x_msg_data,
753: p_encoded => 'F');
754:
755: WHEN OTHERS THEN
756: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
757: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
758: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
759: FND_MESSAGE.Set_Token('REASON', SQLERRM);
760: FND_MSG_PUB.Add;

Line 757: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

753: p_encoded => 'F');
754:
755: WHEN OTHERS THEN
756: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
757: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
758: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
759: FND_MESSAGE.Set_Token('REASON', SQLERRM);
760: FND_MSG_PUB.Add;
761:

Line 758: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

754:
755: WHEN OTHERS THEN
756: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
757: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
758: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
759: FND_MESSAGE.Set_Token('REASON', SQLERRM);
760: FND_MSG_PUB.Add;
761:
762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 759: FND_MESSAGE.Set_Token('REASON', SQLERRM);

755: WHEN OTHERS THEN
756: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
757: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
758: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
759: FND_MESSAGE.Set_Token('REASON', SQLERRM);
760: FND_MSG_PUB.Add;
761:
762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
763:

Line 860: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSS_INVALID_CREATE');

856:
857: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
859: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
860: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSS_INVALID_CREATE');
861: FND_MSG_PUB.Add;
862: RAISE FND_API.G_EXC_ERROR; -- invalid
863: END IF;
864:

Line 891: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSS_INSERT_FAIL');

887: x_mini_site_section_section_id
888: );
889: EXCEPTION
890: WHEN NO_DATA_FOUND THEN
891: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSS_INSERT_FAIL');
892: FND_MSG_PUB.Add;
893: RAISE FND_API.G_EXC_ERROR;
894: WHEN OTHERS THEN
895: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

Line 895: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

891: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSS_INSERT_FAIL');
892: FND_MSG_PUB.Add;
893: RAISE FND_API.G_EXC_ERROR;
894: WHEN OTHERS THEN
895: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
896: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
897: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
898: FND_MESSAGE.Set_Token('REASON', SQLERRM);
899: FND_MSG_PUB.Add;

Line 896: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

892: FND_MSG_PUB.Add;
893: RAISE FND_API.G_EXC_ERROR;
894: WHEN OTHERS THEN
895: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
896: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
897: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
898: FND_MESSAGE.Set_Token('REASON', SQLERRM);
899: FND_MSG_PUB.Add;
900:

Line 897: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

893: RAISE FND_API.G_EXC_ERROR;
894: WHEN OTHERS THEN
895: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
896: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
897: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
898: FND_MESSAGE.Set_Token('REASON', SQLERRM);
899: FND_MSG_PUB.Add;
900:
901: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSS_INSERT_FAIL');

Line 898: FND_MESSAGE.Set_Token('REASON', SQLERRM);

894: WHEN OTHERS THEN
895: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
896: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
897: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
898: FND_MESSAGE.Set_Token('REASON', SQLERRM);
899: FND_MSG_PUB.Add;
900:
901: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSS_INSERT_FAIL');
902: FND_MSG_PUB.Add;

Line 901: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSS_INSERT_FAIL');

897: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
898: FND_MESSAGE.Set_Token('REASON', SQLERRM);
899: FND_MSG_PUB.Add;
900:
901: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSS_INSERT_FAIL');
902: FND_MSG_PUB.Add;
903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
904: END;
905:

Line 938: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

934:
935: WHEN OTHERS THEN
936: ROLLBACK TO CREATE_MSITE_SCT_SECT_PVT;
937:
938: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
939: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
940: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
941: FND_MESSAGE.Set_Token('REASON', SQLERRM);
942: FND_MSG_PUB.Add;

Line 939: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

935: WHEN OTHERS THEN
936: ROLLBACK TO CREATE_MSITE_SCT_SECT_PVT;
937:
938: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
939: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
940: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
941: FND_MESSAGE.Set_Token('REASON', SQLERRM);
942: FND_MSG_PUB.Add;
943:

Line 940: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

936: ROLLBACK TO CREATE_MSITE_SCT_SECT_PVT;
937:
938: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
939: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
940: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
941: FND_MESSAGE.Set_Token('REASON', SQLERRM);
942: FND_MSG_PUB.Add;
943:
944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 941: FND_MESSAGE.Set_Token('REASON', SQLERRM);

937:
938: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
939: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
940: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
941: FND_MESSAGE.Set_Token('REASON', SQLERRM);
942: FND_MSG_PUB.Add;
943:
944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
945:

Line 1050: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_MSS_ID');

1046: END IF;
1047:
1048: EXCEPTION
1049: WHEN NO_DATA_FOUND THEN
1050: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_MSS_ID');
1051: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
1052: IF (p_parent_section_id IS NOT NULL) THEN
1053: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1054: ELSE

Line 1051: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);

1047:
1048: EXCEPTION
1049: WHEN NO_DATA_FOUND THEN
1050: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_MSS_ID');
1051: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
1052: IF (p_parent_section_id IS NOT NULL) THEN
1053: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1054: ELSE
1055: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');

Line 1053: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);

1049: WHEN NO_DATA_FOUND THEN
1050: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_MSS_ID');
1051: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
1052: IF (p_parent_section_id IS NOT NULL) THEN
1053: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1054: ELSE
1055: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
1056: END IF;
1057: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);

Line 1055: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');

1051: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
1052: IF (p_parent_section_id IS NOT NULL) THEN
1053: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1054: ELSE
1055: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
1056: END IF;
1057: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);
1058: FND_MSG_PUB.Add;
1059: RAISE FND_API.G_EXC_ERROR;

Line 1057: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);

1053: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1054: ELSE
1055: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
1056: END IF;
1057: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);
1058: FND_MSG_PUB.Add;
1059: RAISE FND_API.G_EXC_ERROR;
1060: WHEN OTHERS THEN
1061: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

Line 1061: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

1057: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);
1058: FND_MSG_PUB.Add;
1059: RAISE FND_API.G_EXC_ERROR;
1060: WHEN OTHERS THEN
1061: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1062: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1063: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1064: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1065: FND_MSG_PUB.Add;

Line 1062: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

1058: FND_MSG_PUB.Add;
1059: RAISE FND_API.G_EXC_ERROR;
1060: WHEN OTHERS THEN
1061: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1062: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1063: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1064: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1065: FND_MSG_PUB.Add;
1066:

Line 1063: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

1059: RAISE FND_API.G_EXC_ERROR;
1060: WHEN OTHERS THEN
1061: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1062: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1063: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1064: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1065: FND_MSG_PUB.Add;
1066:
1067: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_MSS_ID');

Line 1064: FND_MESSAGE.Set_Token('REASON', SQLERRM);

1060: WHEN OTHERS THEN
1061: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1062: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1063: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1064: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1065: FND_MSG_PUB.Add;
1066:
1067: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_MSS_ID');
1068: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);

Line 1067: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_MSS_ID');

1063: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1064: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1065: FND_MSG_PUB.Add;
1066:
1067: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_MSS_ID');
1068: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
1069: IF (p_parent_section_id IS NOT NULL) THEN
1070: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1071: ELSE

Line 1068: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);

1064: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1065: FND_MSG_PUB.Add;
1066:
1067: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_MSS_ID');
1068: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
1069: IF (p_parent_section_id IS NOT NULL) THEN
1070: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1071: ELSE
1072: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');

Line 1070: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);

1066:
1067: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_MSS_ID');
1068: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
1069: IF (p_parent_section_id IS NOT NULL) THEN
1070: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1071: ELSE
1072: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
1073: END IF;
1074: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);

Line 1072: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');

1068: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
1069: IF (p_parent_section_id IS NOT NULL) THEN
1070: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1071: ELSE
1072: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
1073: END IF;
1074: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);
1075: FND_MSG_PUB.Add;
1076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1074: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);

1070: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1071: ELSE
1072: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
1073: END IF;
1074: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);
1075: FND_MSG_PUB.Add;
1076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1077: END;
1078: ELSE

Line 1081: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_MSS_IDS_SPEC');

1077: END;
1078: ELSE
1079: -- neither mini_site_section_section_id nor combination of
1080: -- mini_site_id, parent_section_id and child_section_id is specified
1081: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_MSS_IDS_SPEC');
1082: FND_MSG_PUB.Add;
1083: RAISE FND_API.G_EXC_ERROR;
1084: END IF;
1085:

Line 1109: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSS_INVALID_UPDATE');

1105:
1106: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1108: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1109: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSS_INVALID_UPDATE');
1110: FND_MSG_PUB.Add;
1111: RAISE FND_API.G_EXC_ERROR; -- invalid
1112: END IF;
1113:

Line 1131: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSS_UPDATE_FAIL');

1127: FND_GLOBAL.login_id
1128: );
1129: EXCEPTION
1130: WHEN NO_DATA_FOUND THEN
1131: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSS_UPDATE_FAIL');
1132: FND_MSG_PUB.Add;
1133: RAISE FND_API.G_EXC_ERROR;
1134: WHEN OTHERS THEN
1135: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

Line 1135: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

1131: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSS_UPDATE_FAIL');
1132: FND_MSG_PUB.Add;
1133: RAISE FND_API.G_EXC_ERROR;
1134: WHEN OTHERS THEN
1135: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1136: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1137: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1138: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1139: FND_MSG_PUB.Add;

Line 1136: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

1132: FND_MSG_PUB.Add;
1133: RAISE FND_API.G_EXC_ERROR;
1134: WHEN OTHERS THEN
1135: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1136: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1137: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1138: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1139: FND_MSG_PUB.Add;
1140:

Line 1137: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

1133: RAISE FND_API.G_EXC_ERROR;
1134: WHEN OTHERS THEN
1135: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1136: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1137: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1138: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1139: FND_MSG_PUB.Add;
1140:
1141: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSS_UPDATE_FAIL');

Line 1138: FND_MESSAGE.Set_Token('REASON', SQLERRM);

1134: WHEN OTHERS THEN
1135: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1136: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1137: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1138: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1139: FND_MSG_PUB.Add;
1140:
1141: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSS_UPDATE_FAIL');
1142: FND_MSG_PUB.Add;

Line 1141: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSS_UPDATE_FAIL');

1137: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1138: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1139: FND_MSG_PUB.Add;
1140:
1141: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSS_UPDATE_FAIL');
1142: FND_MSG_PUB.Add;
1143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1144: END;
1145:

Line 1178: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

1174:
1175: WHEN OTHERS THEN
1176: ROLLBACK TO UPDATE_MSITE_SCT_SECT_PVT;
1177:
1178: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1179: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1180: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1181: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1182: FND_MSG_PUB.Add;

Line 1179: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

1175: WHEN OTHERS THEN
1176: ROLLBACK TO UPDATE_MSITE_SCT_SECT_PVT;
1177:
1178: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1179: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1180: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1181: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1182: FND_MSG_PUB.Add;
1183:

Line 1180: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

1176: ROLLBACK TO UPDATE_MSITE_SCT_SECT_PVT;
1177:
1178: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1179: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1180: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1181: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1182: FND_MSG_PUB.Add;
1183:
1184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1181: FND_MESSAGE.Set_Token('REASON', SQLERRM);

1177:
1178: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1179: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1180: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1181: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1182: FND_MSG_PUB.Add;
1183:
1184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1185:

Line 1278: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_MSS_ID');

1274: END IF;
1275:
1276: EXCEPTION
1277: WHEN NO_DATA_FOUND THEN
1278: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_MSS_ID');
1279: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
1280: IF (p_parent_section_id IS NOT NULL) THEN
1281: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1282: ELSE

Line 1279: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);

1275:
1276: EXCEPTION
1277: WHEN NO_DATA_FOUND THEN
1278: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_MSS_ID');
1279: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
1280: IF (p_parent_section_id IS NOT NULL) THEN
1281: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1282: ELSE
1283: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');

Line 1281: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);

1277: WHEN NO_DATA_FOUND THEN
1278: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_MSS_ID');
1279: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
1280: IF (p_parent_section_id IS NOT NULL) THEN
1281: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1282: ELSE
1283: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
1284: END IF;
1285: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);

Line 1283: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');

1279: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
1280: IF (p_parent_section_id IS NOT NULL) THEN
1281: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1282: ELSE
1283: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
1284: END IF;
1285: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);
1286: FND_MSG_PUB.Add;
1287: RAISE FND_API.G_EXC_ERROR;

Line 1285: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);

1281: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1282: ELSE
1283: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
1284: END IF;
1285: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);
1286: FND_MSG_PUB.Add;
1287: RAISE FND_API.G_EXC_ERROR;
1288: WHEN OTHERS THEN
1289: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

Line 1289: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

1285: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);
1286: FND_MSG_PUB.Add;
1287: RAISE FND_API.G_EXC_ERROR;
1288: WHEN OTHERS THEN
1289: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1290: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1291: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1292: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1293: FND_MSG_PUB.Add;

Line 1290: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

1286: FND_MSG_PUB.Add;
1287: RAISE FND_API.G_EXC_ERROR;
1288: WHEN OTHERS THEN
1289: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1290: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1291: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1292: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1293: FND_MSG_PUB.Add;
1294:

Line 1291: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

1287: RAISE FND_API.G_EXC_ERROR;
1288: WHEN OTHERS THEN
1289: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1290: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1291: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1292: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1293: FND_MSG_PUB.Add;
1294:
1295: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_MSS_ID');

Line 1292: FND_MESSAGE.Set_Token('REASON', SQLERRM);

1288: WHEN OTHERS THEN
1289: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1290: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1291: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1292: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1293: FND_MSG_PUB.Add;
1294:
1295: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_MSS_ID');
1296: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);

Line 1295: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_MSS_ID');

1291: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1292: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1293: FND_MSG_PUB.Add;
1294:
1295: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_MSS_ID');
1296: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
1297: IF (p_parent_section_id IS NOT NULL) THEN
1298: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1299: ELSE

Line 1296: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);

1292: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1293: FND_MSG_PUB.Add;
1294:
1295: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_MSS_ID');
1296: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
1297: IF (p_parent_section_id IS NOT NULL) THEN
1298: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1299: ELSE
1300: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');

Line 1298: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);

1294:
1295: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_MSS_ID');
1296: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
1297: IF (p_parent_section_id IS NOT NULL) THEN
1298: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1299: ELSE
1300: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
1301: END IF;
1302: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);

Line 1300: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');

1296: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
1297: IF (p_parent_section_id IS NOT NULL) THEN
1298: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1299: ELSE
1300: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
1301: END IF;
1302: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);
1303: FND_MSG_PUB.Add;
1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1302: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);

1298: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1299: ELSE
1300: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
1301: END IF;
1302: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);
1303: FND_MSG_PUB.Add;
1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1305: END;
1306:

Line 1310: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_MSS_IDS_SPEC');

1306:
1307: ELSE
1308: -- neither mini_site_section_section_id nor combination of
1309: -- mini_site_id, parent_section_id and child_section_id is specified
1310: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_MSS_IDS_SPEC');
1311: FND_MSG_PUB.Add;
1312: RAISE FND_API.G_EXC_ERROR;
1313: END IF;
1314:

Line 1337: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

1333:
1334: WHEN OTHERS THEN
1335: ROLLBACK TO DELETE_MSITE_SCT_SECT_PVT;
1336:
1337: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1338: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1339: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1340: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1341: FND_MSG_PUB.Add;

Line 1338: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

1334: WHEN OTHERS THEN
1335: ROLLBACK TO DELETE_MSITE_SCT_SECT_PVT;
1336:
1337: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1338: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1339: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1340: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1341: FND_MSG_PUB.Add;
1342:

Line 1339: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

1335: ROLLBACK TO DELETE_MSITE_SCT_SECT_PVT;
1336:
1337: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1338: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1339: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1340: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1341: FND_MSG_PUB.Add;
1342:
1343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1340: FND_MESSAGE.Set_Token('REASON', SQLERRM);

1336:
1337: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1338: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1339: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1340: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1341: FND_MSG_PUB.Add;
1342:
1343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1344:

Line 1468: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

1464:
1465: WHEN OTHERS THEN
1466: ROLLBACK TO UPDATE_MSITE_SCT_SECTS_PVT;
1467:
1468: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1469: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1470: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1471: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1472: FND_MSG_PUB.Add;

Line 1469: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

1465: WHEN OTHERS THEN
1466: ROLLBACK TO UPDATE_MSITE_SCT_SECTS_PVT;
1467:
1468: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1469: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1470: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1471: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1472: FND_MSG_PUB.Add;
1473:

Line 1470: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

1466: ROLLBACK TO UPDATE_MSITE_SCT_SECTS_PVT;
1467:
1468: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1469: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1470: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1471: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1472: FND_MSG_PUB.Add;
1473:
1474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1471: FND_MESSAGE.Set_Token('REASON', SQLERRM);

1467:
1468: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1469: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1470: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1471: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1472: FND_MSG_PUB.Add;
1473:
1474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1475:

Line 1628: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

1624:
1625: WHEN OTHERS THEN
1626: ROLLBACK TO UPDATE_DELETE_SCT_SCTS_PVT;
1627:
1628: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1629: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1630: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1631: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1632: FND_MSG_PUB.Add;

Line 1629: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

1625: WHEN OTHERS THEN
1626: ROLLBACK TO UPDATE_DELETE_SCT_SCTS_PVT;
1627:
1628: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1629: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1630: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1631: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1632: FND_MSG_PUB.Add;
1633:

Line 1630: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

1626: ROLLBACK TO UPDATE_DELETE_SCT_SCTS_PVT;
1627:
1628: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1629: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1630: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1631: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1632: FND_MSG_PUB.Add;
1633:
1634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1631: FND_MESSAGE.Set_Token('REASON', SQLERRM);

1627:
1628: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1629: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1630: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1631: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1632: FND_MSG_PUB.Add;
1633:
1634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1635: