82: -- responsibility-securing_attribute already exists
83:
84: -- !!!!Need create message through Rami
85:
86: fnd_message.set_name('FND','SECURITY-DUPLICATE USER RESP');
87: fnd_msg_pub.Add;
88: raise FND_API.G_EXC_ERROR;
89: else
90: INSERT into AK_WEB_USER_SEC_ATTR_VALUES
121: /* if SQL%NOTFOUND
122: then
123: -- Unable to INSERT
124:
125: fnd_message.set_name('FND','SQL-NO INSERT');
126: fnd_message.set_token('TABLE','FND_USER');
127: fnd_msg_pub.Add;
128: raise FND_API.G_EXC_ERROR;
129: end if;
122: then
123: -- Unable to INSERT
124:
125: fnd_message.set_name('FND','SQL-NO INSERT');
126: fnd_message.set_token('TABLE','FND_USER');
127: fnd_msg_pub.Add;
128: raise FND_API.G_EXC_ERROR;
129: end if;
130: */
263:
264: -- Need to replace message after creating messages through Rami
265: -- !!!!
266:
267: fnd_message.set_name('FND','SQL-NO DELETE');
268: fnd_message.set_token('TABLE','FND_USER_RESPONSIBILITY');
269: fnd_msg_pub.Add;
270: raise FND_API.G_EXC_ERROR;
271: end if;
264: -- Need to replace message after creating messages through Rami
265: -- !!!!
266:
267: fnd_message.set_name('FND','SQL-NO DELETE');
268: fnd_message.set_token('TABLE','FND_USER_RESPONSIBILITY');
269: fnd_msg_pub.Add;
270: raise FND_API.G_EXC_ERROR;
271: end if;
272:
630: -- responsibility-securing_attribute already exists
631:
632: -- !!!!Need create message through Rami
633:
634: fnd_message.set_name('FND','SECURITY-DUPLICATE USER RESP');
635: fnd_msg_pub.Add;
636: raise FND_API.G_EXC_ERROR;
637: else
638: end if;