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 FND_API

Line 489: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

485: ,p_batchstep_rec => NULL
486: ,p_mtl_dtl_rec => l_mtl_dtl_tbl(i)
487: ,x_mtl_req_date => l_mtl_dtl_tbl(i).material_requirement_date
488: ,x_return_status => l_return_status);
489: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
490: RAISE calc_mtl_req_date_err;
491: END IF;
492: END LOOP;
493:

Line 504: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

500: (p_organization_id => l_batch_header.organization_id
501: ,p_move_order_type => gme_common_pvt.g_invis_move_order_type
502: ,x_move_order_header_id => l_batch_header.move_order_header_id
503: ,x_return_status => l_return_status);
504: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
505: RAISE create_mo_hdr_err;
506: ELSE
507: l_in_mtl_dtl_tbl := l_mtl_dtl_tbl;
508: gme_move_orders_pvt.create_move_order_lines

Line 515: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

511: ,p_material_details_tbl => l_in_mtl_dtl_tbl
512: ,x_material_details_tbl => l_mtl_dtl_tbl
513: ,x_trolin_tbl => l_trolin_tbl
514: ,x_return_status => l_return_status);
515: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
516: RAISE create_mo_line_err;
517: END IF;
518: END IF;
519: END IF;

Line 652: p_commit => FND_API.G_TRUE,

648: gme_debug.put_line('Call QM');
649: END IF;
650:
651: gmd_qc_migb12.gmd_qc_migrate_batch_id(p_migration_run_id => g_migration_run_id,
652: p_commit => FND_API.G_TRUE,
653: x_exception_count => l_msg_count);
654: IF (g_debug <= gme_debug.g_log_procedure) THEN
655: gme_debug.put_line('End procedure '||l_api_name);
656: END IF;

Line 1715: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

1711: check_date(p_organization_id => l_batch_header.organization_id,
1712: p_date => l_batch_header.actual_start_date,
1713: x_date => l_date,
1714: x_return_status => l_return_status);
1715: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1716: RAISE no_open_period_err;
1717: ELSE
1718: l_batch_header.actual_start_date := l_date;
1719: END IF;

Line 1736: p_init_msg_list => fnd_api.g_false,

1732: l_min_start_date := l_date;
1733:
1734: gme_api_pub.release_batch(p_api_version => 2.0,
1735: p_validation_level => gme_common_pvt.g_max_errors,
1736: p_init_msg_list => fnd_api.g_false,
1737: p_commit => fnd_api.g_true,
1738: x_message_count => l_msg_cnt,
1739: x_message_list => l_msg_data,
1740: x_return_status => l_return_status,

Line 1737: p_commit => fnd_api.g_true,

1733:
1734: gme_api_pub.release_batch(p_api_version => 2.0,
1735: p_validation_level => gme_common_pvt.g_max_errors,
1736: p_init_msg_list => fnd_api.g_false,
1737: p_commit => fnd_api.g_true,
1738: x_message_count => l_msg_cnt,
1739: x_message_list => l_msg_data,
1740: x_return_status => l_return_status,
1741: p_batch_header_rec => l_batch_header,

Line 1743: p_ignore_exception => fnd_api.g_false,

1739: x_message_list => l_msg_data,
1740: x_return_status => l_return_status,
1741: p_batch_header_rec => l_batch_header,
1742: p_org_code => NULL,
1743: p_ignore_exception => fnd_api.g_false,
1744: p_validate_flexfields => fnd_api.g_false,
1745: x_batch_header_rec => l_batch_header_out,
1746: x_exception_material_tbl => l_exception_tbl);
1747: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

Line 1744: p_validate_flexfields => fnd_api.g_false,

1740: x_return_status => l_return_status,
1741: p_batch_header_rec => l_batch_header,
1742: p_org_code => NULL,
1743: p_ignore_exception => fnd_api.g_false,
1744: p_validate_flexfields => fnd_api.g_false,
1745: x_batch_header_rec => l_batch_header_out,
1746: x_exception_material_tbl => l_exception_tbl);
1747: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1748: RAISE release_batch_err;

Line 1747: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

1743: p_ignore_exception => fnd_api.g_false,
1744: p_validate_flexfields => fnd_api.g_false,
1745: x_batch_header_rec => l_batch_header_out,
1746: x_exception_material_tbl => l_exception_tbl);
1747: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1748: RAISE release_batch_err;
1749: END IF;
1750:
1751: -- Bug 12609227 - Get the mismatching wip plan qty.

Line 1781: p_init_msg_list => fnd_api.g_false,

1777:
1778: -- Bug 12557461 - Rearrange code to call release batch regardless of step status
1779: gme_api_pub.release_step(p_api_version => 2.0,
1780: p_validation_level => gme_common_pvt.g_max_errors,
1781: p_init_msg_list => fnd_api.g_false,
1782: p_commit => fnd_api.g_true,
1783: x_message_count => l_msg_cnt,
1784: x_message_list => l_msg_data,
1785: x_return_status => l_return_status,

Line 1782: p_commit => fnd_api.g_true,

1778: -- Bug 12557461 - Rearrange code to call release batch regardless of step status
1779: gme_api_pub.release_step(p_api_version => 2.0,
1780: p_validation_level => gme_common_pvt.g_max_errors,
1781: p_init_msg_list => fnd_api.g_false,
1782: p_commit => fnd_api.g_true,
1783: x_message_count => l_msg_cnt,
1784: x_message_list => l_msg_data,
1785: x_return_status => l_return_status,
1786: p_batch_step_rec => l_step_rec,

Line 1789: p_ignore_exception => fnd_api.g_false,

1785: x_return_status => l_return_status,
1786: p_batch_step_rec => l_step_rec,
1787: p_batch_no => NULL,
1788: p_org_code => NULL,
1789: p_ignore_exception => fnd_api.g_false,
1790: p_validate_flexfields => fnd_api.g_false,
1791: x_batch_step_rec => l_step_rec_out,
1792: x_exception_material_tbl => l_exception_tbl);
1793: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

Line 1790: p_validate_flexfields => fnd_api.g_false,

1786: p_batch_step_rec => l_step_rec,
1787: p_batch_no => NULL,
1788: p_org_code => NULL,
1789: p_ignore_exception => fnd_api.g_false,
1790: p_validate_flexfields => fnd_api.g_false,
1791: x_batch_step_rec => l_step_rec_out,
1792: x_exception_material_tbl => l_exception_tbl);
1793: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1794: RAISE step_release_err;

Line 1793: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

1789: p_ignore_exception => fnd_api.g_false,
1790: p_validate_flexfields => fnd_api.g_false,
1791: x_batch_step_rec => l_step_rec_out,
1792: x_exception_material_tbl => l_exception_tbl);
1793: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1794: RAISE step_release_err;
1795: END IF;
1796:
1797: l_step_rec := l_step_rec_out;

Line 1832: p_init_msg_list => fnd_api.g_false,

1828: END IF;
1829:
1830: gme_api_pub.complete_step(p_api_version => 2.0,
1831: p_validation_level => gme_common_pvt.g_max_errors,
1832: p_init_msg_list => fnd_api.g_false,
1833: p_commit => fnd_api.g_true,
1834: x_message_count => l_msg_cnt,
1835: x_message_list => l_msg_data,
1836: x_return_status => l_return_status,

Line 1833: p_commit => fnd_api.g_true,

1829:
1830: gme_api_pub.complete_step(p_api_version => 2.0,
1831: p_validation_level => gme_common_pvt.g_max_errors,
1832: p_init_msg_list => fnd_api.g_false,
1833: p_commit => fnd_api.g_true,
1834: x_message_count => l_msg_cnt,
1835: x_message_list => l_msg_data,
1836: x_return_status => l_return_status,
1837: p_batch_step_rec => l_step_rec,

Line 1840: p_ignore_exception => fnd_api.g_false,

1836: x_return_status => l_return_status,
1837: p_batch_step_rec => l_step_rec,
1838: p_batch_no => NULL,
1839: p_org_code => NULL,
1840: p_ignore_exception => fnd_api.g_false,
1841: p_override_quality => fnd_api.g_false,
1842: p_validate_flexfields => fnd_api.g_false,
1843: x_batch_step_rec => l_step_rec_out,
1844: x_exception_material_tbl => l_exception_tbl);

Line 1841: p_override_quality => fnd_api.g_false,

1837: p_batch_step_rec => l_step_rec,
1838: p_batch_no => NULL,
1839: p_org_code => NULL,
1840: p_ignore_exception => fnd_api.g_false,
1841: p_override_quality => fnd_api.g_false,
1842: p_validate_flexfields => fnd_api.g_false,
1843: x_batch_step_rec => l_step_rec_out,
1844: x_exception_material_tbl => l_exception_tbl);
1845: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

Line 1842: p_validate_flexfields => fnd_api.g_false,

1838: p_batch_no => NULL,
1839: p_org_code => NULL,
1840: p_ignore_exception => fnd_api.g_false,
1841: p_override_quality => fnd_api.g_false,
1842: p_validate_flexfields => fnd_api.g_false,
1843: x_batch_step_rec => l_step_rec_out,
1844: x_exception_material_tbl => l_exception_tbl);
1845: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1846: RAISE step_cmplt_err;

Line 1845: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

1841: p_override_quality => fnd_api.g_false,
1842: p_validate_flexfields => fnd_api.g_false,
1843: x_batch_step_rec => l_step_rec_out,
1844: x_exception_material_tbl => l_exception_tbl);
1845: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1846: RAISE step_cmplt_err;
1847: END IF;
1848: END IF;
1849: EXCEPTION

Line 1966: x_return_status := fnd_api.g_ret_sts_success;

1962: l_period_id NUMBER;
1963: l_open_period BOOLEAN;
1964: no_open_periods EXCEPTION;
1965: BEGIN
1966: x_return_status := fnd_api.g_ret_sts_success;
1967: invttmtx.tdatechk(org_id => p_organization_id,
1968: transaction_date => p_date,
1969: period_id => l_period_id,
1970: open_past_period => l_open_period);

Line 1986: x_return_status := fnd_api.g_ret_sts_error;

1982: x_date := p_date;
1983: END IF;
1984: EXCEPTION
1985: WHEN no_open_periods THEN
1986: x_return_status := fnd_api.g_ret_sts_error;
1987: END check_date;
1988:
1989: PROCEDURE get_subinventory(p_whse_code IN VARCHAR2,
1990: x_subinventory OUT NOCOPY VARCHAR2,

Line 2139: p_commit => fnd_api.g_true,

2135: p_subinventory_code => p_subinventory_code,
2136: p_location => p_location,
2137: p_loct_desc => l_loc_rec.loct_desc,
2138: p_start_date_active => l_loc_rec.creation_date,
2139: p_commit => fnd_api.g_true,
2140: x_location_id => x_location_id,
2141: x_failure_count => x_failure_count,
2142: p_disable_date => NULL,
2143: p_segment2 => NULL,

Line 2374: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

2370: check_date(p_organization_id => l_mtl_rec.organization_id,
2371: p_date => l_txns_tbl(i).trans_date,
2372: x_date => l_date,
2373: x_return_status => l_return_status);
2374: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2375: l_msg_name := 'GME_NO_OPEN_PERIODS_TXN';
2376: RAISE defined_error;
2377: END IF;
2378:

Line 2478: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2474: x_subinventory => l_mmti_rec.subinventory_code,
2475: x_locator_id => l_mmti_rec.locator_id,
2476: x_lot_number => l_lot_number,
2477: x_return_status => l_return_status);
2478: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2479: RAISE expected_error;
2480: END IF;
2481:
2482: -- Bug 14361428 Call SAVE BATCH to make sure inventory is available to transact.

Line 2485: p_commit => FND_API.G_FALSE,

2481:
2482: -- Bug 14361428 Call SAVE BATCH to make sure inventory is available to transact.
2483: gme_api_pub.save_batch(p_header_id => gme_common_pvt.g_transaction_header_id,
2484: p_table => gme_common_pvt.g_interface_table,
2485: p_commit => FND_API.G_FALSE,
2486: x_return_status => l_return_status);
2487:
2488: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2489: l_msg_name := 'GME_MIG_INV_TRANSFER_FAIL';

Line 2488: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

2484: p_table => gme_common_pvt.g_interface_table,
2485: p_commit => FND_API.G_FALSE,
2486: x_return_status => l_return_status);
2487:
2488: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2489: l_msg_name := 'GME_MIG_INV_TRANSFER_FAIL';
2490: RAISE create_txn_rsv_pp_err;
2491: END IF;
2492: ELSE

Line 2573: p_commit => fnd_api.g_true,

2569: p_lot_id => l_txns_tbl(i).lot_id,
2570: p_whse_code => l_txns_tbl(i).whse_code,
2571: p_orgn_code => NULL,
2572: p_location => l_txns_tbl(i).location,
2573: p_commit => fnd_api.g_true,
2574: x_lot_number => l_lot_number,
2575: x_parent_lot_number => l_parent_lot_no,
2576: x_failure_count => l_failure_count);
2577:

Line 2641: p_init_msg_list => fnd_api.g_false,

2637: gme_debug.put_line('Creating TXN with '||l_new_data);
2638: END IF;
2639: gme_api_pub.create_material_txn(p_api_version => 2.0,
2640: p_validation_level => gme_common_pvt.g_max_errors,
2641: p_init_msg_list => fnd_api.g_false,
2642: p_commit => fnd_api.g_false,
2643: x_message_count => l_msg_cnt,
2644: x_message_list => l_msg_data,
2645: x_return_status => l_return_status,

Line 2642: p_commit => fnd_api.g_false,

2638: END IF;
2639: gme_api_pub.create_material_txn(p_api_version => 2.0,
2640: p_validation_level => gme_common_pvt.g_max_errors,
2641: p_init_msg_list => fnd_api.g_false,
2642: p_commit => fnd_api.g_false,
2643: x_message_count => l_msg_cnt,
2644: x_message_list => l_msg_data,
2645: x_return_status => l_return_status,
2646: p_org_code => NULL,

Line 2657: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

2653: p_generate_lot => NULL,
2654: p_generate_parent_lot => NULL,
2655: x_mmt_rec => l_mmt_rec,
2656: x_mmln_tbl => l_mmln_rec);
2657: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2658: l_msg_name := 'GME_CREATE_TXN_FAIL';
2659: RAISE create_txn_rsv_pp_err;
2660: END IF;
2661:

Line 2788: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

2784: check_date(p_organization_id => l_mtl_rec.organization_id,
2785: p_date => l_txns_tbl(i).trans_date,
2786: x_date => l_date,
2787: x_return_status => l_return_status);
2788: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2789: l_msg_name := 'GME_NO_OPEN_PERIODS_TXN';
2790: RAISE defined_error;
2791: END IF;
2792:

Line 2812: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2808: x_subinventory => l_subinventory,
2809: x_locator_id => l_locator_id,
2810: x_lot_number => l_lot_number,
2811: x_return_status => l_return_status);
2812: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2813: RAISE expected_error;
2814: END IF;
2815:
2816: gme_api_pub.save_batch(p_header_id => gme_common_pvt.g_transaction_header_id,

Line 2818: p_commit => FND_API.G_FALSE,

2814: END IF;
2815:
2816: gme_api_pub.save_batch(p_header_id => gme_common_pvt.g_transaction_header_id,
2817: p_table => gme_common_pvt.g_interface_table,
2818: p_commit => FND_API.G_FALSE,
2819: x_return_status => l_return_status);
2820: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2821: l_msg_name := 'GME_MIG_INV_TRANSFER_FAIL';
2822: RAISE create_txn_rsv_pp_err;

Line 2820: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

2816: gme_api_pub.save_batch(p_header_id => gme_common_pvt.g_transaction_header_id,
2817: p_table => gme_common_pvt.g_interface_table,
2818: p_commit => FND_API.G_FALSE,
2819: x_return_status => l_return_status);
2820: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2821: l_msg_name := 'GME_MIG_INV_TRANSFER_FAIL';
2822: RAISE create_txn_rsv_pp_err;
2823: END IF;
2824: ELSE

Line 2917: p_commit => fnd_api.g_true,

2913: p_lot_id => l_txns_tbl(i).lot_id,
2914: p_whse_code => l_txns_tbl(i).whse_code,
2915: p_orgn_code => NULL,
2916: p_location => l_txns_tbl(i).location,
2917: p_commit => fnd_api.g_true,
2918: x_lot_number => l_lot_number,
2919: x_parent_lot_number => l_parent_lot_no,
2920: x_failure_count => l_failure_count);
2921:

Line 2959: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

2955: p_subinventory => l_subinventory,
2956: p_locator_id => l_locator_id,
2957: p_lot_number => l_lot_number,
2958: x_return_status => l_return_status);
2959: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2960: l_msg_name := 'GME_CREATE_RESV_FAIL';
2961: RAISE create_txn_rsv_pp_err;
2962: END IF;
2963: END IF;

Line 3012: p_commit => fnd_api.g_true,

3008: p_lot_no => l_lot_no,
3009: p_sublot_no => l_sublot_no,
3010: p_organization_id => l_mtl_dtl_rec.organization_id,
3011: p_locator_id => NULL,
3012: p_commit => fnd_api.g_true,
3013: x_lot_number => l_lot_number,
3014: x_parent_lot_number => l_parent_lot_no,
3015: x_failure_count => l_failure_count);
3016:

Line 3063: p_init_msg_list => fnd_api.g_false,

3059: END IF;
3060:
3061: gme_api_pub.create_pending_product_lot(p_api_version => 2.0,
3062: p_validation_level => gme_common_pvt.g_max_errors,
3063: p_init_msg_list => fnd_api.g_false,
3064: p_commit => fnd_api.g_false,
3065: x_message_count => l_msg_cnt,
3066: x_message_list => l_msg_data,
3067: x_return_status => l_return_status,

Line 3064: p_commit => fnd_api.g_false,

3060:
3061: gme_api_pub.create_pending_product_lot(p_api_version => 2.0,
3062: p_validation_level => gme_common_pvt.g_max_errors,
3063: p_init_msg_list => fnd_api.g_false,
3064: p_commit => fnd_api.g_false,
3065: x_message_count => l_msg_cnt,
3066: x_message_list => l_msg_data,
3067: x_return_status => l_return_status,
3068: p_batch_header_rec => l_batch_hdr,

Line 3070: p_create_lot => fnd_api.g_false,

3066: x_message_list => l_msg_data,
3067: x_return_status => l_return_status,
3068: p_batch_header_rec => l_batch_hdr,
3069: p_org_code => gme_common_pvt.g_organization_code,
3070: p_create_lot => fnd_api.g_false,
3071: p_generate_lot => fnd_api.g_false,
3072: p_generate_parent_lot => fnd_api.g_false,
3073: p_material_detail_rec => l_mtl_dtl_rec,
3074: p_expiration_date => NULL,

Line 3071: p_generate_lot => fnd_api.g_false,

3067: x_return_status => l_return_status,
3068: p_batch_header_rec => l_batch_hdr,
3069: p_org_code => gme_common_pvt.g_organization_code,
3070: p_create_lot => fnd_api.g_false,
3071: p_generate_lot => fnd_api.g_false,
3072: p_generate_parent_lot => fnd_api.g_false,
3073: p_material_detail_rec => l_mtl_dtl_rec,
3074: p_expiration_date => NULL,
3075: p_pending_product_lots_rec => l_plot_in_rec,

Line 3072: p_generate_parent_lot => fnd_api.g_false,

3068: p_batch_header_rec => l_batch_hdr,
3069: p_org_code => gme_common_pvt.g_organization_code,
3070: p_create_lot => fnd_api.g_false,
3071: p_generate_lot => fnd_api.g_false,
3072: p_generate_parent_lot => fnd_api.g_false,
3073: p_material_detail_rec => l_mtl_dtl_rec,
3074: p_expiration_date => NULL,
3075: p_pending_product_lots_rec => l_plot_in_rec,
3076: x_pending_product_lots_rec => l_plot_out_rec);

Line 3077: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

3073: p_material_detail_rec => l_mtl_dtl_rec,
3074: p_expiration_date => NULL,
3075: p_pending_product_lots_rec => l_plot_in_rec,
3076: x_pending_product_lots_rec => l_plot_out_rec);
3077: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3078: l_msg_name := 'GME_CREATE_PPLOT_FAIL';
3079: RAISE create_txn_rsv_pp_err;
3080: END IF;
3081: END IF;

Line 3184: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE

3180: p_token5 => 'TO_UOM',
3181: p_param5 => l_mtl_rec.dtl_um);
3182: ROLLBACK;
3183: WHEN create_txn_rsv_pp_err THEN
3184: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE
3185: ,x_count => l_msg_cnt
3186: ,x_data => l_msg_data);
3187:
3188: l_txn_data := 'item no '||l_mtl_rec.item_no||'->'||'whse code '||l_txns_tbl(i).whse_code||'->'||

Line 3324: x_return_status := FND_API.G_RET_STS_SUCCESS;

3320: IF (g_debug <= gme_debug.g_log_statement) THEN
3321: gme_debug.put_line('Moving from org = '||p_curr_org_id||' to org = '||p_batch_org_id);
3322: END IF;
3323:
3324: x_return_status := FND_API.G_RET_STS_SUCCESS;
3325: OPEN Cur_get_org_params(p_curr_org_id);
3326: FETCH Cur_get_org_params INTO l_allow_neg_inv, l_org_loc_control, l_organization_code;
3327: CLOSE Cur_get_org_params;
3328:

Line 3453: p_commit => fnd_api.g_true,

3449: p_lot_id => p_txn_rec.lot_id,
3450: p_whse_code => p_txn_rec.whse_code,
3451: p_orgn_code => NULL,
3452: p_location => p_txn_rec.location,
3453: p_commit => fnd_api.g_true,
3454: x_lot_number => l_lot_number,
3455: x_parent_lot_number => l_parent_lot_no,
3456: x_failure_count => l_failure_count);
3457:

Line 3481: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

3477: check_date(p_organization_id => p_curr_org_id,
3478: p_date => p_mmti_rec.transaction_date,
3479: x_date => l_date,
3480: x_return_status => l_return_status);
3481: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3482: l_txn_data := 'org '||l_organization_code||'item no '||p_item_no||'->'||'whse code '||p_txn_rec.whse_code||'->'||
3483: 'location '||p_txn_rec.location||'->'||'lot id '||p_txn_rec.lot_id||'->'||
3484: 'trans qty '||p_txn_rec.trans_qty||'->'||'trans um '||p_txn_rec.trans_um||'->'||
3485: 'primary um '||l_item_rec.primary_uom_code||'->'||

Line 3543: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

3539:
3540: insert_interface_recs(p_mti_rec => l_issue_rec,
3541: p_mtli_rec => l_issue_lot_rec,
3542: x_return_status => l_return_status);
3543: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3544: RAISE expected_error;
3545: END IF;
3546:
3547: /* Now start the receipt in the batch org */

Line 3581: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

3577: p_date => l_receipt_rec.transaction_date,
3578: x_date => l_date,
3579: x_return_status => l_return_status);
3580:
3581: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3582: l_txn_data := 'org '||l_organization_code||'item no '||p_item_no||'->'||'whse code '||p_txn_rec.whse_code||'->'||
3583: 'location '||p_txn_rec.location||'->'||'lot id '||p_txn_rec.lot_id||'->'||
3584: 'trans qty '||p_txn_rec.trans_qty||'->'||'trans um '||p_txn_rec.trans_um||'->'||
3585: 'primary um '||l_item_rec.primary_uom_code||'->'||

Line 3707: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

3703:
3704: insert_interface_recs(p_mti_rec => l_receipt_rec,
3705: p_mtli_rec => l_receipt_lot_rec,
3706: x_return_status => l_return_status);
3707: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3708: RAISE expected_error;
3709: END IF;
3710:
3711: x_subinventory := l_receipt_rec.subinventory_code;

Line 3731: x_return_status := FND_API.G_RET_STS_ERROR;

3727: p_token1 => 'ORG',
3728: p_param1 => l_org,
3729: p_token2 => 'ITEM',
3730: p_param2 => p_item_no);
3731: x_return_status := FND_API.G_RET_STS_ERROR;
3732: WHEN no_open_period_err THEN
3733: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE
3734: ,x_count => l_msg_cnt
3735: ,x_data => l_msg_data);

Line 3733: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE

3729: p_token2 => 'ITEM',
3730: p_param2 => p_item_no);
3731: x_return_status := FND_API.G_RET_STS_ERROR;
3732: WHEN no_open_period_err THEN
3733: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE
3734: ,x_count => l_msg_cnt
3735: ,x_data => l_msg_data);
3736: gma_common_logging.gma_migration_central_log
3737: (p_run_id => g_migration_run_id,

Line 3759: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE

3755: 'trans qty '||p_txn_rec.trans_qty||'->'||'trans um '||p_txn_rec.trans_um||'->'||
3756: 'primary um '||l_item_rec.primary_uom_code||'->'||
3757: 'trans date '||to_char(p_txn_rec.trans_date, 'DD-MON-YYYY HH24:MI:SS');
3758:
3759: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE
3760: ,x_count => l_msg_cnt
3761: ,x_data => l_msg_data);
3762: gma_common_logging.gma_migration_central_log
3763: (p_run_id => g_migration_run_id,

Line 3798: x_return_status := FND_API.G_RET_STS_ERROR;

3794: p_token2 => 'TRANS_ID',
3795: p_param2 => p_txn_rec.trans_id,
3796: p_token3 => 'TXN_DATA',
3797: p_param3 => l_txn_data);
3798: x_return_status := FND_API.G_RET_STS_ERROR;
3799: WHEN OTHERS THEN
3800: IF (g_debug <= gme_debug.g_log_unexpected) THEN
3801: gme_debug.put_line('When others in '||l_api_name||' '||SQLERRM);
3802: END IF;

Line 3809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3805: 'trans qty '||p_txn_rec.trans_qty||'->'||'trans um '||p_txn_rec.trans_um||'->'||
3806: 'primary um '||l_item_rec.primary_uom_code||'->'||
3807: 'trans date '||to_char(p_txn_rec.trans_date, 'DD-MON-YYYY HH24:MI:SS');
3808:
3809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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',

Line 3837: x_return_status := FND_API.G_RET_STS_SUCCESS;

3833: BEGIN
3834: IF (g_debug <= gme_debug.g_log_procedure) THEN
3835: gme_debug.put_line('Start procedure '||l_api_name);
3836: END IF;
3837: x_return_status := FND_API.G_RET_STS_SUCCESS;
3838: l_mti_tbl(1) := p_mti_rec;
3839: IF (p_mtli_rec.lot_number IS NOT NULL) THEN
3840: l_mtli_tbl(1) := p_mtli_rec;
3841: END IF;

Line 3854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3850: WHEN OTHERS THEN
3851: IF (g_debug <= gme_debug.g_log_unexpected) THEN
3852: gme_debug.put_line('When others in '||l_api_name||' '||SQLERRM);
3853: END IF;
3854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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',

Line 3910: p_init_msg_list => fnd_api.g_true,

3906: IF (Cur_verify_txns%NOTFOUND) THEN
3907: CLOSE Cur_verify_txns;
3908: gme_api_pub.close_step (p_api_version => 2,
3909: p_validation_level => gme_common_pvt.g_max_errors,
3910: p_init_msg_list => fnd_api.g_true,
3911: p_commit => fnd_api.g_true,
3912: x_message_count => l_msg_cnt,
3913: x_message_list => l_msg_data,
3914: x_return_status => l_return_status,

Line 3911: p_commit => fnd_api.g_true,

3907: CLOSE Cur_verify_txns;
3908: gme_api_pub.close_step (p_api_version => 2,
3909: p_validation_level => gme_common_pvt.g_max_errors,
3910: p_init_msg_list => fnd_api.g_true,
3911: p_commit => fnd_api.g_true,
3912: x_message_count => l_msg_cnt,
3913: x_message_list => l_msg_data,
3914: x_return_status => l_return_status,
3915: p_batch_step_rec => l_step_rec,

Line 3916: p_delete_pending => fnd_api.g_false,

3912: x_message_count => l_msg_cnt,
3913: x_message_list => l_msg_data,
3914: x_return_status => l_return_status,
3915: p_batch_step_rec => l_step_rec,
3916: p_delete_pending => fnd_api.g_false,
3917: p_org_code => NULL,
3918: p_batch_no => NULL,
3919: x_batch_step_rec => l_out_step_rec);
3920: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

Line 3920: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

3916: p_delete_pending => fnd_api.g_false,
3917: p_org_code => NULL,
3918: p_batch_no => NULL,
3919: x_batch_step_rec => l_out_step_rec);
3920: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3921: RAISE step_close_fail;
3922: END IF;
3923: ELSE
3924: CLOSE Cur_verify_txns;

Line 4032: p_commit => fnd_api.g_true,

4028: p_lot_id => get_lots.lot_id,
4029: p_whse_code => NULL,
4030: p_orgn_code => get_lots.plant_code,
4031: p_location => NULL,
4032: p_commit => fnd_api.g_true,
4033: x_lot_number => l_lot_number,
4034: x_parent_lot_number => l_parent_lot_no,
4035: x_failure_count => l_failure_count);
4036: IF (l_lot_number IS NOT NULL) THEN

Line 4042: p_init_msg_list => fnd_api.g_false,

4038: l_plot_in_rec.secondary_quantity := get_lots.qty2;
4039: l_plot_in_rec.lot_number := l_lot_number;
4040: gme_api_pub.create_pending_product_lot(p_api_version => 2.0,
4041: p_validation_level => gme_common_pvt.g_max_errors,
4042: p_init_msg_list => fnd_api.g_false,
4043: p_commit => fnd_api.g_false,
4044: x_message_count => l_msg_cnt,
4045: x_message_list => l_msg_data,
4046: x_return_status => l_return_status,

Line 4043: p_commit => fnd_api.g_false,

4039: l_plot_in_rec.lot_number := l_lot_number;
4040: gme_api_pub.create_pending_product_lot(p_api_version => 2.0,
4041: p_validation_level => gme_common_pvt.g_max_errors,
4042: p_init_msg_list => fnd_api.g_false,
4043: p_commit => fnd_api.g_false,
4044: x_message_count => l_msg_cnt,
4045: x_message_list => l_msg_data,
4046: x_return_status => l_return_status,
4047: p_batch_header_rec => l_batch_hdr,

Line 4049: p_create_lot => fnd_api.g_false,

4045: x_message_list => l_msg_data,
4046: x_return_status => l_return_status,
4047: p_batch_header_rec => l_batch_hdr,
4048: p_org_code => NULL,
4049: p_create_lot => fnd_api.g_false,
4050: p_generate_lot => fnd_api.g_false,
4051: p_generate_parent_lot => fnd_api.g_false,
4052: p_material_detail_rec => l_mtl_rec,
4053: p_expiration_date => NULL,

Line 4050: p_generate_lot => fnd_api.g_false,

4046: x_return_status => l_return_status,
4047: p_batch_header_rec => l_batch_hdr,
4048: p_org_code => NULL,
4049: p_create_lot => fnd_api.g_false,
4050: p_generate_lot => fnd_api.g_false,
4051: p_generate_parent_lot => fnd_api.g_false,
4052: p_material_detail_rec => l_mtl_rec,
4053: p_expiration_date => NULL,
4054: p_pending_product_lots_rec => l_plot_in_rec,

Line 4051: p_generate_parent_lot => fnd_api.g_false,

4047: p_batch_header_rec => l_batch_hdr,
4048: p_org_code => NULL,
4049: p_create_lot => fnd_api.g_false,
4050: p_generate_lot => fnd_api.g_false,
4051: p_generate_parent_lot => fnd_api.g_false,
4052: p_material_detail_rec => l_mtl_rec,
4053: p_expiration_date => NULL,
4054: p_pending_product_lots_rec => l_plot_in_rec,
4055: x_pending_product_lots_rec => l_plot_out_rec);

Line 4056: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

4052: p_material_detail_rec => l_mtl_rec,
4053: p_expiration_date => NULL,
4054: p_pending_product_lots_rec => l_plot_in_rec,
4055: x_pending_product_lots_rec => l_plot_out_rec);
4056: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
4057: RAISE create_pp_lot_err;
4058: END IF;
4059: UPDATE gme_lab_batch_lots
4060: SET attribute27 = 'M'

Line 4082: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE

4078: p_token2 => 'MSG',
4079: p_param2 => l_msg_data);
4080: ROLLBACK;
4081: WHEN create_pp_lot_err THEN
4082: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE
4083: ,x_count => l_msg_cnt
4084: ,x_data => l_msg_data);
4085: l_txn_data := l_item_rec.segment1||'->'||get_lots.lot_id||'->'||get_lots.qty||'->'||get_lots.qty2;
4086: l_new_data := l_item_rec.segment1||'->'||l_lot_number||'->'||get_lots.qty||'->'||get_lots.qty2;