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 385: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

381: ,p_batchstep_rec => NULL
382: ,p_mtl_dtl_rec => l_mtl_dtl_tbl(i)
383: ,x_mtl_req_date => l_mtl_dtl_tbl(i).material_requirement_date
384: ,x_return_status => l_return_status);
385: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
386: RAISE calc_mtl_req_date_err;
387: END IF;
388: END LOOP;
389: IF (g_debug <= gme_debug.g_log_statement) THEN

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

394: (p_organization_id => l_batch_header.organization_id
395: ,p_move_order_type => gme_common_pvt.g_invis_move_order_type
396: ,x_move_order_header_id => l_batch_header.move_order_header_id
397: ,x_return_status => l_return_status);
398: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
399: RAISE create_mo_hdr_err;
400: ELSE
401: l_in_mtl_dtl_tbl := l_mtl_dtl_tbl;
402: gme_move_orders_pvt.create_move_order_lines

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

405: ,p_material_details_tbl => l_in_mtl_dtl_tbl
406: ,x_material_details_tbl => l_mtl_dtl_tbl
407: ,x_trolin_tbl => l_trolin_tbl
408: ,x_return_status => l_return_status);
409: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
410: RAISE create_mo_line_err;
411: END IF;
412: END IF;
413: END IF;

Line 531: p_commit => FND_API.G_TRUE,

527: IF (g_debug <= gme_debug.g_log_statement) THEN
528: gme_debug.put_line('Call QM');
529: END IF;
530: gmd_qc_migb12.gmd_qc_migrate_batch_id(p_migration_run_id => g_migration_run_id,
531: p_commit => FND_API.G_TRUE,
532: x_exception_count => l_msg_count);
533: IF (g_debug <= gme_debug.g_log_procedure) THEN
534: gme_debug.put_line('End procedure '||l_api_name);
535: END IF;

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

1555: check_date(p_organization_id => l_batch_header.organization_id,
1556: p_date => l_batch_header.actual_start_date,
1557: x_date => l_date,
1558: x_return_status => l_return_status);
1559: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1560: RAISE no_open_period_err;
1561: ELSE
1562: l_batch_header.actual_start_date := l_date;
1563: END IF;

Line 1566: p_init_msg_list => fnd_api.g_false,

1562: l_batch_header.actual_start_date := l_date;
1563: END IF;
1564: gme_api_pub.release_batch(p_api_version => 2.0,
1565: p_validation_level => gme_common_pvt.g_max_errors,
1566: p_init_msg_list => fnd_api.g_false,
1567: p_commit => fnd_api.g_true,
1568: x_message_count => l_msg_cnt,
1569: x_message_list => l_msg_data,
1570: x_return_status => l_return_status,

Line 1567: p_commit => fnd_api.g_true,

1563: END IF;
1564: gme_api_pub.release_batch(p_api_version => 2.0,
1565: p_validation_level => gme_common_pvt.g_max_errors,
1566: p_init_msg_list => fnd_api.g_false,
1567: p_commit => fnd_api.g_true,
1568: x_message_count => l_msg_cnt,
1569: x_message_list => l_msg_data,
1570: x_return_status => l_return_status,
1571: p_batch_header_rec => l_batch_header,

Line 1573: p_ignore_exception => fnd_api.g_false,

1569: x_message_list => l_msg_data,
1570: x_return_status => l_return_status,
1571: p_batch_header_rec => l_batch_header,
1572: p_org_code => NULL,
1573: p_ignore_exception => fnd_api.g_false,
1574: p_validate_flexfields => fnd_api.g_false,
1575: x_batch_header_rec => l_batch_header_out,
1576: x_exception_material_tbl => l_exception_tbl);
1577: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

Line 1574: p_validate_flexfields => fnd_api.g_false,

1570: x_return_status => l_return_status,
1571: p_batch_header_rec => l_batch_header,
1572: p_org_code => NULL,
1573: p_ignore_exception => fnd_api.g_false,
1574: p_validate_flexfields => fnd_api.g_false,
1575: x_batch_header_rec => l_batch_header_out,
1576: x_exception_material_tbl => l_exception_tbl);
1577: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1578: RAISE release_batch_err;

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

1573: p_ignore_exception => fnd_api.g_false,
1574: p_validate_flexfields => fnd_api.g_false,
1575: x_batch_header_rec => l_batch_header_out,
1576: x_exception_material_tbl => l_exception_tbl);
1577: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1578: RAISE release_batch_err;
1579: END IF;
1580: FOR get_steps IN Cur_get_steps(get_wip_batches.old_batch_id, l_batch_header.batch_id) LOOP
1581: BEGIN

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

1582: check_date(p_organization_id => l_batch_header.organization_id,
1583: p_date => get_steps.old_actual_start_date,
1584: x_date => l_date,
1585: x_return_status => l_return_status);
1586: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1587: RAISE no_open_period_err;
1588: ELSE
1589: get_steps.actual_start_date := l_date;
1590: END IF;

Line 1598: p_init_msg_list => fnd_api.g_false,

1594: l_step_rec.actual_cmplt_date := get_steps.old_actual_cmplt_date;
1595: IF (get_steps.old_step_status IN (gme_common_pvt.g_step_completed, gme_common_pvt.g_step_closed)) THEN
1596: gme_api_pub.complete_step(p_api_version => 2.0,
1597: p_validation_level => gme_common_pvt.g_max_errors,
1598: p_init_msg_list => fnd_api.g_false,
1599: p_commit => fnd_api.g_true,
1600: x_message_count => l_msg_cnt,
1601: x_message_list => l_msg_data,
1602: x_return_status => l_return_status,

Line 1599: p_commit => fnd_api.g_true,

1595: IF (get_steps.old_step_status IN (gme_common_pvt.g_step_completed, gme_common_pvt.g_step_closed)) THEN
1596: gme_api_pub.complete_step(p_api_version => 2.0,
1597: p_validation_level => gme_common_pvt.g_max_errors,
1598: p_init_msg_list => fnd_api.g_false,
1599: p_commit => fnd_api.g_true,
1600: x_message_count => l_msg_cnt,
1601: x_message_list => l_msg_data,
1602: x_return_status => l_return_status,
1603: p_batch_step_rec => l_step_rec,

Line 1606: p_ignore_exception => fnd_api.g_false,

1602: x_return_status => l_return_status,
1603: p_batch_step_rec => l_step_rec,
1604: p_batch_no => NULL,
1605: p_org_code => NULL,
1606: p_ignore_exception => fnd_api.g_false,
1607: p_override_quality => fnd_api.g_false,
1608: p_validate_flexfields => fnd_api.g_false,
1609: x_batch_step_rec => l_step_rec_out,
1610: x_exception_material_tbl => l_exception_tbl);

Line 1607: p_override_quality => fnd_api.g_false,

1603: p_batch_step_rec => l_step_rec,
1604: p_batch_no => NULL,
1605: p_org_code => NULL,
1606: p_ignore_exception => fnd_api.g_false,
1607: p_override_quality => fnd_api.g_false,
1608: p_validate_flexfields => fnd_api.g_false,
1609: x_batch_step_rec => l_step_rec_out,
1610: x_exception_material_tbl => l_exception_tbl);
1611: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

Line 1608: p_validate_flexfields => fnd_api.g_false,

1604: p_batch_no => NULL,
1605: p_org_code => NULL,
1606: p_ignore_exception => fnd_api.g_false,
1607: p_override_quality => fnd_api.g_false,
1608: p_validate_flexfields => fnd_api.g_false,
1609: x_batch_step_rec => l_step_rec_out,
1610: x_exception_material_tbl => l_exception_tbl);
1611: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1612: RAISE step_cmplt_err;

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

1607: p_override_quality => fnd_api.g_false,
1608: p_validate_flexfields => fnd_api.g_false,
1609: x_batch_step_rec => l_step_rec_out,
1610: x_exception_material_tbl => l_exception_tbl);
1611: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1612: RAISE step_cmplt_err;
1613: END IF;
1614: ELSE
1615: gme_api_pub.release_step(p_api_version => 2.0,

Line 1617: p_init_msg_list => fnd_api.g_false,

1613: END IF;
1614: ELSE
1615: gme_api_pub.release_step(p_api_version => 2.0,
1616: p_validation_level => gme_common_pvt.g_max_errors,
1617: p_init_msg_list => fnd_api.g_false,
1618: p_commit => fnd_api.g_true,
1619: x_message_count => l_msg_cnt,
1620: x_message_list => l_msg_data,
1621: x_return_status => l_return_status,

Line 1618: p_commit => fnd_api.g_true,

1614: ELSE
1615: gme_api_pub.release_step(p_api_version => 2.0,
1616: p_validation_level => gme_common_pvt.g_max_errors,
1617: p_init_msg_list => fnd_api.g_false,
1618: p_commit => fnd_api.g_true,
1619: x_message_count => l_msg_cnt,
1620: x_message_list => l_msg_data,
1621: x_return_status => l_return_status,
1622: p_batch_step_rec => l_step_rec,

Line 1625: p_ignore_exception => fnd_api.g_false,

1621: x_return_status => l_return_status,
1622: p_batch_step_rec => l_step_rec,
1623: p_batch_no => NULL,
1624: p_org_code => NULL,
1625: p_ignore_exception => fnd_api.g_false,
1626: p_validate_flexfields => fnd_api.g_false,
1627: x_batch_step_rec => l_step_rec_out,
1628: x_exception_material_tbl => l_exception_tbl);
1629: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

Line 1626: p_validate_flexfields => fnd_api.g_false,

1622: p_batch_step_rec => l_step_rec,
1623: p_batch_no => NULL,
1624: p_org_code => NULL,
1625: p_ignore_exception => fnd_api.g_false,
1626: p_validate_flexfields => fnd_api.g_false,
1627: x_batch_step_rec => l_step_rec_out,
1628: x_exception_material_tbl => l_exception_tbl);
1629: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1630: RAISE step_release_err;

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

1625: p_ignore_exception => fnd_api.g_false,
1626: p_validate_flexfields => fnd_api.g_false,
1627: x_batch_step_rec => l_step_rec_out,
1628: x_exception_material_tbl => l_exception_tbl);
1629: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1630: RAISE step_release_err;
1631: END IF;
1632: END IF;
1633: EXCEPTION

Line 1750: x_return_status := fnd_api.g_ret_sts_success;

1746: l_period_id NUMBER;
1747: l_open_period BOOLEAN;
1748: no_open_periods EXCEPTION;
1749: BEGIN
1750: x_return_status := fnd_api.g_ret_sts_success;
1751: invttmtx.tdatechk(org_id => p_organization_id,
1752: transaction_date => p_date,
1753: period_id => l_period_id,
1754: open_past_period => l_open_period);

Line 1770: x_return_status := fnd_api.g_ret_sts_error;

1766: x_date := p_date;
1767: END IF;
1768: EXCEPTION
1769: WHEN no_open_periods THEN
1770: x_return_status := fnd_api.g_ret_sts_error;
1771: END check_date;
1772:
1773: PROCEDURE get_subinventory(p_whse_code IN VARCHAR2,
1774: x_subinventory OUT NOCOPY VARCHAR2,

Line 1923: p_commit => fnd_api.g_true,

1919: p_subinventory_code => p_subinventory_code,
1920: p_location => p_location,
1921: p_loct_desc => l_loc_rec.loct_desc,
1922: p_start_date_active => l_loc_rec.creation_date,
1923: p_commit => fnd_api.g_true,
1924: x_location_id => x_location_id,
1925: x_failure_count => x_failure_count,
1926: p_disable_date => NULL,
1927: p_segment2 => NULL,

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

2134: check_date(p_organization_id => l_mtl_rec.organization_id,
2135: p_date => l_txns_tbl(i).trans_date,
2136: x_date => l_date,
2137: x_return_status => l_return_status);
2138: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2139: l_msg_name := 'GME_NO_OPEN_PERIODS_TXN';
2140: RAISE defined_error;
2141: END IF;
2142: l_mmti_rec.transaction_date := l_date;

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

2222: x_subinventory => l_mmti_rec.subinventory_code,
2223: x_locator_id => l_mmti_rec.locator_id,
2224: x_lot_number => l_lot_number,
2225: x_return_status => l_return_status);
2226: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2227: RAISE expected_error;
2228: END IF;
2229: ELSE
2230: IF (g_debug <= gme_debug.g_log_statement) THEN

Line 2296: p_commit => fnd_api.g_true,

2292: p_lot_id => l_txns_tbl(i).lot_id,
2293: p_whse_code => l_txns_tbl(i).whse_code,
2294: p_orgn_code => NULL,
2295: p_location => l_txns_tbl(i).location,
2296: p_commit => fnd_api.g_true,
2297: x_lot_number => l_lot_number,
2298: x_parent_lot_number => l_parent_lot_no,
2299: x_failure_count => l_failure_count);
2300: IF (l_failure_count > 0 OR l_lot_number IS NULL) THEN

Line 2337: p_init_msg_list => fnd_api.g_false,

2333: gme_debug.put_line('Creating TXN with '||l_new_data);
2334: END IF;
2335: gme_api_pub.create_material_txn(p_api_version => 2.0,
2336: p_validation_level => gme_common_pvt.g_max_errors,
2337: p_init_msg_list => fnd_api.g_false,
2338: p_commit => fnd_api.g_false,
2339: x_message_count => l_msg_cnt,
2340: x_message_list => l_msg_data,
2341: x_return_status => l_return_status,

Line 2338: p_commit => fnd_api.g_false,

2334: END IF;
2335: gme_api_pub.create_material_txn(p_api_version => 2.0,
2336: p_validation_level => gme_common_pvt.g_max_errors,
2337: p_init_msg_list => fnd_api.g_false,
2338: p_commit => fnd_api.g_false,
2339: x_message_count => l_msg_cnt,
2340: x_message_list => l_msg_data,
2341: x_return_status => l_return_status,
2342: p_org_code => NULL,

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

2349: p_generate_lot => NULL,
2350: p_generate_parent_lot => NULL,
2351: x_mmt_rec => l_mmt_rec,
2352: x_mmln_tbl => l_mmln_rec);
2353: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2354: l_msg_name := 'GME_CREATE_TXN_FAIL';
2355: RAISE create_txn_rsv_pp_err;
2356: END IF;
2357: ELSE /* IF (l_txns_tbl(i).completed_ind = 1) THEN */

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

2465: check_date(p_organization_id => l_mtl_rec.organization_id,
2466: p_date => l_txns_tbl(i).trans_date,
2467: x_date => l_date,
2468: x_return_status => l_return_status);
2469: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2470: l_msg_name := 'GME_NO_OPEN_PERIODS_TXN';
2471: RAISE defined_error;
2472: END IF;
2473: l_mmti_rec.transaction_date := l_date;

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

2487: x_subinventory => l_subinventory,
2488: x_locator_id => l_locator_id,
2489: x_lot_number => l_lot_number,
2490: x_return_status => l_return_status);
2491: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2492: RAISE expected_error;
2493: END IF;
2494: gme_api_pub.save_batch(p_header_id => gme_common_pvt.g_transaction_header_id,
2495: p_table => gme_common_pvt.g_interface_table,

Line 2496: p_commit => FND_API.G_FALSE,

2492: RAISE expected_error;
2493: END IF;
2494: gme_api_pub.save_batch(p_header_id => gme_common_pvt.g_transaction_header_id,
2495: p_table => gme_common_pvt.g_interface_table,
2496: p_commit => FND_API.G_FALSE,
2497: x_return_status => l_return_status);
2498: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2499: l_msg_name := 'GME_MIG_INV_TRANSFER_FAIL';
2500: RAISE create_txn_rsv_pp_err;

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

2494: gme_api_pub.save_batch(p_header_id => gme_common_pvt.g_transaction_header_id,
2495: p_table => gme_common_pvt.g_interface_table,
2496: p_commit => FND_API.G_FALSE,
2497: x_return_status => l_return_status);
2498: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2499: l_msg_name := 'GME_MIG_INV_TRANSFER_FAIL';
2500: RAISE create_txn_rsv_pp_err;
2501: END IF;
2502: ELSE

Line 2581: p_commit => fnd_api.g_true,

2577: p_lot_id => l_txns_tbl(i).lot_id,
2578: p_whse_code => l_txns_tbl(i).whse_code,
2579: p_orgn_code => NULL,
2580: p_location => l_txns_tbl(i).location,
2581: p_commit => fnd_api.g_true,
2582: x_lot_number => l_lot_number,
2583: x_parent_lot_number => l_parent_lot_no,
2584: x_failure_count => l_failure_count);
2585: IF (l_failure_count > 0 OR l_lot_number IS NULL) THEN

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

2603: p_subinventory => l_subinventory,
2604: p_locator_id => l_locator_id,
2605: p_lot_number => l_lot_number,
2606: x_return_status => l_return_status);
2607: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2608: l_msg_name := 'GME_CREATE_RESV_FAIL';
2609: RAISE create_txn_rsv_pp_err;
2610: END IF;
2611: END IF;

Line 2647: p_commit => fnd_api.g_true,

2643: p_lot_no => l_lot_no,
2644: p_sublot_no => l_sublot_no,
2645: p_organization_id => l_mtl_dtl_rec.organization_id,
2646: p_locator_id => NULL,
2647: p_commit => fnd_api.g_true,
2648: x_lot_number => l_lot_number,
2649: x_parent_lot_number => l_parent_lot_no,
2650: x_failure_count => l_failure_count);
2651: IF (l_failure_count > 0 OR l_lot_number IS NULL) THEN

Line 2681: p_init_msg_list => fnd_api.g_false,

2677: gme_debug.put_line('Creating pending product lot with '||l_new_data);
2678: END IF;
2679: gme_api_pub.create_pending_product_lot(p_api_version => 2.0,
2680: p_validation_level => gme_common_pvt.g_max_errors,
2681: p_init_msg_list => fnd_api.g_false,
2682: p_commit => fnd_api.g_false,
2683: x_message_count => l_msg_cnt,
2684: x_message_list => l_msg_data,
2685: x_return_status => l_return_status,

Line 2682: p_commit => fnd_api.g_false,

2678: END IF;
2679: gme_api_pub.create_pending_product_lot(p_api_version => 2.0,
2680: p_validation_level => gme_common_pvt.g_max_errors,
2681: p_init_msg_list => fnd_api.g_false,
2682: p_commit => fnd_api.g_false,
2683: x_message_count => l_msg_cnt,
2684: x_message_list => l_msg_data,
2685: x_return_status => l_return_status,
2686: p_batch_header_rec => l_batch_hdr,

Line 2688: p_create_lot => fnd_api.g_false,

2684: x_message_list => l_msg_data,
2685: x_return_status => l_return_status,
2686: p_batch_header_rec => l_batch_hdr,
2687: p_org_code => gme_common_pvt.g_organization_code,
2688: p_create_lot => fnd_api.g_false,
2689: p_generate_lot => fnd_api.g_false,
2690: p_generate_parent_lot => fnd_api.g_false,
2691: p_material_detail_rec => l_mtl_dtl_rec,
2692: p_expiration_date => NULL,

Line 2689: p_generate_lot => fnd_api.g_false,

2685: x_return_status => l_return_status,
2686: p_batch_header_rec => l_batch_hdr,
2687: p_org_code => gme_common_pvt.g_organization_code,
2688: p_create_lot => fnd_api.g_false,
2689: p_generate_lot => fnd_api.g_false,
2690: p_generate_parent_lot => fnd_api.g_false,
2691: p_material_detail_rec => l_mtl_dtl_rec,
2692: p_expiration_date => NULL,
2693: p_pending_product_lots_rec => l_plot_in_rec,

Line 2690: p_generate_parent_lot => fnd_api.g_false,

2686: p_batch_header_rec => l_batch_hdr,
2687: p_org_code => gme_common_pvt.g_organization_code,
2688: p_create_lot => fnd_api.g_false,
2689: p_generate_lot => fnd_api.g_false,
2690: p_generate_parent_lot => fnd_api.g_false,
2691: p_material_detail_rec => l_mtl_dtl_rec,
2692: p_expiration_date => NULL,
2693: p_pending_product_lots_rec => l_plot_in_rec,
2694: x_pending_product_lots_rec => l_plot_out_rec);

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

2691: p_material_detail_rec => l_mtl_dtl_rec,
2692: p_expiration_date => NULL,
2693: p_pending_product_lots_rec => l_plot_in_rec,
2694: x_pending_product_lots_rec => l_plot_out_rec);
2695: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2696: l_msg_name := 'GME_CREATE_PPLOT_FAIL';
2697: RAISE create_txn_rsv_pp_err;
2698: END IF;
2699: END IF;

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

2779: p_token5 => 'TO_UOM',
2780: p_param5 => l_mtl_rec.dtl_um);
2781: ROLLBACK;
2782: WHEN create_txn_rsv_pp_err THEN
2783: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE
2784: ,x_count => l_msg_cnt
2785: ,x_data => l_msg_data);
2786: l_txn_data := l_mtl_rec.item_no||'->'||l_txns_tbl(i).whse_code||'->'||l_txns_tbl(i).location||'->'||
2787: l_txns_tbl(i).lot_id||'->'||l_txns_tbl(i).trans_qty||'->'||l_mtl_rec.primary_uom_code||'->'||TO_CHAR(l_txns_tbl(i).trans_date, 'DD-MON-YYYY HH24:MI:SS');

Line 2896: x_return_status := FND_API.G_RET_STS_SUCCESS;

2892: END IF;
2893: IF (g_debug <= gme_debug.g_log_statement) THEN
2894: gme_debug.put_line('Moving from org = '||p_curr_org_id||' to org = '||p_batch_org_id);
2895: END IF;
2896: x_return_status := FND_API.G_RET_STS_SUCCESS;
2897: OPEN Cur_get_org_params(p_curr_org_id);
2898: FETCH Cur_get_org_params INTO l_allow_neg_inv, l_org_loc_control, l_organization_code;
2899: CLOSE Cur_get_org_params;
2900: l_txn_data := p_item_no||'->'||p_txn_rec.whse_code||'->'||p_txn_rec.location||'->'||p_txn_rec.lot_id||'->'||p_txn_rec.trans_qty||'->'||p_txn_rec.trans_um||'->'||to_char(p_txn_rec.trans_date, 'DD-MON-YYYY HH24:MI:SS');

Line 3002: p_commit => fnd_api.g_true,

2998: p_lot_id => p_txn_rec.lot_id,
2999: p_whse_code => p_txn_rec.whse_code,
3000: p_orgn_code => NULL,
3001: p_location => p_txn_rec.location,
3002: p_commit => fnd_api.g_true,
3003: x_lot_number => l_lot_number,
3004: x_parent_lot_number => l_parent_lot_no,
3005: x_failure_count => l_failure_count);
3006: IF (l_failure_count > 0 OR l_lot_number IS NULL) THEN

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

3014: check_date(p_organization_id => p_curr_org_id,
3015: p_date => p_mmti_rec.transaction_date,
3016: x_date => l_date,
3017: x_return_status => l_return_status);
3018: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3019: l_txn_data := l_organization_code||'->'||p_item_no||'->'||p_txn_rec.whse_code||'->'||p_txn_rec.location||'->'||p_txn_rec.lot_id||'->'||
3020: p_txn_rec.trans_qty||'->'||l_item_rec.primary_uom_code||'->'||to_char(p_txn_rec.trans_date, 'DD-MON-YYYY HH24:MI:SS');
3021: gme_common_pvt.log_message(p_product_code => 'INV', p_message_code => 'INV_NO_OPEN_PERIOD');
3022: RAISE no_open_period_err;

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

3069: END IF;
3070: insert_interface_recs(p_mti_rec => l_issue_rec,
3071: p_mtli_rec => l_issue_lot_rec,
3072: x_return_status => l_return_status);
3073: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3074: RAISE expected_error;
3075: END IF;
3076: /* Now start the receipt in the batch org */
3077: OPEN Cur_item_dtl(p_batch_org_id, p_inventory_item_id);

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

3101: check_date(p_organization_id => p_batch_org_id,
3102: p_date => l_receipt_rec.transaction_date,
3103: x_date => l_date,
3104: x_return_status => l_return_status);
3105: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3106: l_txn_data := gme_common_pvt.g_organization_code||'->'||p_item_no||'->'||p_txn_rec.whse_code||'->'||p_txn_rec.location||'->'||p_txn_rec.lot_id||'->'||
3107: p_txn_rec.trans_qty||'->'||l_item_rec.primary_uom_code||'->'||to_char(p_txn_rec.trans_date, 'DD-MON-YYYY HH24:MI:SS');
3108: gme_common_pvt.log_message(p_product_code => 'INV', p_message_code => 'INV_NO_OPEN_PERIOD');
3109: RAISE no_open_period_err;

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

3175: END IF;
3176: insert_interface_recs(p_mti_rec => l_receipt_rec,
3177: p_mtli_rec => l_receipt_lot_rec,
3178: x_return_status => l_return_status);
3179: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3180: RAISE expected_error;
3181: END IF;
3182: x_subinventory := l_receipt_rec.subinventory_code;
3183: x_locator_id := l_receipt_rec.locator_id;

Line 3201: x_return_status := FND_API.G_RET_STS_ERROR;

3197: p_token1 => 'ORG',
3198: p_param1 => l_org,
3199: p_token2 => 'ITEM',
3200: p_param2 => p_item_no);
3201: x_return_status := FND_API.G_RET_STS_ERROR;
3202: WHEN no_open_period_err THEN
3203: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE
3204: ,x_count => l_msg_cnt
3205: ,x_data => l_msg_data);

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

3199: p_token2 => 'ITEM',
3200: p_param2 => p_item_no);
3201: x_return_status := FND_API.G_RET_STS_ERROR;
3202: WHEN no_open_period_err THEN
3203: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE
3204: ,x_count => l_msg_cnt
3205: ,x_data => l_msg_data);
3206: gma_common_logging.gma_migration_central_log
3207: (p_run_id => g_migration_run_id,

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

3219: x_return_status := l_return_status;
3220: WHEN expected_error THEN
3221: l_txn_data := p_item_no||'->'||p_txn_rec.whse_code||'->'||p_txn_rec.location||'->'||p_txn_rec.lot_id||'->'||
3222: p_txn_rec.trans_qty||'->'||l_item_rec.primary_uom_code||'->'||to_char(p_txn_rec.trans_date, 'DD-MON-YYYY HH24:MI:SS');
3223: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE
3224: ,x_count => l_msg_cnt
3225: ,x_data => l_msg_data);
3226: gma_common_logging.gma_migration_central_log
3227: (p_run_id => g_migration_run_id,

Line 3255: x_return_status := FND_API.G_RET_STS_ERROR;

3251: p_token2 => 'TRANS_ID',
3252: p_param2 => p_txn_rec.trans_id,
3253: p_token3 => 'TXN_DATA',
3254: p_param3 => l_txn_data);
3255: x_return_status := FND_API.G_RET_STS_ERROR;
3256: WHEN OTHERS THEN
3257: IF (g_debug <= gme_debug.g_log_unexpected) THEN
3258: gme_debug.put_line('When others in '||l_api_name||' '||SQLERRM);
3259: END IF;

Line 3261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3257: IF (g_debug <= gme_debug.g_log_unexpected) THEN
3258: gme_debug.put_line('When others in '||l_api_name||' '||SQLERRM);
3259: END IF;
3260: l_txn_data := p_item_no||'->'||p_txn_rec.whse_code||'->'||p_txn_rec.location||'->'||p_txn_rec.lot_id||'->'||p_txn_rec.trans_qty||'->'||l_item_rec.primary_uom_code||'->'||to_char(p_txn_rec.trans_date, 'DD-MON-YYYY HH24:MI:SS');
3261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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',

Line 3287: x_return_status := FND_API.G_RET_STS_SUCCESS;

3283: BEGIN
3284: IF (g_debug <= gme_debug.g_log_procedure) THEN
3285: gme_debug.put_line('Start procedure '||l_api_name);
3286: END IF;
3287: x_return_status := FND_API.G_RET_STS_SUCCESS;
3288: l_mti_tbl(1) := p_mti_rec;
3289: IF (p_mtli_rec.lot_number IS NOT NULL) THEN
3290: l_mtli_tbl(1) := p_mtli_rec;
3291: END IF;

Line 3304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3300: WHEN OTHERS THEN
3301: IF (g_debug <= gme_debug.g_log_unexpected) THEN
3302: gme_debug.put_line('When others in '||l_api_name||' '||SQLERRM);
3303: END IF;
3304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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',

Line 3360: p_init_msg_list => fnd_api.g_true,

3356: IF (Cur_verify_txns%NOTFOUND) THEN
3357: CLOSE Cur_verify_txns;
3358: gme_api_pub.close_step (p_api_version => 2,
3359: p_validation_level => gme_common_pvt.g_max_errors,
3360: p_init_msg_list => fnd_api.g_true,
3361: p_commit => fnd_api.g_true,
3362: x_message_count => l_msg_cnt,
3363: x_message_list => l_msg_data,
3364: x_return_status => l_return_status,

Line 3361: p_commit => fnd_api.g_true,

3357: CLOSE Cur_verify_txns;
3358: gme_api_pub.close_step (p_api_version => 2,
3359: p_validation_level => gme_common_pvt.g_max_errors,
3360: p_init_msg_list => fnd_api.g_true,
3361: p_commit => fnd_api.g_true,
3362: x_message_count => l_msg_cnt,
3363: x_message_list => l_msg_data,
3364: x_return_status => l_return_status,
3365: p_batch_step_rec => l_step_rec,

Line 3366: p_delete_pending => fnd_api.g_false,

3362: x_message_count => l_msg_cnt,
3363: x_message_list => l_msg_data,
3364: x_return_status => l_return_status,
3365: p_batch_step_rec => l_step_rec,
3366: p_delete_pending => fnd_api.g_false,
3367: p_org_code => NULL,
3368: p_batch_no => NULL,
3369: x_batch_step_rec => l_out_step_rec);
3370: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

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

3366: p_delete_pending => fnd_api.g_false,
3367: p_org_code => NULL,
3368: p_batch_no => NULL,
3369: x_batch_step_rec => l_out_step_rec);
3370: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3371: RAISE step_close_fail;
3372: END IF;
3373: ELSE
3374: CLOSE Cur_verify_txns;

Line 3482: p_commit => fnd_api.g_true,

3478: p_lot_id => get_lots.lot_id,
3479: p_whse_code => NULL,
3480: p_orgn_code => get_lots.plant_code,
3481: p_location => NULL,
3482: p_commit => fnd_api.g_true,
3483: x_lot_number => l_lot_number,
3484: x_parent_lot_number => l_parent_lot_no,
3485: x_failure_count => l_failure_count);
3486: IF (l_lot_number IS NOT NULL) THEN

Line 3492: p_init_msg_list => fnd_api.g_false,

3488: l_plot_in_rec.secondary_quantity := get_lots.qty2;
3489: l_plot_in_rec.lot_number := l_lot_number;
3490: gme_api_pub.create_pending_product_lot(p_api_version => 2.0,
3491: p_validation_level => gme_common_pvt.g_max_errors,
3492: p_init_msg_list => fnd_api.g_false,
3493: p_commit => fnd_api.g_false,
3494: x_message_count => l_msg_cnt,
3495: x_message_list => l_msg_data,
3496: x_return_status => l_return_status,

Line 3493: p_commit => fnd_api.g_false,

3489: l_plot_in_rec.lot_number := l_lot_number;
3490: gme_api_pub.create_pending_product_lot(p_api_version => 2.0,
3491: p_validation_level => gme_common_pvt.g_max_errors,
3492: p_init_msg_list => fnd_api.g_false,
3493: p_commit => fnd_api.g_false,
3494: x_message_count => l_msg_cnt,
3495: x_message_list => l_msg_data,
3496: x_return_status => l_return_status,
3497: p_batch_header_rec => l_batch_hdr,

Line 3499: p_create_lot => fnd_api.g_false,

3495: x_message_list => l_msg_data,
3496: x_return_status => l_return_status,
3497: p_batch_header_rec => l_batch_hdr,
3498: p_org_code => NULL,
3499: p_create_lot => fnd_api.g_false,
3500: p_generate_lot => fnd_api.g_false,
3501: p_generate_parent_lot => fnd_api.g_false,
3502: p_material_detail_rec => l_mtl_rec,
3503: p_expiration_date => NULL,

Line 3500: p_generate_lot => fnd_api.g_false,

3496: x_return_status => l_return_status,
3497: p_batch_header_rec => l_batch_hdr,
3498: p_org_code => NULL,
3499: p_create_lot => fnd_api.g_false,
3500: p_generate_lot => fnd_api.g_false,
3501: p_generate_parent_lot => fnd_api.g_false,
3502: p_material_detail_rec => l_mtl_rec,
3503: p_expiration_date => NULL,
3504: p_pending_product_lots_rec => l_plot_in_rec,

Line 3501: p_generate_parent_lot => fnd_api.g_false,

3497: p_batch_header_rec => l_batch_hdr,
3498: p_org_code => NULL,
3499: p_create_lot => fnd_api.g_false,
3500: p_generate_lot => fnd_api.g_false,
3501: p_generate_parent_lot => fnd_api.g_false,
3502: p_material_detail_rec => l_mtl_rec,
3503: p_expiration_date => NULL,
3504: p_pending_product_lots_rec => l_plot_in_rec,
3505: x_pending_product_lots_rec => l_plot_out_rec);

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

3502: p_material_detail_rec => l_mtl_rec,
3503: p_expiration_date => NULL,
3504: p_pending_product_lots_rec => l_plot_in_rec,
3505: x_pending_product_lots_rec => l_plot_out_rec);
3506: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3507: RAISE create_pp_lot_err;
3508: END IF;
3509: UPDATE gme_lab_batch_lots
3510: SET attribute27 = 'M'

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

3528: p_token2 => 'MSG',
3529: p_param2 => l_msg_data);
3530: ROLLBACK;
3531: WHEN create_pp_lot_err THEN
3532: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE
3533: ,x_count => l_msg_cnt
3534: ,x_data => l_msg_data);
3535: l_txn_data := l_item_rec.segment1||'->'||get_lots.lot_id||'->'||get_lots.qty||'->'||get_lots.qty2;
3536: l_new_data := l_item_rec.segment1||'->'||l_lot_number||'->'||get_lots.qty||'->'||get_lots.qty2;