DBA Data[Home] [Help]

APPS.IBE_WF_NOTIF_MSG_MAPS_PVT dependencies on FND_MESSAGE

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

150: OR ((tlinfo.MSITE_ID is null) AND (P_MSITE_ID is null)))
151: ) then
152: null;
153: else
154: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
155: app_exception.raise_exception;
156: end if;
157: end loop;
158: return;

Line 212: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_MSG_MAP_NOT_FOUND');

208: end if;
209: debug('update_row 7 ' || p_notif_msg_map_id);
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

Line 213: FND_MESSAGE.SET_TOKEN('ID', p_notif_msg_map_id);

209: debug('update_row 7 ' || p_notif_msg_map_id);
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

Line 218: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_MSG_MAP_DUPINDEX');

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');
219: FND_MESSAGE.SET_TOKEN('ID', p_notif_msg_map_id);
220: FND_MSG_PUB.ADD;
221:
222: end UPDATE_ROW;

Line 219: FND_MESSAGE.SET_TOKEN('ID', p_notif_msg_map_id);

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');
219: FND_MESSAGE.SET_TOKEN('ID', p_notif_msg_map_id);
220: FND_MSG_PUB.ADD;
221:
222: end UPDATE_ROW;
223:

Line 238: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_MSG_MAP_NOT_FOUND');

234: raise no_data_found;
235: end if;
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:

Line 239: FND_MESSAGE.SET_TOKEN('ID', p_notif_msg_map_id);

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

Line 423: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_MSG_MAP_NOT_FOUND');

419: From ibe_wf_notif_msg_maps
420: where notif_msg_map_id = p_notif_msg_map_id
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

Line 424: FND_MESSAGE.SET_TOKEN('ID', p_notif_msg_map_id);

420: where notif_msg_map_id = p_notif_msg_map_id
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;

Line 441: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_MSGMAP_VER_NOT_MATCH');

437: where notif_msg_map_id = p_notif_msg_map_id
438: and object_version_number = p_object_version_number
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

Line 442: FND_MESSAGE.SET_TOKEN('ID', p_notif_msg_map_id);

438: and object_version_number = p_object_version_number
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;

Line 451: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_MSG_MAP_NOT_FOUND');

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

Line 452: FND_MESSAGE.SET_TOKEN('ID', p_notif_msg_map_id);

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

Line 497: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_DUP_NOTIF_MSG_MAPS');

493:
494: if( p_action = 'INSERT' ) Then
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

Line 498: FND_MESSAGE.SET_TOKEN('NAME', p_message_name);

494: if( p_action = 'INSERT' ) Then
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;

Line 507: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_DUP_NOTIF_MSG_MAPS');

503: end if;
504: elsif( p_action='UPDATE') then
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

Line 508: FND_MESSAGE.SET_TOKEN('NAME', p_message_name);

504: elsif( p_action='UPDATE') then
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');

Line 604: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_MSG_NAME_REQ');

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');
605: FND_MSG_PUB.ADD;
606: raise FND_API.G_EXC_ERROR;
607: end if;
608: end if;

Line 670: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_MSG_MAP_NOT_FOUND');

666: P_LAST_UPDATE_LOGIN => FND_GLOBAL.user_id
667: );
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');

Line 671: FND_MESSAGE.SET_TOKEN('ID', p_notif_msg_map_id);

667: );
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;

Line 763: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_MSG_NAME_REQ');

759: else
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

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

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);
774: x_msg_data := FND_MESSAGE.GET;

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

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

Line 774: x_msg_data := FND_MESSAGE.GET;

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;
778: x_return_status := FND_API.G_RET_STS_ERROR;