eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_POST_MIGRATION dependencies on GME_BATCH_HEADER

Line 9: l_batch_header gme_batch_header%ROWTYPE;

5: PROCEDURE recreate_open_batches(err_buf OUT NOCOPY VARCHAR2,
6: ret_code OUT NOCOPY VARCHAR2) IS
7: l_api_name VARCHAR2(30) := 'RECREATE_OPEN_BATCHES';
8: l_item_rec mtl_system_items_vl%ROWTYPE;
9: l_batch_header gme_batch_header%ROWTYPE;
10: l_batch_tbl gme_common_pvt.batch_headers_tab;
11: l_mtl_dtl_mig_tbl gme_post_migration.mtl_dtl_mig_tab;
12: l_mtl_dtl_tbl gme_common_pvt.material_details_tab;
13: l_in_mtl_dtl_tbl gme_common_pvt.material_details_tab;

Line 54: FROM gme_batch_header_mig

50: item_not_defined EXCEPTION;
51:
52: CURSOR Cur_get_batches IS
53: SELECT *
54: FROM gme_batch_header_mig
55: WHERE NVL(migrated_batch_ind, ' ') <> 'M'
56: AND organization_id IS NOT NULL
57: ORDER BY batch_id;
58: CURSOR Cur_get_materials(v_batch_id NUMBER) IS

Line 129: UPDATE gme_batch_header

125: l_prefix := l_batch_prefix;
126: ELSE
127: l_prefix := l_fpo_prefix;
128: END IF;
129: UPDATE gme_batch_header
130: SET batch_no = SUBSTR(batch_no,1,30)||'-M'
131: WHERE batch_id = get_batches.batch_id;
132: UPDATE wip_entities
133: SET wip_entity_name = wip_entity_name||'-M'

Line 174: INSERT INTO gme_batch_header VALUES l_batch_tbl(a);

170: gme_debug.put_line('After wip entities');
171: END IF;
172: l_batch_tbl(1) := l_batch_header;
173: FORALL a IN 1..l_batch_tbl.count
174: INSERT INTO gme_batch_header VALUES l_batch_tbl(a);
175: IF (g_debug <= gme_debug.g_log_statement) THEN
176: gme_debug.put_line('After batch header');
177: END IF;
178: /* Process material details records */

Line 417: UPDATE gme_batch_header

413: END IF;
414: IF (g_debug <= gme_debug.g_log_statement) THEN
415: gme_debug.put_line('After create move order');
416: END IF;
417: UPDATE gme_batch_header
418: SET move_order_header_id = l_batch_header.move_order_header_id
419: WHERE batch_id = l_batch_header.batch_id;
420:
421: FOR a IN 1..l_mtl_dtl_tbl.count LOOP

Line 432: UPDATE gme_batch_header_mig

428: gme_debug.put_line('After update material');
429: END IF;
430: create_batch_mapping(p_batch_header_mig => get_batches,
431: p_batch_header => l_batch_header);
432: UPDATE gme_batch_header_mig
433: SET migrated_batch_ind = 'M'
434: WHERE batch_id = get_batches.batch_id;
435: IF (g_debug <= gme_debug.g_log_statement) THEN
436: gme_debug.put_line('Done batch basic processing');

Line 448: p_table_name => 'GME_BATCH_HEADER',

444: gma_common_logging.gma_migration_central_log
445: (p_run_id => g_migration_run_id,
446: p_log_level => fnd_log.level_error,
447: p_message_token => 'INV_IC_INVALID_ITEM_ORG',
448: p_table_name => 'GME_BATCH_HEADER',
449: p_context => 'RECREATE_OPEN_BATCHES',
450: p_app_short_name => 'INV',
451: p_token1 => 'ORG',
452: p_param1 => gme_common_pvt.g_organization_code,

Line 463: p_table_name => 'GME_BATCH_HEADER',

459: gma_common_logging.gma_migration_central_log
460: (p_run_id => g_migration_run_id,
461: p_log_level => fnd_log.level_error,
462: p_message_token => 'GME_BATCH_MIG_FAILED',
463: p_table_name => 'GME_BATCH_HEADER',
464: p_context => 'RECREATE_OPEN_BATCHES',
465: p_app_short_name => 'GME',
466: p_token1 => 'BATCH_NO',
467: p_param1 => get_batches.plant_code||'-'||get_batches.batch_no,

Line 479: p_table_name => 'GME_BATCH_HEADER',

475: gma_common_logging.gma_migration_central_log
476: (p_run_id => g_migration_run_id,
477: p_log_level => fnd_log.level_error,
478: p_message_token => 'GME_BATCH_MIG_FAILED',
479: p_table_name => 'GME_BATCH_HEADER',
480: p_context => 'RECREATE_OPEN_BATCHES',
481: p_app_short_name => 'GME',
482: p_token1 => 'BATCH_NO',
483: p_param1 => get_batches.plant_code||'-'||get_batches.batch_no,

Line 546: p_table_name => 'GME_BATCH_HEADER',

542: gma_common_logging.gma_migration_central_log
543: (p_run_id => g_migration_run_id,
544: p_log_level => fnd_log.level_unexpected,
545: p_message_token => 'GMA_MIGRATION_DB_ERROR',
546: p_table_name => 'GME_BATCH_HEADER',
547: p_context => 'RECREATE_OPEN_BATCHES',
548: p_db_error => SQLERRM,
549: p_app_short_name => 'GMA');
550: END recreate_open_batches;

Line 552: PROCEDURE build_batch_hdr(p_batch_header_mig IN gme_batch_header_mig%ROWTYPE,

548: p_db_error => SQLERRM,
549: p_app_short_name => 'GMA');
550: END recreate_open_batches;
551:
552: PROCEDURE build_batch_hdr(p_batch_header_mig IN gme_batch_header_mig%ROWTYPE,
553: x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE) IS
554: BEGIN
555: x_batch_header.batch_id := p_batch_header_mig.batch_id;
556: x_batch_header.plant_code := p_batch_header_mig.plant_code;

Line 553: x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE) IS

549: p_app_short_name => 'GMA');
550: END recreate_open_batches;
551:
552: PROCEDURE build_batch_hdr(p_batch_header_mig IN gme_batch_header_mig%ROWTYPE,
553: x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE) IS
554: BEGIN
555: x_batch_header.batch_id := p_batch_header_mig.batch_id;
556: x_batch_header.plant_code := p_batch_header_mig.plant_code;
557: x_batch_header.batch_no := p_batch_header_mig.batch_no;

Line 1358: PROCEDURE create_batch_mapping(p_batch_header_mig IN gme_batch_header_mig%ROWTYPE,

1354: gme_debug.put_line('End procedure '||l_api_name);
1355: END IF;
1356: END create_batch_step_transfers;
1357:
1358: PROCEDURE create_batch_mapping(p_batch_header_mig IN gme_batch_header_mig%ROWTYPE,
1359: p_batch_header IN gme_batch_header%ROWTYPE) IS
1360: BEGIN
1361: INSERT INTO gme_batch_mapping_mig(plant_code,
1362: old_batch_id,

Line 1359: p_batch_header IN gme_batch_header%ROWTYPE) IS

1355: END IF;
1356: END create_batch_step_transfers;
1357:
1358: PROCEDURE create_batch_mapping(p_batch_header_mig IN gme_batch_header_mig%ROWTYPE,
1359: p_batch_header IN gme_batch_header%ROWTYPE) IS
1360: BEGIN
1361: INSERT INTO gme_batch_mapping_mig(plant_code,
1362: old_batch_id,
1363: old_batch_no,

Line 1436: UPDATE gme_batch_header

1432: SET phantom_id = l_new_phantom_id,
1433: phantom_line_id = l_new_prod_line_id
1434: WHERE material_detail_id = get_phantoms.new_ing_line_id;
1435: /* Update phantom batch hdr */
1436: UPDATE gme_batch_header
1437: SET parentline_id = get_phantoms.new_ing_line_id
1438: WHERE batch_id = l_new_phantom_id;
1439: /* Update phantom product */
1440: UPDATE gme_material_details

Line 1450: p_table_name => 'GME_BATCH_HEADER',

1446: gma_common_logging.gma_migration_central_log
1447: (p_run_id => g_migration_run_id,
1448: p_log_level => fnd_log.level_error,
1449: p_message_token => 'GME_PHANT_BATCH_NOT_FOUND',
1450: p_table_name => 'GME_BATCH_HEADER',
1451: p_context => 'RECREATE_OPEN_BATCHES',
1452: p_app_short_name => 'GME',
1453: p_token1 => 'BATCH_NO',
1454: p_param1 => get_phantoms.plant_code||'-'||get_phantoms.new_batch_no);

Line 1461: p_table_name => 'GME_BATCH_HEADER',

1457: gma_common_logging.gma_migration_central_log
1458: (p_run_id => g_migration_run_id,
1459: p_log_level => fnd_log.level_error,
1460: p_message_token => 'GME_PHANTOM_PROD_NOT_FOUND',
1461: p_table_name => 'GME_BATCH_HEADER',
1462: p_context => 'RECREATE_OPEN_BATCHES',
1463: p_app_short_name => 'GME',
1464: p_token1 => 'BATCH_NO',
1465: p_param1 => get_phantoms.plant_code||'-'||get_phantoms.new_batch_no);

Line 1475: p_table_name => 'GME_BATCH_HEADER',

1471: gma_common_logging.gma_migration_central_log
1472: (p_run_id => g_migration_run_id,
1473: p_log_level => fnd_log.level_error,
1474: p_message_token => 'GME_PHANT_BATCH_UNEXPECTED',
1475: p_table_name => 'GME_BATCH_HEADER',
1476: p_context => 'RECREATE_OPEN_BATCHES',
1477: p_app_short_name => 'GME',
1478: p_token1 => 'BATCH_NO',
1479: p_param1 => get_phantoms.plant_code||'-'||get_phantoms.new_batch_no,

Line 1493: FROM gme_batch_header_mig o, gme_batch_mapping_mig m

1489:
1490: PROCEDURE release_batches IS
1491: CURSOR Cur_wip_batches IS
1492: SELECT m.*, o.actual_start_date
1493: FROM gme_batch_header_mig o, gme_batch_mapping_mig m
1494: WHERE o.batch_status = gme_common_pvt.g_batch_wip
1495: AND m.old_batch_id = o.batch_id
1496: AND o.parentline_id IS NULL
1497: AND m.new_batch_id NOT IN (SELECT batch_id

Line 1498: FROM gme_batch_header

1494: WHERE o.batch_status = gme_common_pvt.g_batch_wip
1495: AND m.old_batch_id = o.batch_id
1496: AND o.parentline_id IS NULL
1497: AND m.new_batch_id NOT IN (SELECT batch_id
1498: FROM gme_batch_header
1499: WHERE batch_id = m.new_batch_id
1500: AND batch_status = gme_common_pvt.g_batch_wip)
1501: ORDER BY m.organization_id, m.new_batch_no;
1502: CURSOR Cur_get_steps(v_old_batch_id NUMBER, v_new_batch_id NUMBER) IS

Line 1527: l_batch_header gme_batch_header%ROWTYPE;

1523: l_current_org_id NUMBER;
1524: l_msg_data VARCHAR2(2000);
1525: l_return_status VARCHAR2(1);
1526: l_api_name VARCHAR2(30) := 'release_batches';
1527: l_batch_header gme_batch_header%ROWTYPE;
1528: l_batch_header_out gme_batch_header%ROWTYPE;
1529: l_step_rec gme_batch_steps%ROWTYPE;
1530: l_step_rec_out gme_batch_steps%ROWTYPE;
1531: l_exception_tbl gme_common_pvt.exceptions_tab;

Line 1528: l_batch_header_out gme_batch_header%ROWTYPE;

1524: l_msg_data VARCHAR2(2000);
1525: l_return_status VARCHAR2(1);
1526: l_api_name VARCHAR2(30) := 'release_batches';
1527: l_batch_header gme_batch_header%ROWTYPE;
1528: l_batch_header_out gme_batch_header%ROWTYPE;
1529: l_step_rec gme_batch_steps%ROWTYPE;
1530: l_step_rec_out gme_batch_steps%ROWTYPE;
1531: l_exception_tbl gme_common_pvt.exceptions_tab;
1532: no_open_period_err EXCEPTION;

Line 1641: p_table_name => 'GME_BATCH_HEADER',

1637: gma_common_logging.gma_migration_central_log
1638: (p_run_id => g_migration_run_id,
1639: p_log_level => fnd_log.level_error,
1640: p_message_token => 'GME_NO_OPEN_PERIODS_STEP',
1641: p_table_name => 'GME_BATCH_HEADER',
1642: p_context => 'RECREATE_OPEN_BATCHES',
1643: p_app_short_name => 'GME',
1644: p_token1 => 'BATCH_NO',
1645: p_param1 => get_wip_batches.plant_code||'-'||get_wip_batches.new_batch_no,

Line 1653: p_table_name => 'GME_BATCH_HEADER',

1649: gma_common_logging.gma_migration_central_log
1650: (p_run_id => g_migration_run_id,
1651: p_log_level => fnd_log.level_error,
1652: p_message_token => 'GME_STEP_CMPLT_ERR',
1653: p_table_name => 'GME_BATCH_HEADER',
1654: p_context => 'RECREATE_OPEN_BATCHES',
1655: p_app_short_name => 'GME',
1656: p_token1 => 'BATCH_NO',
1657: p_param1 => get_wip_batches.plant_code||'-'||get_wip_batches.new_batch_no,

Line 1667: p_table_name => 'GME_BATCH_HEADER',

1663: gma_common_logging.gma_migration_central_log
1664: (p_run_id => g_migration_run_id,
1665: p_log_level => fnd_log.level_error,
1666: p_message_token => 'GME_STEP_RELEASE_ERR',
1667: p_table_name => 'GME_BATCH_HEADER',
1668: p_context => 'RECREATE_OPEN_BATCHES',
1669: p_app_short_name => 'GME',
1670: p_token1 => 'BATCH_NO',
1671: p_param1 => get_wip_batches.plant_code||'-'||get_wip_batches.new_batch_no,

Line 1684: p_table_name => 'GME_BATCH_HEADER',

1680: gma_common_logging.gma_migration_central_log
1681: (p_run_id => g_migration_run_id,
1682: p_log_level => fnd_log.level_error,
1683: p_message_token => 'GME_STEP_PROCESS_UNEXP',
1684: p_table_name => 'GME_BATCH_HEADER',
1685: p_context => 'RECREATE_OPEN_BATCHES',
1686: p_app_short_name => 'GME',
1687: p_token1 => 'BATCH_NO',
1688: p_param1 => get_wip_batches.plant_code||'-'||get_wip_batches.new_batch_no,

Line 1701: p_table_name => 'GME_BATCH_HEADER',

1697: gma_common_logging.gma_migration_central_log
1698: (p_run_id => g_migration_run_id,
1699: p_log_level => fnd_log.level_error,
1700: p_message_token => 'GME_NO_OPEN_PERIODS_BATCH',
1701: p_table_name => 'GME_BATCH_HEADER',
1702: p_context => 'RECREATE_OPEN_BATCHES',
1703: p_app_short_name => 'GME',
1704: p_token1 => 'BATCH_NO',
1705: p_param1 => get_wip_batches.plant_code||'-'||get_wip_batches.new_batch_no);

Line 1713: p_table_name => 'GME_BATCH_HEADER',

1709: gma_common_logging.gma_migration_central_log
1710: (p_run_id => g_migration_run_id,
1711: p_log_level => fnd_log.level_error,
1712: p_message_token => 'GME_BATCH_RELEASE_ERR',
1713: p_table_name => 'GME_BATCH_HEADER',
1714: p_context => 'RECREATE_OPEN_BATCHES',
1715: p_app_short_name => 'GME',
1716: p_token1 => 'BATCH_NO',
1717: p_param1 => get_wip_batches.plant_code||'-'||get_wip_batches.new_batch_no,

Line 1728: p_table_name => 'GME_BATCH_HEADER',

1724: gma_common_logging.gma_migration_central_log
1725: (p_run_id => g_migration_run_id,
1726: p_log_level => fnd_log.level_error,
1727: p_message_token => 'GME_BATCH_PROCESS_UNEXP',
1728: p_table_name => 'GME_BATCH_HEADER',
1729: p_context => 'RECREATE_OPEN_BATCHES',
1730: p_app_short_name => 'GME',
1731: p_token1 => 'BATCH_NO',
1732: p_param1 => get_wip_batches.plant_code||'-'||get_wip_batches.new_batch_no,

Line 2028: l_batch_hdr gme_batch_header%ROWTYPE;

2024: CURSOR Cur_lot_mst(v_lot_id NUMBER) IS
2025: SELECT lot_no,sublot_no
2026: FROM ic_lots_mst
2027: WHERE lot_id = v_lot_id;
2028: l_batch_hdr gme_batch_header%ROWTYPE;
2029: l_mtl_rec Cur_mtl_dtl%ROWTYPE;
2030: l_mmti_rec mtl_transactions_interface%ROWTYPE;
2031: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
2032: l_mtl_dtl_rec gme_material_details%ROWTYPE;

Line 2081: IF NOT(gme_batch_header_dbl.fetch_row(p_batch_header => l_batch_hdr,

2077: END IF;
2078: END IF;
2079: IF (l_curr_batch_id <> l_txns_tbl(i).new_batch_id) THEN
2080: l_batch_hdr.batch_id := l_txns_tbl(i).new_batch_id;
2081: IF NOT(gme_batch_header_dbl.fetch_row(p_batch_header => l_batch_hdr,
2082: x_batch_header => l_batch_hdr)) THEN
2083: RAISE batch_fetch_err;
2084: END IF;
2085: l_curr_batch_id := l_txns_tbl(i).new_batch_id;

Line 2167: p_table_name => 'GME_BATCH_HEADER',

2163: gma_common_logging.gma_migration_central_log
2164: (p_run_id => g_migration_run_id,
2165: p_log_level => fnd_log.level_error,
2166: p_message_token => 'GME_MIG_REASON_NOT_FOUND',
2167: p_table_name => 'GME_BATCH_HEADER',
2168: p_context => 'RECREATE_OPEN_BATCHES',
2169: p_app_short_name => 'GME',
2170: p_token1 => 'BATCH_NO',
2171: p_param1 => l_txns_tbl(i).plant_code||'-'||l_txns_tbl(i).new_batch_no,

Line 2717: p_table_name => 'GME_BATCH_HEADER',

2713: gma_common_logging.gma_migration_central_log
2714: (p_run_id => g_migration_run_id,
2715: p_log_level => fnd_log.level_error,
2716: p_message_token => 'GME_TXNS_MIG_FAILED',
2717: p_table_name => 'GME_BATCH_HEADER',
2718: p_context => 'RECREATE_OPEN_BATCHES',
2719: p_app_short_name => 'GME',
2720: p_token1 => 'BATCH_NO',
2721: p_param1 => l_txns_tbl(i).plant_code||'-'||l_txns_tbl(i).new_batch_no,

Line 2734: p_table_name => 'GME_BATCH_HEADER',

2730: gma_common_logging.gma_migration_central_log
2731: (p_run_id => g_migration_run_id,
2732: p_log_level => fnd_log.level_error,
2733: p_message_token => 'GME_GENERAL_TXN_FAIL',
2734: p_table_name => 'GME_BATCH_HEADER',
2735: p_context => 'RECREATE_OPEN_BATCHES',
2736: p_app_short_name => 'GME',
2737: p_token1 => 'BATCH_NO',
2738: p_param1 => l_txns_tbl(i).plant_code||'-'||l_txns_tbl(i).new_batch_no,

Line 2751: p_table_name => 'GME_BATCH_HEADER',

2747: gma_common_logging.gma_migration_central_log
2748: (p_run_id => g_migration_run_id,
2749: p_log_level => fnd_log.level_error,
2750: p_message_token => l_msg_name,
2751: p_table_name => 'GME_BATCH_HEADER',
2752: p_context => 'RECREATE_OPEN_BATCHES',
2753: p_app_short_name => 'GME',
2754: p_token1 => 'BATCH_NO',
2755: p_param1 => l_txns_tbl(i).plant_code||'-'||l_txns_tbl(i).new_batch_no,

Line 2768: p_table_name => 'GME_BATCH_HEADER',

2764: gma_common_logging.gma_migration_central_log
2765: (p_run_id => g_migration_run_id,
2766: p_log_level => fnd_log.level_error,
2767: p_message_token => 'GME_MIG_UOM_CONV_FAIL',
2768: p_table_name => 'GME_BATCH_HEADER',
2769: p_context => 'RECREATE_OPEN_BATCHES',
2770: p_app_short_name => 'GME',
2771: p_token1 => 'BATCH_NO',
2772: p_param1 => l_txns_tbl(i).plant_code||'-'||l_txns_tbl(i).new_batch_no,

Line 2792: p_table_name => 'GME_BATCH_HEADER',

2788: gma_common_logging.gma_migration_central_log
2789: (p_run_id => g_migration_run_id,
2790: p_log_level => fnd_log.level_error,
2791: p_message_token => l_msg_name,
2792: p_table_name => 'GME_BATCH_HEADER',
2793: p_context => 'RECREATE_OPEN_BATCHES',
2794: p_app_short_name => 'GME',
2795: p_token1 => 'BATCH_NO',
2796: p_param1 => l_txns_tbl(i).plant_code||'-'||l_txns_tbl(i).new_batch_no,

Line 2816: p_table_name => 'GME_BATCH_HEADER',

2812: gma_common_logging.gma_migration_central_log
2813: (p_run_id => g_migration_run_id,
2814: p_log_level => fnd_log.level_error,
2815: p_message_token => 'GME_GENERAL_TXN_FAIL',
2816: p_table_name => 'GME_BATCH_HEADER',
2817: p_context => 'RECREATE_OPEN_BATCHES',
2818: p_app_short_name => 'GME',
2819: p_token1 => 'BATCH_NO',
2820: p_param1 => l_txns_tbl(i).plant_code||'-'||l_txns_tbl(i).new_batch_no,

Line 2908: p_table_name => 'GME_BATCH_HEADER',

2904: gma_common_logging.gma_migration_central_log
2905: (p_run_id => g_migration_run_id,
2906: p_log_level => fnd_log.level_error,
2907: p_message_token => 'GME_MIG_INV_TRANSFER',
2908: p_table_name => 'GME_BATCH_HEADER',
2909: p_context => 'RECREATE_OPEN_BATCHES',
2910: p_app_short_name => 'GME',
2911: p_token1 => 'BATCH_NO',
2912: p_param1 => p_txn_rec.plant_code||'-'||p_txn_rec.new_batch_no,

Line 3194: p_table_name => 'GME_BATCH_HEADER',

3190: gma_common_logging.gma_migration_central_log
3191: (p_run_id => g_migration_run_id,
3192: p_log_level => fnd_log.level_error,
3193: p_message_token => 'INV_IC_INVALID_ITEM_ORG',
3194: p_table_name => 'GME_BATCH_HEADER',
3195: p_context => 'RECREATE_OPEN_BATCHES',
3196: p_app_short_name => 'INV',
3197: p_token1 => 'ORG',
3198: p_param1 => l_org,

Line 3210: p_table_name => 'GME_BATCH_HEADER',

3206: gma_common_logging.gma_migration_central_log
3207: (p_run_id => g_migration_run_id,
3208: p_log_level => fnd_log.level_error,
3209: p_message_token => 'GME_GENERAL_TXN_FAIL',
3210: p_table_name => 'GME_BATCH_HEADER',
3211: p_context => 'RECREATE_OPEN_BATCHES',
3212: p_app_short_name => 'GME',
3213: p_token1 => 'BATCH_NO',
3214: p_param1 => p_txn_rec.plant_code||'-'||p_txn_rec.new_batch_no,

Line 3230: p_table_name => 'GME_BATCH_HEADER',

3226: gma_common_logging.gma_migration_central_log
3227: (p_run_id => g_migration_run_id,
3228: p_log_level => fnd_log.level_error,
3229: p_message_token => 'GME_GENERAL_TXN_FAIL',
3230: p_table_name => 'GME_BATCH_HEADER',
3231: p_context => 'RECREATE_OPEN_BATCHES',
3232: p_app_short_name => 'GME',
3233: p_token1 => 'BATCH_NO',
3234: p_param1 => p_txn_rec.plant_code||'-'||p_txn_rec.new_batch_no,

Line 3246: p_table_name => 'GME_BATCH_HEADER',

3242: gma_common_logging.gma_migration_central_log
3243: (p_run_id => g_migration_run_id,
3244: p_log_level => fnd_log.level_error,
3245: p_message_token => l_msg_name,
3246: p_table_name => 'GME_BATCH_HEADER',
3247: p_context => 'RECREATE_OPEN_BATCHES',
3248: p_app_short_name => 'GME',
3249: p_token1 => 'BATCH_NO',
3250: p_param1 => p_txn_rec.plant_code||'-'||p_txn_rec.new_batch_no,

Line 3266: p_table_name => 'GME_BATCH_HEADER',

3262: gma_common_logging.gma_migration_central_log
3263: (p_run_id => g_migration_run_id,
3264: p_log_level => fnd_log.level_error,
3265: p_message_token => 'GME_GENERAL_TXN_FAIL',
3266: p_table_name => 'GME_BATCH_HEADER',
3267: p_context => 'RECREATE_OPEN_BATCHES',
3268: p_app_short_name => 'GME',
3269: p_token1 => 'BATCH_NO',
3270: p_param1 => p_txn_rec.plant_code||'-'||p_txn_rec.new_batch_no,

Line 3309: p_table_name => 'GME_BATCH_HEADER',

3305: gma_common_logging.gma_migration_central_log
3306: (p_run_id => g_migration_run_id,
3307: p_log_level => fnd_log.level_unexpected,
3308: p_message_token => 'GMA_MIGRATION_DB_ERROR',
3309: p_table_name => 'GME_BATCH_HEADER',
3310: p_context => 'RECREATE_OPEN_BATCHES',
3311: p_db_error => SQLERRM,
3312: p_app_short_name => 'GMA');
3313: END insert_interface_recs;

Line 3382: p_table_name => 'GME_BATCH_HEADER',

3378: gma_common_logging.gma_migration_central_log
3379: (p_run_id => g_migration_run_id,
3380: p_log_level => fnd_log.level_error,
3381: p_message_token => 'GME_STEP_CLOSE_ERR',
3382: p_table_name => 'GME_BATCH_HEADER',
3383: p_context => 'RECREATE_OPEN_BATCHES',
3384: p_app_short_name => 'GME',
3385: p_token1 => 'BATCH_NO',
3386: p_param1 => get_steps.plant_code||'-'||get_steps.new_batch_no,

Line 3399: p_table_name => 'GME_BATCH_HEADER',

3395: gma_common_logging.gma_migration_central_log
3396: (p_run_id => g_migration_run_id,
3397: p_log_level => fnd_log.level_error,
3398: p_message_token => 'GME_STEP_PROCESS_UNEXP',
3399: p_table_name => 'GME_BATCH_HEADER',
3400: p_context => 'RECREATE_OPEN_BATCHES',
3401: p_app_short_name => 'GME',
3402: p_token1 => 'BATCH_NO',
3403: p_param1 => get_steps.plant_code||'-'||get_steps.new_batch_no,

Line 3443: l_batch_hdr gme_batch_header%ROWTYPE;

3439: l_txn_data VARCHAR2(500);
3440: l_new_data VARCHAR2(500);
3441: l_msg_data VARCHAR2(2000);
3442: l_item_rec Cur_item_dtl%ROWTYPE;
3443: l_batch_hdr gme_batch_header%ROWTYPE;
3444: l_mtl_rec gme_material_details%ROWTYPE;
3445: l_plot_out_rec gme_pending_product_lots%ROWTYPE;
3446: l_plot_in_rec gme_pending_product_lots%ROWTYPE;
3447: batch_fetch_err EXCEPTION;

Line 3459: IF NOT(gme_batch_header_dbl.fetch_row(p_batch_header => l_batch_hdr,

3455: l_lot_number := NULL;
3456: l_txn_data := NULL;
3457: IF (NVL(l_curr_batch_id,0) <> NVL(get_lots.new_batch_id, -1)) THEN
3458: l_batch_hdr.batch_id := get_lots.new_batch_id;
3459: IF NOT(gme_batch_header_dbl.fetch_row(p_batch_header => l_batch_hdr,
3460: x_batch_header => l_batch_hdr)) THEN
3461: RAISE batch_fetch_err;
3462: END IF;
3463: l_curr_batch_id := get_lots.new_batch_id;

Line 3523: p_table_name => 'GME_BATCH_HEADER',

3519: gma_common_logging.gma_migration_central_log
3520: (p_run_id => g_migration_run_id,
3521: p_log_level => fnd_log.level_error,
3522: p_message_token => 'GME_TXNS_MIG_FAILED',
3523: p_table_name => 'GME_BATCH_HEADER',
3524: p_context => 'RECREATE_OPEN_BATCHES',
3525: p_app_short_name => 'GME',
3526: p_token1 => 'BATCH_NO',
3527: p_param1 => get_lots.plant_code||'-'||get_lots.new_batch_no,

Line 3541: p_table_name => 'GME_BATCH_HEADER',

3537: gma_common_logging.gma_migration_central_log
3538: (p_run_id => g_migration_run_id,
3539: p_log_level => fnd_log.level_error,
3540: p_message_token => 'GME_CREATE_PPLOT_FAIL',
3541: p_table_name => 'GME_BATCH_HEADER',
3542: p_context => 'RECREATE_OPEN_BATCHES',
3543: p_app_short_name => 'GME',
3544: p_token1 => 'BATCH_NO',
3545: p_param1 => get_lots.plant_code||'-'||get_lots.new_batch_no,

Line 3564: p_table_name => 'GME_BATCH_HEADER',

3560: gma_common_logging.gma_migration_central_log
3561: (p_run_id => g_migration_run_id,
3562: p_log_level => fnd_log.level_error,
3563: p_message_token => 'GME_TXNS_MIG_FAILED',
3564: p_table_name => 'GME_BATCH_HEADER',
3565: p_context => 'RECREATE_OPEN_BATCHES',
3566: p_app_short_name => 'GME',
3567: p_token1 => 'BATCH_NO',
3568: p_param1 => get_lots.plant_code||'->'||get_lots.new_batch_no||'->'||l_mtl_rec.line_type||'->'||