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_PUB dependencies on GMD_API_PUB

Line 160: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',

156: ,x_user_id => l_user_id);
157:
158: IF NVL(l_user_id, -1) < 0
159: THEN
160: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',
161: 'l_user_name', p_user_name);
162: RAISE FND_API.G_EXC_ERROR;
163:
164: ELSE

Line 166: GMD_API_PUB.SET_USER_CONTEXT(p_user_id => l_user_id,

162: RAISE FND_API.G_EXC_ERROR;
163:
164: ELSE
165: -- Added below for BUG 2711643. Hverddin
166: GMD_API_PUB.SET_USER_CONTEXT(p_user_id => l_user_id,
167: x_return_status => l_return_status);
168:
169: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
170: RAISE FND_API.G_EXC_ERROR;

Line 219: GMD_API_PUB.Log_Message('GMD_FAILED_TO_INSERT_ROW',

215: -- Insert SPEC
216: -- ===========
217: IF NOT GMD_Specifications_PVT.INSERT_ROW(p_spec => l_spec)
218: THEN
219: GMD_API_PUB.Log_Message('GMD_FAILED_TO_INSERT_ROW',
220: 'l_table_name', 'GMD_SPECIFICATIONS',
221: 'l_column_name', 'SPEC_ID',
222: 'l_key_value', l_spec.spec_id);
223: RAISE FND_API.G_EXC_ERROR;

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

231: -- =======================================================================
232: l_spec_id := p_spec_tests_tbl(1).spec_id;
233: IF l_spec_id is NULL
234: THEN
235: GMD_API_PUB.Log_Message('GMD_SPEC_ID_REQUIRED');
236: GMD_API_PUB.Log_Message('GMD_SPEC_TEST_REQUIRES_SPEC_ID');
237: RAISE FND_API.G_EXC_ERROR;
238: END IF;
239:

Line 236: GMD_API_PUB.Log_Message('GMD_SPEC_TEST_REQUIRES_SPEC_ID');

232: l_spec_id := p_spec_tests_tbl(1).spec_id;
233: IF l_spec_id is NULL
234: THEN
235: GMD_API_PUB.Log_Message('GMD_SPEC_ID_REQUIRED');
236: GMD_API_PUB.Log_Message('GMD_SPEC_TEST_REQUIRES_SPEC_ID');
237: RAISE FND_API.G_EXC_ERROR;
238: END IF;
239:
240: END IF;

Line 290: GMD_API_PUB.Log_Message('GMD_INCONSISTENT_SPEC_ID',

286: -- Validate that the spec_id's are all consistent. Must all belong to the same header
287: -- ===================================================================================
288: IF ( NVL(l_spec_tests.spec_id, l_spec.spec_id ) <> l_spec_id)
289: THEN
290: GMD_API_PUB.Log_Message('GMD_INCONSISTENT_SPEC_ID',
291: 'SPEC_ID', l_spec_tests.spec_id);
292: RAISE FND_API.G_EXC_ERROR;
293: END IF;
294:

Line 313: GMD_API_PUB.Log_Message('GMD_API_RECORD_IDENTIFIER',

309: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
310: -- Message detailing cause of validation failure is already on
311: -- the stack. But ensure the precise record is identified
312: -- ==========================================================
313: GMD_API_PUB.Log_Message('GMD_API_RECORD_IDENTIFIER',
314: 'l_table_name', 'GMD_SPEC_TESTS',
315: 'l_column_name', 'TEST_ID',
316: 'l_key_value', l_spec_tests.test_id);
317: RAISE FND_API.G_EXC_ERROR;

Line 329: GMD_API_PUB.Log_Message('GMD_FAILED_TO_INSERT_ROW',

325: l_spec_tests.last_updated_by := l_user_id;
326:
327: IF NOT GMD_SPEC_TESTS_PVT.INSERT_ROW(p_spec_tests => l_spec_tests)
328: THEN
329: GMD_API_PUB.Log_Message('GMD_FAILED_TO_INSERT_ROW',
330: 'l_table_name', 'GMD_SPEC_TESTS',
331: 'l_column_name', 'TEST_ID',
332: 'l_key_value', l_spec_tests.test_id);
333: RAISE FND_API.G_EXC_ERROR;

Line 356: GMD_API_PUB.Log_Message('GMD_API_RECORD_IDENTIFIER',

352: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
353: -- Message detailing cause of validation failure is already on
354: -- the stack. But ensure the precise record is identified
355: -- ==========================================================
356: GMD_API_PUB.Log_Message('GMD_API_RECORD_IDENTIFIER',
357: 'l_table_name', 'GMD_SPECIFICATIONS',
358: 'l_column_name', 'SPEC_NAME',
359: 'l_key_value', l_spec.spec_name);
360: RAISE FND_API.G_EXC_ERROR;

Line 480: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',

476: ,x_user_id => l_spec.last_updated_by);
477:
478: IF NVL(l_spec.last_updated_by, -1) < 0
479: THEN
480: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',
481: 'l_user_name', p_user_name);
482: RAISE FND_API.G_EXC_ERROR;
483: ELSE
484: -- Added below for BUG 2711643. Hverddin

Line 485: GMD_API_PUB.SET_USER_CONTEXT(p_user_id => l_spec.last_updated_by,

481: 'l_user_name', p_user_name);
482: RAISE FND_API.G_EXC_ERROR;
483: ELSE
484: -- Added below for BUG 2711643. Hverddin
485: GMD_API_PUB.SET_USER_CONTEXT(p_user_id => l_spec.last_updated_by,
486: x_return_status => l_return_status);
487:
488: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
489: RAISE FND_API.G_EXC_ERROR;

Line 511: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

507: IF NOT GMD_Specifications_PVT.Lock_Row(p_spec.spec_id)
508: THEN
509: -- Report Failure to obtain locks
510: -- ==============================
511: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
512: 'l_table_name', 'GMD_SPECIFICATIONS',
513: 'l_column_name', 'SPEC_ID',
514: 'l_key_value', p_spec.spec_id);
515: RAISE FND_API.G_EXC_ERROR;

Line 523: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',

519: , p_last_update_date => sysdate
520: , p_last_updated_by => l_spec.last_updated_by
521: )
522: THEN
523: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',
524: 'l_table_name', 'GMD_SPECIFICATIONS',
525: 'l_column_name', 'SPEC_ID',
526: 'l_key_value', p_spec.spec_id);
527: ELSE -- Report one row successfully delete marked

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

646: -- =====================================
647: IF ( l_spec_tests.spec_id IS NULL )
648: THEN
649: -- raise validation error
650: GMD_API_PUB.Log_Message('GMD_SPEC_ID_REQUIRED');
651: RAISE FND_API.G_EXC_ERROR;
652: END IF;
653:
654: -- First loop only ,validate the owning SPEC

Line 679: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

675: IF NOT GMD_Specifications_PVT.Lock_Row(l_spec_tests.spec_id)
676: THEN
677: -- Report Failure to obtain locks
678: -- ==============================
679: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
680: 'l_table_name', 'GMD_SPECIFICATIONS',
681: 'l_column_name', 'SPEC_ID',
682: 'l_key_value', l_spec_tests.spec_id);
683: RAISE FND_API.G_EXC_ERROR;

Line 690: GMD_API_PUB.Log_Message('GMD_SUPPLY_CONSISTENT_SPEC_IDS',

686: -- All spec_tests must relate to the same owning spec
687: -- ==================================================
688: ELSIF l_spec_id <> l_spec_tests.spec_id
689: THEN
690: GMD_API_PUB.Log_Message('GMD_SUPPLY_CONSISTENT_SPEC_IDS',
691: 'SPEC_ID1', l_spec_id,
692: 'SPEC_ID2', l_spec_tests.spec_id);
693: RAISE FND_API.G_EXC_ERROR;
694: END IF; -- end of spec validation

Line 701: GMD_API_PUB.Log_Message('GMD_FAILED_TO_FETCH_ROW',

697: -- ================================
698: -- KYH 05/NOV/02 use separate params for fetch_row input and output
699: IF NOT GMD_SPEC_TESTS_PVT.fetch_row ( l_spec_tests,l_spec_tests_out)
700: THEN
701: GMD_API_PUB.Log_Message('GMD_FAILED_TO_FETCH_ROW',
702: 'l_table_name', 'GMD_SPEC_TESTS',
703: 'l_column_name', 'TEST_ID',
704: 'l_key_value', l_spec_tests.test_id);
705: RAISE FND_API.G_EXC_ERROR;

Line 715: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

711: IF NOT GMD_SPEC_TESTS_PVT.Lock_Row(l_spec_tests.spec_id,l_spec_tests.test_id)
712: THEN
713: -- Report Failure to obtain locks
714: -- ==============================
715: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
716: 'l_table_name', 'GMD_SPEC_TESTS',
717: 'l_column_name', 'TEST_ID',
718: 'l_key_value', l_spec_tests.test_id);
719: RAISE FND_API.G_EXC_ERROR;

Line 726: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',

722: IF NOT GMD_SPEC_TESTS_PVT.Delete_Row ( p_spec_id => l_spec_tests.spec_id
723: , p_test_id => l_spec_tests.test_id
724: )
725: THEN
726: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',
727: 'l_table_name', 'GMD_SPEC_TESTS',
728: 'l_column_name', 'TEST_ID',
729: 'l_key_value', l_spec_tests.test_id);
730: RAISE FND_API.G_EXC_ERROR;