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 315: raise FND_API.G_EXC_ERROR;

311: p_param4 => NULL,
312: p_param5 => NULL,
313: p_db_error => NULL,
314: p_app_short_name => 'GMI');
315: raise FND_API.G_EXC_ERROR;
316: END IF;
317:
318:
319: l_enabled_flag := 'Y';

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

361: migrated_ind = 1
362: WHERE
363: inv_type = l_inv_type.inv_type;
364:
365: IF (p_commit <> FND_API.G_FALSE) THEN
366: COMMIT;
367: END IF;
368: l_migrate_count := l_migrate_count + 1;
369: EXCEPTION

Line 370: WHEN FND_API.G_EXC_ERROR THEN

366: COMMIT;
367: END IF;
368: l_migrate_count := l_migrate_count + 1;
369: EXCEPTION
370: WHEN FND_API.G_EXC_ERROR THEN
371: NULL; -- Move to the next record.
372: END;
373: END LOOP;
374:

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

504: UPDATE gmi_category_sets
505: SET migrated_ind = 1
506: WHERE opm_class = c.opm_class;
507:
508: IF (p_commit <> FND_API.G_FALSE) THEN
509: COMMIT;
510: END IF;
511: l_migrate_count := l_migrate_count + 1;
512: EXCEPTION

Line 835: raise FND_API.G_EXC_ERROR;

831: p_param4 => NULL,
832: p_param5 => NULL,
833: p_db_error => NULL,
834: p_app_short_name => 'GMI');
835: raise FND_API.G_EXC_ERROR;
836: END IF;
837:
838: SELECT mtl_material_status_s.NEXTVAL
839: INTO l_status_id

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

945: migrated_ind = 1
946: WHERE
947: lot_status = l_lot_status.lot_status;
948:
949: IF (p_commit <> FND_API.G_FALSE) THEN
950: COMMIT;
951: END IF;
952: l_migrate_count := l_migrate_count + 1;
953: EXCEPTION

Line 954: WHEN FND_API.G_EXC_ERROR THEN

950: COMMIT;
951: END IF;
952: l_migrate_count := l_migrate_count + 1;
953: EXCEPTION
954: WHEN FND_API.G_EXC_ERROR THEN
955: NULL; -- Move to the next record.
956: END;
957: END LOOP;
958:

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

1132: UPDATE gmd_actions_b
1133: SET migrated_ind = 1
1134: WHERE action_code = g.action_code;
1135:
1136: IF (p_commit <> FND_API.G_FALSE) THEN
1137: COMMIT;
1138: END IF;
1139: l_migrate_count := l_migrate_count + 1;
1140: EXCEPTION

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

1320: UPDATE gmd_grades_b
1321: SET migrated_ind = 1
1322: WHERE qc_grade = g.qc_grade;
1323:
1324: IF (p_commit <> FND_API.G_FALSE) THEN
1325: COMMIT;
1326: END IF;
1327: l_migrate_count := l_migrate_count + 1;
1328: EXCEPTION

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

1474: X_LAST_UPDATED_BY => 0,
1475: X_LAST_UPDATE_LOGIN => NULL);
1476:
1477:
1478: IF (p_commit <> FND_API.G_FALSE) THEN
1479: COMMIT;
1480: END IF;
1481: l_migrate_count := l_migrate_count + 1;
1482: EXCEPTION

Line 1640: raise FND_API.G_EXC_ERROR;

1636: p_param4 => NULL,
1637: p_param5 => NULL,
1638: p_db_error => NULL,
1639: p_app_short_name => 'GMI');
1640: raise FND_API.G_EXC_ERROR;
1641: END IF;
1642:
1643: l_field_name := 'From UOM data';
1644: l_field_value := 'Organization = '||to_char(c.organization_id)||', Item Id = '||to_char(l_inventory_item_id);

Line 1697: raise FND_API.G_EXC_ERROR;

1693: p_param4 => l_from_uom_class,
1694: p_param5 => c.um_type,
1695: p_db_error => NULL,
1696: p_app_short_name => 'GMI');
1697: raise FND_API.G_EXC_ERROR;
1698: END IF;
1699:
1700: SELECT MTL_CONVERSION_ID_S.NEXTVAL INTO l_conversion_id FROM DUAL;
1701:

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

1809: p_param4 => NULL,
1810: p_param5 => NULL,
1811: p_db_error => NULL,
1812: p_app_short_name => 'GMI');
1813: RAISE FND_API.G_EXC_ERROR; -- Skip this conversion
1814: END IF;
1815:
1816: -- Get the Locator id
1817: l_field_name := 'Loctor Id';

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

1846: p_param4 => NULL,
1847: p_param5 => NULL,
1848: p_db_error => NULL,
1849: p_app_short_name => 'GMI');
1850: RAISE FND_API.G_EXC_ERROR; -- Skip this conversion
1851: END IF;
1852: EXCEPTION
1853: WHEN NO_DATA_FOUND THEN
1854: -- Create locator in discrete ( dynamic locator)

Line 1863: p_commit => FND_API.G_TRUE,

1859: p_subinventory_code => adetail.whse_code,
1860: p_location => adetail.location,
1861: p_loct_desc => adetail.location,
1862: p_start_date_active => adetail.creation_date,
1863: p_commit => FND_API.G_TRUE,
1864: x_location_id => l_locator_id,
1865: x_failure_count => l_failure_count,
1866: p_segment2 => NULL,
1867: p_segment3 => NULL,

Line 1902: raise FND_API.G_EXC_ERROR;

1898: p_param4 => NULL,
1899: p_param5 => NULL,
1900: p_db_error => NULL,
1901: p_app_short_name => 'GMI');
1902: raise FND_API.G_EXC_ERROR;
1903: END IF;
1904: END;
1905: END IF;
1906:

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

1956: item_id = c.item_id AND
1957: organization_id = c.organization_id AND
1958: lot_number = c.lot_number;
1959:
1960: IF (p_commit <> FND_API.G_FALSE) THEN
1961: COMMIT;
1962: END IF;
1963: l_migrate_count := l_migrate_count + 1;
1964: EXCEPTION

Line 1982: WHEN FND_API.G_EXC_ERROR THEN

1978: p_param5 => NULL,
1979: p_db_error => NULL,
1980: p_app_short_name => 'GMI');
1981: x_failure_count := x_failure_count + 1;
1982: WHEN FND_API.G_EXC_ERROR THEN
1983: ROLLBACK;
1984: x_failure_count := x_failure_count + 1;
1985: NULL; -- Skip to the next row.
1986: END;

Line 2452: p_commit => FND_API.G_TRUE,

2448: p_migration_run_id => p_migration_run_id,
2449: p_item_id => bal.item_id,
2450: p_organization_id => l_organization_id,
2451: p_mode => '',
2452: p_commit => FND_API.G_TRUE,
2453: x_inventory_item_id => l_inventory_item_id,
2454: x_failure_count => l_failure_count);
2455: IF (l_failure_count > 0) THEN
2456: -- Log Error

Line 2471: raise FND_API.G_EXC_ERROR;

2467: p_param4 => NULL,
2468: p_param5 => NULL,
2469: p_db_error => NULL,
2470: p_app_short_name => 'GMI');
2471: raise FND_API.G_EXC_ERROR;
2472: END IF;
2473:
2474: l_field_name := 'OPM Item attributes';
2475: l_field_value := 'OPM item id = '||to_char(bal.item_id);

Line 2498: raise FND_API.G_EXC_ERROR;

2494: p_param4 => NULL,
2495: p_param5 => NULL,
2496: p_db_error => NULL,
2497: p_app_short_name => 'GMI');
2498: raise FND_API.G_EXC_ERROR;
2499: END IF;
2500:
2501: -- Get the discrete lot number
2502: l_lot_number := NULL;

Line 2514: p_commit => FND_API.G_TRUE,

2510: p_lot_id => bal.lot_id,
2511: p_whse_code => bal.whse_code,
2512: p_orgn_code => NULL,
2513: p_location => bal.location,
2514: p_commit => FND_API.G_TRUE,
2515: x_lot_number => l_lot_number,
2516: x_parent_lot_number => l_parent_lot_number,
2517: x_failure_count => l_failure_count);
2518:

Line 2535: raise FND_API.G_EXC_ERROR;

2531: p_param4 => bal.location,
2532: p_param5 => NULL,
2533: p_db_error => NULL,
2534: p_app_short_name => 'GMI');
2535: raise FND_API.G_EXC_ERROR;
2536: END IF;
2537: END IF;
2538:
2539: -- Get the loctor id

Line 2576: raise FND_API.G_EXC_ERROR;

2572: p_param4 => NULL,
2573: p_param5 => NULL,
2574: p_db_error => NULL,
2575: p_app_short_name => 'GMI');
2576: raise FND_API.G_EXC_ERROR;
2577: END IF;
2578:
2579: EXCEPTION
2580: WHEN NO_DATA_FOUND THEN

Line 2599: p_commit => FND_API.G_TRUE,

2595: p_subinventory_code => l_subinventory_code,
2596: p_location => bal.location,
2597: p_loct_desc => bal.location,
2598: p_start_date_active => bal.creation_date,
2599: p_commit => FND_API.G_TRUE,
2600: x_location_id => l_locator_id,
2601: x_failure_count => l_failure_count,
2602: p_segment2 => NULL,
2603: p_segment3 => NULL,

Line 2637: raise FND_API.G_EXC_ERROR;

2633: p_param4 => NULL,
2634: p_param5 => NULL,
2635: p_db_error => NULL,
2636: p_app_short_name => 'GMI');
2637: raise FND_API.G_EXC_ERROR;
2638: END IF;
2639: END;
2640: END IF;
2641:

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

2716: x_line_row_tbl => o_line_row_tbl,
2717: x_lot_row_tbl => o_lot_row_tbl,
2718: x_transaction_set_id => l_transaction_set_id);
2719:
2720: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2721: -- dbms_output.put_line ('Balance migration failed for item, whse, lot, location'||l_item_no||', '||bal.whse_code||', '||l_lot_number||', '||bal.location);
2722: GMA_COMMON_LOGGING.gma_migration_central_log (
2723: p_run_id => p_migration_run_id,
2724: p_log_level => FND_LOG.LEVEL_ERROR,

Line 2753: RAISE FND_API.G_EXC_ERROR;

2749: p_param5 => NULL,
2750: p_db_error => NULL,
2751: p_app_short_name => 'GMI');
2752: END LOOP;
2753: RAISE FND_API.G_EXC_ERROR;
2754: END IF;
2755:
2756: -- Update the discrete transactions as costed
2757: UPDATE mtl_material_transactions

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

2768: WHERE
2769: rowid = bal.rowid;
2770:
2771: l_migrate_count := l_migrate_count + 1;
2772: IF (p_commit <> FND_API.G_FALSE) THEN
2773: COMMIT;
2774: END IF;
2775: EXCEPTION
2776: WHEN NO_DATA_FOUND THEN

Line 2801: WHEN FND_API.G_EXC_ERROR THEN

2797: l_skip_to_next_whse := 1;
2798: END IF;
2799: -- ROLLBACK TO bal_migration_start;
2800: ROLLBACK ;
2801: WHEN FND_API.G_EXC_ERROR THEN
2802: x_failure_count := x_failure_count + 1;
2803: -- ROLLBACK TO bal_migration_start;
2804: ROLLBACK ;
2805: END;