DBA Data[Home] [Help]

APPS.AME_MIGRATE_PARALLEL_CONFIG dependencies on AME_MIGRATE_PARALLEL_CONFIG

Line 1: package BODY ame_migrate_parallel_config as

1: package BODY ame_migrate_parallel_config as
2: /* $Header: amemigcfg.pkb 120.3 2006/12/26 13:03:53 avarri noship $ */
3: procedure log_message
4: (p_package varchar2
5: ,p_routine varchar2

Line 61: log_message('ame_migrate_parallel_config'

57: l_group_count integer;
58: l_string varchar2(300);
59: l_migration_date date;
60: begin
61: log_message('ame_migrate_parallel_config'
62: ,'migrate_approval_group_config'
63: ,'Approval Group Config Migration');
64: l_migration_date := sysdate;
65: log_message('ame_migrate_parallel_config'

Line 65: log_message('ame_migrate_parallel_config'

61: log_message('ame_migrate_parallel_config'
62: ,'migrate_approval_group_config'
63: ,'Approval Group Config Migration');
64: l_migration_date := sysdate;
65: log_message('ame_migrate_parallel_config'
66: ,'migrate_approval_group_config'
67: ,'Migration date:' || to_char(l_migration_date,'RRRR:MM:DD:HH24:MI:SS'));
68: log_message('ame_migrate_parallel_config'
69: ,'migrate_approval_group_config'

Line 68: log_message('ame_migrate_parallel_config'

64: l_migration_date := sysdate;
65: log_message('ame_migrate_parallel_config'
66: ,'migrate_approval_group_config'
67: ,'Migration date:' || to_char(l_migration_date,'RRRR:MM:DD:HH24:MI:SS'));
68: log_message('ame_migrate_parallel_config'
69: ,'migrate_approval_group_config'
70: ,rpad('=',102,'='));
71: l_group_count := 0;
72: open unused_group_config_cursor;

Line 94: log_message('ame_migrate_parallel_config'

90: l_string := to_char(l_application_id);
91: end if;
92:
93: l_string := l_string || '| ' || rpad(to_char(l_approval_group_id),50,' ');
94: log_message('ame_migrate_parallel_config'
95: ,'migrate_approval_group_config'
96: ,l_string);
97:
98: l_group_count := l_group_count + 1;

Line 102: log_message('ame_migrate_parallel_config'

98: l_group_count := l_group_count + 1;
99: end loop;
100: close unused_group_config_cursor;
101:
102: log_message('ame_migrate_parallel_config'
103: ,'migrate_approval_group_config'
104: ,rpad('=',102,'='));
105: log_message('ame_migrate_parallel_config'
106: ,'migrate_approval_group_config'

Line 105: log_message('ame_migrate_parallel_config'

101:
102: log_message('ame_migrate_parallel_config'
103: ,'migrate_approval_group_config'
104: ,rpad('=',102,'='));
105: log_message('ame_migrate_parallel_config'
106: ,'migrate_approval_group_config'
107: ,'Migration Completed Successfully');
108: log_message('ame_migrate_parallel_config'
109: ,'migrate_approval_group_config'

Line 108: log_message('ame_migrate_parallel_config'

104: ,rpad('=',102,'='));
105: log_message('ame_migrate_parallel_config'
106: ,'migrate_approval_group_config'
107: ,'Migration Completed Successfully');
108: log_message('ame_migrate_parallel_config'
109: ,'migrate_approval_group_config'
110: ,'Total ' || l_group_count || ' configurations migrated');
111: log_message('ame_migrate_parallel_config'
112: ,'migrate_approval_group_config'

Line 111: log_message('ame_migrate_parallel_config'

107: ,'Migration Completed Successfully');
108: log_message('ame_migrate_parallel_config'
109: ,'migrate_approval_group_config'
110: ,'Total ' || l_group_count || ' configurations migrated');
111: log_message('ame_migrate_parallel_config'
112: ,'migrate_approval_group_config'
113: ,'Migration completion date:' || to_char(sysdate,'RRRR:MM:DD:HH24:MI:SS'));
114: commit;
115: retcode := 0;

Line 122: log_message('ame_migrate_parallel_config'

118: when others then
119: rollback;
120: if unused_group_config_cursor%isopen then
121: close unused_group_config_cursor;
122: log_message('ame_migrate_parallel_config'
123: ,'migrate_approval_group_config'
124: ,'Failed during migration of ' ||
125: l_application_name ||
126: ',' ||

Line 129: log_message('ame_migrate_parallel_config'

125: l_application_name ||
126: ',' ||
127: l_approval_group_name);
128: end if;
129: log_message('ame_migrate_parallel_config'
130: ,'migrate_approval_group_config'
131: ,'Approval Group Migration Failed');
132: log_message('ame_migrate_parallel_config'
133: ,'migrate_approval_group_config'

Line 132: log_message('ame_migrate_parallel_config'

128: end if;
129: log_message('ame_migrate_parallel_config'
130: ,'migrate_approval_group_config'
131: ,'Approval Group Migration Failed');
132: log_message('ame_migrate_parallel_config'
133: ,'migrate_approval_group_config'
134: ,'Cause:' || sqlerrm);
135: retcode := 1;
136: errbuf := 'Approval Groups Migration Failed';

Line 172: log_message('ame_migrate_parallel_config'

168: l_atype_count integer;
169: l_string varchar2(300);
170: l_migration_date date;
171: begin
172: log_message('ame_migrate_parallel_config'
173: ,'migrate_action_type_config'
174: ,'Action Type Config Migration');
175: l_migration_date := sysdate;
176: log_message('ame_migrate_parallel_config'

Line 176: log_message('ame_migrate_parallel_config'

172: log_message('ame_migrate_parallel_config'
173: ,'migrate_action_type_config'
174: ,'Action Type Config Migration');
175: l_migration_date := sysdate;
176: log_message('ame_migrate_parallel_config'
177: ,'migrate_action_type_config'
178: ,'Migration date:' || to_char(l_migration_date,'RRRR:MM:DD:HH24:MI:SS'));
179: log_message('ame_migrate_parallel_config'
180: ,'migrate_action_type_config'

Line 179: log_message('ame_migrate_parallel_config'

175: l_migration_date := sysdate;
176: log_message('ame_migrate_parallel_config'
177: ,'migrate_action_type_config'
178: ,'Migration date:' || to_char(l_migration_date,'RRRR:MM:DD:HH24:MI:SS'));
179: log_message('ame_migrate_parallel_config'
180: ,'migrate_action_type_config'
181: ,rpad('=',102,'='));
182:
183: l_atype_count := 0;

Line 206: log_message('ame_migrate_parallel_config'

202: l_string := to_char(l_application_id);
203: end if;
204:
205: l_string := l_string || '| ' || rpad(to_char(l_action_type_id),50,' ');
206: log_message('ame_migrate_parallel_config'
207: ,'migrate_action_type_config'
208: ,l_string);
209:
210: l_atype_count := l_atype_count + 1;

Line 214: log_message('ame_migrate_parallel_config'

210: l_atype_count := l_atype_count + 1;
211: end loop;
212: close unused_atype_config_cursor;
213:
214: log_message('ame_migrate_parallel_config'
215: ,'migrate_action_type_config'
216: ,rpad('=',102,'='));
217: log_message('ame_migrate_parallel_config'
218: ,'migrate_action_type_config'

Line 217: log_message('ame_migrate_parallel_config'

213:
214: log_message('ame_migrate_parallel_config'
215: ,'migrate_action_type_config'
216: ,rpad('=',102,'='));
217: log_message('ame_migrate_parallel_config'
218: ,'migrate_action_type_config'
219: ,'Migration Completed Successfully');
220: log_message('ame_migrate_parallel_config'
221: ,'migrate_action_type_config'

Line 220: log_message('ame_migrate_parallel_config'

216: ,rpad('=',102,'='));
217: log_message('ame_migrate_parallel_config'
218: ,'migrate_action_type_config'
219: ,'Migration Completed Successfully');
220: log_message('ame_migrate_parallel_config'
221: ,'migrate_action_type_config'
222: ,'Total ' || l_atype_count || ' configurations migrated');
223: log_message('ame_migrate_parallel_config'
224: ,'migrate_action_type_config'

Line 223: log_message('ame_migrate_parallel_config'

219: ,'Migration Completed Successfully');
220: log_message('ame_migrate_parallel_config'
221: ,'migrate_action_type_config'
222: ,'Total ' || l_atype_count || ' configurations migrated');
223: log_message('ame_migrate_parallel_config'
224: ,'migrate_action_type_config'
225: ,'Migration completion date:' || to_char(sysdate,'RRRR:MM:DD:HH24:MI:SS'));
226: -- Set the chain ordering mode for the action type configurations of
227: -- those action types for which it is not applicable.

Line 248: log_message('ame_migrate_parallel_config'

244: when others then
245: rollback;
246: if unused_atype_config_cursor%isopen then
247: close unused_atype_config_cursor;
248: log_message('ame_migrate_parallel_config'
249: ,'migrate_action_type_config'
250: ,'Failed during migration of ' ||
251: l_application_name ||
252: ',' ||

Line 255: log_message('ame_migrate_parallel_config'

251: l_application_name ||
252: ',' ||
253: l_action_type_name);
254: end if;
255: log_message('ame_migrate_parallel_config'
256: ,'migrate_action_type_config'
257: ,'Action Types Migration Failed');
258: log_message('ame_migrate_parallel_config'
259: ,'migrate_action_type_config'

Line 258: log_message('ame_migrate_parallel_config'

254: end if;
255: log_message('ame_migrate_parallel_config'
256: ,'migrate_action_type_config'
257: ,'Action Types Migration Failed');
258: log_message('ame_migrate_parallel_config'
259: ,'migrate_action_type_config'
260: ,'Cause:' || sqlerrm);
261: retcode := 1;
262: errbuf := 'Action Types Migration Failed';

Line 300: end ame_migrate_parallel_config;

296: errbuf := 'Successfully Completed the Parallelization Config Migration';
297: end if;
298: end migrate_parallel_config;
299:
300: end ame_migrate_parallel_config;