3348: -- Insert new member using Dimension table handler package
3349: ----------------------------------------------------------
3350:
3351: -- First get the translated default member name and description
3352: FND_MESSAGE.Set_Name('FEM','FEM_DEFAULT_TXT');
3353: v_member_name := substr(FND_MESSAGE.Get,1,150);
3354: FND_MESSAGE.Set_Name('FEM','FEM_DEFAULT_MEMBER_TXT');
3355: v_member_desc := substr(FND_MESSAGE.Get,1,255);
3356:
3349: ----------------------------------------------------------
3350:
3351: -- First get the translated default member name and description
3352: FND_MESSAGE.Set_Name('FEM','FEM_DEFAULT_TXT');
3353: v_member_name := substr(FND_MESSAGE.Get,1,150);
3354: FND_MESSAGE.Set_Name('FEM','FEM_DEFAULT_MEMBER_TXT');
3355: v_member_desc := substr(FND_MESSAGE.Get,1,255);
3356:
3357: v_sql :=
3350:
3351: -- First get the translated default member name and description
3352: FND_MESSAGE.Set_Name('FEM','FEM_DEFAULT_TXT');
3353: v_member_name := substr(FND_MESSAGE.Get,1,150);
3354: FND_MESSAGE.Set_Name('FEM','FEM_DEFAULT_MEMBER_TXT');
3355: v_member_desc := substr(FND_MESSAGE.Get,1,255);
3356:
3357: v_sql :=
3358: 'DECLARE v_rowid VARCHAR2(20);'||
3351: -- First get the translated default member name and description
3352: FND_MESSAGE.Set_Name('FEM','FEM_DEFAULT_TXT');
3353: v_member_name := substr(FND_MESSAGE.Get,1,150);
3354: FND_MESSAGE.Set_Name('FEM','FEM_DEFAULT_MEMBER_TXT');
3355: v_member_desc := substr(FND_MESSAGE.Get,1,255);
3356:
3357: v_sql :=
3358: 'DECLARE v_rowid VARCHAR2(20);'||
3359: ' BEGIN '||