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.INV_GMI_MIGRATION dependencies on FND_API

Line 354: raise FND_API.G_EXC_ERROR;

350: p_param4 => NULL,
351: p_param5 => NULL,
352: p_db_error => NULL,
353: p_app_short_name => 'GMI');
354: raise FND_API.G_EXC_ERROR;
355: END IF;
356:
357:
358: l_enabled_flag := 'Y';

Line 404: IF (p_commit <> FND_API.G_FALSE) THEN

400: migrated_ind = 1
401: WHERE
402: inv_type = l_inv_type.inv_type;
403:
404: IF (p_commit <> FND_API.G_FALSE) THEN
405: COMMIT;
406: END IF;
407: l_migrate_count := l_migrate_count + 1;
408: EXCEPTION

Line 409: WHEN FND_API.G_EXC_ERROR THEN

405: COMMIT;
406: END IF;
407: l_migrate_count := l_migrate_count + 1;
408: EXCEPTION
409: WHEN FND_API.G_EXC_ERROR THEN
410: NULL; -- Move to the next record.
411: END;
412: END LOOP;
413:

Line 547: IF (p_commit <> FND_API.G_FALSE) THEN

543: UPDATE gmi_category_sets
544: SET migrated_ind = 1
545: WHERE opm_class = c.opm_class;
546:
547: IF (p_commit <> FND_API.G_FALSE) THEN
548: COMMIT;
549: END IF;
550: l_migrate_count := l_migrate_count + 1;
551: EXCEPTION

Line 897: IF (p_commit <> FND_API.G_FALSE) THEN

893: AND rownum = 1),
894: migrated_ind = 1
895: WHERE lot_status = l_lot_status.lot_status;
896:
897: IF (p_commit <> FND_API.G_FALSE) THEN
898: COMMIT;
899: END IF;
900:
901: l_migrate_count := l_migrate_count + 1;

Line 921: raise FND_API.G_EXC_ERROR;

917: p_param4 => NULL,
918: p_param5 => NULL,
919: p_db_error => NULL,
920: p_app_short_name => 'GMI');
921: raise FND_API.G_EXC_ERROR;
922: END IF;
923:
924: SELECT mtl_material_status_s.NEXTVAL
925: INTO l_status_id

Line 1041: IF (p_commit <> FND_API.G_FALSE) THEN

1037: migrated_ind = 1
1038: WHERE
1039: lot_status = l_lot_status.lot_status;
1040:
1041: IF (p_commit <> FND_API.G_FALSE) THEN
1042: COMMIT;
1043: END IF;
1044: l_migrate_count := l_migrate_count + 1;
1045: EXCEPTION

Line 1046: WHEN FND_API.G_EXC_ERROR THEN

1042: COMMIT;
1043: END IF;
1044: l_migrate_count := l_migrate_count + 1;
1045: EXCEPTION
1046: WHEN FND_API.G_EXC_ERROR THEN
1047: NULL; -- Move to the next record.
1048: END;
1049: END LOOP;
1050:

Line 1228: IF (p_commit <> FND_API.G_FALSE) THEN

1224: UPDATE gmd_actions_b
1225: SET migrated_ind = 1
1226: WHERE action_code = g.action_code;
1227:
1228: IF (p_commit <> FND_API.G_FALSE) THEN
1229: COMMIT;
1230: END IF;
1231: l_migrate_count := l_migrate_count + 1;
1232: EXCEPTION

Line 1416: IF (p_commit <> FND_API.G_FALSE) THEN

1412: UPDATE gmd_grades_b
1413: SET migrated_ind = 1
1414: WHERE qc_grade = g.qc_grade;
1415:
1416: IF (p_commit <> FND_API.G_FALSE) THEN
1417: COMMIT;
1418: END IF;
1419: l_migrate_count := l_migrate_count + 1;
1420: EXCEPTION

Line 1570: IF (p_commit <> FND_API.G_FALSE) THEN

1566: X_LAST_UPDATED_BY => 0,
1567: X_LAST_UPDATE_LOGIN => NULL);
1568:
1569:
1570: IF (p_commit <> FND_API.G_FALSE) THEN
1571: COMMIT;
1572: END IF;
1573: l_migrate_count := l_migrate_count + 1;
1574: EXCEPTION

Line 1732: raise FND_API.G_EXC_ERROR;

1728: p_param4 => NULL,
1729: p_param5 => NULL,
1730: p_db_error => NULL,
1731: p_app_short_name => 'GMI');
1732: raise FND_API.G_EXC_ERROR;
1733: END IF;
1734:
1735: l_field_name := 'From UOM data';
1736: l_field_value := 'Organization = '||to_char(c.organization_id)||', Item Id = '||to_char(l_inventory_item_id);

Line 1789: raise FND_API.G_EXC_ERROR;

1785: p_param4 => l_from_uom_class,
1786: p_param5 => c.um_type,
1787: p_db_error => NULL,
1788: p_app_short_name => 'GMI');
1789: raise FND_API.G_EXC_ERROR;
1790: END IF;
1791:
1792: SELECT MTL_CONVERSION_ID_S.NEXTVAL INTO l_conversion_id FROM DUAL;
1793:

Line 1905: RAISE FND_API.G_EXC_ERROR; -- Skip this conversion

1901: p_param4 => NULL,
1902: p_param5 => NULL,
1903: p_db_error => NULL,
1904: p_app_short_name => 'GMI');
1905: RAISE FND_API.G_EXC_ERROR; -- Skip this conversion
1906: END IF;
1907:
1908: -- Get the Locator id
1909: l_field_name := 'Loctor Id';

Line 1942: RAISE FND_API.G_EXC_ERROR; -- Skip this conversion

1938: p_param4 => NULL,
1939: p_param5 => NULL,
1940: p_db_error => NULL,
1941: p_app_short_name => 'GMI');
1942: RAISE FND_API.G_EXC_ERROR; -- Skip this conversion
1943: END IF;
1944: EXCEPTION
1945: WHEN NO_DATA_FOUND THEN
1946: -- Create locator in discrete ( dynamic locator)

Line 1955: p_commit => FND_API.G_TRUE,

1951: p_subinventory_code => adetail.whse_code,
1952: p_location => adetail.location,
1953: p_loct_desc => adetail.location,
1954: p_start_date_active => adetail.creation_date,
1955: p_commit => FND_API.G_TRUE,
1956: x_location_id => l_locator_id,
1957: x_failure_count => l_failure_count,
1958: p_segment2 => NULL,
1959: p_segment3 => NULL,

Line 1994: raise FND_API.G_EXC_ERROR;

1990: p_param4 => NULL,
1991: p_param5 => NULL,
1992: p_db_error => NULL,
1993: p_app_short_name => 'GMI');
1994: raise FND_API.G_EXC_ERROR;
1995: END IF;
1996: END;
1997: END IF;
1998:

Line 2052: IF (p_commit <> FND_API.G_FALSE) THEN

2048: item_id = c.item_id AND
2049: organization_id = c.organization_id AND
2050: lot_number = c.lot_number;
2051:
2052: IF (p_commit <> FND_API.G_FALSE) THEN
2053: COMMIT;
2054: END IF;
2055: l_migrate_count := l_migrate_count + 1;
2056: EXCEPTION

Line 2074: WHEN FND_API.G_EXC_ERROR THEN

2070: p_param5 => NULL,
2071: p_db_error => NULL,
2072: p_app_short_name => 'GMI');
2073: x_failure_count := x_failure_count + 1;
2074: WHEN FND_API.G_EXC_ERROR THEN
2075: ROLLBACK;
2076: x_failure_count := x_failure_count + 1;
2077: NULL; -- Skip to the next row.
2078: END;

Line 2566: p_commit => FND_API.G_TRUE,

2562: p_migration_run_id => p_migration_run_id,
2563: p_item_id => bal.item_id,
2564: p_organization_id => l_organization_id,
2565: p_mode => '',
2566: p_commit => FND_API.G_TRUE,
2567: x_inventory_item_id => l_inventory_item_id,
2568: x_failure_count => l_failure_count);
2569: IF (l_failure_count > 0) THEN
2570: -- Log Error

Line 2585: raise FND_API.G_EXC_ERROR;

2581: p_param4 => NULL,
2582: p_param5 => NULL,
2583: p_db_error => NULL,
2584: p_app_short_name => 'GMI');
2585: raise FND_API.G_EXC_ERROR;
2586: END IF;
2587:
2588: l_field_name := 'OPM Item attributes';
2589: l_field_value := 'OPM item id = '||to_char(bal.item_id);

Line 2613: raise FND_API.G_EXC_ERROR;

2609: p_param4 => NULL,
2610: p_param5 => NULL,
2611: p_db_error => NULL,
2612: p_app_short_name => 'GMI');
2613: raise FND_API.G_EXC_ERROR;
2614: END IF;
2615:
2616: -- Get the discrete lot number
2617: l_lot_number := NULL;

Line 2629: p_commit => FND_API.G_TRUE,

2625: p_lot_id => bal.lot_id,
2626: p_whse_code => bal.whse_code,
2627: p_orgn_code => NULL,
2628: p_location => bal.location,
2629: p_commit => FND_API.G_TRUE,
2630: x_lot_number => l_lot_number,
2631: x_parent_lot_number => l_parent_lot_number,
2632: x_failure_count => l_failure_count);
2633:

Line 2650: raise FND_API.G_EXC_ERROR;

2646: p_param4 => bal.location,
2647: p_param5 => NULL,
2648: p_db_error => NULL,
2649: p_app_short_name => 'GMI');
2650: raise FND_API.G_EXC_ERROR;
2651: END IF;
2652: END IF;
2653:
2654: -- Get the loctor id

Line 2696: raise FND_API.G_EXC_ERROR;

2692: p_param4 => NULL,
2693: p_param5 => NULL,
2694: p_db_error => NULL,
2695: p_app_short_name => 'GMI');
2696: raise FND_API.G_EXC_ERROR;
2697: END IF;
2698:
2699: EXCEPTION
2700: WHEN NO_DATA_FOUND THEN

Line 2719: p_commit => FND_API.G_TRUE,

2715: p_subinventory_code => l_subinventory_code,
2716: p_location => bal.location,
2717: p_loct_desc => bal.location,
2718: p_start_date_active => bal.creation_date,
2719: p_commit => FND_API.G_TRUE,
2720: x_location_id => l_locator_id,
2721: x_failure_count => l_failure_count,
2722: p_segment2 => NULL,
2723: p_segment3 => NULL,

Line 2757: raise FND_API.G_EXC_ERROR;

2753: p_param4 => NULL,
2754: p_param5 => NULL,
2755: p_db_error => NULL,
2756: p_app_short_name => 'GMI');
2757: raise FND_API.G_EXC_ERROR;
2758: END IF;
2759: END;
2760: END IF;
2761:

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

2836: x_line_row_tbl => o_line_row_tbl,
2837: x_lot_row_tbl => o_lot_row_tbl,
2838: x_transaction_set_id => l_transaction_set_id);
2839:
2840: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2841: -- dbms_output.put_line ('Balance migration failed for item, whse, lot, location'||l_item_no||', '||bal.whse_code||', '||l_lot_number||', '||bal.location);
2842: GMA_COMMON_LOGGING.gma_migration_central_log (
2843: p_run_id => p_migration_run_id,
2844: p_log_level => FND_LOG.LEVEL_ERROR,

Line 2873: RAISE FND_API.G_EXC_ERROR;

2869: p_param5 => NULL,
2870: p_db_error => NULL,
2871: p_app_short_name => 'GMI');
2872: END LOOP;
2873: RAISE FND_API.G_EXC_ERROR;
2874: END IF;
2875: /*
2876: -- Update the discrete transactions as costed
2877: UPDATE mtl_material_transactions

Line 2892: IF (p_commit <> FND_API.G_FALSE) THEN

2888: WHERE
2889: rowid = bal.rowid;
2890:
2891: l_migrate_count := l_migrate_count + 1;
2892: IF (p_commit <> FND_API.G_FALSE) THEN
2893: COMMIT;
2894: END IF;
2895: EXCEPTION
2896: WHEN NO_DATA_FOUND THEN

Line 2921: WHEN FND_API.G_EXC_ERROR THEN

2917: l_skip_to_next_whse := 1;
2918: END IF;
2919: -- ROLLBACK TO bal_migration_start;
2920: ROLLBACK ;
2921: WHEN FND_API.G_EXC_ERROR THEN
2922: x_failure_count := x_failure_count + 1;
2923: -- ROLLBACK TO bal_migration_start;
2924: ROLLBACK ;
2925: END;