DBA Data[Home] [Help]

APPS.GME_TRANSFORM_BATCH dependencies on GMA_COMMON_LOGGING

Line 19: gma_common_logging.gma_migration_central_log

15: PROCEDURE gme_migration (p_migration_run_id IN NUMBER,
16: p_commit IN VARCHAR2,
17: x_failure_count OUT NOCOPY NUMBER) IS
18: BEGIN
19: gma_common_logging.gma_migration_central_log
20: (p_run_id => p_migration_run_id,
21: p_log_level => fnd_log.level_procedure,
22: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
23: p_table_name => 'GME_PARAMETERS',

Line 29: gma_common_logging.gma_migration_central_log

25: p_app_short_name => 'GMA');
26: create_gme_parameters(p_migration_run_id => p_migration_run_id,
27: x_exception_count => x_failure_count);
28:
29: gma_common_logging.gma_migration_central_log
30: (p_run_id => p_migration_run_id,
31: p_log_level => fnd_log.level_procedure,
32: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
33: p_table_name => 'GME_BATCH_HEADER',

Line 39: gma_common_logging.gma_migration_central_log

35: p_app_short_name => 'GMA');
36: update_batch_header(p_migration_run_id => p_migration_run_id,
37: x_exception_count => x_failure_count);
38:
39: gma_common_logging.gma_migration_central_log
40: (p_run_id => p_migration_run_id,
41: p_log_level => fnd_log.level_procedure,
42: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
43: p_table_name => 'WIP_ENTITIES',

Line 50: gma_common_logging.gma_migration_central_log

46: update_wip_entities(p_migration_run_id => p_migration_run_id,
47: x_exception_count => x_failure_count);
48:
49:
50: gma_common_logging.gma_migration_central_log
51: (p_run_id => p_migration_run_id,
52: p_log_level => fnd_log.level_procedure,
53: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
54: p_table_name => 'GME_GANTT_DOCUMENT_FILTER',

Line 59: gma_common_logging.gma_migration_central_log

55: p_context => 'GANTT FILTERS',
56: p_app_short_name => 'GMA');
57: update_from_doc_no(p_migration_run_id);
58:
59: gma_common_logging.gma_migration_central_log
60: (p_run_id => p_migration_run_id,
61: p_log_level => fnd_log.level_procedure,
62: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
63: p_table_name => 'GME_RESOURCE_TXNS',

Line 165: gma_common_logging.gma_migration_central_log(p_run_id => p_migration_run_id,

161: NULL, --last_update_login
162: SYSDATE --last_updated_date
163: );
164: l_count := l_count + 1;
165: gma_common_logging.gma_migration_central_log(p_run_id => p_migration_run_id,
166: p_log_level => fnd_log.level_procedure,
167: p_message_token => 'GME_CREATE_PARAMS_SUCCESS',
168: p_table_name => 'GME_PARAMETERS',
169: p_context => 'PROFILES',

Line 176: gma_common_logging.gma_migration_central_log

172: p_app_short_name => 'GME');
173: EXCEPTION
174: WHEN OTHERS THEN
175: x_exception_count := x_exception_count + 1;
176: gma_common_logging.gma_migration_central_log
177: (p_run_id => p_migration_run_id,
178: p_log_level => fnd_log.level_unexpected,
179: p_message_token => 'GMA_MIGRATION_DB_ERROR',
180: p_table_name => 'GME_PARAMETERS',

Line 184: gma_common_logging.gma_migration_central_log

180: p_table_name => 'GME_PARAMETERS',
181: p_context => 'PROFILES',
182: p_db_error => SQLERRM,
183: p_app_short_name => 'GMA');
184: gma_common_logging.gma_migration_central_log
185: (p_run_id => p_migration_run_id,
186: p_log_level => fnd_log.level_unexpected,
187: p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
188: p_table_name => 'GME_PARAMETERS',

Line 193: gma_common_logging.gma_migration_central_log

189: p_context => 'PROFILES',
190: p_app_short_name => 'GMA');
191: END;
192: END LOOP;
193: gma_common_logging.gma_migration_central_log
194: (p_run_id => p_migration_run_id,
195: p_log_level => fnd_log.level_procedure,
196: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
197: p_table_name => 'GME_PARAMETERS',

Line 204: gma_common_logging.gma_migration_central_log

200: p_app_short_name => 'GMA');
201: EXCEPTION
202: WHEN OTHERS THEN
203: x_exception_count := x_exception_count + 1;
204: gma_common_logging.gma_migration_central_log
205: (p_run_id => p_migration_run_id,
206: p_log_level => fnd_log.level_unexpected,
207: p_message_token => 'GMA_MIGRATION_DB_ERROR',
208: p_table_name => 'GME_PARAMETERS',

Line 212: gma_common_logging.gma_migration_central_log

208: p_table_name => 'GME_PARAMETERS',
209: p_context => 'PROFILES',
210: p_db_error => SQLERRM,
211: p_app_short_name => 'GMA');
212: gma_common_logging.gma_migration_central_log
213: (p_run_id => p_migration_run_id,
214: p_log_level => fnd_log.level_unexpected,
215: p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
216: p_table_name => 'GME_PARAMETERS',

Line 230: gma_common_logging.gma_migration_central_log

226: FROM sy_orgn_mst org
227: WHERE org.orgn_code = h.plant_code),
228: migrated_batch_ind = 'Y'
229: WHERE laboratory_ind IS NULL;
230: gma_common_logging.gma_migration_central_log
231: (p_run_id => p_migration_run_id,
232: p_log_level => fnd_log.level_procedure,
233: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
234: p_table_name => 'GME_BATCH_HEADER',

Line 241: gma_common_logging.gma_migration_central_log

237: p_app_short_name => 'GMA');
238: EXCEPTION
239: WHEN OTHERS THEN
240: x_exception_count := x_exception_count + 1;
241: gma_common_logging.gma_migration_central_log
242: (p_run_id => p_migration_run_id,
243: p_log_level => fnd_log.level_unexpected,
244: p_message_token => 'GMA_MIGRATION_DB_ERROR',
245: p_table_name => 'GME_BATCH_HEADER',

Line 249: gma_common_logging.gma_migration_central_log

245: p_table_name => 'GME_BATCH_HEADER',
246: p_context => 'UPDATE_LAB_IND',
247: p_db_error => SQLERRM,
248: p_app_short_name => 'GMA');
249: gma_common_logging.gma_migration_central_log
250: (p_run_id => p_migration_run_id,
251: p_log_level => fnd_log.level_unexpected,
252: p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
253: p_table_name => 'GME_BATCH_HEADER',

Line 312: gma_common_logging.gma_migration_central_log

308: l_count := l_count + 1;
309: EXCEPTION
310: WHEN OTHERS THEN
311: x_exception_count := x_exception_count + 1;
312: gma_common_logging.gma_migration_central_log
313: (p_run_id => p_migration_run_id,
314: p_log_level => fnd_log.level_unexpected,
315: p_message_token => 'GMA_MIGRATION_DB_ERROR',
316: p_table_name => 'WIP_ENTITIES',

Line 320: gma_common_logging.gma_migration_central_log

316: p_table_name => 'WIP_ENTITIES',
317: p_context => 'CREATE_WIP_ENTITY',
318: p_db_error => SQLERRM,
319: p_app_short_name => 'GMA');
320: gma_common_logging.gma_migration_central_log
321: (p_run_id => p_migration_run_id,
322: p_log_level => fnd_log.level_unexpected,
323: p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
324: p_table_name => 'WIP_ENTITIES',

Line 342: gma_common_logging.gma_migration_central_log

338: SELECT wip_entities_s.NEXTVAL
339: INTO l_wip_entity_id
340: FROM DUAL;
341: END LOOP;
342: gma_common_logging.gma_migration_central_log
343: (p_run_id => p_migration_run_id,
344: p_log_level => fnd_log.level_procedure,
345: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
346: p_table_name => 'WIP_ENTITIES',

Line 354: gma_common_logging.gma_migration_central_log

350: p_app_short_name => 'GMA');
351: EXCEPTION
352: WHEN OTHERS THEN
353: x_exception_count := x_exception_count + 1;
354: gma_common_logging.gma_migration_central_log
355: (p_run_id => p_migration_run_id,
356: p_log_level => fnd_log.level_unexpected,
357: p_message_token => 'GMA_MIGRATION_DB_ERROR',
358: p_table_name => 'WIP_ENTITIES',

Line 362: gma_common_logging.gma_migration_central_log

358: p_table_name => 'WIP_ENTITIES',
359: p_context => 'CREATE_WIP_ENTITY',
360: p_db_error => SQLERRM,
361: p_app_short_name => 'GMA');
362: gma_common_logging.gma_migration_central_log
363: (p_run_id => p_migration_run_id,
364: p_log_level => fnd_log.level_unexpected,
365: p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
366: p_table_name => 'WIP_ENTITIES',

Line 376: gma_common_logging.gma_migration_central_log

372: PROCEDURE update_from_doc_no(p_migration_run_id NUMBER) IS
373: BEGIN
374: UPDATE gme_gantt_document_filter
375: SET from_doc_no = document_no;
376: gma_common_logging.gma_migration_central_log
377: (p_run_id => p_migration_run_id,
378: p_log_level => fnd_log.level_procedure,
379: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
380: p_table_name => 'GME_GANTT_DOCUMENT_FILTER',

Line 390: gma_common_logging.gma_migration_central_log

386: PROCEDURE update_reason_id(p_migration_run_id NUMBER) IS
387: BEGIN
388: UPDATE gme_resource_txns t
389: SET reason_id = (SELECT reason_id FROM sy_reas_cds_b WHERE reason_code = t.reason_code);
390: gma_common_logging.gma_migration_central_log
391: (p_run_id => p_migration_run_id,
392: p_log_level => fnd_log.level_procedure,
393: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
394: p_table_name => 'GME_RESOURCE_TXNS',

Line 400: gma_common_logging.gma_migration_central_log

396: p_param1 => SQL%ROWCOUNT,
397: p_app_short_name => 'GMA');
398: UPDATE gme_resource_txns_mig t
399: SET reason_id = (SELECT reason_id FROM sy_reas_cds_b WHERE reason_code = t.reason_code);
400: gma_common_logging.gma_migration_central_log
401: (p_run_id => p_migration_run_id,
402: p_log_level => fnd_log.level_procedure,
403: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
404: p_table_name => 'GME_RESOURCE_TXNS_MIG',