DBA Data[Home] [Help]

APPS.AME_MIGRATION_PKG dependencies on AME_EXCEPTIONS_LOG

Line 10: select ame_exceptions_log_s.nextval

6: ) as
7: l_log_id integer;
8: pragma autonomous_transaction;
9: begin
10: select ame_exceptions_log_s.nextval
11: into l_log_id
12: from dual;
13:
14: insert into ame_exceptions_log

Line 14: insert into ame_exceptions_log

10: select ame_exceptions_log_s.nextval
11: into l_log_id
12: from dual;
13:
14: insert into ame_exceptions_log
15: (log_id,package_name,routine_name,transaction_id,application_id,exception_number,exception_string)
16: values
17: (l_log_id,'ame_migration_pkg','sql code block','','',p_errorcode,to_char(sysdate, 'YYYY:MM:DD:HH24:MI:SS')|| p_message);
18: commit;

Line 353: errbuf := 'Migration of users failed for some users. Check ame_exceptions_log for more details.';

349: log_message('User Responsibility Migration Completed Successfully at '||
350: to_char(sysdate,'YYYY:MM:DD:HH24:MI:SS'));
351: --+
352: if(retcode = 1) then
353: errbuf := 'Migration of users failed for some users. Check ame_exceptions_log for more details.';
354: else
355: errbuf := 'Migration successfully completed for all users.';
356: end if;
357: --+