158: ( x_mesg_token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
159: , x_return_Status OUT NOCOPY VARCHAR2
160: )
161: IS
162: l_UserId NUMBER := FND_GLOBAL.User_Id;
163: l_LanguageCode VARCHAR2(4) := EGO_Globals.Get_Language_Code;
164:
165: BEGIN
166:
259: , EGO_Globals.G_Catalog_Group_Rec.attribute13
260: , EGO_Globals.G_Catalog_Group_Rec.attribute14
261: , EGO_Globals.G_Catalog_Group_Rec.attribute15
262: , SYSDATE
263: , FND_Global.User_Id
264: , SYSDATE
265: , FND_Global.User_Id
266: , FND_Global.User_Id
267: );
261: , EGO_Globals.G_Catalog_Group_Rec.attribute15
262: , SYSDATE
263: , FND_Global.User_Id
264: , SYSDATE
265: , FND_Global.User_Id
266: , FND_Global.User_Id
267: );
268:
269:
262: , SYSDATE
263: , FND_Global.User_Id
264: , SYSDATE
265: , FND_Global.User_Id
266: , FND_Global.User_Id
267: );
268:
269:
270: -- dbms_output.put_line('Inserting into TL table . . .');
381: , Segment19= EGO_Item_Catalog_Pub.G_KF_Segment_Values(19)
382: , Segment20= EGO_Item_Catalog_Pub.G_KF_Segment_Values(20)
383: , description = EGO_Globals.G_Catalog_Group_Rec.description
384: , last_update_date = SYSDATE
385: , last_updated_by = FND_Global.User_Id
386: , last_update_login = FND_Global.User_Id
387: , attribute_category = EGO_Globals.G_Catalog_Group_Rec.attribute_category
388: , attribute1 = EGO_Globals.G_Catalog_Group_Rec.attribute1
389: , attribute2 = EGO_Globals.G_Catalog_Group_Rec.attribute2
382: , Segment20= EGO_Item_Catalog_Pub.G_KF_Segment_Values(20)
383: , description = EGO_Globals.G_Catalog_Group_Rec.description
384: , last_update_date = SYSDATE
385: , last_updated_by = FND_Global.User_Id
386: , last_update_login = FND_Global.User_Id
387: , attribute_category = EGO_Globals.G_Catalog_Group_Rec.attribute_category
388: , attribute1 = EGO_Globals.G_Catalog_Group_Rec.attribute1
389: , attribute2 = EGO_Globals.G_Catalog_Group_Rec.attribute2
390: , attribute3 = EGO_Globals.G_Catalog_Group_Rec.attribute3
406: /* Update the TL table description */
407:
408: UPDATE Mtl_Item_Catalog_Groups_TL
409: SET description = EGO_Globals.G_Catalog_Group_Rec.description
410: , last_updated_by = FND_Global.User_Id
411: , last_update_date = SYSDATE
412: WHERE item_catalog_group_id =
413: EGO_Globals.G_Catalog_Group_Rec.Catalog_Group_Id
414: AND LANGUAGE = EGO_Globals.Get_Language_Code;