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

144: ,x_user_id => l_user_id);
145:
146: IF NVL(l_user_id, -1) < 0
147: THEN
148: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',
149: 'l_user_name', p_user_name);
150: RAISE FND_API.G_EXC_ERROR;
151:
152: ELSE

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

150: RAISE FND_API.G_EXC_ERROR;
151:
152: ELSE
153: -- Added below for BUG 2711643. Hverddin
154: GMD_API_PUB.SET_USER_CONTEXT(p_user_id => l_user_id,
155: x_return_status => l_return_status);
156:
157: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
158: RAISE FND_API.G_EXC_ERROR;

Line 207: GMD_API_PUB.Log_Message('GMD_FAILED_TO_INSERT_ROW',

203: -- Insert SPEC
204: -- ===========
205: IF NOT GMD_Specifications_PVT.INSERT_ROW(p_spec => l_spec)
206: THEN
207: GMD_API_PUB.Log_Message('GMD_FAILED_TO_INSERT_ROW',
208: 'l_table_name', 'GMD_SPECIFICATIONS',
209: 'l_column_name', 'SPEC_ID',
210: 'l_key_value', l_spec.spec_id);
211: RAISE FND_API.G_EXC_ERROR;

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

219: -- =======================================================================
220: l_spec_id := p_spec_tests_tbl(1).spec_id;
221: IF l_spec_id is NULL
222: THEN
223: GMD_API_PUB.Log_Message('GMD_SPEC_ID_REQUIRED');
224: GMD_API_PUB.Log_Message('GMD_SPEC_TEST_REQUIRES_SPEC_ID');
225: RAISE FND_API.G_EXC_ERROR;
226: END IF;
227:

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

220: l_spec_id := p_spec_tests_tbl(1).spec_id;
221: IF l_spec_id is NULL
222: THEN
223: GMD_API_PUB.Log_Message('GMD_SPEC_ID_REQUIRED');
224: GMD_API_PUB.Log_Message('GMD_SPEC_TEST_REQUIRES_SPEC_ID');
225: RAISE FND_API.G_EXC_ERROR;
226: END IF;
227:
228: END IF;

Line 277: GMD_API_PUB.Log_Message('GMD_INCONSISTENT_SPEC_ID',

273: -- Validate that the spec_id's are all consistent. Must all belong to the same header
274: -- ===================================================================================
275: IF ( NVL(l_spec_tests.spec_id, l_spec.spec_id ) <> l_spec_id)
276: THEN
277: GMD_API_PUB.Log_Message('GMD_INCONSISTENT_SPEC_ID',
278: 'SPEC_ID', l_spec_tests.spec_id);
279: RAISE FND_API.G_EXC_ERROR;
280: END IF;
281:

Line 300: GMD_API_PUB.Log_Message('GMD_API_RECORD_IDENTIFIER',

296: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
297: -- Message detailing cause of validation failure is already on
298: -- the stack. But ensure the precise record is identified
299: -- ==========================================================
300: GMD_API_PUB.Log_Message('GMD_API_RECORD_IDENTIFIER',
301: 'l_table_name', 'GMD_SPEC_TESTS',
302: 'l_column_name', 'TEST_ID',
303: 'l_key_value', l_spec_tests.test_id);
304: RAISE FND_API.G_EXC_ERROR;

Line 316: GMD_API_PUB.Log_Message('GMD_FAILED_TO_INSERT_ROW',

312: l_spec_tests.last_updated_by := l_user_id;
313:
314: IF NOT GMD_SPEC_TESTS_PVT.INSERT_ROW(p_spec_tests => l_spec_tests)
315: THEN
316: GMD_API_PUB.Log_Message('GMD_FAILED_TO_INSERT_ROW',
317: 'l_table_name', 'GMD_SPEC_TESTS',
318: 'l_column_name', 'TEST_ID',
319: 'l_key_value', l_spec_tests.test_id);
320: RAISE FND_API.G_EXC_ERROR;

Line 343: GMD_API_PUB.Log_Message('GMD_API_RECORD_IDENTIFIER',

339: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
340: -- Message detailing cause of validation failure is already on
341: -- the stack. But ensure the precise record is identified
342: -- ==========================================================
343: GMD_API_PUB.Log_Message('GMD_API_RECORD_IDENTIFIER',
344: 'l_table_name', 'GMD_SPECIFICATIONS',
345: 'l_column_name', 'SPEC_NAME',
346: 'l_key_value', l_spec.spec_name);
347: RAISE FND_API.G_EXC_ERROR;

Line 467: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',

463: ,x_user_id => l_spec.last_updated_by);
464:
465: IF NVL(l_spec.last_updated_by, -1) < 0
466: THEN
467: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME',
468: 'l_user_name', p_user_name);
469: RAISE FND_API.G_EXC_ERROR;
470: ELSE
471: -- Added below for BUG 2711643. Hverddin

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

468: 'l_user_name', p_user_name);
469: RAISE FND_API.G_EXC_ERROR;
470: ELSE
471: -- Added below for BUG 2711643. Hverddin
472: GMD_API_PUB.SET_USER_CONTEXT(p_user_id => l_spec.last_updated_by,
473: x_return_status => l_return_status);
474:
475: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
476: RAISE FND_API.G_EXC_ERROR;

Line 498: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

494: IF NOT GMD_Specifications_PVT.Lock_Row(p_spec.spec_id)
495: THEN
496: -- Report Failure to obtain locks
497: -- ==============================
498: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
499: 'l_table_name', 'GMD_SPECIFICATIONS',
500: 'l_column_name', 'SPEC_ID',
501: 'l_key_value', p_spec.spec_id);
502: RAISE FND_API.G_EXC_ERROR;

Line 510: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',

506: , p_last_update_date => sysdate
507: , p_last_updated_by => l_spec.last_updated_by
508: )
509: THEN
510: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',
511: 'l_table_name', 'GMD_SPECIFICATIONS',
512: 'l_column_name', 'SPEC_ID',
513: 'l_key_value', p_spec.spec_id);
514: ELSE -- Report one row successfully delete marked

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

633: -- =====================================
634: IF ( l_spec_tests.spec_id IS NULL )
635: THEN
636: -- raise validation error
637: GMD_API_PUB.Log_Message('GMD_SPEC_ID_REQUIRED');
638: RAISE FND_API.G_EXC_ERROR;
639: END IF;
640:
641: -- First loop only ,validate the owning SPEC

Line 666: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

662: IF NOT GMD_Specifications_PVT.Lock_Row(l_spec_tests.spec_id)
663: THEN
664: -- Report Failure to obtain locks
665: -- ==============================
666: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
667: 'l_table_name', 'GMD_SPECIFICATIONS',
668: 'l_column_name', 'SPEC_ID',
669: 'l_key_value', l_spec_tests.spec_id);
670: RAISE FND_API.G_EXC_ERROR;

Line 677: GMD_API_PUB.Log_Message('GMD_SUPPLY_CONSISTENT_SPEC_IDS',

673: -- All spec_tests must relate to the same owning spec
674: -- ==================================================
675: ELSIF l_spec_id <> l_spec_tests.spec_id
676: THEN
677: GMD_API_PUB.Log_Message('GMD_SUPPLY_CONSISTENT_SPEC_IDS',
678: 'SPEC_ID1', l_spec_id,
679: 'SPEC_ID2', l_spec_tests.spec_id);
680: RAISE FND_API.G_EXC_ERROR;
681: END IF; -- end of spec validation

Line 688: GMD_API_PUB.Log_Message('GMD_FAILED_TO_FETCH_ROW',

684: -- ================================
685: -- KYH 05/NOV/02 use separate params for fetch_row input and output
686: IF NOT GMD_SPEC_TESTS_PVT.fetch_row ( l_spec_tests,l_spec_tests_out)
687: THEN
688: GMD_API_PUB.Log_Message('GMD_FAILED_TO_FETCH_ROW',
689: 'l_table_name', 'GMD_SPEC_TESTS',
690: 'l_column_name', 'TEST_ID',
691: 'l_key_value', l_spec_tests.test_id);
692: RAISE FND_API.G_EXC_ERROR;

Line 702: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

698: IF NOT GMD_SPEC_TESTS_PVT.Lock_Row(l_spec_tests.spec_id,l_spec_tests.test_id)
699: THEN
700: -- Report Failure to obtain locks
701: -- ==============================
702: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
703: 'l_table_name', 'GMD_SPEC_TESTS',
704: 'l_column_name', 'TEST_ID',
705: 'l_key_value', l_spec_tests.test_id);
706: RAISE FND_API.G_EXC_ERROR;

Line 713: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',

709: IF NOT GMD_SPEC_TESTS_PVT.Delete_Row ( p_spec_id => l_spec_tests.spec_id
710: , p_test_id => l_spec_tests.test_id
711: )
712: THEN
713: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',
714: 'l_table_name', 'GMD_SPEC_TESTS',
715: 'l_column_name', 'TEST_ID',
716: 'l_key_value', l_spec_tests.test_id);
717: RAISE FND_API.G_EXC_ERROR;