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_WF_NOTIF_MSG_MAPS_PVT dependencies on FND_API

Line 409: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM) return BOOLEAN

405: END LOAD_ROW;
406:
407: function check_msg_map_exists(
408: p_notif_msg_map_id IN NUMBER,
409: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM) return BOOLEAN
410: IS
411: l_exists VARCHAR2(1) := '0';
412: BEGIN
413: if( p_object_version_number = FND_API.G_MISS_NUM OR p_object_version_number IS NULL ) then

Line 413: if( p_object_version_number = FND_API.G_MISS_NUM OR p_object_version_number IS NULL ) then

409: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM) return BOOLEAN
410: IS
411: l_exists VARCHAR2(1) := '0';
412: BEGIN
413: if( p_object_version_number = FND_API.G_MISS_NUM OR p_object_version_number IS NULL ) then
414: select '1'
415: into l_exists
416: from dual
417: where exists (

Line 524: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

520: END;
521:
522: procedure save_wf_notif_msg_maps(
523: p_api_version IN NUMBER,
524: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
525: p_commit IN VARCHAR2 := FND_API.G_FALSE,
526: x_return_status OUT NOCOPY VARCHAR2,
527: x_msg_count OUT NOCOPY NUMBER,
528: x_msg_data OUT NOCOPY VARCHAR2,

Line 525: p_commit IN VARCHAR2 := FND_API.G_FALSE,

521:
522: procedure save_wf_notif_msg_maps(
523: p_api_version IN NUMBER,
524: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
525: p_commit IN VARCHAR2 := FND_API.G_FALSE,
526: x_return_status OUT NOCOPY VARCHAR2,
527: x_msg_count OUT NOCOPY NUMBER,
528: x_msg_data OUT NOCOPY VARCHAR2,
529: P_NOTIF_MSG_MAP_ID in NUMBER,

Line 540: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,

536: P_ALL_MSITE_FLAG in VARCHAR2,
537: P_ALL_USER_TYPE_FLAG in VARCHAR2,
538: P_MSITE_ID in NUMBER,
539: P_ORG_ID in NUMBER,
540: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
541: P_MESSAGE_NAME in VARCHAR2)
542: IS
543: l_api_name VARCHAR2(30) := 'SAVE_WF_NOTIF_MSG_MAPS';
544: l_full_name VARCHAR2(60) := g_pkg_name || '.' || l_api_name;

Line 556: if NOT FND_API.Compatible_Api_Call(g_api_version, p_api_version, l_api_name, g_pkg_name) THEN

552: --null;
553: debug('save_notif_msg_maps 1');
554: savepoint save_wf_notif_msg_maps;
555:
556: if NOT FND_API.Compatible_Api_Call(g_api_version, p_api_version, l_api_name, g_pkg_name) THEN
557: raise FND_API.G_EXC_UNEXPECTED_ERROR;
558: end if;
559:
560: if FND_API.To_Boolean(p_init_msg_list) then

Line 557: raise FND_API.G_EXC_UNEXPECTED_ERROR;

553: debug('save_notif_msg_maps 1');
554: savepoint save_wf_notif_msg_maps;
555:
556: if NOT FND_API.Compatible_Api_Call(g_api_version, p_api_version, l_api_name, g_pkg_name) THEN
557: raise FND_API.G_EXC_UNEXPECTED_ERROR;
558: end if;
559:
560: if FND_API.To_Boolean(p_init_msg_list) then
561: FND_MSG_PUB.initialize;

Line 560: if FND_API.To_Boolean(p_init_msg_list) then

556: if NOT FND_API.Compatible_Api_Call(g_api_version, p_api_version, l_api_name, g_pkg_name) THEN
557: raise FND_API.G_EXC_UNEXPECTED_ERROR;
558: end if;
559:
560: if FND_API.To_Boolean(p_init_msg_list) then
561: FND_MSG_PUB.initialize;
562: end if;
563:
564: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 564: x_return_status := FND_API.G_RET_STS_SUCCESS;

560: if FND_API.To_Boolean(p_init_msg_list) then
561: FND_MSG_PUB.initialize;
562: end if;
563:
564: x_return_status := FND_API.G_RET_STS_SUCCESS;
565:
566:
567: if( p_notif_msg_map_id IS NOT NULL AND p_notif_setup_id IS NOT NULL) THEN
568: debug('save_notif_msg_maps 2');

Line 571: if( p_object_version_number = FND_API.G_MISS_NUM ) then

567: if( p_notif_msg_map_id IS NOT NULL AND p_notif_setup_id IS NOT NULL) THEN
568: debug('save_notif_msg_maps 2');
569: if( check_msg_map_exists(p_notif_msg_map_id, p_object_version_number) = TRUE ) THEN
570: l_operation_type := 'UPDATE';
571: if( p_object_version_number = FND_API.G_MISS_NUM ) then
572: select object_version_number
573: into l_object_version_number
574: from ibe_wf_notif_msg_maps
575: where notif_msg_map_id = p_notif_msg_map_id

Line 583: raise FND_API.G_EXC_ERROR;

579: end if;
580: l_object_version_number := l_object_version_number + 1;
581: else
582: debug('save_notif_msg_maps 3');
583: raise FND_API.G_EXC_ERROR;
584: end if;
585: if( check_msg_map_duplicate(
586: l_operation_type, p_notif_msg_map_id, p_notification_name, p_message_name, p_msite_id, p_org_id, p_user_type,
587: p_all_org_flag, p_all_msite_flag, p_all_user_type_flag) <> TRUE ) then

Line 589: raise FND_API.G_EXC_ERROR;

585: if( check_msg_map_duplicate(
586: l_operation_type, p_notif_msg_map_id, p_notification_name, p_message_name, p_msite_id, p_org_id, p_user_type,
587: p_all_org_flag, p_all_msite_flag, p_all_user_type_flag) <> TRUE ) then
588: debug('save_notif_msg_maps 5');
589: raise FND_API.G_EXC_ERROR;
590: end if;
591: end if;
592:
593: if( l_operation_type = 'INSERT') THEN

Line 600: raise FND_API.G_EXC_ERROR;

596: if( check_msg_map_duplicate(
597: l_operation_type, p_notif_msg_map_id, p_notification_name, p_message_name, p_msite_id, p_org_id, p_user_type,
598: p_all_org_flag, p_all_msite_flag, p_all_user_type_flag) <> TRUE ) then
599: debug('save_notif_msg_maps 5');
600: raise FND_API.G_EXC_ERROR;
601: end if;
602: else
603: debug('save_notif_msg_maps 6');
604: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_MSG_NAME_REQ');

Line 606: raise FND_API.G_EXC_ERROR;

602: else
603: debug('save_notif_msg_maps 6');
604: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_MSG_NAME_REQ');
605: FND_MSG_PUB.ADD;
606: raise FND_API.G_EXC_ERROR;
607: end if;
608: end if;
609:
610: if( l_operation_type = 'INSERT' ) then

Line 677: if( FND_API.to_Boolean(p_commit)) then

673: end;
674: debug('save_notif_msg_maps 12');
675: end if;
676:
677: if( FND_API.to_Boolean(p_commit)) then
678: debug('save_notif_msg_maps 13');
679: commit;
680: end if;
681:

Line 682: x_return_status := FND_API.G_RET_STS_SUCCESS;

678: debug('save_notif_msg_maps 13');
679: commit;
680: end if;
681:
682: x_return_status := FND_API.G_RET_STS_SUCCESS;
683: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
684: if( x_msg_count > 1 ) then
685: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
686: end if;

Line 683: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

679: commit;
680: end if;
681:
682: x_return_status := FND_API.G_RET_STS_SUCCESS;
683: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
684: if( x_msg_count > 1 ) then
685: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
686: end if;
687: debug('save_notif_msg_maps 14');

Line 685: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

681:
682: x_return_status := FND_API.G_RET_STS_SUCCESS;
683: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
684: if( x_msg_count > 1 ) then
685: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
686: end if;
687: debug('save_notif_msg_maps 14');
688: EXCEPTION
689: when FND_API.G_EXC_ERROR THEN

Line 689: when FND_API.G_EXC_ERROR THEN

685: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
686: end if;
687: debug('save_notif_msg_maps 14');
688: EXCEPTION
689: when FND_API.G_EXC_ERROR THEN
690: rollback to save_wf_notif_msg_maps;
691: x_return_status := FND_API.G_RET_STS_ERROR;
692: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
693: if( x_msg_count > 1 ) then

Line 691: x_return_status := FND_API.G_RET_STS_ERROR;

687: debug('save_notif_msg_maps 14');
688: EXCEPTION
689: when FND_API.G_EXC_ERROR THEN
690: rollback to save_wf_notif_msg_maps;
691: x_return_status := FND_API.G_RET_STS_ERROR;
692: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
693: if( x_msg_count > 1 ) then
694: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
695: end if;

Line 692: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

688: EXCEPTION
689: when FND_API.G_EXC_ERROR THEN
690: rollback to save_wf_notif_msg_maps;
691: x_return_status := FND_API.G_RET_STS_ERROR;
692: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
693: if( x_msg_count > 1 ) then
694: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
695: end if;
696:

Line 694: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

690: rollback to save_wf_notif_msg_maps;
691: x_return_status := FND_API.G_RET_STS_ERROR;
692: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
693: if( x_msg_count > 1 ) then
694: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
695: end if;
696:
697: when FND_API.G_EXC_UNEXPECTED_ERROR THEN
698: rollback to save_wf_notif_msg_maps;

Line 697: when FND_API.G_EXC_UNEXPECTED_ERROR THEN

693: if( x_msg_count > 1 ) then
694: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
695: end if;
696:
697: when FND_API.G_EXC_UNEXPECTED_ERROR THEN
698: rollback to save_wf_notif_msg_maps;
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
700: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
701: if( x_msg_count > 1) then

Line 699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

695: end if;
696:
697: when FND_API.G_EXC_UNEXPECTED_ERROR THEN
698: rollback to save_wf_notif_msg_maps;
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
700: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
701: if( x_msg_count > 1) then
702: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
703: end if;

Line 700: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

696:
697: when FND_API.G_EXC_UNEXPECTED_ERROR THEN
698: rollback to save_wf_notif_msg_maps;
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
700: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
701: if( x_msg_count > 1) then
702: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
703: end if;
704:

Line 702: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

698: rollback to save_wf_notif_msg_maps;
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
700: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
701: if( x_msg_count > 1) then
702: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
703: end if;
704:
705: when OTHERS then
706: rollback to save_wf_notif_msg_maps;

Line 707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

703: end if;
704:
705: when OTHERS then
706: rollback to save_wf_notif_msg_maps;
707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
708: if FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
709: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, l_api_name);
710: end if;
711: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

Line 711: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
708: if FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
709: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, l_api_name);
710: end if;
711: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
712: if( x_msg_count > 1 ) then
713: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
714: end if;
715: END save_wf_notif_msg_maps;

Line 713: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

709: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, l_api_name);
710: end if;
711: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
712: if( x_msg_count > 1 ) then
713: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
714: end if;
715: END save_wf_notif_msg_maps;
716:
717: procedure delete_wf_notif_msg_maps(

Line 719: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

715: END save_wf_notif_msg_maps;
716:
717: procedure delete_wf_notif_msg_maps(
718: p_api_version IN NUMBER,
719: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
720: p_commit IN VARCHAR2 := FND_API.G_FALSE,
721: x_return_status OUT NOCOPY VARCHAR2,
722: x_msg_count OUT NOCOPY NUMBER,
723: x_msg_data OUT NOCOPY VARCHAR2,

Line 720: p_commit IN VARCHAR2 := FND_API.G_FALSE,

716:
717: procedure delete_wf_notif_msg_maps(
718: p_api_version IN NUMBER,
719: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
720: p_commit IN VARCHAR2 := FND_API.G_FALSE,
721: x_return_status OUT NOCOPY VARCHAR2,
722: x_msg_count OUT NOCOPY NUMBER,
723: x_msg_data OUT NOCOPY VARCHAR2,
724: P_NOTIFICATION_NAME in VARCHAR2,

Line 740: IF NOT FND_API.compatible_api_call(g_api_version, p_api_version, l_api_name, g_pkg_name ) THEN

736: BEGIN
737: --null;
738: savepoint delete_wf_notif_msg_maps;
739:
740: IF NOT FND_API.compatible_api_call(g_api_version, p_api_version, l_api_name, g_pkg_name ) THEN
741: RAISE FND_API.g_exc_unexpected_error;
742: END IF;
743:
744: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 741: RAISE FND_API.g_exc_unexpected_error;

737: --null;
738: savepoint delete_wf_notif_msg_maps;
739:
740: IF NOT FND_API.compatible_api_call(g_api_version, p_api_version, l_api_name, g_pkg_name ) THEN
741: RAISE FND_API.g_exc_unexpected_error;
742: END IF;
743:
744: IF FND_API.to_boolean(p_init_msg_list) THEN
745: FND_MSG_PUB.initialize;

Line 744: IF FND_API.to_boolean(p_init_msg_list) THEN

740: IF NOT FND_API.compatible_api_call(g_api_version, p_api_version, l_api_name, g_pkg_name ) THEN
741: RAISE FND_API.g_exc_unexpected_error;
742: END IF;
743:
744: IF FND_API.to_boolean(p_init_msg_list) THEN
745: FND_MSG_PUB.initialize;
746: END IF;
747:
748: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 748: x_return_status := FND_API.G_RET_STS_SUCCESS;

744: IF FND_API.to_boolean(p_init_msg_list) THEN
745: FND_MSG_PUB.initialize;
746: END IF;
747:
748: x_return_status := FND_API.G_RET_STS_SUCCESS;
749:
750: if( p_notification_name IS NOT NULL AND p_message_name IS NOT NULL ) THEN
751: open wf_notif_setup(p_notification_name);
752: LOOP

Line 765: raise FND_API.G_EXC_ERROR;

761: end if;
762: else
763: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_MSG_NAME_REQ');
764: FND_MSG_PUB.ADD;
765: raise FND_API.G_EXC_ERROR;
766: end if;
767: EXCEPTION
768: when NO_DATA_FOUND THEN
769: x_return_status := FND_API.G_RET_STS_ERROR;

Line 769: x_return_status := FND_API.G_RET_STS_ERROR;

765: raise FND_API.G_EXC_ERROR;
766: end if;
767: EXCEPTION
768: when NO_DATA_FOUND THEN
769: x_return_status := FND_API.G_RET_STS_ERROR;
770: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_NAME_NOT_FOUND');
771: FND_MESSAGE.SET_TOKEN('NAME', p_notification_name);
772: --FND_MSG_PUB.ADD;
773: --FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

Line 773: --FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

769: x_return_status := FND_API.G_RET_STS_ERROR;
770: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_NAME_NOT_FOUND');
771: FND_MESSAGE.SET_TOKEN('NAME', p_notification_name);
772: --FND_MSG_PUB.ADD;
773: --FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
774: x_msg_data := FND_MESSAGE.GET;
775: x_msg_count := 1;
776: when FND_API.G_EXC_ERROR THEN
777: rollback to save_wf_notif_msg_maps;

Line 776: when FND_API.G_EXC_ERROR THEN

772: --FND_MSG_PUB.ADD;
773: --FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
774: x_msg_data := FND_MESSAGE.GET;
775: x_msg_count := 1;
776: when FND_API.G_EXC_ERROR THEN
777: rollback to save_wf_notif_msg_maps;
778: x_return_status := FND_API.G_RET_STS_ERROR;
779: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
780: if( x_msg_count > 1 ) then

Line 778: x_return_status := FND_API.G_RET_STS_ERROR;

774: x_msg_data := FND_MESSAGE.GET;
775: x_msg_count := 1;
776: when FND_API.G_EXC_ERROR THEN
777: rollback to save_wf_notif_msg_maps;
778: x_return_status := FND_API.G_RET_STS_ERROR;
779: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
780: if( x_msg_count > 1 ) then
781: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
782: end if;

Line 779: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

775: x_msg_count := 1;
776: when FND_API.G_EXC_ERROR THEN
777: rollback to save_wf_notif_msg_maps;
778: x_return_status := FND_API.G_RET_STS_ERROR;
779: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
780: if( x_msg_count > 1 ) then
781: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
782: end if;
783:

Line 781: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

777: rollback to save_wf_notif_msg_maps;
778: x_return_status := FND_API.G_RET_STS_ERROR;
779: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
780: if( x_msg_count > 1 ) then
781: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
782: end if;
783:
784: when FND_API.G_EXC_UNEXPECTED_ERROR THEN
785: rollback to save_wf_notif_msg_maps;

Line 784: when FND_API.G_EXC_UNEXPECTED_ERROR THEN

780: if( x_msg_count > 1 ) then
781: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
782: end if;
783:
784: when FND_API.G_EXC_UNEXPECTED_ERROR THEN
785: rollback to save_wf_notif_msg_maps;
786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
787: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
788: if( x_msg_count > 1 ) then

Line 786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

782: end if;
783:
784: when FND_API.G_EXC_UNEXPECTED_ERROR THEN
785: rollback to save_wf_notif_msg_maps;
786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
787: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
788: if( x_msg_count > 1 ) then
789: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
790: end if;

Line 787: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

783:
784: when FND_API.G_EXC_UNEXPECTED_ERROR THEN
785: rollback to save_wf_notif_msg_maps;
786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
787: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
788: if( x_msg_count > 1 ) then
789: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
790: end if;
791:

Line 789: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

785: rollback to save_wf_notif_msg_maps;
786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
787: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
788: if( x_msg_count > 1 ) then
789: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
790: end if;
791:
792: when OTHERS then
793: rollback to save_wf_notif_msg_maps;

Line 794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

790: end if;
791:
792: when OTHERS then
793: rollback to save_wf_notif_msg_maps;
794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
795: if FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
796: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, l_api_name);
797: end if;
798: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

Line 798: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);

794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
795: if FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
796: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, l_api_name);
797: end if;
798: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
799: if( x_msg_count > 1 ) then
800: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
801: end if;
802: ENd delete_wf_notif_msg_maps;

Line 800: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

796: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, l_api_name);
797: end if;
798: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
799: if( x_msg_count > 1 ) then
800: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
801: end if;
802: ENd delete_wf_notif_msg_maps;
803:
804: end IBE_WF_NOTIF_MSG_MAPS_PVT;