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 124: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',

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

Line 305: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',

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

Line 482: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',

478: ,x_user_id => l_user_id);
479:
480: IF NVL(l_user_id, -1) < 0
481: THEN
482: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',
483: 'l_user_name', p_user_name);
484: RAISE FND_API.G_EXC_ERROR;
485: END IF;
486:

Line 654: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',

650: ,x_user_id => l_user_id);
651:
652: IF NVL(l_user_id, -1) < 0
653: THEN
654: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',
655: 'l_user_name', p_user_name);
656: RAISE FND_API.G_EXC_ERROR;
657: END IF;
658:

Line 831: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',

827: ,x_user_id => l_user_id);
828:
829: IF NVL(l_user_id, -1) < 0
830: THEN
831: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',
832: 'l_user_name', p_user_name);
833: RAISE FND_API.G_EXC_ERROR;
834: END IF;
835:

Line 1024: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',

1020: ,x_user_id => l_spec.last_updated_by);
1021:
1022: IF NVL(l_spec.last_updated_by, -1) < 0
1023: THEN
1024: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',
1025: 'l_user_name', p_user_name);
1026: RAISE FND_API.G_EXC_ERROR;
1027: END IF;
1028:

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

1034: -- =====================================
1035: IF ( l_inventory_spec_vrs.spec_id IS NULL )
1036: THEN
1037: -- raise validation error
1038: GMD_API_PUB.Log_Message('GMD_SPEC_ID_REQUIRED');
1039: RAISE FND_API.G_EXC_ERROR;
1040: END IF;
1041:
1042: -- Retrieve and validate the owning SPEC if it is not already retrieved/validated

Line 1062: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

1058: IF NOT GMD_Specifications_PVT.Lock_Row(l_inventory_spec_vrs.spec_id)
1059: THEN
1060: -- Report Failure to obtain locks
1061: -- ==============================
1062: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
1063: 'l_table_name', 'GMD_SPECIFICATIONS',
1064: 'l_column_name', 'SPEC_ID',
1065: 'l_key_value', l_inventory_spec_vrs.spec_id);
1066: RAISE FND_API.G_EXC_ERROR;

Line 1090: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

1086: IF NOT GMD_INVENTORY_SPEC_VRS_PVT.Lock_Row( l_inventory_spec_vrs.spec_vr_id)
1087: THEN
1088: -- Report Failure to obtain locks
1089: -- ==============================
1090: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
1091: 'l_table_name', 'GMD_INVENTORY_SPEC_VRS',
1092: 'l_column_name', 'SPEC_VR_ID',
1093: 'l_key_value', l_inventory_spec_vrs.spec_vr_id);
1094: RAISE FND_API.G_EXC_ERROR;

Line 1103: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',

1099: , p_last_update_date => sysdate
1100: , p_last_updated_by => l_spec.last_updated_by
1101: )
1102: THEN
1103: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',
1104: 'l_table_name', 'GMD_INVENTORY_SPEC_VRS',
1105: 'l_column_name', 'SPEC_VR_ID',
1106: 'l_key_value', l_inventory_spec_vrs.spec_vr_id);
1107: fnd_msg_pub.ADD;

Line 1241: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',

1237: ,x_user_id => l_spec.last_updated_by);
1238:
1239: IF NVL(l_spec.last_updated_by, -1) < 0
1240: THEN
1241: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',
1242: 'l_user_name', p_user_name);
1243: RAISE FND_API.G_EXC_ERROR;
1244: END IF;
1245:

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

1251: -- =====================================
1252: IF ( l_wip_spec_vrs.spec_id IS NULL )
1253: THEN
1254: -- raise validation error
1255: GMD_API_PUB.Log_Message('GMD_SPEC_ID_REQUIRED');
1256: RAISE FND_API.G_EXC_ERROR;
1257: END IF;
1258:
1259: -- Retrieve and validate the owning SPEC if it is not already retrieved/validated

Line 1279: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

1275: IF NOT GMD_Specifications_PVT.Lock_Row(l_wip_spec_vrs.spec_id)
1276: THEN
1277: -- Report Failure to obtain locks
1278: -- ==============================
1279: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
1280: 'l_table_name', 'GMD_SPECIFICATIONS',
1281: 'l_column_name', 'SPEC_ID',
1282: 'l_key_value', l_wip_spec_vrs.spec_id);
1283: RAISE FND_API.G_EXC_ERROR;

Line 1306: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

1302: IF NOT GMD_WIP_SPEC_VRS_PVT.Lock_Row( l_wip_spec_vrs.spec_vr_id)
1303: THEN
1304: -- Report Failure to obtain locks
1305: -- ==============================
1306: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
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 1318: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',

1314: , p_last_update_date => sysdate
1315: , p_last_updated_by => l_spec.last_updated_by
1316: )
1317: THEN
1318: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',
1319: 'l_table_name', 'GMD_WIP_SPEC_VRS',
1320: 'l_column_name', 'SPEC_VR_ID',
1321: 'l_key_value', l_wip_spec_vrs.spec_vr_id);
1322: RAISE FND_API.G_EXC_ERROR;

Line 1455: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',

1451: ,x_user_id => l_spec.last_updated_by);
1452:
1453: IF NVL(l_spec.last_updated_by, -1) < 0
1454: THEN
1455: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',
1456: 'l_user_name', p_user_name);
1457: RAISE FND_API.G_EXC_ERROR;
1458: END IF;
1459:

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

1465: -- =====================================
1466: IF ( l_customer_spec_vrs.spec_id IS NULL )
1467: THEN
1468: -- raise validation error
1469: GMD_API_PUB.Log_Message('GMD_SPEC_ID_REQUIRED');
1470: RAISE FND_API.G_EXC_ERROR;
1471: END IF;
1472:
1473: -- Retrieve and validate the owning SPEC if it is not already retrieved/validated

Line 1493: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

1489: IF NOT GMD_Specifications_PVT.Lock_Row(l_customer_spec_vrs.spec_id)
1490: THEN
1491: -- Report Failure to obtain locks
1492: -- ==============================
1493: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
1494: 'l_table_name', 'GMD_SPECIFICATIONS',
1495: 'l_column_name', 'SPEC_ID',
1496: 'l_key_value', l_customer_spec_vrs.spec_id);
1497: RAISE FND_API.G_EXC_ERROR;

Line 1520: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

1516: IF NOT GMD_CUSTOMER_SPEC_VRS_PVT.Lock_Row( l_customer_spec_vrs.spec_vr_id)
1517: THEN
1518: -- Report Failure to obtain locks
1519: -- ==============================
1520: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
1521: 'l_table_name', 'GMD_CUSTOMER_SPEC_VRS',
1522: 'l_column_name', 'SPEC_VR_ID',
1523: 'l_key_value', l_customer_spec_vrs.spec_vr_id);
1524: RAISE FND_API.G_EXC_ERROR;

Line 1533: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',

1529: , p_last_update_date => sysdate
1530: , p_last_updated_by => l_spec.last_updated_by
1531: )
1532: THEN
1533: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',
1534: 'l_table_name', 'GMD_CUSTOMER_SPEC_VRS',
1535: 'l_column_name', 'SPEC_VR_ID',
1536: 'l_key_value', l_customer_spec_vrs.spec_vr_id);
1537: RAISE FND_API.G_EXC_ERROR;

Line 1669: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',

1665: ,x_user_id => l_spec.last_updated_by);
1666:
1667: IF NVL(l_spec.last_updated_by, -1) < 0
1668: THEN
1669: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',
1670: 'l_user_name', p_user_name);
1671: RAISE FND_API.G_EXC_ERROR;
1672: END IF;
1673:

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

1679: -- =====================================
1680: IF ( l_supplier_spec_vrs.spec_id IS NULL )
1681: THEN
1682: -- raise validation error
1683: GMD_API_PUB.Log_Message('GMD_SPEC_ID_REQUIRED');
1684: RAISE FND_API.G_EXC_ERROR;
1685: END IF;
1686:
1687: -- Retrieve and validate the owning SPEC if it is not already retrieved/validated

Line 1707: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

1703: IF NOT GMD_Specifications_PVT.Lock_Row(l_supplier_spec_vrs.spec_id)
1704: THEN
1705: -- Report Failure to obtain locks
1706: -- ==============================
1707: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
1708: 'l_table_name', 'GMD_SPECIFICATIONS',
1709: 'l_column_name', 'SPEC_ID',
1710: 'l_key_value', l_supplier_spec_vrs.spec_id);
1711: RAISE FND_API.G_EXC_ERROR;

Line 1734: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

1730: IF NOT GMD_SUPPLIER_SPEC_VRS_PVT.Lock_Row( l_supplier_spec_vrs.spec_vr_id)
1731: THEN
1732: -- Report Failure to obtain locks
1733: -- ==============================
1734: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
1735: 'l_table_name', 'GMD_SUPPLIER_SPEC_VRS',
1736: 'l_column_name', 'SPEC_VR_ID',
1737: 'l_key_value', l_supplier_spec_vrs.spec_vr_id);
1738: RAISE FND_API.G_EXC_ERROR;

Line 1747: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',

1743: , p_last_update_date => sysdate
1744: , p_last_updated_by => l_spec.last_updated_by
1745: )
1746: THEN
1747: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',
1748: 'l_table_name', 'GMD_SUPPLIER_SPEC_VRS',
1749: 'l_column_name', 'SPEC_VR_ID',
1750: 'l_key_value', l_supplier_spec_vrs.spec_vr_id);
1751: RAISE FND_API.G_EXC_ERROR;

Line 1885: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',

1881: ,x_user_id => l_spec.last_updated_by);
1882:
1883: IF NVL(l_spec.last_updated_by, -1) < 0
1884: THEN
1885: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',
1886: 'l_user_name', p_user_name);
1887: RAISE FND_API.G_EXC_ERROR;
1888: END IF;
1889:

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

1895: -- =====================================
1896: IF ( l_monitoring_spec_vrs.spec_id IS NULL )
1897: THEN
1898: -- raise validation error
1899: GMD_API_PUB.Log_Message('GMD_SPEC_ID_REQUIRED');
1900: RAISE FND_API.G_EXC_ERROR;
1901: END IF;
1902:
1903: -- Retrieve and validate the owning SPEC if it is not already retrieved/validated

Line 1923: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

1919: IF NOT GMD_Specifications_PVT.Lock_Row(l_monitoring_spec_vrs.spec_id)
1920: THEN
1921: -- Report Failure to obtain locks
1922: -- ==============================
1923: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
1924: 'l_table_name', 'GMD_SPECIFICATIONS',
1925: 'l_column_name', 'SPEC_ID',
1926: 'l_key_value', l_monitoring_spec_vrs.spec_id);
1927: RAISE FND_API.G_EXC_ERROR;

Line 1951: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

1947: IF NOT GMD_MONITORING_SPEC_VRS_PVT.Lock_Row( l_monitoring_spec_vrs.spec_vr_id)
1948: THEN
1949: -- Report Failure to obtain locks
1950: -- ==============================
1951: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
1952: 'l_table_name', 'GMD_monitoring_SPEC_VRS',
1953: 'l_column_name', 'SPEC_VR_ID',
1954: 'l_key_value', l_monitoring_spec_vrs.spec_vr_id);
1955: RAISE FND_API.G_EXC_ERROR;

Line 1964: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',

1960: , p_last_update_date => sysdate
1961: , p_last_updated_by => l_spec.last_updated_by
1962: )
1963: THEN
1964: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',
1965: 'l_table_name', 'GMD_MONITORING_SPEC_VRS',
1966: 'l_column_name', 'SPEC_VR_ID',
1967: 'l_key_value', l_monitoring_spec_vrs.spec_vr_id);
1968: RAISE FND_API.G_EXC_ERROR;