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 166: p_log_level => fnd_log.level_procedure,

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

Line 178: p_log_level => fnd_log.level_unexpected,

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

Line 186: p_log_level => fnd_log.level_unexpected,

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

Line 195: p_log_level => fnd_log.level_procedure,

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

Line 206: p_log_level => fnd_log.level_unexpected,

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

Line 214: p_log_level => fnd_log.level_unexpected,

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

Line 232: p_log_level => fnd_log.level_procedure,

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

Line 243: p_log_level => fnd_log.level_unexpected,

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

Line 251: p_log_level => fnd_log.level_unexpected,

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

Line 314: p_log_level => fnd_log.level_unexpected,

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

Line 322: p_log_level => fnd_log.level_unexpected,

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

Line 344: p_log_level => fnd_log.level_procedure,

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

Line 356: p_log_level => fnd_log.level_unexpected,

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

Line 364: p_log_level => fnd_log.level_unexpected,

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

Line 378: p_log_level => fnd_log.level_procedure,

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

Line 392: p_log_level => fnd_log.level_procedure,

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

Line 402: p_log_level => fnd_log.level_procedure,

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