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_MSG_PUB

Line 214: FND_MSG_PUB.ADD;*/

210: /*EXCEPTION
211: when NO_DATA_FOUND THEN
212: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_MSG_MAP_NOT_FOUND');
213: FND_MESSAGE.SET_TOKEN('ID', p_notif_msg_map_id);
214: FND_MSG_PUB.ADD;*/
215: /* added by abhandar 07/21/03*/
216: EXCEPTION
217: WHEN DUP_VAL_ON_INDEX THEN
218: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_MSG_MAP_DUPINDEX');

Line 220: FND_MSG_PUB.ADD;

216: EXCEPTION
217: WHEN DUP_VAL_ON_INDEX THEN
218: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_MSG_MAP_DUPINDEX');
219: FND_MESSAGE.SET_TOKEN('ID', p_notif_msg_map_id);
220: FND_MSG_PUB.ADD;
221:
222: end UPDATE_ROW;
223:
224: procedure DELETE_ROW (

Line 240: FND_MSG_PUB.ADD;

236: EXCEPTION
237: when NO_DATA_FOUND THEN
238: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_MSG_MAP_NOT_FOUND');
239: FND_MESSAGE.SET_TOKEN('ID', p_notif_msg_map_id);
240: FND_MSG_PUB.ADD;
241: end DELETE_ROW;
242:
243: procedure LOAD_SEED_ROW (
244: P_NOTIF_MSG_MAP_ID in NUMBER,

Line 425: FND_MSG_PUB.ADD;

421: );
422: if( l_exists <> '1' ) then
423: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_MSG_MAP_NOT_FOUND');
424: FND_MESSAGE.SET_TOKEN('ID', p_notif_msg_map_id);
425: FND_MSG_PUB.ADD;
426: return FALSE;
427: else
428: return TRUE;
429: end if;

Line 443: FND_MSG_PUB.ADD;

439: );
440: if( l_exists <> '1' ) then
441: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_MSGMAP_VER_NOT_MATCH');
442: FND_MESSAGE.SET_TOKEN('ID', p_notif_msg_map_id);
443: FND_MSG_PUB.ADD;
444: return FALSE;
445: else
446: return TRUE;
447: end if;

Line 453: FND_MSG_PUB.ADD;

449: EXCEPTION
450: when NO_DATA_FOUND THEN
451: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_MSG_MAP_NOT_FOUND');
452: FND_MESSAGE.SET_TOKEN('ID', p_notif_msg_map_id);
453: FND_MSG_PUB.ADD;
454: return FALSE;
455: END;
456:
457: FUNCTION check_msg_map_duplicate(

Line 499: FND_MSG_PUB.ADD;

495: if( l_notif_msg_map_id is not null ) then
496: debug('return false');
497: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_DUP_NOTIF_MSG_MAPS');
498: FND_MESSAGE.SET_TOKEN('NAME', p_message_name);
499: FND_MSG_PUB.ADD;
500: return FALSE;
501: else
502: return TRUE;
503: end if;

Line 509: FND_MSG_PUB.ADD;

505: if( l_notif_msg_map_id is not null AND l_notif_msg_map_id <> p_msg_map_id ) then
506: debug('return false');
507: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_DUP_NOTIF_MSG_MAPS');
508: FND_MESSAGE.SET_TOKEN('NAME', p_message_name);
509: FND_MSG_PUB.ADD;
510: return FALSE;
511: else
512: debug('return true');
513: return TRUE;

Line 561: FND_MSG_PUB.initialize;

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;
565:

Line 605: FND_MSG_PUB.ADD;

601: end if;
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:

Line 672: FND_MSG_PUB.ADD;

668: Exception
669: when no_data_found then
670: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_MSG_MAP_NOT_FOUND');
671: FND_MESSAGE.SET_TOKEN('ID', p_notif_msg_map_id);
672: FND_MSG_PUB.ADD;
673: end;
674: debug('save_notif_msg_maps 12');
675: end if;
676:

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 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 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 708: if FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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);
712: if( x_msg_count > 1 ) then

Line 709: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, l_api_name);

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);
712: if( x_msg_count > 1 ) then
713: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

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 745: FND_MSG_PUB.initialize;

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;
749:

Line 764: FND_MSG_PUB.ADD;

760: raise no_data_found;
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

Line 772: --FND_MSG_PUB.ADD;

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);
774: x_msg_data := FND_MESSAGE.GET;
775: x_msg_count := 1;
776: when FND_API.G_EXC_ERROR THEN

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 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 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 795: if FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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);
799: if( x_msg_count > 1 ) then

Line 796: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, l_api_name);

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);
799: if( x_msg_count > 1 ) then
800: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

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;