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

Line 125: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME','l_user_name', p_user_name);

121: ,x_user_id => l_user_id);
122:
123: IF NVL(l_user_id, -1) < 0
124: THEN
125: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME','l_user_name', p_user_name);
126: RAISE FND_API.G_EXC_ERROR;
127: ELSE
128: -- Added below for BUG 2711643. Hverddin
129: GMD_API_PUB.SET_USER_CONTEXT(p_user_id => l_user_id,

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

125: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME','l_user_name', p_user_name);
126: RAISE FND_API.G_EXC_ERROR;
127: ELSE
128: -- Added below for BUG 2711643. Hverddin
129: GMD_API_PUB.SET_USER_CONTEXT(p_user_id => l_user_id,
130: x_return_status => l_return_status);
131:
132: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
133: RAISE FND_API.G_EXC_ERROR;

Line 155: GMD_API_PUB.LOG_MESSAGE('GMD_API_NO_ACTION_REQUIRED');

151: IF ( NOT G_PROCESS_TESTS ) AND ( NOT G_PROCESS_VALUES )
152: AND ( NOT G_PROCESS_CUSTOMERS) THEN
153:
154: -- Raise Error No Validate Parameters Defined
155: GMD_API_PUB.LOG_MESSAGE('GMD_API_NO_ACTION_REQUIRED');
156: RAISE FND_API.G_EXC_ERROR;
157: END IF;
158:
159:

Line 175: GMD_API_PUB.log_message('SY_WFDUPLICATE');

171: IF gmd_qc_tests_grp.test_group_order_exist(
172: p_init_msg_list,
173: p_qc_tests_rec.test_class,
174: p_qc_tests_rec.test_group_order) THEN
175: GMD_API_PUB.log_message('SY_WFDUPLICATE');
176: RAISE FND_API.G_EXC_ERROR;
177: END IF;
178: END IF;
179:

Line 229: GMD_API_PUB.log_message('GMD_TEST_ID_CODE_NULL');

225: -- Only Processing Values
226:
227: -- Get The Test Record For The Values Specified
228: IF ( p_qc_test_values_tbl(1).test_id IS NULL ) THEN
229: GMD_API_PUB.log_message('GMD_TEST_ID_CODE_NULL');
230: RAISE FND_API.G_EXC_ERROR;
231: END IF;
232:
233: l_qc_tests_rec_in.test_id := p_qc_test_values_tbl(1).test_id;

Line 247: GMD_API_PUB.log_message('GMD_INVALID_TEST_TYPE',

243: -- Validate Test Type For Test Record
244:
245: IF l_qc_tests_rec.test_type in ('U','N','E') THEN
246: -- GIVE AN ERROR No Test Values Allowed For These Test Types
247: GMD_API_PUB.log_message('GMD_INVALID_TEST_TYPE',
248: 'TEST_TYPE',l_qc_tests_rec.test_type); /* Bug 350233 - Use of rec variable rather than l_test_type local variable*/
249: RAISE FND_API.G_EXC_ERROR;
250: END IF;
251:

Line 263: GMD_API_PUB.log_message('GMD_TEST_ID_CODE_NULL');

259: l_qc_test_values_rec_in.test_id := l_qc_tests_rec.test_id;
260: END IF;
261:
262: IF l_qc_test_values_rec_in.test_id IS NULL THEN
263: GMD_API_PUB.log_message('GMD_TEST_ID_CODE_NULL');
264: RAISE FND_API.G_EXC_ERROR;
265: END IF;
266:
267: -- Validate that the test_id's are all the same, we can only

Line 272: GMD_API_PUB.log_message('GMD_INVALID_VALUES_TEST', 'TEST_CODE',

268: -- process values for the same test.
269:
270: IF l_qc_test_values_rec_in.test_id <> l_qc_tests_rec.test_id THEN
271: -- Set error message
272: GMD_API_PUB.log_message('GMD_INVALID_VALUES_TEST', 'TEST_CODE',
273: l_qc_tests_rec.test_code );
274: RAISE FND_API.G_EXC_ERROR;
275: END IF;
276:

Line 333: GMD_API_PUB.log_message('GMD_TEST_ID_CODE_NULL');

329:
330: -- Get The Test Record For The Values Specified
331: IF ( p_qc_cust_tests_tbl(1).test_id IS NULL ) THEN
332: -- Error Message No Test Id Specified for Values Rec
333: GMD_API_PUB.log_message('GMD_TEST_ID_CODE_NULL');
334: RAISE FND_API.G_EXC_ERROR;
335: END IF;
336:
337: l_qc_tests_rec_in.test_id := p_qc_cust_tests_tbl(1).test_id;

Line 356: GMD_API_PUB.log_message('GMD_API_CUST_ID_NULL');

352:
353: l_qc_cust_tests_rec := p_qc_cust_tests_tbl(i);
354:
355: IF ( l_qc_cust_tests_rec.cust_id IS NULL ) THEN
356: GMD_API_PUB.log_message('GMD_API_CUST_ID_NULL');
357: RAISE FND_API.G_EXC_ERROR;
358: END IF;
359:
360: IF G_PROCESS_TESTS THEN

Line 365: GMD_API_PUB.log_message('GMD_TEST_ID_CODE_NULL');

361: l_qc_cust_tests_rec.test_id := l_qc_tests_rec.test_id;
362: END IF;
363:
364: IF l_qc_cust_tests_rec.test_id IS NULL THEN
365: GMD_API_PUB.log_message('GMD_TEST_ID_CODE_NULL');
366: RAISE FND_API.G_EXC_ERROR;
367: END IF;
368:
369: -- Validate that the test_id's are all the same,

Line 373: GMD_API_PUB.log_message('GMD_INVALID_VALUES_TEST', 'TEST_CODE',

369: -- Validate that the test_id's are all the same,
370: -- we can only update values for the same test.
371:
372: IF l_qc_cust_tests_rec.test_id <> l_qc_tests_rec.test_id THEN
373: GMD_API_PUB.log_message('GMD_INVALID_VALUES_TEST', 'TEST_CODE',
374: l_qc_tests_rec.test_code );
375: RAISE FND_API.G_EXC_ERROR;
376:
377: END IF;

Line 511: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME','l_user_name', p_user_name);

507: ,x_user_id => l_user_id);
508:
509: IF NVL(l_user_id, -1) < 0
510: THEN
511: GMD_API_PUB.Log_Message('GMD_INVALID_USER_NAME','l_user_name', p_user_name);
512: RAISE FND_API.G_EXC_ERROR;
513: ELSE
514:
515: -- Added below for BUG 2711643. Hverddin

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

512: RAISE FND_API.G_EXC_ERROR;
513: ELSE
514:
515: -- Added below for BUG 2711643. Hverddin
516: GMD_API_PUB.SET_USER_CONTEXT(p_user_id => l_user_id,
517: x_return_status => l_return_status);
518:
519: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
520: RAISE FND_API.G_EXC_ERROR;

Line 529: GMD_API_PUB.log_message('GMD_TEST_ID_CODE_NULL');

525: -- Check Required Fields Present
526:
527: IF ( l_qc_tests_rec_in.test_code IS NULL ) AND
528: ( l_qc_tests_rec_in.test_id IS NULL ) THEN
529: GMD_API_PUB.log_message('GMD_TEST_ID_CODE_NULL');
530: RAISE FND_API.G_EXC_ERROR;
531: END IF;
532:
533: -- Fetch the Test Header Row.

Line 544: GMD_API_PUB.Log_Message('GMD_RECORD_DELETE_MARKED',

540:
541: -- Validate that the Test Header is Not Already Marked For Purge
542:
543: IF l_qc_tests_rec.delete_mark = 1 THEN
544: GMD_API_PUB.Log_Message('GMD_RECORD_DELETE_MARKED',
545: 'l_table_name', 'GMD_QC_TESTS',
546: 'l_column_name', 'TEST_ID',
547: 'l_key_value', l_qc_tests_rec.test_id);
548:

Line 559: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

555: IF NOT GMD_QC_TESTS_PVT.lock_row
556: ( p_test_id => l_qc_tests_rec.test_id,
557: p_test_code => l_qc_tests_rec.test_code
558: ) THEN
559: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
560: 'l_table_name', 'GMD_QC_TESTS',
561: 'l_column_name','TEST_ID',
562: 'l_key_value', l_qc_tests_rec.test_id);
563:

Line 575: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',

571: p_last_update_date => SYSDATE,
572: p_last_updated_by => l_user_id,
573: p_last_update_login => l_qc_tests_rec.last_update_login
574: ) THEN
575: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',
576: 'l_table_name', 'GMD_QC_TESTS',
577: 'l_column_name','TEST_ID',
578: 'l_key_value', l_qc_tests_rec.test_id);
579:

Line 683: GMD_API_PUB.LOG_MESSAGE('GMD_API_NO_ACTION_REQUIRED');

679:
680: -- Check That input Table is Populated
681:
682: IF p_qc_test_values_tbl.COUNT = 0 THEN
683: GMD_API_PUB.LOG_MESSAGE('GMD_API_NO_ACTION_REQUIRED');
684: RAISE FND_API.G_EXC_ERROR;
685: END IF;
686:
687:

Line 692: GMD_API_PUB.log_message('GMD_TEST_ID_CODE_NULL');

688: -- Since we can only delete values associated to one test
689: -- Get the test record based on first value record.
690:
691: IF p_qc_test_values_tbl(1).test_id IS NULL THEN
692: GMD_API_PUB.log_message('GMD_TEST_ID_CODE_NULL');
693: RAISE FND_API.G_EXC_ERROR;
694: ELSE
695: l_qc_tests_rec_in.test_id := p_qc_test_values_tbl(1).test_id;
696: END IF;

Line 711: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

707:
708: IF NOT GMD_QC_TESTS_PVT.lock_row(
709: p_test_id => l_qc_tests_rec.test_id,
710: p_test_code => l_qc_tests_rec.test_code) THEN
711: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
712: 'l_table_name', 'GMD_QC_TESTS',
713: 'l_column_name','TEST_ID',
714: 'l_key_value', l_qc_tests_rec.test_id);
715:

Line 728: GMD_API_PUB.log_message('GMD_TEST_VALUE_ID_REQ');

724: l_qc_test_values_rec := p_qc_test_values_tbl(i);
725:
726: IF l_qc_test_values_rec.test_value_id is NULL THEN
727: -- Raise Error No Validate Parameters Defined
728: GMD_API_PUB.log_message('GMD_TEST_VALUE_ID_REQ');
729: RAISE FND_API.G_EXC_ERROR;
730: END IF;
731:
732: IF l_qc_test_values_rec.test_id is NULL THEN

Line 734: GMD_API_PUB.log_message('GMD_TEST_ID_CODE_NULL');

730: END IF;
731:
732: IF l_qc_test_values_rec.test_id is NULL THEN
733: -- Raise Error No Validate Parameters Defined
734: GMD_API_PUB.log_message('GMD_TEST_ID_CODE_NULL');
735: RAISE FND_API.G_EXC_ERROR;
736: END IF;
737:
738: -- Check that the test_id's being processed are consistant

Line 740: GMD_API_PUB.log_message('GMD_INVALID_VALUES_TEST', 'TEST_CODE',

736: END IF;
737:
738: -- Check that the test_id's being processed are consistant
739: IF l_qc_tests_rec.test_id <> l_qc_test_values_rec.test_id THEN
740: GMD_API_PUB.log_message('GMD_INVALID_VALUES_TEST', 'TEST_CODE',
741: l_qc_tests_rec.test_code );
742: RAISE FND_API.G_EXC_ERROR;
743: END IF;
744:

Line 760: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

756: -- Lock the Value Row.
757:
758: IF NOT GMD_QC_TEST_VALUES_PVT.LOCK_ROW(
759: p_test_value_id => l_qc_test_values_rec.test_value_id) THEN
760: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
761: 'l_table_name', 'GMD_QC_TEST_VALUES',
762: 'l_column_name','TEST_VALUE_ID',
763: 'l_key_value', l_qc_test_values_rec.test_value_id);
764:

Line 773: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',

769: -- Delete the Value Row.
770:
771: IF NOT GMD_QC_TEST_VALUES_PVT.DELETE_ROW(
772: p_test_value_id => l_qc_test_values_rec.test_value_id) THEN
773: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',
774: 'l_table_name', 'GMD_QC_TEST_VALUES',
775: 'l_column_name', 'TEST_VALUE_ID',
776: 'l_key_value', l_qc_test_values_rec.test_value_id);
777:

Line 897: GMD_API_PUB.log_message('GMD_TEST_ID_CODE_NULL');

893: -- Since we can only delete customer values associated to one test
894: -- Get the test record based on first customer value record.
895:
896: IF p_qc_cust_tests_tbl(1).test_id IS NULL THEN
897: GMD_API_PUB.log_message('GMD_TEST_ID_CODE_NULL');
898: RAISE FND_API.G_EXC_ERROR;
899: ELSE
900: l_qc_tests_rec_in.test_id := p_qc_cust_tests_tbl(1).test_id;
901: END IF;

Line 916: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

912:
913: IF NOT GMD_QC_TESTS_PVT.lock_row(
914: p_test_id => l_qc_tests_rec.test_id,
915: p_test_code => l_qc_tests_rec.test_code) THEN
916: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
917: 'l_table_name', 'GMD_QC_TESTS',
918: 'l_column_name','TEST_ID',
919: 'l_key_value', l_qc_tests_rec.test_id);
920:

Line 930: GMD_API_PUB.log_message('GMD_TEST_ID_CODE_NULL');

926:
927: l_qc_cust_tests_rec := p_qc_cust_tests_tbl(i);
928:
929: IF l_qc_cust_tests_rec.test_id is NULL THEN
930: GMD_API_PUB.log_message('GMD_TEST_ID_CODE_NULL');
931: RAISE FND_API.G_EXC_ERROR;
932: END IF;
933:
934: IF l_qc_cust_tests_rec.cust_id is NULL THEN

Line 935: GMD_API_PUB.log_message('GMD_API_CUST_ID_NULL');

931: RAISE FND_API.G_EXC_ERROR;
932: END IF;
933:
934: IF l_qc_cust_tests_rec.cust_id is NULL THEN
935: GMD_API_PUB.log_message('GMD_API_CUST_ID_NULL');
936: RAISE FND_API.G_EXC_ERROR;
937: END IF;
938:
939: -- Check that the test_id's being processed are consistant

Line 942: GMD_API_PUB.log_message('GMD_INVALID_VALUES_TEST', 'TEST_CODE',

938:
939: -- Check that the test_id's being processed are consistant
940:
941: IF l_qc_tests_rec.test_id <> l_qc_cust_tests_rec.test_id THEN
942: GMD_API_PUB.log_message('GMD_INVALID_VALUES_TEST', 'TEST_CODE',
943: l_qc_tests_rec.test_code );
944: RAISE FND_API.G_EXC_ERROR;
945: END IF;
946:

Line 966: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

962:
963: IF NOT GMD_CUSTOMER_TESTS_PVT.LOCK_ROW(
964: p_test_id => l_qc_cust_tests_rec.test_id,
965: p_cust_id => l_qc_cust_tests_rec.cust_id) THEN
966: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
967: 'l_table_name', 'GMD_CUSTOMER_TESTS',
968: 'l_column_name','CUST_ID',
969: 'l_key_value', l_qc_cust_tests_rec.cust_id);
970: RAISE FND_API.G_EXC_ERROR;

Line 979: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',

975: IF NOT GMD_CUSTOMER_TESTS_PVT.DELETE_ROW(
976: p_test_id => l_qc_cust_tests_rec.test_id,
977: p_cust_id => l_qc_cust_tests_rec.cust_id) THEN
978:
979: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',
980: 'l_table_name', 'GMD_CUSTOMER_TESTS',
981: 'l_column_name','CUST_ID',
982: 'l_key_value', l_qc_cust_tests_rec.cust_id);
983: