DBA Data[Home] [Help]

APPS.GMD_LM_MIGRATION dependencies on GMA_MIGRATION

Line 71: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id

67: END LOOP;
68: EXCEPTION
69: WHEN OTHERS THEN
70: P_line_no := P_line_no + 1;
71: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id
72: ,p_table_name => 'GMD_TECH_PARAMETERS'
73: ,p_db_error => sqlerrm
74: ,p_param1 => NULL
75: ,p_param2 => NULL

Line 79: ,p_message_token => 'GMA_MIGRATION_DB_ERROR'

75: ,p_param2 => NULL
76: ,p_param3 => NULL
77: ,p_param4 => NULL
78: ,p_param5 => NULL
79: ,p_message_token => 'GMA_MIGRATION_DB_ERROR'
80: ,p_message_type => 'D'
81: ,p_line_no => P_line_no
82: ,p_position=> 1
83: ,p_base_message=> NULL);

Line 132: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id

128: END LOOP;
129: EXCEPTION
130: WHEN OTHERS THEN
131: P_line_no := P_line_no + 1;
132: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id
133: ,p_table_name => 'LM_SPRD_DTL'
134: ,p_db_error => sqlerrm
135: ,p_param1 => NULL
136: ,p_param2 => NULL

Line 140: ,p_message_token => 'GMA_MIGRATION_DB_ERROR'

136: ,p_param2 => NULL
137: ,p_param3 => NULL
138: ,p_param4 => NULL
139: ,p_param5 => NULL
140: ,p_message_token => 'GMA_MIGRATION_DB_ERROR'
141: ,p_message_type => 'D'
142: ,p_line_no => P_line_no
143: ,p_position=> 1
144: ,p_base_message=> NULL);

Line 189: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id

185: p_data => l_msg_data,
186: p_encoded => 'F',
187: p_msg_index_out => l_msg_index);
188: P_line_no := P_line_no + 1;
189: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id
190: ,p_table_name => 'GMD_PARSED_EXPRESSION'
191: ,p_db_error => l_msg_data
192: ,p_param1 => get_exp_rec.tech_parm_name
193: ,p_param2 => get_exp_rec.orgn_code

Line 197: ,p_message_token => 'GMA_MIGRATION_DB_ERROR'

193: ,p_param2 => get_exp_rec.orgn_code
194: ,p_param3 => NULL
195: ,p_param4 => NULL
196: ,p_param5 => NULL
197: ,p_message_token => 'GMA_MIGRATION_DB_ERROR'
198: ,p_message_type => 'D'
199: ,p_line_no => P_line_no
200: ,p_position=> 1
201: ,p_base_message=> NULL);

Line 210: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id

206: END IF;
207: EXCEPTION
208: WHEN OTHERS THEN
209: P_line_no := P_line_no + 1;
210: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id
211: ,p_table_name => 'GMD_PARSED_EXPRESSION'
212: ,p_db_error => sqlerrm
213: ,p_param1 => NULL
214: ,p_param2 => NULL

Line 218: ,p_message_token => 'GMA_MIGRATION_DB_ERROR'

214: ,p_param2 => NULL
215: ,p_param3 => NULL
216: ,p_param4 => NULL
217: ,p_param5 => NULL
218: ,p_message_token => 'GMA_MIGRATION_DB_ERROR'
219: ,p_message_type => 'D'
220: ,p_line_no => P_line_no
221: ,p_position=> 1
222: ,p_base_message=> NULL);

Line 275: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id

271: WHERE orgn_code = v_lm_prlt_asc_rec.orgn_code);
272: EXCEPTION
273: WHEN OTHERS THEN
274: P_line_no := P_line_no + 1;
275: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id
276: ,p_table_name => 'GMD_TECHNICAL_SEQUENCE_HDR'
277: ,p_db_error => sqlerrm
278: ,p_param1 => NULL
279: ,p_param2 => NULL

Line 283: ,p_message_token => 'GMA_MIGRATION_DB_ERROR'

279: ,p_param2 => NULL
280: ,p_param3 => NULL
281: ,p_param4 => NULL
282: ,p_param5 => NULL
283: ,p_message_token => 'GMA_MIGRATION_DB_ERROR'
284: ,p_message_type => 'D'
285: ,p_line_no => P_line_no
286: ,p_position=> 1
287: ,p_base_message=> NULL);

Line 353: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id

349:
350: EXCEPTION
351: WHEN E_Tech_parm_Not_Found THEN
352: P_line_no := P_line_no + 1;
353: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id
354: ,p_table_name => 'GMD_TECHNICAL_SEQUENCE_DTL'
355: ,p_db_error => sqlerrm
356: ,p_param1 => v_lm_prlt_asc_rec.tech_parm_name
357: ,p_param2 => v_lm_prlt_asc_rec.orgn_code

Line 369: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id

365: ,p_base_message=> NULL);
366:
367: WHEN OTHERS THEN
368: P_line_no := P_line_no + 1;
369: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id
370: ,p_table_name => 'GMD_TECHNICAL_SEQUENCE_DTL'
371: ,p_db_error => sqlerrm
372: ,p_param1 => NULL
373: ,p_param2 => NULL

Line 377: ,p_message_token => 'GMA_MIGRATION_DB_ERROR'

373: ,p_param2 => NULL
374: ,p_param3 => NULL
375: ,p_param4 => NULL
376: ,p_param5 => NULL
377: ,p_message_token => 'GMA_MIGRATION_DB_ERROR'
378: ,p_message_type => 'D'
379: ,p_line_no => P_line_no
380: ,p_position=> 1
381: ,p_base_message=> NULL);

Line 429: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id

425:
426: EXCEPTION
427: WHEN OTHERS THEN
428: P_line_no := P_line_no + 1;
429: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id
430: ,p_table_name => 'GMD_TECHNICAL_SEQUENCE_HDR'
431: ,p_db_error => sqlerrm
432: ,p_param1 => NULL
433: ,p_param2 => NULL

Line 437: ,p_message_token => 'GMA_MIGRATION_DB_ERROR'

433: ,p_param2 => NULL
434: ,p_param3 => NULL
435: ,p_param4 => NULL
436: ,p_param5 => NULL
437: ,p_message_token => 'GMA_MIGRATION_DB_ERROR'
438: ,p_message_type => 'D'
439: ,p_line_no => P_line_no
440: ,p_position=> 1
441: ,p_base_message=> NULL);

Line 503: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id

499: EXCEPTION
500:
501: WHEN OTHERS THEN
502: P_line_no := P_line_no + 1;
503: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id
504: ,p_table_name => 'GMD_TECHNICAL_DATA_HDR'
505: ,p_db_error => sqlerrm
506: ,p_param1 => NULL
507: ,p_param2 => NULL

Line 511: ,p_message_token => 'GMA_MIGRATION_DB_ERROR'

507: ,p_param2 => NULL
508: ,p_param3 => NULL
509: ,p_param4 => NULL
510: ,p_param5 => NULL
511: ,p_message_token => 'GMA_MIGRATION_DB_ERROR'
512: ,p_message_type => 'D'
513: ,p_line_no => P_line_no
514: ,p_position=> 1
515: ,p_base_message=> NULL);

Line 590: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id

586:
587: EXCEPTION
588: WHEN E_Tech_parm_Not_Found THEN
589: P_line_no := P_line_no + 1;
590: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id
591: ,p_table_name => 'GMD_TECHNICAL_DATA_HDR'
592: ,p_db_error => sqlerrm
593: ,p_param1 => NULL
594: ,p_param2 => NULL

Line 598: ,p_message_token => 'GMA_MIGRATION_DB_ERROR'

594: ,p_param2 => NULL
595: ,p_param3 => NULL
596: ,p_param4 => NULL
597: ,p_param5 => NULL
598: ,p_message_token => 'GMA_MIGRATION_DB_ERROR'
599: ,p_message_type => 'D'
600: ,p_line_no => P_line_no
601: ,p_position=> 1
602: ,p_base_message=> NULL);

Line 606: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id

602: ,p_base_message=> NULL);
603:
604: WHEN OTHERS THEN
605: P_line_no := P_line_no + 1;
606: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id
607: ,p_table_name => 'GMD_TECHNICAL_DATA_DTL'
608: ,p_db_error => sqlerrm
609: ,p_param1 => NULL
610: ,p_param2 => NULL

Line 614: ,p_message_token => 'GMA_MIGRATION_DB_ERROR'

610: ,p_param2 => NULL
611: ,p_param3 => NULL
612: ,p_param4 => NULL
613: ,p_param5 => NULL
614: ,p_message_token => 'GMA_MIGRATION_DB_ERROR'
615: ,p_message_type => 'D'
616: ,p_line_no => P_line_no
617: ,p_position=> 1
618: ,p_base_message=> NULL);

Line 673: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id

669: CLOSE C_get_lm_item_dat;
670: EXCEPTION
671: WHEN OTHERS THEN
672: P_line_no := P_line_no + 1;
673: GMA_MIGRATION.gma_insert_message (p_run_id => p_run_id
674: ,p_table_name => 'GMD_TECHNICAL_DATA_HDR'
675: ,p_db_error => sqlerrm
676: ,p_param1 => NULL
677: ,p_param2 => NULL

Line 681: ,p_message_token => 'GMA_MIGRATION_DB_ERROR'

677: ,p_param2 => NULL
678: ,p_param3 => NULL
679: ,p_param4 => NULL
680: ,p_param5 => NULL
681: ,p_message_token => 'GMA_MIGRATION_DB_ERROR'
682: ,p_message_type => 'D'
683: ,p_line_no => P_line_no
684: ,p_position=> 1
685: ,p_base_message=> NULL);

Line 696: * GMA TABLE called gma_migration_log that would list out all

692: * Synopsis : GMD_LM_MIGRATION.run;
693: *
694: * Description : Main Program - it calls procedure insert_gmd_tech_seq_comps
695: * and insert_gmd_tech_data_comps. It also creates the rows in
696: * GMA TABLE called gma_migration_log that would list out all
697: * existing entity instances that might have problems migrating
698: * over to the New process parameter tables.
699: *
700: * History :

Line 705: P_run_id := GMA_MIGRATION.gma_migration_start

701: * Shyam Sitaraman 02/28/03 Initial Implementation
702: * *************************************************************** */
703: PROCEDURE run IS
704: BEGIN
705: P_run_id := GMA_MIGRATION.gma_migration_start
706: (p_app_short_name => 'GMD'
707: ,p_mig_name => 'GMD_LM_MIGRATION');
708: GMD_LM_MIGRATION.generate_tech_parm_id;
709: GMD_LM_MIGRATION.populate_lm_sprd_dtl_sec_qty;

Line 713: GMA_MIGRATION.gma_migration_end (l_run_id => p_run_id);

709: GMD_LM_MIGRATION.populate_lm_sprd_dtl_sec_qty;
710: GMD_LM_MIGRATION.populate_parsed_expressions;
711: GMD_LM_MIGRATION.insert_gmd_tech_seq_comps;
712: GMD_LM_MIGRATION.insert_gmd_tech_data_comps;
713: GMA_MIGRATION.gma_migration_end (l_run_id => p_run_id);
714: END run;
715:
716:
717: END GMD_LM_MIGRATION;