DBA Data[Home] [Help]

APPS.IEM_MIGRATION_PVT dependencies on IEM_ARCH_MSGS

Line 381: insert into iem_arch_msgs

377: sysdate,
378: l_last_update_login);
379:
380: -- Insert into IEM_ARCH_MESSAGES
381: insert into iem_arch_msgs
382: (MESSAGE_ID,
383: MESSAGE_CONTENT,
384: CREATED_BY,
385: CREATION_DATE,

Line 425: delete from iem_arch_msgs where message_id=l_message_id;

421: --siahmed moved this section of the code out of exception block and put it outside
422: --so every block will fall under this rather than duplicating the code
423: IF l_mig_status = 'E' THEN
424: BEGIN
425: delete from iem_arch_msgs where message_id=l_message_id;
426: delete from iem_arch_msgdtls where message_id=l_message_id;
427: EXCEPTION WHEN OTHERS THEN
428: l_error_text:=l_error_text ||'-Other exception during delete sqlerrm:'||sqlerrm;
429: END;