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 57: FROM gme_batch_header_mig

53: item_not_defined EXCEPTION;
54:
55: CURSOR Cur_get_batches IS
56: SELECT *
57: FROM gme_batch_header_mig
58: WHERE NVL(migrated_batch_ind, ' ') <> 'M'
59: AND organization_id IS NOT NULL
60: ORDER BY batch_id;
61:

Line 176: UPDATE gme_batch_header

172: ELSE
173: l_prefix := l_fpo_prefix;
174: END IF;
175:
176: UPDATE gme_batch_header
177: SET batch_no = SUBSTR(batch_no,1,30)||'-M'
178: WHERE batch_id = get_batches.batch_id;
179:
180: UPDATE wip_entities

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

246: END IF;
247:
248: l_batch_tbl(1) := l_batch_header;
249: FORALL a IN 1..l_batch_tbl.count
250: INSERT INTO gme_batch_header VALUES l_batch_tbl(a);
251:
252: IF (g_debug <= gme_debug.g_log_statement) THEN
253: gme_debug.put_line('After batch header');
254: END IF;

Line 524: UPDATE gme_batch_header

520: IF (g_debug <= gme_debug.g_log_statement) THEN
521: gme_debug.put_line('After create move order');
522: END IF;
523:
524: UPDATE gme_batch_header
525: SET move_order_header_id = l_batch_header.move_order_header_id
526: WHERE batch_id = l_batch_header.batch_id;
527:
528: FOR a IN 1..l_mtl_dtl_tbl.count LOOP

Line 541: UPDATE gme_batch_header_mig

537:
538: create_batch_mapping(p_batch_header_mig => get_batches,
539: p_batch_header => l_batch_header);
540:
541: UPDATE gme_batch_header_mig
542: SET migrated_batch_ind = 'M'
543: WHERE batch_id = get_batches.batch_id;
544:
545: IF (g_debug <= gme_debug.g_log_statement) THEN

Line 559: p_table_name => 'GME_BATCH_HEADER',

555: gma_common_logging.gma_migration_central_log
556: (p_run_id => g_migration_run_id,
557: p_log_level => fnd_log.level_error,
558: p_message_token => 'INV_IC_INVALID_ITEM_ORG',
559: p_table_name => 'GME_BATCH_HEADER',
560: p_context => 'RECREATE_OPEN_BATCHES',
561: p_app_short_name => 'INV',
562: p_token1 => 'ORG',
563: p_param1 => gme_common_pvt.g_organization_code,

Line 574: p_table_name => 'GME_BATCH_HEADER',

570: gma_common_logging.gma_migration_central_log
571: (p_run_id => g_migration_run_id,
572: p_log_level => fnd_log.level_error,
573: p_message_token => 'GME_BATCH_MIG_FAILED',
574: p_table_name => 'GME_BATCH_HEADER',
575: p_context => 'RECREATE_OPEN_BATCHES',
576: p_app_short_name => 'GME',
577: p_token1 => 'BATCH_NO',
578: p_param1 => get_batches.plant_code||'-'||get_batches.batch_no,

Line 590: p_table_name => 'GME_BATCH_HEADER',

586: gma_common_logging.gma_migration_central_log
587: (p_run_id => g_migration_run_id,
588: p_log_level => fnd_log.level_error,
589: p_message_token => 'GME_BATCH_MIG_FAILED',
590: p_table_name => 'GME_BATCH_HEADER',
591: p_context => 'RECREATE_OPEN_BATCHES',
592: p_app_short_name => 'GME',
593: p_token1 => 'BATCH_NO',
594: p_param1 => get_batches.plant_code||'-'||get_batches.batch_no,

Line 668: p_table_name => 'GME_BATCH_HEADER',

664: gma_common_logging.gma_migration_central_log
665: (p_run_id => g_migration_run_id,
666: p_log_level => fnd_log.level_unexpected,
667: p_message_token => 'GMA_MIGRATION_DB_ERROR',
668: p_table_name => 'GME_BATCH_HEADER',
669: p_context => 'RECREATE_OPEN_BATCHES',
670: p_db_error => SQLERRM,
671: p_app_short_name => 'GMA');
672: END recreate_open_batches;

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

670: p_db_error => SQLERRM,
671: p_app_short_name => 'GMA');
672: END recreate_open_batches;
673:
674: PROCEDURE build_batch_hdr(p_batch_header_mig IN gme_batch_header_mig%ROWTYPE,
675: x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE) IS
676: BEGIN
677: x_batch_header.batch_id := p_batch_header_mig.batch_id;
678: x_batch_header.plant_code := p_batch_header_mig.plant_code;

Line 675: x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE) IS

671: p_app_short_name => 'GMA');
672: END recreate_open_batches;
673:
674: PROCEDURE build_batch_hdr(p_batch_header_mig IN gme_batch_header_mig%ROWTYPE,
675: x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE) IS
676: BEGIN
677: x_batch_header.batch_id := p_batch_header_mig.batch_id;
678: x_batch_header.plant_code := p_batch_header_mig.plant_code;
679: x_batch_header.batch_no := p_batch_header_mig.batch_no;

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

1485: gme_debug.put_line('End procedure '||l_api_name);
1486: END IF;
1487: END create_batch_step_transfers;
1488:
1489: PROCEDURE create_batch_mapping(p_batch_header_mig IN gme_batch_header_mig%ROWTYPE,
1490: p_batch_header IN gme_batch_header%ROWTYPE) IS
1491: BEGIN
1492: INSERT INTO gme_batch_mapping_mig(plant_code,
1493: old_batch_id,

Line 1490: p_batch_header IN gme_batch_header%ROWTYPE) IS

1486: END IF;
1487: END create_batch_step_transfers;
1488:
1489: PROCEDURE create_batch_mapping(p_batch_header_mig IN gme_batch_header_mig%ROWTYPE,
1490: p_batch_header IN gme_batch_header%ROWTYPE) IS
1491: BEGIN
1492: INSERT INTO gme_batch_mapping_mig(plant_code,
1493: old_batch_id,
1494: old_batch_no,

Line 1570: UPDATE gme_batch_header

1566: SET phantom_id = l_new_phantom_id,
1567: phantom_line_id = l_new_prod_line_id
1568: WHERE material_detail_id = get_phantoms.new_ing_line_id;
1569: /* Update phantom batch hdr */
1570: UPDATE gme_batch_header
1571: SET parentline_id = get_phantoms.new_ing_line_id
1572: WHERE batch_id = l_new_phantom_id;
1573: /* Update phantom product */
1574: UPDATE gme_material_details

Line 1584: p_table_name => 'GME_BATCH_HEADER',

1580: gma_common_logging.gma_migration_central_log
1581: (p_run_id => g_migration_run_id,
1582: p_log_level => fnd_log.level_error,
1583: p_message_token => 'GME_PHANT_BATCH_NOT_FOUND',
1584: p_table_name => 'GME_BATCH_HEADER',
1585: p_context => 'RECREATE_OPEN_BATCHES',
1586: p_app_short_name => 'GME',
1587: p_token1 => 'BATCH_NO',
1588: p_param1 => get_phantoms.plant_code||'-'||get_phantoms.new_batch_no);

Line 1595: p_table_name => 'GME_BATCH_HEADER',

1591: gma_common_logging.gma_migration_central_log
1592: (p_run_id => g_migration_run_id,
1593: p_log_level => fnd_log.level_error,
1594: p_message_token => 'GME_PHANTOM_PROD_NOT_FOUND',
1595: p_table_name => 'GME_BATCH_HEADER',
1596: p_context => 'RECREATE_OPEN_BATCHES',
1597: p_app_short_name => 'GME',
1598: p_token1 => 'BATCH_NO',
1599: p_param1 => get_phantoms.plant_code||'-'||get_phantoms.new_batch_no);

Line 1609: p_table_name => 'GME_BATCH_HEADER',

1605: gma_common_logging.gma_migration_central_log
1606: (p_run_id => g_migration_run_id,
1607: p_log_level => fnd_log.level_error,
1608: p_message_token => 'GME_PHANT_BATCH_UNEXPECTED',
1609: p_table_name => 'GME_BATCH_HEADER',
1610: p_context => 'RECREATE_OPEN_BATCHES',
1611: p_app_short_name => 'GME',
1612: p_token1 => 'BATCH_NO',
1613: p_param1 => get_phantoms.plant_code||'-'||get_phantoms.new_batch_no,

Line 1627: FROM gme_batch_header_mig o, gme_batch_mapping_mig m

1623:
1624: PROCEDURE release_batches IS
1625: CURSOR Cur_wip_batches IS
1626: SELECT m.*, o.actual_start_date
1627: FROM gme_batch_header_mig o, gme_batch_mapping_mig m
1628: WHERE o.batch_status = gme_common_pvt.g_batch_wip
1629: AND m.old_batch_id = o.batch_id
1630: AND o.parentline_id IS NULL
1631: AND m.new_batch_id NOT IN (SELECT batch_id

Line 1632: FROM gme_batch_header

1628: WHERE o.batch_status = gme_common_pvt.g_batch_wip
1629: AND m.old_batch_id = o.batch_id
1630: AND o.parentline_id IS NULL
1631: AND m.new_batch_id NOT IN (SELECT batch_id
1632: FROM gme_batch_header
1633: WHERE batch_id = m.new_batch_id
1634: AND batch_status = gme_common_pvt.g_batch_wip)
1635: ORDER BY m.organization_id, m.new_batch_no;
1636:

Line 1682: l_batch_header gme_batch_header%ROWTYPE;

1678: l_other_date_used NUMBER;
1679: l_other_date_used_step NUMBER;
1680:
1681: l_api_name VARCHAR2(30) := 'release_batches';
1682: l_batch_header gme_batch_header%ROWTYPE;
1683: l_batch_header_out gme_batch_header%ROWTYPE;
1684: l_step_rec gme_batch_steps%ROWTYPE;
1685: l_step_rec_out gme_batch_steps%ROWTYPE;
1686: l_exception_tbl gme_common_pvt.exceptions_tab;

Line 1683: l_batch_header_out gme_batch_header%ROWTYPE;

1679: l_other_date_used_step NUMBER;
1680:
1681: l_api_name VARCHAR2(30) := 'release_batches';
1682: l_batch_header gme_batch_header%ROWTYPE;
1683: l_batch_header_out gme_batch_header%ROWTYPE;
1684: l_step_rec gme_batch_steps%ROWTYPE;
1685: l_step_rec_out gme_batch_steps%ROWTYPE;
1686: l_exception_tbl gme_common_pvt.exceptions_tab;
1687: no_open_period_err EXCEPTION;

Line 1857: p_table_name => 'GME_BATCH_HEADER',

1853: gma_common_logging.gma_migration_central_log
1854: (p_run_id => g_migration_run_id,
1855: p_log_level => fnd_log.level_error,
1856: p_message_token => 'GME_NO_OPEN_PERIODS_STEP',
1857: p_table_name => 'GME_BATCH_HEADER',
1858: p_context => 'RECREATE_OPEN_BATCHES',
1859: p_app_short_name => 'GME',
1860: p_token1 => 'BATCH_NO',
1861: p_param1 => get_wip_batches.plant_code||'-'||get_wip_batches.new_batch_no,

Line 1869: p_table_name => 'GME_BATCH_HEADER',

1865: gma_common_logging.gma_migration_central_log
1866: (p_run_id => g_migration_run_id,
1867: p_log_level => fnd_log.level_error,
1868: p_message_token => 'GME_STEP_CMPLT_ERR',
1869: p_table_name => 'GME_BATCH_HEADER',
1870: p_context => 'RECREATE_OPEN_BATCHES',
1871: p_app_short_name => 'GME',
1872: p_token1 => 'BATCH_NO',
1873: p_param1 => get_wip_batches.plant_code||'-'||get_wip_batches.new_batch_no,

Line 1883: p_table_name => 'GME_BATCH_HEADER',

1879: gma_common_logging.gma_migration_central_log
1880: (p_run_id => g_migration_run_id,
1881: p_log_level => fnd_log.level_error,
1882: p_message_token => 'GME_STEP_RELEASE_ERR',
1883: p_table_name => 'GME_BATCH_HEADER',
1884: p_context => 'RECREATE_OPEN_BATCHES',
1885: p_app_short_name => 'GME',
1886: p_token1 => 'BATCH_NO',
1887: p_param1 => get_wip_batches.plant_code||'-'||get_wip_batches.new_batch_no,

Line 1900: p_table_name => 'GME_BATCH_HEADER',

1896: gma_common_logging.gma_migration_central_log
1897: (p_run_id => g_migration_run_id,
1898: p_log_level => fnd_log.level_error,
1899: p_message_token => 'GME_STEP_PROCESS_UNEXP',
1900: p_table_name => 'GME_BATCH_HEADER',
1901: p_context => 'RECREATE_OPEN_BATCHES',
1902: p_app_short_name => 'GME',
1903: p_token1 => 'BATCH_NO',
1904: p_param1 => get_wip_batches.plant_code||'-'||get_wip_batches.new_batch_no,

Line 1917: p_table_name => 'GME_BATCH_HEADER',

1913: gma_common_logging.gma_migration_central_log
1914: (p_run_id => g_migration_run_id,
1915: p_log_level => fnd_log.level_error,
1916: p_message_token => 'GME_NO_OPEN_PERIODS_BATCH',
1917: p_table_name => 'GME_BATCH_HEADER',
1918: p_context => 'RECREATE_OPEN_BATCHES',
1919: p_app_short_name => 'GME',
1920: p_token1 => 'BATCH_NO',
1921: p_param1 => get_wip_batches.plant_code||'-'||get_wip_batches.new_batch_no);

Line 1929: p_table_name => 'GME_BATCH_HEADER',

1925: gma_common_logging.gma_migration_central_log
1926: (p_run_id => g_migration_run_id,
1927: p_log_level => fnd_log.level_error,
1928: p_message_token => 'GME_BATCH_RELEASE_ERR',
1929: p_table_name => 'GME_BATCH_HEADER',
1930: p_context => 'RECREATE_OPEN_BATCHES',
1931: p_app_short_name => 'GME',
1932: p_token1 => 'BATCH_NO',
1933: p_param1 => get_wip_batches.plant_code||'-'||get_wip_batches.new_batch_no,

Line 1944: p_table_name => 'GME_BATCH_HEADER',

1940: gma_common_logging.gma_migration_central_log
1941: (p_run_id => g_migration_run_id,
1942: p_log_level => fnd_log.level_error,
1943: p_message_token => 'GME_BATCH_PROCESS_UNEXP',
1944: p_table_name => 'GME_BATCH_HEADER',
1945: p_context => 'RECREATE_OPEN_BATCHES',
1946: p_app_short_name => 'GME',
1947: p_token1 => 'BATCH_NO',
1948: p_param1 => get_wip_batches.plant_code||'-'||get_wip_batches.new_batch_no,

Line 2246: l_batch_hdr gme_batch_header%ROWTYPE;

2242: SELECT lot_no,sublot_no
2243: FROM ic_lots_mst
2244: WHERE lot_id = v_lot_id;
2245:
2246: l_batch_hdr gme_batch_header%ROWTYPE;
2247: l_mtl_rec Cur_mtl_dtl%ROWTYPE;
2248: l_mmti_rec mtl_transactions_interface%ROWTYPE;
2249: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
2250: l_mtl_dtl_rec gme_material_details%ROWTYPE;

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

2302: END IF;
2303:
2304: IF (l_curr_batch_id <> l_txns_tbl(i).new_batch_id) THEN
2305: l_batch_hdr.batch_id := l_txns_tbl(i).new_batch_id;
2306: IF NOT(gme_batch_header_dbl.fetch_row(p_batch_header => l_batch_hdr,
2307: x_batch_header => l_batch_hdr)) THEN
2308: RAISE batch_fetch_err;
2309: END IF;
2310: l_curr_batch_id := l_txns_tbl(i).new_batch_id;

Line 2417: p_table_name => 'GME_BATCH_HEADER',

2413: gma_common_logging.gma_migration_central_log
2414: (p_run_id => g_migration_run_id,
2415: p_log_level => fnd_log.level_error,
2416: p_message_token => 'GME_MIG_REASON_NOT_FOUND',
2417: p_table_name => 'GME_BATCH_HEADER',
2418: p_context => 'RECREATE_OPEN_BATCHES',
2419: p_app_short_name => 'GME',
2420: p_token1 => 'BATCH_NO',
2421: p_param1 => l_txns_tbl(i).plant_code||'-'||l_txns_tbl(i).new_batch_no,

Line 3104: p_table_name => 'GME_BATCH_HEADER',

3100: gma_common_logging.gma_migration_central_log
3101: (p_run_id => g_migration_run_id,
3102: p_log_level => fnd_log.level_error,
3103: p_message_token => 'GME_TXNS_MIG_FAILED',
3104: p_table_name => 'GME_BATCH_HEADER',
3105: p_context => 'RECREATE_OPEN_BATCHES',
3106: p_app_short_name => 'GME',
3107: p_token1 => 'BATCH_NO',
3108: p_param1 => l_txns_tbl(i).plant_code||'-'||l_txns_tbl(i).new_batch_no,

Line 3125: p_table_name => 'GME_BATCH_HEADER',

3121: gma_common_logging.gma_migration_central_log
3122: (p_run_id => g_migration_run_id,
3123: p_log_level => fnd_log.level_error,
3124: p_message_token => 'GME_GENERAL_TXN_FAIL',
3125: p_table_name => 'GME_BATCH_HEADER',
3126: p_context => 'CREATE_TXNS_RESERVATIONS_EXP_ERROR',
3127: p_app_short_name => 'GME',
3128: p_token1 => 'BATCH_NO',
3129: p_param1 => l_txns_tbl(i).plant_code||'-'||l_txns_tbl(i).new_batch_no,

Line 3148: p_table_name => 'GME_BATCH_HEADER',

3144: gma_common_logging.gma_migration_central_log
3145: (p_run_id => g_migration_run_id,
3146: p_log_level => fnd_log.level_error,
3147: p_message_token => l_msg_name,
3148: p_table_name => 'GME_BATCH_HEADER',
3149: p_context => 'RECREATE_OPEN_BATCHES',
3150: p_app_short_name => 'GME',
3151: p_token1 => 'BATCH_NO',
3152: p_param1 => l_txns_tbl(i).plant_code||'-'||l_txns_tbl(i).new_batch_no,

Line 3169: p_table_name => 'GME_BATCH_HEADER',

3165: gma_common_logging.gma_migration_central_log
3166: (p_run_id => g_migration_run_id,
3167: p_log_level => fnd_log.level_error,
3168: p_message_token => 'GME_MIG_UOM_CONV_FAIL',
3169: p_table_name => 'GME_BATCH_HEADER',
3170: p_context => 'RECREATE_OPEN_BATCHES',
3171: p_app_short_name => 'GME',
3172: p_token1 => 'BATCH_NO',
3173: p_param1 => l_txns_tbl(i).plant_code||'-'||l_txns_tbl(i).new_batch_no,

Line 3198: p_table_name => 'GME_BATCH_HEADER',

3194: gma_common_logging.gma_migration_central_log
3195: (p_run_id => g_migration_run_id,
3196: p_log_level => fnd_log.level_error,
3197: p_message_token => l_msg_name,
3198: p_table_name => 'GME_BATCH_HEADER',
3199: p_context => 'RECREATE_OPEN_BATCHES',
3200: p_app_short_name => 'GME',
3201: p_token1 => 'BATCH_NO',
3202: p_param1 => l_txns_tbl(i).plant_code||'-'||l_txns_tbl(i).new_batch_no,

Line 3227: p_table_name => 'GME_BATCH_HEADER',

3223: gma_common_logging.gma_migration_central_log
3224: (p_run_id => g_migration_run_id,
3225: p_log_level => fnd_log.level_error,
3226: p_message_token => 'GME_GENERAL_TXN_FAIL',
3227: p_table_name => 'GME_BATCH_HEADER',
3228: p_context => 'CREATE_TXNS_RESERVATIONS_OTHERS',
3229: p_app_short_name => 'GME',
3230: p_token1 => 'BATCH_NO',
3231: p_param1 => l_txns_tbl(i).plant_code||'-'||l_txns_tbl(i).new_batch_no,

Line 3342: p_table_name => 'GME_BATCH_HEADER',

3338: gma_common_logging.gma_migration_central_log
3339: (p_run_id => g_migration_run_id,
3340: p_log_level => fnd_log.level_error,
3341: p_message_token => 'GME_MIG_INV_TRANSFER',
3342: p_table_name => 'GME_BATCH_HEADER',
3343: p_context => 'RECREATE_OPEN_BATCHES',
3344: p_app_short_name => 'GME',
3345: p_token1 => 'BATCH_NO',
3346: p_param1 => p_txn_rec.plant_code||'-'||p_txn_rec.new_batch_no,

Line 3724: p_table_name => 'GME_BATCH_HEADER',

3720: gma_common_logging.gma_migration_central_log
3721: (p_run_id => g_migration_run_id,
3722: p_log_level => fnd_log.level_error,
3723: p_message_token => 'INV_IC_INVALID_ITEM_ORG',
3724: p_table_name => 'GME_BATCH_HEADER',
3725: p_context => 'RECREATE_OPEN_BATCHES',
3726: p_app_short_name => 'INV',
3727: p_token1 => 'ORG',
3728: p_param1 => l_org,

Line 3740: p_table_name => 'GME_BATCH_HEADER',

3736: gma_common_logging.gma_migration_central_log
3737: (p_run_id => g_migration_run_id,
3738: p_log_level => fnd_log.level_error,
3739: p_message_token => 'GME_GENERAL_TXN_FAIL',
3740: p_table_name => 'GME_BATCH_HEADER',
3741: p_context => 'CREATE_ISSUE_RECEIPT_NO_OPEN_PER',
3742: p_app_short_name => 'GME',
3743: p_token1 => 'BATCH_NO',
3744: p_param1 => p_txn_rec.plant_code||'-'||p_txn_rec.new_batch_no,

Line 3766: p_table_name => 'GME_BATCH_HEADER',

3762: gma_common_logging.gma_migration_central_log
3763: (p_run_id => g_migration_run_id,
3764: p_log_level => fnd_log.level_error,
3765: p_message_token => 'GME_GENERAL_TXN_FAIL',
3766: p_table_name => 'GME_BATCH_HEADER',
3767: p_context => 'CREATE_ISSUE_RECEIPT_EXP_ERROR',
3768: p_app_short_name => 'GME',
3769: p_token1 => 'BATCH_NO',
3770: p_param1 => p_txn_rec.plant_code||'-'||p_txn_rec.new_batch_no,

Line 3789: p_table_name => 'GME_BATCH_HEADER',

3785: gma_common_logging.gma_migration_central_log
3786: (p_run_id => g_migration_run_id,
3787: p_log_level => fnd_log.level_error,
3788: p_message_token => l_msg_name,
3789: p_table_name => 'GME_BATCH_HEADER',
3790: p_context => 'RECREATE_OPEN_BATCHES',
3791: p_app_short_name => 'GME',
3792: p_token1 => 'BATCH_NO',
3793: p_param1 => p_txn_rec.plant_code||'-'||p_txn_rec.new_batch_no,

Line 3814: p_table_name => 'GME_BATCH_HEADER',

3810: gma_common_logging.gma_migration_central_log
3811: (p_run_id => g_migration_run_id,
3812: p_log_level => fnd_log.level_error,
3813: p_message_token => 'GME_GENERAL_TXN_FAIL',
3814: p_table_name => 'GME_BATCH_HEADER',
3815: p_context => 'CREATE_ISSUE_RECEIPT_OTHERS',
3816: p_app_short_name => 'GME',
3817: p_token1 => 'BATCH_NO',
3818: p_param1 => p_txn_rec.plant_code||'-'||p_txn_rec.new_batch_no,

Line 3859: p_table_name => 'GME_BATCH_HEADER',

3855: gma_common_logging.gma_migration_central_log
3856: (p_run_id => g_migration_run_id,
3857: p_log_level => fnd_log.level_unexpected,
3858: p_message_token => 'GMA_MIGRATION_DB_ERROR',
3859: p_table_name => 'GME_BATCH_HEADER',
3860: p_context => 'RECREATE_OPEN_BATCHES',
3861: p_db_error => SQLERRM,
3862: p_app_short_name => 'GMA');
3863: END insert_interface_recs;

Line 3932: p_table_name => 'GME_BATCH_HEADER',

3928: gma_common_logging.gma_migration_central_log
3929: (p_run_id => g_migration_run_id,
3930: p_log_level => fnd_log.level_error,
3931: p_message_token => 'GME_STEP_CLOSE_ERR',
3932: p_table_name => 'GME_BATCH_HEADER',
3933: p_context => 'RECREATE_OPEN_BATCHES',
3934: p_app_short_name => 'GME',
3935: p_token1 => 'BATCH_NO',
3936: p_param1 => get_steps.plant_code||'-'||get_steps.new_batch_no,

Line 3949: p_table_name => 'GME_BATCH_HEADER',

3945: gma_common_logging.gma_migration_central_log
3946: (p_run_id => g_migration_run_id,
3947: p_log_level => fnd_log.level_error,
3948: p_message_token => 'GME_STEP_PROCESS_UNEXP',
3949: p_table_name => 'GME_BATCH_HEADER',
3950: p_context => 'RECREATE_OPEN_BATCHES',
3951: p_app_short_name => 'GME',
3952: p_token1 => 'BATCH_NO',
3953: p_param1 => get_steps.plant_code||'-'||get_steps.new_batch_no,

Line 3993: l_batch_hdr gme_batch_header%ROWTYPE;

3989: l_txn_data VARCHAR2(500);
3990: l_new_data VARCHAR2(500);
3991: l_msg_data VARCHAR2(2000);
3992: l_item_rec Cur_item_dtl%ROWTYPE;
3993: l_batch_hdr gme_batch_header%ROWTYPE;
3994: l_mtl_rec gme_material_details%ROWTYPE;
3995: l_plot_out_rec gme_pending_product_lots%ROWTYPE;
3996: l_plot_in_rec gme_pending_product_lots%ROWTYPE;
3997: batch_fetch_err EXCEPTION;

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

4005: l_lot_number := NULL;
4006: l_txn_data := NULL;
4007: IF (NVL(l_curr_batch_id,0) <> NVL(get_lots.new_batch_id, -1)) THEN
4008: l_batch_hdr.batch_id := get_lots.new_batch_id;
4009: IF NOT(gme_batch_header_dbl.fetch_row(p_batch_header => l_batch_hdr,
4010: x_batch_header => l_batch_hdr)) THEN
4011: RAISE batch_fetch_err;
4012: END IF;
4013: l_curr_batch_id := get_lots.new_batch_id;

Line 4073: p_table_name => 'GME_BATCH_HEADER',

4069: gma_common_logging.gma_migration_central_log
4070: (p_run_id => g_migration_run_id,
4071: p_log_level => fnd_log.level_error,
4072: p_message_token => 'GME_TXNS_MIG_FAILED',
4073: p_table_name => 'GME_BATCH_HEADER',
4074: p_context => 'RECREATE_OPEN_BATCHES',
4075: p_app_short_name => 'GME',
4076: p_token1 => 'BATCH_NO',
4077: p_param1 => get_lots.plant_code||'-'||get_lots.new_batch_no,

Line 4091: p_table_name => 'GME_BATCH_HEADER',

4087: gma_common_logging.gma_migration_central_log
4088: (p_run_id => g_migration_run_id,
4089: p_log_level => fnd_log.level_error,
4090: p_message_token => 'GME_CREATE_PPLOT_FAIL',
4091: p_table_name => 'GME_BATCH_HEADER',
4092: p_context => 'RECREATE_OPEN_BATCHES',
4093: p_app_short_name => 'GME',
4094: p_token1 => 'BATCH_NO',
4095: p_param1 => get_lots.plant_code||'-'||get_lots.new_batch_no,

Line 4114: p_table_name => 'GME_BATCH_HEADER',

4110: gma_common_logging.gma_migration_central_log
4111: (p_run_id => g_migration_run_id,
4112: p_log_level => fnd_log.level_error,
4113: p_message_token => 'GME_TXNS_MIG_FAILED',
4114: p_table_name => 'GME_BATCH_HEADER',
4115: p_context => 'RECREATE_OPEN_BATCHES',
4116: p_app_short_name => 'GME',
4117: p_token1 => 'BATCH_NO',
4118: p_param1 => get_lots.plant_code||'->'||get_lots.new_batch_no||'->'||l_mtl_rec.line_type||'->'||