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 206: gma_common_logging.gma_migration_central_log(p_run_id => p_migration_run_id,

202: NULL, --last_update_login
203: SYSDATE --last_updated_date
204: );
205: l_count := l_count + 1;
206: gma_common_logging.gma_migration_central_log(p_run_id => p_migration_run_id,
207: p_log_level => fnd_log.level_procedure,
208: p_message_token => 'GME_CREATE_PARAMS_SUCCESS',
209: p_table_name => 'GME_PARAMETERS',
210: p_context => 'PROFILES',

Line 217: gma_common_logging.gma_migration_central_log

213: p_app_short_name => 'GME');
214: EXCEPTION
215: WHEN OTHERS THEN
216: x_exception_count := x_exception_count + 1;
217: gma_common_logging.gma_migration_central_log
218: (p_run_id => p_migration_run_id,
219: p_log_level => fnd_log.level_unexpected,
220: p_message_token => 'GMA_MIGRATION_DB_ERROR',
221: p_table_name => 'GME_PARAMETERS',

Line 225: gma_common_logging.gma_migration_central_log

221: p_table_name => 'GME_PARAMETERS',
222: p_context => 'PROFILES',
223: p_db_error => SQLERRM,
224: p_app_short_name => 'GMA');
225: gma_common_logging.gma_migration_central_log
226: (p_run_id => p_migration_run_id,
227: p_log_level => fnd_log.level_unexpected,
228: p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
229: p_table_name => 'GME_PARAMETERS',

Line 234: gma_common_logging.gma_migration_central_log

230: p_context => 'PROFILES',
231: p_app_short_name => 'GMA');
232: END;
233: END LOOP;
234: gma_common_logging.gma_migration_central_log
235: (p_run_id => p_migration_run_id,
236: p_log_level => fnd_log.level_procedure,
237: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
238: p_table_name => 'GME_PARAMETERS',

Line 245: gma_common_logging.gma_migration_central_log

241: p_app_short_name => 'GMA');
242: EXCEPTION
243: WHEN OTHERS THEN
244: x_exception_count := x_exception_count + 1;
245: gma_common_logging.gma_migration_central_log
246: (p_run_id => p_migration_run_id,
247: p_log_level => fnd_log.level_unexpected,
248: p_message_token => 'GMA_MIGRATION_DB_ERROR',
249: p_table_name => 'GME_PARAMETERS',

Line 253: gma_common_logging.gma_migration_central_log

249: p_table_name => 'GME_PARAMETERS',
250: p_context => 'PROFILES',
251: p_db_error => SQLERRM,
252: p_app_short_name => 'GMA');
253: gma_common_logging.gma_migration_central_log
254: (p_run_id => p_migration_run_id,
255: p_log_level => fnd_log.level_unexpected,
256: p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
257: p_table_name => 'GME_PARAMETERS',

Line 271: gma_common_logging.gma_migration_central_log

267: FROM sy_orgn_mst org
268: WHERE org.orgn_code = h.plant_code),
269: migrated_batch_ind = 'Y'
270: WHERE laboratory_ind IS NULL;
271: gma_common_logging.gma_migration_central_log
272: (p_run_id => p_migration_run_id,
273: p_log_level => fnd_log.level_procedure,
274: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
275: p_table_name => 'GME_BATCH_HEADER',

Line 282: gma_common_logging.gma_migration_central_log

278: p_app_short_name => 'GMA');
279: EXCEPTION
280: WHEN OTHERS THEN
281: x_exception_count := x_exception_count + 1;
282: gma_common_logging.gma_migration_central_log
283: (p_run_id => p_migration_run_id,
284: p_log_level => fnd_log.level_unexpected,
285: p_message_token => 'GMA_MIGRATION_DB_ERROR',
286: p_table_name => 'GME_BATCH_HEADER',

Line 290: gma_common_logging.gma_migration_central_log

286: p_table_name => 'GME_BATCH_HEADER',
287: p_context => 'UPDATE_LAB_IND',
288: p_db_error => SQLERRM,
289: p_app_short_name => 'GMA');
290: gma_common_logging.gma_migration_central_log
291: (p_run_id => p_migration_run_id,
292: p_log_level => fnd_log.level_unexpected,
293: p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
294: p_table_name => 'GME_BATCH_HEADER',

Line 414: gma_common_logging.gma_migration_central_log

410: l_count := l_count + 1;
411: EXCEPTION
412: WHEN OTHERS THEN
413: x_exception_count := x_exception_count + 1;
414: gma_common_logging.gma_migration_central_log
415: (p_run_id => p_migration_run_id,
416: p_log_level => fnd_log.level_unexpected,
417: p_message_token => 'GMA_MIGRATION_DB_ERROR',
418: p_table_name => 'WIP_ENTITIES',

Line 422: gma_common_logging.gma_migration_central_log

418: p_table_name => 'WIP_ENTITIES',
419: p_context => 'CREATE_WIP_ENTITY',
420: p_db_error => SQLERRM,
421: p_app_short_name => 'GMA');
422: gma_common_logging.gma_migration_central_log
423: (p_run_id => p_migration_run_id,
424: p_log_level => fnd_log.level_unexpected,
425: p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
426: p_table_name => 'WIP_ENTITIES',

Line 444: gma_common_logging.gma_migration_central_log

440: SELECT wip_entities_s.NEXTVAL
441: INTO l_wip_entity_id
442: FROM DUAL;
443: END LOOP;
444: gma_common_logging.gma_migration_central_log
445: (p_run_id => p_migration_run_id,
446: p_log_level => fnd_log.level_procedure,
447: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
448: p_table_name => 'WIP_ENTITIES',

Line 456: gma_common_logging.gma_migration_central_log

452: p_app_short_name => 'GMA');
453: EXCEPTION
454: WHEN OTHERS THEN
455: x_exception_count := x_exception_count + 1;
456: gma_common_logging.gma_migration_central_log
457: (p_run_id => p_migration_run_id,
458: p_log_level => fnd_log.level_unexpected,
459: p_message_token => 'GMA_MIGRATION_DB_ERROR',
460: p_table_name => 'WIP_ENTITIES',

Line 464: gma_common_logging.gma_migration_central_log

460: p_table_name => 'WIP_ENTITIES',
461: p_context => 'CREATE_WIP_ENTITY',
462: p_db_error => SQLERRM,
463: p_app_short_name => 'GMA');
464: gma_common_logging.gma_migration_central_log
465: (p_run_id => p_migration_run_id,
466: p_log_level => fnd_log.level_unexpected,
467: p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
468: p_table_name => 'WIP_ENTITIES',

Line 478: gma_common_logging.gma_migration_central_log

474: PROCEDURE update_from_doc_no(p_migration_run_id NUMBER) IS
475: BEGIN
476: UPDATE gme_gantt_document_filter
477: SET from_doc_no = document_no;
478: gma_common_logging.gma_migration_central_log
479: (p_run_id => p_migration_run_id,
480: p_log_level => fnd_log.level_procedure,
481: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
482: p_table_name => 'GME_GANTT_DOCUMENT_FILTER',

Line 492: gma_common_logging.gma_migration_central_log

488: PROCEDURE update_reason_id(p_migration_run_id NUMBER) IS
489: BEGIN
490: UPDATE gme_resource_txns t
491: SET reason_id = (SELECT reason_id FROM sy_reas_cds_b WHERE reason_code = t.reason_code);
492: gma_common_logging.gma_migration_central_log
493: (p_run_id => p_migration_run_id,
494: p_log_level => fnd_log.level_procedure,
495: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
496: p_table_name => 'GME_RESOURCE_TXNS',

Line 502: gma_common_logging.gma_migration_central_log

498: p_param1 => SQL%ROWCOUNT,
499: p_app_short_name => 'GMA');
500: UPDATE gme_resource_txns_mig t
501: SET reason_id = (SELECT reason_id FROM sy_reas_cds_b WHERE reason_code = t.reason_code);
502: gma_common_logging.gma_migration_central_log
503: (p_run_id => p_migration_run_id,
504: p_log_level => fnd_log.level_procedure,
505: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
506: p_table_name => 'GME_RESOURCE_TXNS_MIG',