DBA Data[Home] [Help]

APPS.GME_TRANSFORM_BATCH dependencies on FND_LOG

Line 21: p_log_level => fnd_log.level_procedure,

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',
24: p_context => 'PROFILES',
25: p_app_short_name => 'GMA');

Line 31: p_log_level => fnd_log.level_procedure,

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',
34: p_context => 'UPDATE_LAB_IND',
35: p_app_short_name => 'GMA');

Line 41: p_log_level => fnd_log.level_procedure,

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',
44: p_context => 'CREATE_WIP_ENTITY',
45: p_app_short_name => 'GMA');

Line 52: p_log_level => fnd_log.level_procedure,

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',
55: p_context => 'GANTT FILTERS',
56: p_app_short_name => 'GMA');

Line 61: p_log_level => fnd_log.level_procedure,

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',
64: p_context => 'REASON_ID',
65: p_app_short_name => 'GMA');

Line 207: p_log_level => fnd_log.level_procedure,

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',
211: p_token1 => 'ORG_CODE',

Line 219: p_log_level => fnd_log.level_unexpected,

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',
222: p_context => 'PROFILES',
223: p_db_error => SQLERRM,

Line 227: p_log_level => fnd_log.level_unexpected,

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',
230: p_context => 'PROFILES',
231: p_app_short_name => 'GMA');

Line 236: p_log_level => fnd_log.level_procedure,

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',
239: p_context => 'PROFILES',
240: p_param1 => l_count,

Line 247: p_log_level => fnd_log.level_unexpected,

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',
250: p_context => 'PROFILES',
251: p_db_error => SQLERRM,

Line 255: p_log_level => fnd_log.level_unexpected,

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',
258: p_context => 'PROFILES',
259: p_app_short_name => 'GMA');

Line 273: p_log_level => fnd_log.level_procedure,

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',
276: p_context => 'UPDATE_LAB_IND',
277: p_param1 => SQL%ROWCOUNT,

Line 284: p_log_level => fnd_log.level_unexpected,

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',
287: p_context => 'UPDATE_LAB_IND',
288: p_db_error => SQLERRM,

Line 292: p_log_level => fnd_log.level_unexpected,

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',
295: p_context => 'UPDATE_LAB_IND',
296: p_app_short_name => 'GMA');

Line 416: p_log_level => fnd_log.level_unexpected,

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',
419: p_context => 'CREATE_WIP_ENTITY',
420: p_db_error => SQLERRM,

Line 424: p_log_level => fnd_log.level_unexpected,

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',
427: p_context => 'CREATE_WIP_ENTITY',
428: p_app_short_name => 'GMA');

Line 446: p_log_level => fnd_log.level_procedure,

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',
449: p_context => 'CREATE_WIP_ENTITY',
450: p_token1 => 'PARAM1',

Line 458: p_log_level => fnd_log.level_unexpected,

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',
461: p_context => 'CREATE_WIP_ENTITY',
462: p_db_error => SQLERRM,

Line 466: p_log_level => fnd_log.level_unexpected,

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',
469: p_context => 'CREATE_WIP_ENTITY',
470: p_app_short_name => 'GMA',

Line 480: p_log_level => fnd_log.level_procedure,

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',
483: p_context => 'GANTT FILTERS',
484: p_param1 => SQL%ROWCOUNT,

Line 494: p_log_level => fnd_log.level_procedure,

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',
497: p_context => 'REASON_ID',
498: p_param1 => SQL%ROWCOUNT,

Line 504: p_log_level => fnd_log.level_procedure,

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',
507: p_context => 'REASON_ID',
508: p_param1 => SQL%ROWCOUNT,