DBA Data[Home] [Help]

APPS.IBE_WF_NOTIF_SETUP_PVT dependencies on FND_MESSAGE

Line 127: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

123: OR ((tlinfo.OBJECT_VERSION_NUMBER is null) AND (P_OBJECT_VERSION_NUMBER is null)))
124: ) then
125: null;
126: else
127: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
128: app_exception.raise_exception;
129: end if;
130: end loop;
131: return;

Line 171: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_NAME_NOT_FOUND');

167:
168: --debug('update_row 2');
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;

Line 172: FND_MESSAGE.SET_NAME('NAME', p_notification_name);

168: --debug('update_row 2');
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');

Line 191: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_NOT_FOUND');

187: raise no_data_found;
188: end if;
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:

Line 192: FND_MESSAGE.SET_TOKEN('ID', p_notif_setup_id);

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

Line 314: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_DUP_NOTIF_SETUP');

310: from ibe_wf_notif_setup
311: where notification_name = p_notification_name);
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

Line 315: FND_MESSAGE.SET_TOKEN('NAME', p_notification_name);

311: where notification_name = p_notification_name);
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;

Line 345: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_NOT_FOUND');

341:
342: if( l_exists = '1' ) then
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;

Line 346: FND_MESSAGE.SET_TOKEN('ID', to_char(p_notif_setup_id));

342: if( l_exists = '1' ) then
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

Line 363: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_VER_NOT_MATCH');

359:
360: if( l_exists = '1' ) then
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;

Line 364: FND_MESSAGE.SET_TOKEN('ID', to_char(p_notif_setup_id));

360: if( l_exists = '1' ) then
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;

Line 372: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_NOT_FOUND');

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

Line 373: FND_MESSAGE.SET_TOKEN('ID', p_notif_setup_id);

369:
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:

Line 457: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_NOTIF_NAME');

453:
454: elsif( p_notification_name is null AND l_operation_type = 'INSERT') then
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;

Line 458: FND_MESSAGE.SET_TOKEN('NAME', p_notification_name);

454: elsif( p_notification_name is null AND l_operation_type = 'INSERT') then
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:

Line 467: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_FIELD');

463: --debug('save_wf_notif_setup 10');
464: -- now validate if all parameters that are required is not null
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

Line 468: FND_MESSAGE.SET_TOKEN('NAME', 'ORG_ID_FLAG');

464: -- now validate if all parameters that are required is not null
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');

Line 472: 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');
474: FND_MSG_PUB.ADD;
475: raise FND_API.G_EXC_ERROR;
476: elsif( p_user_type_flag is null ) THEN

Line 473: FND_MESSAGE.SET_TOKEN('NAME', 'MSITE_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');
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');

Line 477: 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');
479: FND_MSG_PUB.ADD;
480: raise FND_API.G_EXC_ERROR;
481: elsif( p_enabled_flag is null ) THEN

Line 478: FND_MESSAGE.SET_TOKEN('NAME', 'USER_TYPE_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');
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');

Line 482: 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');
484: FND_MSG_PUB.ADD;
485: raise FND_API.G_EXC_ERROR;
486: elsif( p_default_MESSAGE_NAME is null ) THEN

Line 483: FND_MESSAGE.SET_TOKEN('NAME', 'ENABLED_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');
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');

Line 487: 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');
489: FND_MSG_PUB.ADD;
490: raise FND_API.G_EXC_ERROR;
491: end if;

Line 488: FND_MESSAGE.SET_TOKEN('NAME', 'DEFAULT_MESSAGE_NAME');

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');
489: FND_MSG_PUB.ADD;
490: raise FND_API.G_EXC_ERROR;
491: end if;
492:

Line 663: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_NOTIF_NAME');

659: END LOOP;
660: close wf_notif_msg_maps;
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;

Line 664: FND_MESSAGE.SET_TOKEN('NAME', 'Notification_Name');

660: close wf_notif_msg_maps;
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

Line 723: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_NOTIF_NAME');

719: if( p_notif_name_tbl IS NULL ) THEN
720: x_return_status.extend(1);
721: x_return_status(1) := FND_API.G_RET_STS_ERROR;
722: x_msg_data.extend(1);
723: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_NOTIF_NAME');
724: FND_MESSAGE.SET_TOKEN('NAME', 'Notification_Name');
725: x_msg_data(1) := FND_MESSAGE.GET;
726: x_msg_count := 1;
727: elsif( p_notif_name_tbl.COUNT <> p_enabled_flag_tbl.COUNT ) THEN

Line 724: FND_MESSAGE.SET_TOKEN('NAME', 'Notification_Name');

720: x_return_status.extend(1);
721: x_return_status(1) := FND_API.G_RET_STS_ERROR;
722: x_msg_data.extend(1);
723: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_NOTIF_NAME');
724: FND_MESSAGE.SET_TOKEN('NAME', 'Notification_Name');
725: x_msg_data(1) := FND_MESSAGE.GET;
726: x_msg_count := 1;
727: elsif( p_notif_name_tbl.COUNT <> p_enabled_flag_tbl.COUNT ) THEN
728: x_return_status.extend(1);

Line 725: x_msg_data(1) := FND_MESSAGE.GET;

721: x_return_status(1) := FND_API.G_RET_STS_ERROR;
722: x_msg_data.extend(1);
723: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_NOTIF_NAME');
724: FND_MESSAGE.SET_TOKEN('NAME', 'Notification_Name');
725: x_msg_data(1) := FND_MESSAGE.GET;
726: x_msg_count := 1;
727: elsif( p_notif_name_tbl.COUNT <> p_enabled_flag_tbl.COUNT ) THEN
728: x_return_status.extend(1);
729: x_return_status(1) := FND_API.G_RET_STS_ERROR;

Line 731: x_msg_data(1) := FND_MESSAGE.GET_STRING('IBE', 'IBE_WF_NOTIF_UPDATE_ERROR');

727: elsif( p_notif_name_tbl.COUNT <> p_enabled_flag_tbl.COUNT ) THEN
728: x_return_status.extend(1);
729: x_return_status(1) := FND_API.G_RET_STS_ERROR;
730: x_msg_data.extend(1);
731: x_msg_data(1) := FND_MESSAGE.GET_STRING('IBE', 'IBE_WF_NOTIF_UPDATE_ERROR');
732: x_msg_count := 1;
733: else
734: update ibe_wf_notif_setup
735: set enabled_flag = 'Y'

Line 756: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_NAME_NOT_FOUND');

752: EXCEPTION
753: when no_data_found THEN
754: x_return_status(i) := FND_API.G_RET_STS_ERROR;
755: x_msg_count := x_msg_count + 1;
756: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_NAME_NOT_FOUND');
757: FND_MESSAGE.SET_TOKEN('NAME', p_notif_name_tbl(i));
758: x_msg_data(i) := FND_MESSAGE.GET;
759: end;
760: --debug('l_notif_setup_id is ' || l_notif_setup_id);

Line 757: FND_MESSAGE.SET_TOKEN('NAME', p_notif_name_tbl(i));

753: when no_data_found THEN
754: x_return_status(i) := FND_API.G_RET_STS_ERROR;
755: x_msg_count := x_msg_count + 1;
756: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_NAME_NOT_FOUND');
757: FND_MESSAGE.SET_TOKEN('NAME', p_notif_name_tbl(i));
758: x_msg_data(i) := FND_MESSAGE.GET;
759: end;
760: --debug('l_notif_setup_id is ' || l_notif_setup_id);
761: --debug('l_object_version_number is ' || l_object_version_number);

Line 758: x_msg_data(i) := FND_MESSAGE.GET;

754: x_return_status(i) := FND_API.G_RET_STS_ERROR;
755: x_msg_count := x_msg_count + 1;
756: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_NAME_NOT_FOUND');
757: FND_MESSAGE.SET_TOKEN('NAME', p_notif_name_tbl(i));
758: x_msg_data(i) := FND_MESSAGE.GET;
759: end;
760: --debug('l_notif_setup_id is ' || l_notif_setup_id);
761: --debug('l_object_version_number is ' || l_object_version_number);
762: if( x_return_status(i) = FND_API.G_RET_STS_SUCCESS ) then

Line 786: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_NOTIF_NAME');

782: x_msg_count := x_msg_count + l_msg_count;
783: end if;
784: else
785: x_return_status(i) := FND_API.G_RET_STS_ERROR;
786: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_NOTIF_NAME');
787: FND_MESSAGE.SET_TOKEN('NAME', 'Notification_Name');
788: x_msg_data(i) := FND_MESSAGE.GET;
789: x_msg_count := x_msg_count + 1;
790: END IF;

Line 787: FND_MESSAGE.SET_TOKEN('NAME', 'Notification_Name');

783: end if;
784: else
785: x_return_status(i) := FND_API.G_RET_STS_ERROR;
786: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_NOTIF_NAME');
787: FND_MESSAGE.SET_TOKEN('NAME', 'Notification_Name');
788: x_msg_data(i) := FND_MESSAGE.GET;
789: x_msg_count := x_msg_count + 1;
790: END IF;
791: END LOOP;

Line 788: x_msg_data(i) := FND_MESSAGE.GET;

784: else
785: x_return_status(i) := FND_API.G_RET_STS_ERROR;
786: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_REQUIRED_NOTIF_NAME');
787: FND_MESSAGE.SET_TOKEN('NAME', 'Notification_Name');
788: x_msg_data(i) := FND_MESSAGE.GET;
789: x_msg_count := x_msg_count + 1;
790: END IF;
791: END LOOP;
792: end if;