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.GMD_SPEC_VRS_PUB dependencies on GMD_API_PUB

Line 122: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',

118: ,x_user_id => l_user_id);
119:
120: IF NVL(l_user_id, -1) < 0
121: THEN
122: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',
123: 'l_user_name', p_user_name);
124: RAISE FND_API.G_EXC_ERROR;
125: END IF;
126:

Line 301: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',

297: ,x_user_id => l_user_id);
298:
299: IF NVL(l_user_id, -1) < 0
300: THEN
301: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',
302: 'l_user_name', p_user_name);
303: RAISE FND_API.G_EXC_ERROR;
304: END IF;
305:

Line 476: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',

472: ,x_user_id => l_user_id);
473:
474: IF NVL(l_user_id, -1) < 0
475: THEN
476: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',
477: 'l_user_name', p_user_name);
478: RAISE FND_API.G_EXC_ERROR;
479: END IF;
480:

Line 646: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',

642: ,x_user_id => l_user_id);
643:
644: IF NVL(l_user_id, -1) < 0
645: THEN
646: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',
647: 'l_user_name', p_user_name);
648: RAISE FND_API.G_EXC_ERROR;
649: END IF;
650:

Line 821: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',

817: ,x_user_id => l_user_id);
818:
819: IF NVL(l_user_id, -1) < 0
820: THEN
821: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',
822: 'l_user_name', p_user_name);
823: RAISE FND_API.G_EXC_ERROR;
824: END IF;
825:

Line 1012: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',

1008: ,x_user_id => l_spec.last_updated_by);
1009:
1010: IF NVL(l_spec.last_updated_by, -1) < 0
1011: THEN
1012: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',
1013: 'l_user_name', p_user_name);
1014: RAISE FND_API.G_EXC_ERROR;
1015: END IF;
1016:

Line 1026: GMD_API_PUB.Log_Message('GMD_SPEC_ID_REQUIRED');

1022: -- =====================================
1023: IF ( l_inventory_spec_vrs.spec_id IS NULL )
1024: THEN
1025: -- raise validation error
1026: GMD_API_PUB.Log_Message('GMD_SPEC_ID_REQUIRED');
1027: RAISE FND_API.G_EXC_ERROR;
1028: END IF;
1029:
1030: -- Retrieve and validate the owning SPEC if it is not already retrieved/validated

Line 1050: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

1046: IF NOT GMD_Specifications_PVT.Lock_Row(l_inventory_spec_vrs.spec_id)
1047: THEN
1048: -- Report Failure to obtain locks
1049: -- ==============================
1050: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
1051: 'l_table_name', 'GMD_SPECIFICATIONS',
1052: 'l_column_name', 'SPEC_ID',
1053: 'l_key_value', l_inventory_spec_vrs.spec_id);
1054: RAISE FND_API.G_EXC_ERROR;

Line 1078: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

1074: IF NOT GMD_INVENTORY_SPEC_VRS_PVT.Lock_Row( l_inventory_spec_vrs.spec_vr_id)
1075: THEN
1076: -- Report Failure to obtain locks
1077: -- ==============================
1078: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
1079: 'l_table_name', 'GMD_INVENTORY_SPEC_VRS',
1080: 'l_column_name', 'SPEC_VR_ID',
1081: 'l_key_value', l_inventory_spec_vrs.spec_vr_id);
1082: RAISE FND_API.G_EXC_ERROR;

Line 1091: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',

1087: , p_last_update_date => sysdate
1088: , p_last_updated_by => l_spec.last_updated_by
1089: )
1090: THEN
1091: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',
1092: 'l_table_name', 'GMD_INVENTORY_SPEC_VRS',
1093: 'l_column_name', 'SPEC_VR_ID',
1094: 'l_key_value', l_inventory_spec_vrs.spec_vr_id);
1095: fnd_msg_pub.ADD;

Line 1229: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',

1225: ,x_user_id => l_spec.last_updated_by);
1226:
1227: IF NVL(l_spec.last_updated_by, -1) < 0
1228: THEN
1229: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',
1230: 'l_user_name', p_user_name);
1231: RAISE FND_API.G_EXC_ERROR;
1232: END IF;
1233:

Line 1243: GMD_API_PUB.Log_Message('GMD_SPEC_ID_REQUIRED');

1239: -- =====================================
1240: IF ( l_wip_spec_vrs.spec_id IS NULL )
1241: THEN
1242: -- raise validation error
1243: GMD_API_PUB.Log_Message('GMD_SPEC_ID_REQUIRED');
1244: RAISE FND_API.G_EXC_ERROR;
1245: END IF;
1246:
1247: -- Retrieve and validate the owning SPEC if it is not already retrieved/validated

Line 1267: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

1263: IF NOT GMD_Specifications_PVT.Lock_Row(l_wip_spec_vrs.spec_id)
1264: THEN
1265: -- Report Failure to obtain locks
1266: -- ==============================
1267: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
1268: 'l_table_name', 'GMD_SPECIFICATIONS',
1269: 'l_column_name', 'SPEC_ID',
1270: 'l_key_value', l_wip_spec_vrs.spec_id);
1271: RAISE FND_API.G_EXC_ERROR;

Line 1294: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

1290: IF NOT GMD_WIP_SPEC_VRS_PVT.Lock_Row( l_wip_spec_vrs.spec_vr_id)
1291: THEN
1292: -- Report Failure to obtain locks
1293: -- ==============================
1294: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
1295: 'l_table_name', 'GMD_WIP_SPEC_VRS',
1296: 'l_column_name', 'SPEC_VR_ID',
1297: 'l_key_value', l_wip_spec_vrs.spec_vr_id);
1298: RAISE FND_API.G_EXC_ERROR;

Line 1306: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',

1302: , p_last_update_date => sysdate
1303: , p_last_updated_by => l_spec.last_updated_by
1304: )
1305: THEN
1306: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',
1307: 'l_table_name', 'GMD_WIP_SPEC_VRS',
1308: 'l_column_name', 'SPEC_VR_ID',
1309: 'l_key_value', l_wip_spec_vrs.spec_vr_id);
1310: RAISE FND_API.G_EXC_ERROR;

Line 1443: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',

1439: ,x_user_id => l_spec.last_updated_by);
1440:
1441: IF NVL(l_spec.last_updated_by, -1) < 0
1442: THEN
1443: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',
1444: 'l_user_name', p_user_name);
1445: RAISE FND_API.G_EXC_ERROR;
1446: END IF;
1447:

Line 1457: GMD_API_PUB.Log_Message('GMD_SPEC_ID_REQUIRED');

1453: -- =====================================
1454: IF ( l_customer_spec_vrs.spec_id IS NULL )
1455: THEN
1456: -- raise validation error
1457: GMD_API_PUB.Log_Message('GMD_SPEC_ID_REQUIRED');
1458: RAISE FND_API.G_EXC_ERROR;
1459: END IF;
1460:
1461: -- Retrieve and validate the owning SPEC if it is not already retrieved/validated

Line 1481: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

1477: IF NOT GMD_Specifications_PVT.Lock_Row(l_customer_spec_vrs.spec_id)
1478: THEN
1479: -- Report Failure to obtain locks
1480: -- ==============================
1481: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
1482: 'l_table_name', 'GMD_SPECIFICATIONS',
1483: 'l_column_name', 'SPEC_ID',
1484: 'l_key_value', l_customer_spec_vrs.spec_id);
1485: RAISE FND_API.G_EXC_ERROR;

Line 1508: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

1504: IF NOT GMD_CUSTOMER_SPEC_VRS_PVT.Lock_Row( l_customer_spec_vrs.spec_vr_id)
1505: THEN
1506: -- Report Failure to obtain locks
1507: -- ==============================
1508: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
1509: 'l_table_name', 'GMD_CUSTOMER_SPEC_VRS',
1510: 'l_column_name', 'SPEC_VR_ID',
1511: 'l_key_value', l_customer_spec_vrs.spec_vr_id);
1512: RAISE FND_API.G_EXC_ERROR;

Line 1521: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',

1517: , p_last_update_date => sysdate
1518: , p_last_updated_by => l_spec.last_updated_by
1519: )
1520: THEN
1521: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',
1522: 'l_table_name', 'GMD_CUSTOMER_SPEC_VRS',
1523: 'l_column_name', 'SPEC_VR_ID',
1524: 'l_key_value', l_customer_spec_vrs.spec_vr_id);
1525: RAISE FND_API.G_EXC_ERROR;

Line 1657: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',

1653: ,x_user_id => l_spec.last_updated_by);
1654:
1655: IF NVL(l_spec.last_updated_by, -1) < 0
1656: THEN
1657: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',
1658: 'l_user_name', p_user_name);
1659: RAISE FND_API.G_EXC_ERROR;
1660: END IF;
1661:

Line 1671: GMD_API_PUB.Log_Message('GMD_SPEC_ID_REQUIRED');

1667: -- =====================================
1668: IF ( l_supplier_spec_vrs.spec_id IS NULL )
1669: THEN
1670: -- raise validation error
1671: GMD_API_PUB.Log_Message('GMD_SPEC_ID_REQUIRED');
1672: RAISE FND_API.G_EXC_ERROR;
1673: END IF;
1674:
1675: -- Retrieve and validate the owning SPEC if it is not already retrieved/validated

Line 1695: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

1691: IF NOT GMD_Specifications_PVT.Lock_Row(l_supplier_spec_vrs.spec_id)
1692: THEN
1693: -- Report Failure to obtain locks
1694: -- ==============================
1695: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
1696: 'l_table_name', 'GMD_SPECIFICATIONS',
1697: 'l_column_name', 'SPEC_ID',
1698: 'l_key_value', l_supplier_spec_vrs.spec_id);
1699: RAISE FND_API.G_EXC_ERROR;

Line 1722: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

1718: IF NOT GMD_SUPPLIER_SPEC_VRS_PVT.Lock_Row( l_supplier_spec_vrs.spec_vr_id)
1719: THEN
1720: -- Report Failure to obtain locks
1721: -- ==============================
1722: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
1723: 'l_table_name', 'GMD_SUPPLIER_SPEC_VRS',
1724: 'l_column_name', 'SPEC_VR_ID',
1725: 'l_key_value', l_supplier_spec_vrs.spec_vr_id);
1726: RAISE FND_API.G_EXC_ERROR;

Line 1735: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',

1731: , p_last_update_date => sysdate
1732: , p_last_updated_by => l_spec.last_updated_by
1733: )
1734: THEN
1735: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',
1736: 'l_table_name', 'GMD_SUPPLIER_SPEC_VRS',
1737: 'l_column_name', 'SPEC_VR_ID',
1738: 'l_key_value', l_supplier_spec_vrs.spec_vr_id);
1739: RAISE FND_API.G_EXC_ERROR;

Line 1873: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',

1869: ,x_user_id => l_spec.last_updated_by);
1870:
1871: IF NVL(l_spec.last_updated_by, -1) < 0
1872: THEN
1873: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',
1874: 'l_user_name', p_user_name);
1875: RAISE FND_API.G_EXC_ERROR;
1876: END IF;
1877:

Line 1887: GMD_API_PUB.Log_Message('GMD_SPEC_ID_REQUIRED');

1883: -- =====================================
1884: IF ( l_monitoring_spec_vrs.spec_id IS NULL )
1885: THEN
1886: -- raise validation error
1887: GMD_API_PUB.Log_Message('GMD_SPEC_ID_REQUIRED');
1888: RAISE FND_API.G_EXC_ERROR;
1889: END IF;
1890:
1891: -- Retrieve and validate the owning SPEC if it is not already retrieved/validated

Line 1911: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

1907: IF NOT GMD_Specifications_PVT.Lock_Row(l_monitoring_spec_vrs.spec_id)
1908: THEN
1909: -- Report Failure to obtain locks
1910: -- ==============================
1911: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
1912: 'l_table_name', 'GMD_SPECIFICATIONS',
1913: 'l_column_name', 'SPEC_ID',
1914: 'l_key_value', l_monitoring_spec_vrs.spec_id);
1915: RAISE FND_API.G_EXC_ERROR;

Line 1939: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

1935: IF NOT GMD_MONITORING_SPEC_VRS_PVT.Lock_Row( l_monitoring_spec_vrs.spec_vr_id)
1936: THEN
1937: -- Report Failure to obtain locks
1938: -- ==============================
1939: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
1940: 'l_table_name', 'GMD_monitoring_SPEC_VRS',
1941: 'l_column_name', 'SPEC_VR_ID',
1942: 'l_key_value', l_monitoring_spec_vrs.spec_vr_id);
1943: RAISE FND_API.G_EXC_ERROR;

Line 1952: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',

1948: , p_last_update_date => sysdate
1949: , p_last_updated_by => l_spec.last_updated_by
1950: )
1951: THEN
1952: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',
1953: 'l_table_name', 'GMD_MONITORING_SPEC_VRS',
1954: 'l_column_name', 'SPEC_VR_ID',
1955: 'l_key_value', l_monitoring_spec_vrs.spec_vr_id);
1956: RAISE FND_API.G_EXC_ERROR;