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

Line 173: FND_MSG_PUB.ADD;

169: if (sql%notfound) then
170: --debug('update_row 3');
171: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_NAME_NOT_FOUND');
172: FND_MESSAGE.SET_NAME('NAME', p_notification_name);
173: FND_MSG_PUB.ADD;
174: raise no_data_found;
175: end if;
176: --debug('update_row 4');
177: end UPDATE_ROW;

Line 193: FND_MSG_PUB.ADD;

189: EXCEPTION
190: when NO_DATA_FOUND then
191: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_NOT_FOUND');
192: FND_MESSAGE.SET_TOKEN('ID', p_notif_setup_id);
193: FND_MSG_PUB.ADD;
194: end DELETE_ROW;
195:
196: procedure LOAD_ROW(
197: P_NOTIF_SETUP_ID in NUMBER,

Line 316: FND_MSG_PUB.ADD;

312:
313: if( l_exists = '1' ) then
314: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_DUP_NOTIF_SETUP');
315: FND_MESSAGE.SET_TOKEN('NAME', p_notification_name);
316: FND_MSG_PUB.ADD;
317: return FALSE;
318: else
319: return TRUE;
320: end if;

Line 347: FND_MSG_PUB.ADD;

343: return TRUE;
344: else
345: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_NOT_FOUND');
346: FND_MESSAGE.SET_TOKEN('ID', to_char(p_notif_setup_id));
347: FND_MSG_PUB.ADD;
348: return false;
349: END if;
350: else
351: select '1'

Line 365: FND_MSG_PUB.ADD;

361: return TRUE;
362: else
363: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_VER_NOT_MATCH');
364: FND_MESSAGE.SET_TOKEN('ID', to_char(p_notif_setup_id));
365: FND_MSG_PUB.ADD;
366: return false;
367: END if;
368: end if;
369:

Line 374: FND_MSG_PUB.ADD;

370: EXCEPTION
371: when NO_DATA_FOUND then
372: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_NOT_FOUND');
373: FND_MESSAGE.SET_TOKEN('ID', p_notif_setup_id);
374: FND_MSG_PUB.ADD;
375: return FALSE;
376: END;
377:
378:

Line 422: FND_MSG_PUB.initialize;

418: end if;
419:
420: if FND_API.To_Boolean(p_init_msg_list) then
421: --debug('Save_wf_notif_setup 3');
422: FND_MSG_PUB.initialize;
423: end if;
424:
425: --debug('Save_wf_notif_setup 4');
426: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 459: FND_MSG_PUB.ADD;

455:
456: --debug('save_wf_notif_setup 9');
457: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_NOTIF_NAME');
458: FND_MESSAGE.SET_TOKEN('NAME', p_notification_name);
459: FND_MSG_PUB.ADD;
460: raise FND_API.G_EXC_ERROR;
461: end if;
462:
463: --debug('save_wf_notif_setup 10');

Line 469: FND_MSG_PUB.ADD;

465:
466: if( p_org_id_flag is null ) then
467: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_FIELD');
468: FND_MESSAGE.SET_TOKEN('NAME', 'ORG_ID_FLAG');
469: FND_MSG_PUB.ADD;
470: raise FND_API.G_EXC_ERROR;
471: elsif( p_msite_id_flag is null ) THEN
472: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_FIELD');
473: FND_MESSAGE.SET_TOKEN('NAME', 'MSITE_ID_FLAG');

Line 474: FND_MSG_PUB.ADD;

470: raise FND_API.G_EXC_ERROR;
471: elsif( p_msite_id_flag is null ) THEN
472: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_FIELD');
473: FND_MESSAGE.SET_TOKEN('NAME', 'MSITE_ID_FLAG');
474: FND_MSG_PUB.ADD;
475: raise FND_API.G_EXC_ERROR;
476: elsif( p_user_type_flag is null ) THEN
477: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_FIELD');
478: FND_MESSAGE.SET_TOKEN('NAME', 'USER_TYPE_FLAG');

Line 479: FND_MSG_PUB.ADD;

475: raise FND_API.G_EXC_ERROR;
476: elsif( p_user_type_flag is null ) THEN
477: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_FIELD');
478: FND_MESSAGE.SET_TOKEN('NAME', 'USER_TYPE_FLAG');
479: FND_MSG_PUB.ADD;
480: raise FND_API.G_EXC_ERROR;
481: elsif( p_enabled_flag is null ) THEN
482: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_FIELD');
483: FND_MESSAGE.SET_TOKEN('NAME', 'ENABLED_FLAG');

Line 484: FND_MSG_PUB.ADD;

480: raise FND_API.G_EXC_ERROR;
481: elsif( p_enabled_flag is null ) THEN
482: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_FIELD');
483: FND_MESSAGE.SET_TOKEN('NAME', 'ENABLED_FLAG');
484: FND_MSG_PUB.ADD;
485: raise FND_API.G_EXC_ERROR;
486: elsif( p_default_MESSAGE_NAME is null ) THEN
487: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_FIELD');
488: FND_MESSAGE.SET_TOKEN('NAME', 'DEFAULT_MESSAGE_NAME');

Line 489: FND_MSG_PUB.ADD;

485: raise FND_API.G_EXC_ERROR;
486: elsif( p_default_MESSAGE_NAME is null ) THEN
487: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_FIELD');
488: FND_MESSAGE.SET_TOKEN('NAME', 'DEFAULT_MESSAGE_NAME');
489: FND_MSG_PUB.ADD;
490: raise FND_API.G_EXC_ERROR;
491: end if;
492:
493: if( l_operation_type = 'INSERT' ) THEN

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

557:
558: --debug('save_wf_notif_setup 17');
559: x_return_status := FND_API.G_RET_STS_SUCCESS;
560:
561: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
562: if( x_msg_count > 1 ) then
563: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
564: end if;
565: --debug('save_wf_notif_setup 18');

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

559: x_return_status := FND_API.G_RET_STS_SUCCESS;
560:
561: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
562: if( x_msg_count > 1 ) then
563: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
564: end if;
565: --debug('save_wf_notif_setup 18');
566: EXCEPTION
567: when FND_API.G_EXC_ERROR THEN

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

566: EXCEPTION
567: when FND_API.G_EXC_ERROR THEN
568: rollback to save_wf_notif_setup;
569: x_return_status := FND_API.G_RET_STS_ERROR;
570: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
571: if( x_msg_count > 1 ) then
572: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
573: end if;
574: when FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

568: rollback to save_wf_notif_setup;
569: x_return_status := FND_API.G_RET_STS_ERROR;
570: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
571: if( x_msg_count > 1 ) then
572: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
573: end if;
574: when FND_API.G_EXC_UNEXPECTED_ERROR THEN
575: rollback to save_wf_notif_setup;
576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

573: end if;
574: when FND_API.G_EXC_UNEXPECTED_ERROR THEN
575: rollback to save_wf_notif_setup;
576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
577: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
578: if( x_msg_count > 1 ) then
579: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
580: end if;
581:

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

575: rollback to save_wf_notif_setup;
576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
577: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
578: if( x_msg_count > 1 ) then
579: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
580: end if;
581:
582: when OTHERS then
583: rollback to save_wf_notif_setup;

Line 585: if FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

581:
582: when OTHERS then
583: rollback to save_wf_notif_setup;
584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
585: if FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
586: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, l_api_name);
587: end if;
588: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
589: if( x_msg_count > 1 ) then

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

582: when OTHERS then
583: rollback to save_wf_notif_setup;
584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
585: if FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
586: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, l_api_name);
587: end if;
588: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
589: if( x_msg_count > 1 ) then
590: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

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

584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
585: if FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
586: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, l_api_name);
587: end if;
588: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
589: if( x_msg_count > 1 ) then
590: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
591: end if;
592: END save_wf_notif_setup;

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

586: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, l_api_name);
587: end if;
588: FND_MSG_PUB.COUNT_AND_GET(p_encoded => FND_API.G_FALSE, P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA);
589: if( x_msg_count > 1 ) then
590: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
591: end if;
592: END save_wf_notif_setup;
593:
594: PROCEDURE delete_wf_notif_setup

Line 630: FND_MSG_PUB.initialize;

626: RAISE FND_API.g_exc_unexpected_error;
627: END IF;
628:
629: IF FND_API.to_boolean(p_init_msg_list) THEN
630: FND_MSG_PUB.initialize;
631: END IF;
632:
633: x_return_status := FND_API.G_RET_STS_SUCCESS;
634:

Line 665: FND_MSG_PUB.ADD;

661: Delete_Row(p_notif_setup_id => l_notif_setup_id);
662: else
663: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_NOTIF_NAME');
664: FND_MESSAGE.SET_TOKEN('NAME', 'Notification_Name');
665: FND_MSG_PUB.ADD;
666: raise FND_API.G_EXC_ERROR;
667: end if;
668: EXCEPTION
669: WHEN FND_API.g_exc_error THEN

Line 672: FND_MSG_PUB.COUNT_AND_GET( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data );

668: EXCEPTION
669: WHEN FND_API.g_exc_error THEN
670: ROLLBACK TO delete_wf_notif_setup;
671: x_return_status := FND_API.g_ret_sts_error;
672: FND_MSG_PUB.COUNT_AND_GET( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data );
673: if( x_msg_count > 1 ) then
674: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
675: end if;
676:

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

670: ROLLBACK TO delete_wf_notif_setup;
671: x_return_status := FND_API.g_ret_sts_error;
672: FND_MSG_PUB.COUNT_AND_GET( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data );
673: if( x_msg_count > 1 ) then
674: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
675: end if;
676:
677: WHEN FND_API.g_exc_unexpected_error THEN
678: ROLLBACK TO delete_wf_notif_setup;

Line 680: FND_MSG_PUB.COUNT_AND_GET( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data );

676:
677: WHEN FND_API.g_exc_unexpected_error THEN
678: ROLLBACK TO delete_wf_notif_setup;
679: x_return_status := FND_API.g_ret_sts_unexp_error ;
680: FND_MSG_PUB.COUNT_AND_GET( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data );
681: if( x_msg_count > 1 ) then
682: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
683: end if;
684: WHEN OTHERS THEN

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

678: ROLLBACK TO delete_wf_notif_setup;
679: x_return_status := FND_API.g_ret_sts_unexp_error ;
680: FND_MSG_PUB.COUNT_AND_GET( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data );
681: if( x_msg_count > 1 ) then
682: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
683: end if;
684: WHEN OTHERS THEN
685: ROLLBACK TO delete_wf_notif_setup;
686: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 687: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

683: end if;
684: WHEN OTHERS THEN
685: ROLLBACK TO delete_wf_notif_setup;
686: x_return_status := FND_API.g_ret_sts_unexp_error ;
687: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
688: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, l_api_name);
689: END IF;
690: FND_MSG_PUB.COUNT_AND_GET( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data );
691: if( x_msg_count > 1 ) then

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

684: WHEN OTHERS THEN
685: ROLLBACK TO delete_wf_notif_setup;
686: x_return_status := FND_API.g_ret_sts_unexp_error ;
687: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
688: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, l_api_name);
689: END IF;
690: FND_MSG_PUB.COUNT_AND_GET( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data );
691: if( x_msg_count > 1 ) then
692: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

Line 690: FND_MSG_PUB.COUNT_AND_GET( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data );

686: x_return_status := FND_API.g_ret_sts_unexp_error ;
687: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
688: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, l_api_name);
689: END IF;
690: FND_MSG_PUB.COUNT_AND_GET( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data );
691: if( x_msg_count > 1 ) then
692: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
693: end if;
694: END Delete_wf_notif_setup;

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

688: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, l_api_name);
689: END IF;
690: FND_MSG_PUB.COUNT_AND_GET( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data );
691: if( x_msg_count > 1 ) then
692: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
693: end if;
694: END Delete_wf_notif_setup;
695:
696: procedure Update_Wf_notif_setup(