APPS.GMD_SPEC_GRP dependencies on GMD_API_PUB

Line 141: GMD_API_PUB.Log_Message('GMD_SPEC_NAME_REQD');

137: x_return_status := FND_API.G_RET_STS_SUCCESS;
138:
139: -- Spec Name
140: IF (ltrim(rtrim(p_spec_header.spec_name)) IS NULL) THEN
141: GMD_API_PUB.Log_Message('GMD_SPEC_NAME_REQD');
142: RAISE FND_API.G_EXC_ERROR;
143: END IF;
144:
145: -- Spec Vers

Line 147: GMD_API_PUB.Log_Message('GMD_SPEC_VERS_REQD');

143: END IF;
144:
145: -- Spec Vers
146: IF (p_spec_header.spec_vers IS NULL) THEN
147: GMD_API_PUB.Log_Message('GMD_SPEC_VERS_REQD');
148: RAISE FND_API.G_EXC_ERROR;
149: ELSIF (p_spec_header.spec_vers < 0) THEN
150: GMD_API_PUB.Log_Message('GMD_SPEC_VERS_INVALID');
151: RAISE FND_API.G_EXC_ERROR;

Line 150: GMD_API_PUB.Log_Message('GMD_SPEC_VERS_INVALID');

146: IF (p_spec_header.spec_vers IS NULL) THEN
147: GMD_API_PUB.Log_Message('GMD_SPEC_VERS_REQD');
148: RAISE FND_API.G_EXC_ERROR;
149: ELSIF (p_spec_header.spec_vers < 0) THEN
150: GMD_API_PUB.Log_Message('GMD_SPEC_VERS_INVALID');
151: RAISE FND_API.G_EXC_ERROR;
152: END IF;
153:
154: --Spec Type (Bug 3451973)

Line 158: GMD_API_PUB.Log_Message('GMD_SPEC_TYPE_NOT_FOUND');

154: --Spec Type (Bug 3451973)
155: IF (p_spec_header.spec_type in ('M', 'I')) THEN
156: null ;
157: else
158: GMD_API_PUB.Log_Message('GMD_SPEC_TYPE_NOT_FOUND');
159: RAISE FND_API.G_EXC_ERROR;
160: end if;
161:
162: -- Item ID

Line 166: GMD_API_PUB.Log_Message('GMD_SPEC_ITEM_REQD');

162: -- Item ID
163: IF (p_spec_header.inventory_item_id IS NULL)
164: and (p_spec_header.spec_type = 'I') -- Bug 3401368: this is only for item specs
165: THEN
166: GMD_API_PUB.Log_Message('GMD_SPEC_ITEM_REQD');
167: RAISE FND_API.G_EXC_ERROR;
168: ELSE
169: -- Get the Item No
170: OPEN c_item(p_spec_header.inventory_item_id, p_spec_header.owner_organization_id);

Line 175: GMD_API_PUB.Log_Message('GMD_SPEC_ITEM_NOT_FOUND');

171: FETCH c_item INTO x_item_number,l_grade_ctl;
172: IF (c_item%NOTFOUND) and (p_spec_header.spec_type = 'I') -- Bug 3401368: this is only for item specs
173: THEN
174: CLOSE c_item;
175: GMD_API_PUB.Log_Message('GMD_SPEC_ITEM_NOT_FOUND');
176: RAISE FND_API.G_EXC_ERROR;
177: END IF;
178: CLOSE c_item;
179: END IF;

Line 194: GMD_API_PUB.Log_Message('GMD_SPEC_REVISION_NOT_FOUND',

190: FETCH c_revision INTO dummy;
191: IF c_revision%NOTFOUND THEN
192: CLOSE c_revision;
193: CLOSE c_rev_ctrl;
194: GMD_API_PUB.Log_Message('GMD_SPEC_REVISION_NOT_FOUND',
195: 'REVISION', p_spec_header.revision);
196: RAISE FND_API.G_EXC_ERROR;
197: END IF; --c_revision%NOTFOUND
198: CLOSE c_revision;

Line 201: GMD_API_PUB.Log_Message('GMD_SPEC_NOT_REVISION_CTRL');

197: END IF; --c_revision%NOTFOUND
198: CLOSE c_revision;
199: ELSIF dummy = 1 THEN --The item is not a revision controlled item
200: CLOSE c_rev_ctrl;
201: GMD_API_PUB.Log_Message('GMD_SPEC_NOT_REVISION_CTRL');
202: RAISE FND_API.G_EXC_ERROR;
203: END IF; --dummy = 2
204: CLOSE c_rev_ctrl;
205: END IF; --(p_spec_header.revision IS NOT NULL)

Line 210: GMD_API_PUB.Log_Message('GMD_GRADE_NOT_REQD');

206: -- End RLNAGARA Bug # 4548546
207:
208: -- Grade
209: IF l_grade_ctl = 'N' and p_spec_header.grade_code IS NOT NULL THEN
210: GMD_API_PUB.Log_Message('GMD_GRADE_NOT_REQD');
211: RAISE FND_API.G_EXC_ERROR;
212: END IF;
213:
214: IF (p_spec_header.grade_code IS NOT NULL) THEN

Line 220: GMD_API_PUB.Log_Message('GMD_SPEC_GRADE_NOT_FOUND',

216: OPEN c_grade(p_spec_header.grade_code);
217: FETCH c_grade INTO dummy;
218: IF c_grade%NOTFOUND THEN
219: CLOSE c_grade;
220: GMD_API_PUB.Log_Message('GMD_SPEC_GRADE_NOT_FOUND',
221: 'GRADE', p_spec_header.grade_code);
222: RAISE FND_API.G_EXC_ERROR;
223: END IF;
224: CLOSE c_grade;

Line 229: GMD_API_PUB.Log_Message('GMD_SPEC_STATUS_REQD');

225: END IF;
226:
227: -- Spec Status
228: IF (p_spec_header.spec_status IS NULL) THEN
229: GMD_API_PUB.Log_Message('GMD_SPEC_STATUS_REQD');
230: RAISE FND_API.G_EXC_ERROR;
231: ELSE
232: -- Check that Status exist in GMD_QM_STATUS
233: OPEN c_status(p_spec_header.spec_status);

Line 237: GMD_API_PUB.Log_Message('GMD_SPEC_STATUS_NOT_FOUND',

233: OPEN c_status(p_spec_header.spec_status);
234: FETCH c_status INTO dummy;
235: IF c_status%NOTFOUND THEN
236: CLOSE c_status;
237: GMD_API_PUB.Log_Message('GMD_SPEC_STATUS_NOT_FOUND',
238: 'STATUS', p_spec_header.spec_status);
239: RAISE FND_API.G_EXC_ERROR;
240: END IF;
241: CLOSE c_status;

Line 246: GMD_API_PUB.Log_Message('GMD_SPEC_ORGN_REQD');

242: END IF;
243:
244: -- Owner Orgn Code
245: IF (p_spec_header.owner_organization_id IS NULL) THEN
246: GMD_API_PUB.Log_Message('GMD_SPEC_ORGN_REQD');
247: RAISE FND_API.G_EXC_ERROR;
248: ELSE
249: -- Check that Owner Organization id exist in MTL_PARAMETERS
250: OPEN c_orgn(p_spec_header.owner_organization_id);

Line 254: GMD_API_PUB.Log_Message('GMD_SPEC_ORGN_ID_NOT_FOUND',

250: OPEN c_orgn(p_spec_header.owner_organization_id);
251: FETCH c_orgn INTO dummy;
252: IF c_orgn%NOTFOUND THEN
253: CLOSE c_orgn;
254: GMD_API_PUB.Log_Message('GMD_SPEC_ORGN_ID_NOT_FOUND',
255: 'ORGNID', p_spec_header.owner_organization_id);
256: RAISE FND_API.G_EXC_ERROR;
257: END IF;
258: CLOSE c_orgn;

Line 263: GMD_API_PUB.Log_Message('GMD_SPEC_OWNER_REQD');

259: END IF;
260:
261: -- Owner ID
262: IF (p_spec_header.owner_id IS NULL) THEN
263: GMD_API_PUB.Log_Message('GMD_SPEC_OWNER_REQD');
264: RAISE FND_API.G_EXC_ERROR;
265: ELSE
266: -- Get the Owner Name
267: OPEN c_owner(p_spec_header.owner_id);

Line 271: GMD_API_PUB.Log_Message('GMD_SPEC_OWNER_NOT_FOUND');

267: OPEN c_owner(p_spec_header.owner_id);
268: FETCH c_owner INTO x_owner;
269: IF c_owner%NOTFOUND THEN
270: CLOSE c_owner;
271: GMD_API_PUB.Log_Message('GMD_SPEC_OWNER_NOT_FOUND');
272: RAISE FND_API.G_EXC_ERROR;
273: END IF;
274: CLOSE c_owner;
275: END IF;

Line 280: GMD_API_PUB.Log_Message('GMD_OVERLAY_NOT_VALID');

276:
277:
278: -- Overlay Ind (Bug 3452015)
279: if (nvl(p_spec_header.OVERLAY_IND,'Y') <> 'Y') then
280: GMD_API_PUB.Log_Message('GMD_OVERLAY_NOT_VALID');
281: RAISE FND_API.G_EXC_ERROR;
282: end if ;
283:
284: IF (p_spec_header.OVERLAY_IND is NULL) THEN

Line 286: GMD_API_PUB.Log_Message('GMD_OVERLAY_NOT_VALID');

282: end if ;
283:
284: IF (p_spec_header.OVERLAY_IND is NULL) THEN
285: IF (p_spec_header.BASE_SPEC_ID IS NOT NULL) THEN
286: GMD_API_PUB.Log_Message('GMD_OVERLAY_NOT_VALID');
287: RAISE FND_API.G_EXC_ERROR;
288: end if;
289: end if;
290:

Line 293: GMD_API_PUB.Log_Message('GMD_BASE_SPEC_NOT_FOUND',

289: end if;
290:
291: IF (p_spec_header.OVERLAY_IND = 'Y') THEN
292: IF (p_spec_header.BASE_SPEC_ID IS NULL) THEN
293: GMD_API_PUB.Log_Message('GMD_BASE_SPEC_NOT_FOUND',
294: 'BASE_SPEC_ID', p_spec_header.base_spec_id);
295: RAISE FND_API.G_EXC_ERROR;
296: end if;
297: end if;

Line 307: GMD_API_PUB.Log_Message('GMD_BASE_SPEC_NOT_FOUND',

303: OPEN c_spec(p_spec_header.base_spec_id);
304: FETCH c_spec INTO dummy;
305: IF c_spec%NOTFOUND THEN
306: CLOSE c_spec;
307: GMD_API_PUB.Log_Message('GMD_BASE_SPEC_NOT_FOUND',
308: 'BASE_SPEC_ID', p_spec_header.base_spec_id);
309: RAISE FND_API.G_EXC_ERROR;
310: END IF;
311: CLOSE c_spec;

Line 320: GMD_API_PUB.Log_Message('GMD_API_ERROR','PACKAGE','gmd_spec_grp.check_for_null_and_fks_in_spec',

316: x_return_status := FND_API.G_RET_STS_ERROR ;
317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
319: WHEN OTHERS THEN
320: GMD_API_PUB.Log_Message('GMD_API_ERROR','PACKAGE','gmd_spec_grp.check_for_null_and_fks_in_spec',
321: 'ERROR',substr(sqlerrm,1,100),'POSITION','010');
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
323:
324: END check_for_null_and_fks_in_spec;

Line 393: GMD_API_PUB.Log_Message('GMD_TEST_ID_CODE_NULL');

389:
390: x_spec_tests := p_spec_tests;
391: -- Test
392: IF x_spec_tests.test_id IS NULL THEN
393: GMD_API_PUB.Log_Message('GMD_TEST_ID_CODE_NULL');
394: RAISE FND_API.G_EXC_ERROR;
395: ELSE
396: OPEN cr_test(x_spec_tests.test_id);
397: FETCH cr_test INTO l_test_code,l_test_method_id,l_test_type,l_test_min_value_num,

Line 401: GMD_API_PUB.Log_Message('GMD_INVALID_TEST','TEST',x_spec_tests.test_id);

397: FETCH cr_test INTO l_test_code,l_test_method_id,l_test_type,l_test_min_value_num,
398: l_test_max_value_num,l_test_priority;
399: IF cr_test%NOTFOUND THEN
400: CLOSE cr_test;
401: GMD_API_PUB.Log_Message('GMD_INVALID_TEST','TEST',x_spec_tests.test_id);
402: RAISE FND_API.G_EXC_ERROR;
403: END IF;
404: CLOSE cr_test ;
405: END IF;

Line 411: GMD_API_PUB.Log_Message('GMD_SPEC_TST_MTHD_INVALID');

407: -- test method
408: IF x_spec_tests.test_method_id IS NULL THEN
409: x_spec_tests.test_method_id := l_test_method_id;
410: ELSIF x_spec_tests.test_method_id <> l_test_method_id THEN
411: GMD_API_PUB.Log_Message('GMD_SPEC_TST_MTHD_INVALID');
412: RAISE FND_API.G_EXC_ERROR;
413: END IF;
414:
415: OPEN cr_test_method_valid(l_test_method_id);

Line 419: GMD_API_PUB.Log_Message('GMD_TEST_METHOD_DELETED');

415: OPEN cr_test_method_valid(l_test_method_id);
416: FETCH cr_test_method_valid INTO l_test_method_id,l_test_method_replicate;
417: IF cr_test_method_valid%NOTFOUND THEN
418: CLOSE cr_test_method_valid;
419: GMD_API_PUB.Log_Message('GMD_TEST_METHOD_DELETED');
420: RAISE FND_API.G_EXC_ERROR;
421: END IF;
422: CLOSE cr_test_method_valid ;
423:

Line 426: GMD_API_PUB.Log_Message('GMD_SPEC_TEST_SEQ_REQD');

422: CLOSE cr_test_method_valid ;
423:
424: -- test sequence
425: IF x_spec_tests.seq IS NULL THEN
426: GMD_API_PUB.Log_Message('GMD_SPEC_TEST_SEQ_REQD');
427: RAISE FND_API.G_EXC_ERROR;
428: ELSE
429: IF x_spec_tests.seq <> trunc(x_spec_tests.seq) THEN
430: GMD_API_PUB.Log_Message('GMD_SPEC_TEST_SEQ_NO');

Line 430: GMD_API_PUB.Log_Message('GMD_SPEC_TEST_SEQ_NO');

426: GMD_API_PUB.Log_Message('GMD_SPEC_TEST_SEQ_REQD');
427: RAISE FND_API.G_EXC_ERROR;
428: ELSE
429: IF x_spec_tests.seq <> trunc(x_spec_tests.seq) THEN
430: GMD_API_PUB.Log_Message('GMD_SPEC_TEST_SEQ_NO');
431: RAISE FND_API.G_EXC_ERROR;
432: END IF;
433: END IF;
434:

Line 506: GMD_API_PUB.Log_Message('GMD_PRECISION_REQD','TEST',l_test_code);

502: RAISE FND_API.G_EXC_ERROR;
503: END IF;
504: ELSE
505: IF (x_spec_tests.display_precision IS NULL OR x_spec_tests.report_precision IS NULL ) THEN
506: GMD_API_PUB.Log_Message('GMD_PRECISION_REQD','TEST',l_test_code);
507: RAISE FND_API.G_EXC_ERROR;
508: END IF;
509:
510: IF (x_spec_tests.display_precision not between 0 and 9) THEN

Line 511: GMD_API_PUB.Log_Message('GMD_INVALID_PRECISION','PRECISION',x_spec_tests.display_precision);

507: RAISE FND_API.G_EXC_ERROR;
508: END IF;
509:
510: IF (x_spec_tests.display_precision not between 0 and 9) THEN
511: GMD_API_PUB.Log_Message('GMD_INVALID_PRECISION','PRECISION',x_spec_tests.display_precision);
512: RAISE FND_API.G_EXC_ERROR;
513: END IF;
514:
515: IF (x_spec_tests.report_precision not between 0 and 9) THEN

Line 516: GMD_API_PUB.Log_Message('GMD_INVALID_PRECISION','PRECISION',x_spec_tests.report_precision);

512: RAISE FND_API.G_EXC_ERROR;
513: END IF;
514:
515: IF (x_spec_tests.report_precision not between 0 and 9) THEN
516: GMD_API_PUB.Log_Message('GMD_INVALID_PRECISION','PRECISION',x_spec_tests.report_precision);
517: RAISE FND_API.G_EXC_ERROR;
518: END IF;
519:
520: IF (x_spec_tests.min_value_num IS NULL AND x_spec_tests.max_value_num IS NULL) THEN

Line 576: GMD_API_PUB.Log_Message('GMD_TEST_UOM_QTY_NOT_REQD');

572:
573: -- test UOM and Quantity.
574: IF (l_test_type = 'E') THEN
575: IF (x_spec_tests.test_qty_uom IS NOT NULL OR x_spec_tests.test_qty IS NOT NULL) THEN
576: GMD_API_PUB.Log_Message('GMD_TEST_UOM_QTY_NOT_REQD');
577: RAISE FND_API.G_EXC_ERROR;
578: END IF;
579: ELSE
580: IF x_spec_tests.test_qty <= 0 THEN

Line 581: GMD_API_PUB.Log_Message('GMD_TEST_QTY_NEG');

577: RAISE FND_API.G_EXC_ERROR;
578: END IF;
579: ELSE
580: IF x_spec_tests.test_qty <= 0 THEN
581: GMD_API_PUB.Log_Message('GMD_TEST_QTY_NEG');
582: RAISE FND_API.G_EXC_ERROR;
583: END IF;
584:
585: IF (x_spec_tests.test_qty_uom IS NOT NULL AND x_spec_tests.test_qty IS NULL) OR

Line 587: GMD_API_PUB.Log_Message('GMD_TEST_UOM_QTY_REQD');

583: END IF;
584:
585: IF (x_spec_tests.test_qty_uom IS NOT NULL AND x_spec_tests.test_qty IS NULL) OR
586: (x_spec_tests.test_qty_uom IS NULL AND x_spec_tests.test_qty IS NOT NULL) THEN
587: GMD_API_PUB.Log_Message('GMD_TEST_UOM_QTY_REQD');
588: RAISE FND_API.G_EXC_ERROR;
589: END IF;
590: END IF;
591:

Line 596: GMD_API_PUB.Log_Message('GMD_INVALID_TEST_PRIORITY');

592: IF x_spec_tests.test_priority IS NULL THEN
593: x_spec_tests.test_priority := l_test_priority;
594:
595: ELSIF (NOT GMD_QC_TESTS_GRP.validate_test_priority(p_test_priority => x_spec_tests.test_priority)) THEN
596: GMD_API_PUB.Log_Message('GMD_INVALID_TEST_PRIORITY');
597: RAISE FND_API.G_EXC_ERROR;
598: END IF;
599:
600: -- Replicate Validation

Line 602: GMD_API_PUB.Log_Message('GMD_TEST_REP_REQD');

598: END IF;
599:
600: -- Replicate Validation
601: IF x_spec_tests.test_replicate IS NULL THEN
602: GMD_API_PUB.Log_Message('GMD_TEST_REP_REQD');
603: RAISE FND_API.G_EXC_ERROR;
604: ELSIF (l_test_type = 'E' and x_spec_tests.test_replicate <> 1) THEN
605: GMD_API_PUB.Log_Message('SPEC_TEST_REPLICATE_ONE');
606: RAISE FND_API.G_EXC_ERROR;

Line 605: GMD_API_PUB.Log_Message('SPEC_TEST_REPLICATE_ONE');

601: IF x_spec_tests.test_replicate IS NULL THEN
602: GMD_API_PUB.Log_Message('GMD_TEST_REP_REQD');
603: RAISE FND_API.G_EXC_ERROR;
604: ELSIF (l_test_type = 'E' and x_spec_tests.test_replicate <> 1) THEN
605: GMD_API_PUB.Log_Message('SPEC_TEST_REPLICATE_ONE');
606: RAISE FND_API.G_EXC_ERROR;
607: ELSIF (x_spec_tests.test_replicate < l_test_method_replicate) THEN
608: GMD_API_PUB.Log_Message('SPEC_TEST_REPLICATE_ERROR',
609: 'SPEC_TEST', l_test_code);

Line 608: GMD_API_PUB.Log_Message('SPEC_TEST_REPLICATE_ERROR',

604: ELSIF (l_test_type = 'E' and x_spec_tests.test_replicate <> 1) THEN
605: GMD_API_PUB.Log_Message('SPEC_TEST_REPLICATE_ONE');
606: RAISE FND_API.G_EXC_ERROR;
607: ELSIF (x_spec_tests.test_replicate < l_test_method_replicate) THEN
608: GMD_API_PUB.Log_Message('SPEC_TEST_REPLICATE_ERROR',
609: 'SPEC_TEST', l_test_code);
610: RAISE FND_API.G_EXC_ERROR;
611: END IF;
612:

Line 620: GMD_API_PUB.Log_Message('GMD_UOM_CONV_IND');

616: IF (x_spec_tests.CALC_UOM_CONV_IND IS NULL) or
617: (x_spec_tests.CALC_UOM_CONV_IND = 'Y') then
618: null;
619: else
620: GMD_API_PUB.Log_Message('GMD_UOM_CONV_IND');
621: RAISE FND_API.G_EXC_ERROR;
622: END IF;
623:
624:

Line 631: GMD_API_PUB.Log_Message('GMD_INVALID_ACTION_CODE','ACTION',x_spec_tests.below_min_action_code);

627: OPEN cr_action_code(x_spec_tests.below_min_action_code);
628: FETCH cr_action_code INTO l_temp;
629: IF cr_action_code%NOTFOUND THEN
630: CLOSE cr_action_code;
631: GMD_API_PUB.Log_Message('GMD_INVALID_ACTION_CODE','ACTION',x_spec_tests.below_min_action_code);
632: RAISE FND_API.G_EXC_ERROR;
633: END IF;
634: CLOSE cr_action_code ;
635: END IF;

Line 642: GMD_API_PUB.Log_Message('GMD_INVALID_ACTION_CODE','ACTION',x_spec_tests.above_min_action_code);

638: OPEN cr_action_code(x_spec_tests.above_min_action_code);
639: FETCH cr_action_code INTO l_temp;
640: IF cr_action_code%NOTFOUND THEN
641: CLOSE cr_action_code;
642: GMD_API_PUB.Log_Message('GMD_INVALID_ACTION_CODE','ACTION',x_spec_tests.above_min_action_code);
643: RAISE FND_API.G_EXC_ERROR;
644: END IF;
645: CLOSE cr_action_code ;
646: END IF;

Line 653: GMD_API_PUB.Log_Message('GMD_INVALID_ACTION_CODE','ACTION',x_spec_tests.below_max_action_code);

649: OPEN cr_action_code(x_spec_tests.below_max_action_code);
650: FETCH cr_action_code INTO l_temp;
651: IF cr_action_code%NOTFOUND THEN
652: CLOSE cr_action_code;
653: GMD_API_PUB.Log_Message('GMD_INVALID_ACTION_CODE','ACTION',x_spec_tests.below_max_action_code);
654: RAISE FND_API.G_EXC_ERROR;
655: END IF;
656: CLOSE cr_action_code ;
657: END IF;

Line 664: GMD_API_PUB.Log_Message('GMD_INVALID_ACTION_CODE','ACTION',x_spec_tests.above_max_action_code);

660: OPEN cr_action_code(x_spec_tests.above_max_action_code);
661: FETCH cr_action_code INTO l_temp;
662: IF cr_action_code%NOTFOUND THEN
663: CLOSE cr_action_code;
664: GMD_API_PUB.Log_Message('GMD_INVALID_ACTION_CODE','ACTION',x_spec_tests.above_max_action_code);
665: RAISE FND_API.G_EXC_ERROR;
666: END IF;
667: CLOSE cr_action_code ;
668: END IF;

Line 675: GMD_API_PUB.Log_Message('GMD_INVALID_ACTION_CODE','ACTION',x_spec_tests.out_of_spec_action);

671: OPEN cr_action_code(x_spec_tests.out_of_spec_action);
672: FETCH cr_action_code INTO l_temp;
673: IF cr_action_code%NOTFOUND THEN
674: CLOSE cr_action_code;
675: GMD_API_PUB.Log_Message('GMD_INVALID_ACTION_CODE','ACTION',x_spec_tests.out_of_spec_action);
676: RAISE FND_API.G_EXC_ERROR;
677: END IF;
678: CLOSE cr_action_code ;
679: END IF;

Line 684: GMD_API_PUB.Log_Message('GMD_SPEC_INVALID_IND','COLUMN','USE_TO_CONTROL_STEP');

680:
681: IF x_spec_tests.use_to_control_step IS NULL OR x_spec_tests.use_to_control_step IN ('N','Y') THEN
682: NULL ;
683: ELSE
684: GMD_API_PUB.Log_Message('GMD_SPEC_INVALID_IND','COLUMN','USE_TO_CONTROL_STEP');
685: RAISE FND_API.G_EXC_ERROR;
686: END IF;
687: IF x_spec_tests.use_to_control_step = 'N' THEN
688: x_spec_tests.use_to_control_step:= NULL;

Line 694: GMD_API_PUB.Log_Message('GMD_SPEC_INVALID_IND','COLUMN','OPTIONAL_IND');

690:
691: IF x_spec_tests.optional_ind IS NULL OR x_spec_tests.optional_ind IN ('N','Y') THEN
692: NULL ;
693: ELSE
694: GMD_API_PUB.Log_Message('GMD_SPEC_INVALID_IND','COLUMN','OPTIONAL_IND');
695: RAISE FND_API.G_EXC_ERROR;
696: END IF;
697: IF x_spec_tests.optional_ind = 'N' THEN
698: x_spec_tests.optional_ind:= NULL;

Line 704: GMD_API_PUB.Log_Message('GMD_SPEC_INVALID_IND','COLUMN','PRINT_SPEC_IND');

700:
701: IF x_spec_tests.print_spec_ind IS NULL OR x_spec_tests.print_spec_ind IN ('N','Y') THEN
702: NULL ;
703: ELSE
704: GMD_API_PUB.Log_Message('GMD_SPEC_INVALID_IND','COLUMN','PRINT_SPEC_IND');
705: RAISE FND_API.G_EXC_ERROR;
706: END IF;
707: IF x_spec_tests.print_spec_ind = 'N' THEN
708: x_spec_tests.print_spec_ind:= NULL;

Line 714: GMD_API_PUB.Log_Message('GMD_SPEC_INVALID_IND','COLUMN','PRINT_RESULT_IND');

710:
711: IF x_spec_tests.print_result_ind IS NULL OR x_spec_tests.print_result_ind IN ('N','Y') THEN
712: NULL ;
713: ELSE
714: GMD_API_PUB.Log_Message('GMD_SPEC_INVALID_IND','COLUMN','PRINT_RESULT_IND');
715: RAISE FND_API.G_EXC_ERROR;
716: END IF;
717: IF x_spec_tests.print_result_ind = 'N' THEN
718: x_spec_tests.print_result_ind:= NULL;

Line 724: GMD_API_PUB.Log_Message('GMD_SPEC_INVALID_IND','COLUMN','RETEST_LOT_EXPIRY_IND');

720:
721: IF x_spec_tests.retest_lot_expiry_ind IS NULL OR x_spec_tests.retest_lot_expiry_ind IN ('N','Y') THEN
722: NULL ;
723: ELSE
724: GMD_API_PUB.Log_Message('GMD_SPEC_INVALID_IND','COLUMN','RETEST_LOT_EXPIRY_IND');
725: RAISE FND_API.G_EXC_ERROR;
726: END IF;
727: IF x_spec_tests.retest_lot_expiry_ind = 'N' THEN
728: x_spec_tests.retest_lot_expiry_ind:= NULL;

Line 738: GMD_API_PUB.Log_Message('GMD_API_ERROR','PACKAGE','gmd_spec_grp.check_for_null_and_fks_in_stst',

734: x_return_status := FND_API.G_RET_STS_ERROR ;
735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
737: WHEN OTHERS THEN
738: GMD_API_PUB.Log_Message('GMD_API_ERROR','PACKAGE','gmd_spec_grp.check_for_null_and_fks_in_stst',
739: 'ERROR',substr(sqlerrm,1,100),'POSITION','010');
740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
741:
742: END check_for_null_and_fks_in_stst;

Line 812: GMD_API_PUB.Log_Message('GMD_SPEC_VERS_EXIST',

808:
809: -- Verify that spec_name and spec_vers are unique
810: IF (p_operation = 'INSERT' AND spec_vers_exist(p_spec_header.spec_name, p_spec_header.spec_vers)) THEN
811: -- Ah...Ha, Spec and Version combination is already used
812: GMD_API_PUB.Log_Message('GMD_SPEC_VERS_EXIST',
813: 'SPEC', p_spec_header.spec_name,
814: 'VERS', p_spec_header.spec_vers);
815: RAISE FND_API.G_EXC_ERROR;
816: END IF;

Line 825: GMD_API_PUB.Log_Message('GMD_USER_ORGN_NO_ACCESS',

821: -- Peep...Peep...Security Alert. User does not have access to Owner Organization
822: SELECT organization_code INTO l_owner_organization_code
823: FROM mtl_parameters
824: WHERE organization_id = p_spec_header.owner_organization_id;
825: GMD_API_PUB.Log_Message('GMD_USER_ORGN_NO_ACCESS',
826: 'OWNER', l_owner,
827: 'ORGN', l_owner_organization_code);
828: RAISE FND_API.G_EXC_ERROR;
829: END IF;

Line 839: GMD_API_PUB.Log_Message('GMD_API_ERROR','PACKAGE','gmd_spec_grp.validate_spec_header',

835: x_return_status := FND_API.G_RET_STS_ERROR ;
836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
838: WHEN OTHERS THEN
839: GMD_API_PUB.Log_Message('GMD_API_ERROR','PACKAGE','gmd_spec_grp.validate_spec_header',
840: 'ERROR',substr(sqlerrm,1,100),'POSITION','010');
841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
842:
843:

Line 1128: GMD_API_PUB.Log_Message('GMD_SPEC_TEST_SEQ_EXIST', 'SEQ', x_spec_test.seq);

1124: -- Verify that Seq is unique
1125: IF (spec_test_seq_exist(x_spec_test.spec_id,x_spec_test.seq) )
1126: THEN
1127: -- Seq is already used
1128: GMD_API_PUB.Log_Message('GMD_SPEC_TEST_SEQ_EXIST', 'SEQ', x_spec_test.seq);
1129: RAISE FND_API.G_EXC_ERROR;
1130: end if ;
1131:
1132:

Line 1136: GMD_API_PUB.Log_Message('GMD_SPEC_TEST_EXIST', 'TEST_ID', x_spec_test.test_id);

1132:
1133: -- Verify that Test is unique (added by KYH 01/OCT/02)
1134: IF spec_test_exist(x_spec_test.spec_id,x_spec_test.test_id) THEN
1135: -- Test is already used
1136: GMD_API_PUB.Log_Message('GMD_SPEC_TEST_EXIST', 'TEST_ID', x_spec_test.test_id);
1137: RAISE FND_API.G_EXC_ERROR;
1138: END IF;
1139:
1140: open c_spec_type(x_spec_test.spec_id);

Line 1174: -- GMD_API_PUB.Log_Message('GMD_SPEC_TEST_EXIST', 'TEST_ID', x_spec_test.test_id);

1170: THEN
1171: RAISE error_fetch_item;
1172: END;
1173:
1174: -- GMD_API_PUB.Log_Message('GMD_SPEC_TEST_EXIST', 'TEST_ID', x_spec_test.test_id);
1175: --RAISE FND_API.G_EXC_ERROR;
1176:
1177:
1178: BEGIN

Line 1212: GMD_API_PUB.Log_Message('TEST_VALUES_NOT_FOUND');

1208: OPEN c_test_value(l_test.test_id, x_spec_test.min_value_char);
1209: FETCH c_test_value INTO x_spec_test.min_value_num;
1210: IF c_test_value%NOTFOUND THEN
1211: CLOSE c_test_value;
1212: GMD_API_PUB.Log_Message('TEST_VALUES_NOT_FOUND');
1213: RAISE FND_API.G_EXC_ERROR;
1214: END IF;
1215: CLOSE c_test_value;
1216: END IF;

Line 1224: GMD_API_PUB.Log_Message('TEST_VALUES_NOT_FOUND');

1220: OPEN c_test_value(l_test.test_id, x_spec_test.target_value_char);
1221: FETCH c_test_value INTO x_spec_test.target_value_num;
1222: IF c_test_value%NOTFOUND THEN
1223: CLOSE c_test_value;
1224: GMD_API_PUB.Log_Message('TEST_VALUES_NOT_FOUND');
1225: RAISE FND_API.G_EXC_ERROR;
1226: END IF;
1227: CLOSE c_test_value;
1228: END IF;

Line 1235: GMD_API_PUB.Log_Message('TEST_VALUES_NOT_FOUND');

1231: OPEN c_test_value(l_test.test_id, x_spec_test.max_value_char);
1232: FETCH c_test_value INTO x_spec_test.max_value_num;
1233: IF c_test_value%NOTFOUND THEN
1234: CLOSE c_test_value;
1235: GMD_API_PUB.Log_Message('TEST_VALUES_NOT_FOUND');
1236: RAISE FND_API.G_EXC_ERROR;
1237: END IF;
1238: CLOSE c_test_value;
1239: END IF;

Line 1275: GMD_API_PUB.Log_Message('SPEC_TEST_RETEST_IND_ERROR',

1271:
1272:
1273: -- Lot Retest Indicator
1274: IF ( x_spec_test.retest_lot_expiry_ind = 'Y' and l_item.lot_control_code = 1) THEN
1275: GMD_API_PUB.Log_Message('SPEC_TEST_RETEST_IND_ERROR',
1276: 'SPEC_TEST', l_test.test_code,
1277: 'SPEC_TEST', l_item.concatenated_segments);
1278: RAISE FND_API.G_EXC_ERROR;
1279: END IF;

Line 1305: GMD_API_PUB.Log_Message('GMD_EXP_ERR_VAL_REQ_ACTION');

1301: RAISE FND_API.G_EXC_ERROR;
1302: END IF;
1303:
1304: IF x_spec_test.below_min_action_code IS NOT NULL and x_spec_test.below_spec_min IS NULL THEN
1305: GMD_API_PUB.Log_Message('GMD_EXP_ERR_VAL_REQ_ACTION');
1306: RAISE FND_API.G_EXC_ERROR;
1307: END IF;
1308:
1309: IF x_spec_test.above_min_action_code IS NOT NULL and x_spec_test.above_spec_min IS NULL THEN

Line 1310: GMD_API_PUB.Log_Message('GMD_EXP_ERR_VAL_REQ_ACTION');

1306: RAISE FND_API.G_EXC_ERROR;
1307: END IF;
1308:
1309: IF x_spec_test.above_min_action_code IS NOT NULL and x_spec_test.above_spec_min IS NULL THEN
1310: GMD_API_PUB.Log_Message('GMD_EXP_ERR_VAL_REQ_ACTION');
1311: RAISE FND_API.G_EXC_ERROR;
1312: END IF;
1313:
1314: IF x_spec_test.below_max_action_code IS NOT NULL and x_spec_test.below_spec_max IS NULL THEN

Line 1315: GMD_API_PUB.Log_Message('GMD_EXP_ERR_VAL_REQ_ACTION');

1311: RAISE FND_API.G_EXC_ERROR;
1312: END IF;
1313:
1314: IF x_spec_test.below_max_action_code IS NOT NULL and x_spec_test.below_spec_max IS NULL THEN
1315: GMD_API_PUB.Log_Message('GMD_EXP_ERR_VAL_REQ_ACTION');
1316: RAISE FND_API.G_EXC_ERROR;
1317: END IF;
1318:
1319: IF x_spec_test.above_max_action_code IS NOT NULL and x_spec_test.above_spec_max IS NULL THEN

Line 1320: GMD_API_PUB.Log_Message('GMD_EXP_ERR_VAL_REQ_ACTION');

1316: RAISE FND_API.G_EXC_ERROR;
1317: END IF;
1318:
1319: IF x_spec_test.above_max_action_code IS NOT NULL and x_spec_test.above_spec_max IS NULL THEN
1320: GMD_API_PUB.Log_Message('GMD_EXP_ERR_VAL_REQ_ACTION');
1321: RAISE FND_API.G_EXC_ERROR;
1322: END IF;
1323:
1324: END IF;

Line 1364: GMD_API_PUB.Log_Message('GMD_API_ERROR','PACKAGE','gmd_spec_grp.validate_spec_test',

1360: x_return_status := FND_API.G_RET_STS_ERROR ;
1361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1363: WHEN OTHERS THEN
1364: GMD_API_PUB.Log_Message('GMD_API_ERROR','PACKAGE','gmd_spec_grp.validate_spec_test',
1365: 'ERROR',substr(sqlerrm,1,100),'POSITION','010');
1366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1367:
1368:

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

1397: BEGIN
1398: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1399:
1400: IF p_spec_id IS NULL THEN
1401: GMD_API_PUB.Log_Message('GMD_SPEC_ID_REQUIRED');
1402: RAISE FND_API.G_EXC_ERROR;
1403: END IF;
1404:
1405: -- atleast one test should be present in the spec.

Line 1430: GMD_API_PUB.Log_Message('GMD_SOME_REF_TESTS_MISSING');

1426: p_spec_id => p_spec_id,
1427: p_exp_test_seq => l_test_seq,
1428: p_exp_test_id => l_test_id ) THEN
1429: CLOSE cr_expression_tests ;
1430: GMD_API_PUB.Log_Message('GMD_SOME_REF_TESTS_MISSING');
1431: RAISE FND_API.G_EXC_ERROR;
1432: END IF;
1433: END LOOP;
1434:

Line 1440: GMD_API_PUB.Log_Message('GMD_API_ERROR','PACKAGE','gmd_spec_grp.validate_after_insert_all',

1436: WHEN FND_API.G_EXC_ERROR THEN
1437: x_return_status := FND_API.G_RET_STS_ERROR ;
1438:
1439: WHEN OTHERS THEN
1440: GMD_API_PUB.Log_Message('GMD_API_ERROR','PACKAGE','gmd_spec_grp.validate_after_insert_all',
1441: 'ERROR',substr(sqlerrm,1,100),'POSITION','010');
1442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1443:
1444: END validate_after_insert_all;

Line 1852: gmd_api_pub.log_message('GMD_VAL_MISSING_NUM_LABEL_TEST','VALUE',p_value);

1848: CLOSE cr_test_values;
1849: RETURN TRUE;
1850: END IF;
1851: CLOSE cr_test_values;
1852: gmd_api_pub.log_message('GMD_VAL_MISSING_NUM_LABEL_TEST','VALUE',p_value);
1853: RETURN FALSE;
1854:
1855: EXCEPTION
1856: WHEN REQ_FIELDS_MISSING THEN

Line 1857: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_GRP.VALUE_IN_NUM_RANGE_DISPLAY');

1853: RETURN FALSE;
1854:
1855: EXCEPTION
1856: WHEN REQ_FIELDS_MISSING THEN
1857: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_GRP.VALUE_IN_NUM_RANGE_DISPLAY');
1858: x_return_status := FND_API.G_RET_STS_ERROR ;
1859: RETURN FALSE;
1860: WHEN OTHERS THEN
1861: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_GRP.VALUE_IN_NUM_RANGE_DISPLAY','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);

Line 1861: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_GRP.VALUE_IN_NUM_RANGE_DISPLAY','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);

1857: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_GRP.VALUE_IN_NUM_RANGE_DISPLAY');
1858: x_return_status := FND_API.G_RET_STS_ERROR ;
1859: RETURN FALSE;
1860: WHEN OTHERS THEN
1861: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_GRP.VALUE_IN_NUM_RANGE_DISPLAY','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
1862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1863: RETURN FALSE;
1864: END value_in_num_range_display ;
1865:

Line 1966: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_GRP.SPEC_TEST_MIN_TARGET_MAX_VALID');

1962: RETURN TRUE;
1963:
1964: EXCEPTION
1965: WHEN REQ_FIELDS_MISSING THEN
1966: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_GRP.SPEC_TEST_MIN_TARGET_MAX_VALID');
1967: RETURN FALSE;
1968: WHEN e_min_error THEN
1969: gmd_api_pub.log_message('GMD_SPEC_TEST_MIN_ERROR','SPEC_TEST_MIN',to_char(p_st_min),'SPEC_TEST_MAX',
1970: to_char(p_st_max),'SPEC_TEST_TARGET',to_char(p_st_target),'TEST_MIN',to_char(p_t_min),'TEST_MAX',to_char(p_t_max));

Line 1969: gmd_api_pub.log_message('GMD_SPEC_TEST_MIN_ERROR','SPEC_TEST_MIN',to_char(p_st_min),'SPEC_TEST_MAX',

1965: WHEN REQ_FIELDS_MISSING THEN
1966: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_GRP.SPEC_TEST_MIN_TARGET_MAX_VALID');
1967: RETURN FALSE;
1968: WHEN e_min_error THEN
1969: gmd_api_pub.log_message('GMD_SPEC_TEST_MIN_ERROR','SPEC_TEST_MIN',to_char(p_st_min),'SPEC_TEST_MAX',
1970: to_char(p_st_max),'SPEC_TEST_TARGET',to_char(p_st_target),'TEST_MIN',to_char(p_t_min),'TEST_MAX',to_char(p_t_max));
1971: RETURN FALSE;
1972: WHEN e_max_error THEN
1973: gmd_api_pub.log_message('GMD_SPEC_TEST_MAX_ERROR','SPEC_TEST_MIN',to_char(p_st_min),'SPEC_TEST_MAX',

Line 1973: gmd_api_pub.log_message('GMD_SPEC_TEST_MAX_ERROR','SPEC_TEST_MIN',to_char(p_st_min),'SPEC_TEST_MAX',

1969: gmd_api_pub.log_message('GMD_SPEC_TEST_MIN_ERROR','SPEC_TEST_MIN',to_char(p_st_min),'SPEC_TEST_MAX',
1970: to_char(p_st_max),'SPEC_TEST_TARGET',to_char(p_st_target),'TEST_MIN',to_char(p_t_min),'TEST_MAX',to_char(p_t_max));
1971: RETURN FALSE;
1972: WHEN e_max_error THEN
1973: gmd_api_pub.log_message('GMD_SPEC_TEST_MAX_ERROR','SPEC_TEST_MIN',to_char(p_st_min),'SPEC_TEST_MAX',
1974: to_char(p_st_max),'SPEC_TEST_TARGET',to_char(p_st_target),'TEST_MIN',to_char(p_t_min),'TEST_MAX',to_char(p_t_max));
1975: RETURN FALSE;
1976: WHEN e_target_error THEN
1977: gmd_api_pub.log_message('GMD_SPEC_TEST_TARGET_ERROR','SPEC_TEST_MIN',to_char(p_st_min),'SPEC_TEST_MAX',

Line 1977: gmd_api_pub.log_message('GMD_SPEC_TEST_TARGET_ERROR','SPEC_TEST_MIN',to_char(p_st_min),'SPEC_TEST_MAX',

1973: gmd_api_pub.log_message('GMD_SPEC_TEST_MAX_ERROR','SPEC_TEST_MIN',to_char(p_st_min),'SPEC_TEST_MAX',
1974: to_char(p_st_max),'SPEC_TEST_TARGET',to_char(p_st_target),'TEST_MIN',to_char(p_t_min),'TEST_MAX',to_char(p_t_max));
1975: RETURN FALSE;
1976: WHEN e_target_error THEN
1977: gmd_api_pub.log_message('GMD_SPEC_TEST_TARGET_ERROR','SPEC_TEST_MIN',to_char(p_st_min),'SPEC_TEST_MAX',
1978: to_char(p_st_max),'SPEC_TEST_TARGET',to_char(p_st_target),'TEST_MIN',to_char(p_t_min),'TEST_MAX',to_char(p_t_max));
1979: RETURN FALSE;
1980: WHEN OTHERS THEN
1981: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_GRP.SPEC_TEST_MIN_TARGET_MAX_VALID','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);

Line 1981: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_GRP.SPEC_TEST_MIN_TARGET_MAX_VALID','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);

1977: gmd_api_pub.log_message('GMD_SPEC_TEST_TARGET_ERROR','SPEC_TEST_MIN',to_char(p_st_min),'SPEC_TEST_MAX',
1978: to_char(p_st_max),'SPEC_TEST_TARGET',to_char(p_st_target),'TEST_MIN',to_char(p_t_min),'TEST_MAX',to_char(p_t_max));
1979: RETURN FALSE;
1980: WHEN OTHERS THEN
1981: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_GRP.SPEC_TEST_MIN_TARGET_MAX_VALID','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
1982: RETURN FALSE;
1983: END spec_test_min_target_max_valid;
1984:
1985:

Line 2030: GMD_API_PUB.Log_Message('GMD_INVALID_EXP_ERROR_TYPE');

2026: RETURN TRUE;
2027: END IF;
2028:
2029: IF p_exp_error_type NOT IN ( 'N','P') THEN
2030: GMD_API_PUB.Log_Message('GMD_INVALID_EXP_ERROR_TYPE');
2031: RETURN FALSE;
2032: END IF;
2033:
2034: IF p_validation_level IN ('FULL','BELOW_SPEC_MIN') THEN

Line 2041: GMD_API_PUB.Log_Message('GMD_SPEC_ERROR_REG_NOT_APPL');

2037: RETURN TRUE;
2038: END IF;
2039:
2040: IF p_below_spec_min IS NOT NULL AND (p_spec_test_min = p_test_min OR p_test_max = p_test_min) THEN
2041: GMD_API_PUB.Log_Message('GMD_SPEC_ERROR_REG_NOT_APPL');
2042: RETURN FALSE;
2043: END IF;
2044:
2045: IF (p_below_spec_min IS NOT NULL AND p_spec_test_min IS NOT NULL and p_test_min IS NOT NULL ) THEN

Line 2058: GMD_API_PUB.Log_Message('GMD_INVALID_SPEC_VAL_NUM','MAX_VAL',to_char(l_max_value));

2054: l_max_value := ABS(p_spec_test_min - p_test_min);
2055: ELSE
2056: l_max_value := (ABS(p_spec_test_min - p_test_min) * 100)/(p_test_max - p_test_min);
2057: END IF;
2058: GMD_API_PUB.Log_Message('GMD_INVALID_SPEC_VAL_NUM','MAX_VAL',to_char(l_max_value));
2059: RETURN FALSE;
2060: END IF;
2061: END IF;
2062: END IF;

Line 2073: GMD_API_PUB.Log_Message('GMD_SPEC_ERROR_REG_NOT_APPL');

2069: RETURN TRUE;
2070: END IF;
2071:
2072: IF p_above_spec_max IS NOT NULL AND (p_spec_test_max = p_test_max OR p_test_max = p_test_min) THEN
2073: GMD_API_PUB.Log_Message('GMD_SPEC_ERROR_REG_NOT_APPL');
2074: RETURN FALSE;
2075: END IF;
2076:
2077: IF (p_above_spec_max IS NOT NULL AND p_spec_test_max IS NOT NULL and p_test_max IS NOT NULL ) THEN

Line 2090: GMD_API_PUB.Log_Message('GMD_INVALID_SPEC_VAL_NUM','MAX_VAL',to_char(l_max_value));

2086: l_max_value := ABS(p_test_max - p_spec_test_max);
2087: ELSE
2088: l_max_value := (ABS(p_test_max - p_spec_test_max) * 100)/(p_test_max - p_test_min);
2089: END IF;
2090: GMD_API_PUB.Log_Message('GMD_INVALID_SPEC_VAL_NUM','MAX_VAL',to_char(l_max_value));
2091: RETURN FALSE;
2092: END IF;
2093: END IF;
2094: END IF;

Line 2105: GMD_API_PUB.Log_Message('GMD_SPEC_ERROR_REG_NOT_APPL');

2101: RETURN TRUE;
2102: END IF;
2103:
2104: IF p_above_spec_min IS NOT NULL AND (p_spec_test_target = p_test_min OR p_test_max = p_test_min) THEN
2105: GMD_API_PUB.Log_Message('GMD_SPEC_ERROR_REG_NOT_APPL');
2106: RETURN FALSE;
2107: END IF;
2108:
2109: IF (p_above_spec_min IS NOT NULL AND p_spec_test_min IS NOT NULL and p_spec_test_target IS NOT NULL ) THEN

Line 2122: GMD_API_PUB.Log_Message('GMD_INVALID_SPEC_VAL_NUM','MAX_VAL',to_char(l_max_value));

2118: l_max_value := ABS(p_spec_test_target - p_spec_test_min);
2119: ELSE
2120: l_max_value := (ABS(p_spec_test_target - p_spec_test_min) * 100)/(p_test_max - p_test_min);
2121: END IF;
2122: GMD_API_PUB.Log_Message('GMD_INVALID_SPEC_VAL_NUM','MAX_VAL',to_char(l_max_value));
2123: RETURN FALSE;
2124: END IF;
2125: END IF;
2126: END IF;

Line 2137: GMD_API_PUB.Log_Message('GMD_SPEC_ERROR_REG_NOT_APPL');

2133: RETURN TRUE;
2134: END IF;
2135:
2136: IF p_below_spec_max IS NOT NULL AND (p_spec_test_max = p_spec_test_target OR p_test_max = p_test_min) THEN
2137: GMD_API_PUB.Log_Message('GMD_SPEC_ERROR_REG_NOT_APPL');
2138: RETURN FALSE;
2139: END IF;
2140:
2141: IF (p_below_spec_max IS NOT NULL AND p_spec_test_max IS NOT NULL and p_spec_test_target IS NOT NULL ) THEN

Line 2154: GMD_API_PUB.Log_Message('GMD_INVALID_SPEC_VAL_NUM','MAX_VAL',to_char(l_max_value));

2150: l_max_value := ABS(p_spec_test_max - p_spec_test_target);
2151: ELSE
2152: l_max_value := (ABS(p_spec_test_max - p_spec_test_target) * 100)/(p_test_max - p_test_min);
2153: END IF;
2154: GMD_API_PUB.Log_Message('GMD_INVALID_SPEC_VAL_NUM','MAX_VAL',to_char(l_max_value));
2155: RETURN FALSE;
2156: END IF;
2157: END IF;
2158: END IF;

Line 2164: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_GRP.SPEC_TEST_EXP_ERROR_REGION_VAL','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);

2160: RETURN TRUE;
2161:
2162: EXCEPTION
2163: WHEN OTHERS THEN
2164: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_GRP.SPEC_TEST_EXP_ERROR_REGION_VAL','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
2165: RETURN FALSE;
2166: END SPEC_TEST_EXP_ERROR_REGION_VAL;
2167:
2168:

Line 2196: GMD_API_PUB.Log_Message('GMD_REP_GRTR_DIS_PRCSN');

2192:
2193: BEGIN
2194:
2195: IF (p_spec_report_precision > p_spec_display_precision) THEN
2196: GMD_API_PUB.Log_Message('GMD_REP_GRTR_DIS_PRCSN');
2197:
2198: RETURN FALSE;
2199: ELSIF (p_spec_display_precision > p_test_display_precision) THEN
2200: GMD_API_PUB.Log_Message('SPEC_TEST_DISPLAY_PREC_ERROR');

Line 2200: GMD_API_PUB.Log_Message('SPEC_TEST_DISPLAY_PREC_ERROR');

2196: GMD_API_PUB.Log_Message('GMD_REP_GRTR_DIS_PRCSN');
2197:
2198: RETURN FALSE;
2199: ELSIF (p_spec_display_precision > p_test_display_precision) THEN
2200: GMD_API_PUB.Log_Message('SPEC_TEST_DISPLAY_PREC_ERROR');
2201:
2202: RETURN FALSE;
2203: ELSIF (p_spec_report_precision > p_test_report_precision) THEN
2204: GMD_API_PUB.Log_Message('SPEC_TEST_REPORT_PREC_ERROR');

Line 2204: GMD_API_PUB.Log_Message('SPEC_TEST_REPORT_PREC_ERROR');

2200: GMD_API_PUB.Log_Message('SPEC_TEST_DISPLAY_PREC_ERROR');
2201:
2202: RETURN FALSE;
2203: ELSIF (p_spec_report_precision > p_test_report_precision) THEN
2204: GMD_API_PUB.Log_Message('SPEC_TEST_REPORT_PREC_ERROR');
2205:
2206: RETURN FALSE;
2207: END IF;
2208: