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.QA_SPECS_PUB dependencies on FND_MESSAGE

Line 281: fnd_message.set_name('QA', 'QA_API_INVALID_ELEMENT');

277: OPEN c;
278: FETCH c INTO l_char_id;
279: IF c%NOTFOUND THEN
280: CLOSE c;
281: fnd_message.set_name('QA', 'QA_API_INVALID_ELEMENT');
282: fnd_msg_pub.add();
283: RAISE fnd_api.g_exc_error;
284: END IF;
285:

Line 316: fnd_message.set_name('QA', 'QA_API_SPEC_MUST_HAVE_CHARS');

312: l_found := c%FOUND;
313: CLOSE c;
314:
315: IF NOT l_found THEN
316: fnd_message.set_name('QA', 'QA_API_SPEC_MUST_HAVE_CHARS');
317: fnd_msg_pub.add();
318: RAISE fnd_api.g_exc_error;
319: END IF;
320:

Line 357: fnd_message.set_name('QA', 'QA_API_INVALID_ITEM_NAME');

353:
354: l_item_id := qa_flex_util.get_item_id(p_org_id, p_item_name);
355:
356: IF (l_item_id IS NULL) THEN
357: fnd_message.set_name('QA', 'QA_API_INVALID_ITEM_NAME');
358: fnd_msg_pub.add();
359: RAISE fnd_api.g_exc_error;
360: ELSE
361: l_revision_flag := get_revision_flag(l_item_id, p_org_id);

Line 365: fnd_message.set_name('QA', 'QA_API_REVISION_CONTROLLED');

361: l_revision_flag := get_revision_flag(l_item_id, p_org_id);
362: IF (l_revision_flag = 1) THEN
363:
364: IF (p_item_revision IS NOT NULL) THEN
365: fnd_message.set_name('QA', 'QA_API_REVISION_CONTROLLED');
366: fnd_msg_pub.add();
367: RAISE fnd_api.g_exc_error;
368: END IF;
369:

Line 371: fnd_message.set_name('QA', 'QA_API_MANDATORY_REVISION');

367: RAISE fnd_api.g_exc_error;
368: END IF;
369:
370: ELSIF (l_revision_flag = 2) and (p_item_revision IS NULL) THEN
371: fnd_message.set_name('QA', 'QA_API_MANDATORY_REVISION');
372: fnd_msg_pub.add();
373: RAISE fnd_api.g_exc_error;
374:
375: ELSE

Line 378: fnd_message.set_name('QA', 'QA_API_INVALID_REVISION');

374:
375: ELSE
376: IF NOT qa_plan_element_api.validate_revision(p_org_id,
377: l_item_id, p_item_revision) THEN
378: fnd_message.set_name('QA', 'QA_API_INVALID_REVISION');
379: fnd_msg_pub.add();
380: RAISE fnd_api.g_exc_error;
381: END IF;
382: END IF;

Line 405: fnd_message.set_name('QA', 'QA_INVALID_NUMBER');

401: IF p_datatype = qa_ss_const.number_datatype THEN
402: BEGIN
403: temp_number := to_number(p_value);
404: EXCEPTION WHEN OTHERS THEN
405: fnd_message.set_name('QA', 'QA_INVALID_NUMBER');
406: fnd_msg_pub.add();
407: RAISE fnd_api.g_exc_error;
408: END;
409:

Line 414: fnd_message.set_name('QA', 'QA_INVALID_DATE');

410: ELSIF p_datatype = qa_ss_const.date_datatype THEN
411: BEGIN
412: temp_date := qltdate.any_to_date(p_value);
413: EXCEPTION WHEN OTHERS THEN
414: fnd_message.set_name('QA', 'QA_INVALID_DATE');
415: fnd_msg_pub.add();
416: RAISE fnd_api.g_exc_error;
417: END;
418: END IF;

Line 486: fnd_message.set_name('QA', 'QA_API_INVALID_CATEGORY_SET');

482: FETCH c INTO l_category_set_id, x_structure_id, x_validate_flag;
483: CLOSE c;
484:
485: IF (l_category_set_id IS NULL) THEN
486: fnd_message.set_name('QA', 'QA_API_INVALID_CATEGORY_SET');
487: fnd_msg_pub.add();
488: RAISE fnd_api.g_exc_error;
489: END IF;
490:

Line 533: fnd_message.set_name('QA', 'QA_API_INVALID_CATEGORY');

529: l_category_id := FND_FLEX_KEYVAL.combination_id;
530: END IF;
531:
532: IF (l_category_id IS NULL) THEN
533: fnd_message.set_name('QA', 'QA_API_INVALID_CATEGORY');
534: fnd_msg_pub.add();
535: RAISE fnd_api.g_exc_error;
536: END IF;
537:

Line 563: fnd_message.set_name('QA', 'QA_API_SPEC_NAME_NOT_FOUND');

559: FETCH c INTO l_spec_id;
560:
561: IF c%NOTFOUND THEN
562: CLOSE c;
563: fnd_message.set_name('QA', 'QA_API_SPEC_NAME_NOT_FOUND');
564: fnd_msg_pub.add();
565: RAISE fnd_api.g_exc_error;
566: END IF;
567:

Line 865: fnd_message.set_name('QA', 'QA_API_INVALID_USER');

861: x_return_status := fnd_api.g_ret_sts_success;
862:
863: l_user_id := get_user_id(p_user_name);
864: IF l_user_id = -1 THEN
865: fnd_message.set_name('QA', 'QA_API_INVALID_USER');
866: fnd_msg_pub.add();
867: raise fnd_api.g_exc_error;
868: END IF;
869:

Line 909: fnd_message.set_name('QA', 'QA_API_DUPLICATE_SPEC_NAME');

905: --
906: -- 8. insert the row
907:
908: IF (spec_exists(p_spec_name)) THEN
909: fnd_message.set_name('QA', 'QA_API_DUPLICATE_SPEC_NAME');
910: fnd_msg_pub.add();
911: RAISE fnd_api.g_exc_error;
912: END IF;
913:

Line 916: fnd_message.set_name('QA', 'QA_SPEC_NOT_EXISTS');

912: END IF;
913:
914: -- See if the spec exists with p_common_spec_name
915: IF p_reference_spec IS NOT NULL AND NOT spec_exists(p_reference_spec) THEN
916: fnd_message.set_name('QA', 'QA_SPEC_NOT_EXISTS');
917: fnd_message.set_token('ENTITY1', p_reference_spec);
918: fnd_msg_pub.add();
919: RAISE fnd_api.g_exc_error;
920: END IF;

Line 917: fnd_message.set_token('ENTITY1', p_reference_spec);

913:
914: -- See if the spec exists with p_common_spec_name
915: IF p_reference_spec IS NOT NULL AND NOT spec_exists(p_reference_spec) THEN
916: fnd_message.set_name('QA', 'QA_SPEC_NOT_EXISTS');
917: fnd_message.set_token('ENTITY1', p_reference_spec);
918: fnd_msg_pub.add();
919: RAISE fnd_api.g_exc_error;
920: END IF;
921:

Line 924: fnd_message.set_name('QA', 'QA_CANNOT_REFER_CHILD_SPEC');

920: END IF;
921:
922: -- Force not to reference a child spec if common_spec_name is passed
923: IF p_reference_spec IS NOT NULL AND is_child_spec(p_reference_spec) THEN
924: fnd_message.set_name('QA', 'QA_CANNOT_REFER_CHILD_SPEC');
925: fnd_msg_pub.add();
926: RAISE fnd_api.g_exc_error;
927: END IF;
928:

Line 932: fnd_message.set_name('QA', 'QA_API_INVALID_ORG_CODE');

928:
929: l_org_id := qa_plans_api.get_org_id(p_organization_code);
930:
931: IF (l_org_id IS NULL) THEN
932: fnd_message.set_name('QA', 'QA_API_INVALID_ORG_CODE');
933: fnd_msg_pub.add();
934: RAISE fnd_api.g_exc_error;
935: END IF;
936:

Line 939: fnd_message.set_name('QA', 'QA_EFFECTIVE_DATE_RANGE');

935: END IF;
936:
937: IF (p_effective_to IS NOT NULL) THEN
938: IF (p_effective_to < p_effective_from) THEN
939: fnd_message.set_name('QA', 'QA_EFFECTIVE_DATE_RANGE');
940: fnd_msg_pub.add();
941: RAISE fnd_api.g_exc_error;
942: END IF;
943: END IF;

Line 970: fnd_message.set_name('QA', 'QA_API_INVALID_VENDOR_NAME');

966: END IF;
967: END IF;
968:
969: IF (l_vendor_id IS NULL) THEN
970: fnd_message.set_name('QA', 'QA_API_INVALID_VENDOR_NAME');
971: fnd_msg_pub.add();
972: RAISE fnd_api.g_exc_error;
973: END IF;
974:

Line 999: fnd_message.set_name('QA', 'QA_API_INVALID_CUSTOMER_NAME');

995:
996: END IF;
997:
998: IF (l_customer_id IS NULL) THEN
999: fnd_message.set_name('QA', 'QA_API_INVALID_CUSTOMER_NAME');
1000: fnd_msg_pub.add();
1001: RAISE fnd_api.g_exc_error;
1002: END IF;
1003:

Line 1005: fnd_message.set_name('QA', 'QA_API_INVALID_ASSIGNMENT_TYPE');

1001: RAISE fnd_api.g_exc_error;
1002: END IF;
1003:
1004: ELSE
1005: fnd_message.set_name('QA', 'QA_API_INVALID_ASSIGNMENT_TYPE');
1006: fnd_msg_pub.add();
1007: RAISE fnd_api.g_exc_error;
1008: END IF;
1009:

Line 1029: fnd_message.set_name('QA', 'QA_API_INVALID_ELEMENT');

1025: IF (l_char_id IS NOT NULL) THEN
1026: l_datatype := qa_chars_api.datatype(l_char_id);
1027: validate_datatype(l_sub_type_value, l_datatype);
1028: ELSE
1029: fnd_message.set_name('QA', 'QA_API_INVALID_ELEMENT');
1030: fnd_msg_pub.add();
1031: RAISE fnd_api.g_exc_error;
1032: END IF;
1033: ELSE

Line 1042: fnd_message.set_name('QA', 'QA_SPEC_COMBINATION_EXISTS');

1038: IF (combination_exists(l_category_set_id, l_category_id, l_item_id,
1039: p_item_revision, l_org_id, l_vendor_id, l_customer_id, l_char_id,
1040: l_sub_type_value, l_existing_spec_name)) THEN
1041:
1042: fnd_message.set_name('QA', 'QA_SPEC_COMBINATION_EXISTS');
1043: fnd_message.set_token('ENTITY1', l_existing_spec_name);
1044: fnd_msg_pub.add();
1045: RAISE fnd_api.g_exc_error;
1046: END IF;

Line 1043: fnd_message.set_token('ENTITY1', l_existing_spec_name);

1039: p_item_revision, l_org_id, l_vendor_id, l_customer_id, l_char_id,
1040: l_sub_type_value, l_existing_spec_name)) THEN
1041:
1042: fnd_message.set_name('QA', 'QA_SPEC_COMBINATION_EXISTS');
1043: fnd_message.set_token('ENTITY1', l_existing_spec_name);
1044: fnd_msg_pub.add();
1045: RAISE fnd_api.g_exc_error;
1046: END IF;
1047:

Line 1249: fnd_message.set_name('QA', 'QA_API_INVALID_USER');

1245: x_return_status := fnd_api.g_ret_sts_success;
1246:
1247: l_user_id := get_user_id(p_user_name);
1248: IF l_user_id = -1 THEN
1249: fnd_message.set_name('QA', 'QA_API_INVALID_USER');
1250: fnd_msg_pub.add();
1251: raise fnd_api.g_exc_error;
1252: END IF;
1253:

Line 1259: fnd_message.set_name('QA', 'QA_SPEC_ELEM_TO_CHILD');

1255: l_spec_id := get_spec_id(p_spec_name, p_organization_code);
1256:
1257: -- See if the spec is a child and throw exception appropriately
1258: IF is_child_spec(l_spec_id) THEN
1259: fnd_message.set_name('QA', 'QA_SPEC_ELEM_TO_CHILD');
1260: fnd_msg_pub.add();
1261: raise fnd_api.g_exc_error;
1262: END IF;
1263:

Line 1265: fnd_message.set_name ('QA', 'QA_API_DUPLICATE_SPEC_ELEMENT');

1261: raise fnd_api.g_exc_error;
1262: END IF;
1263:
1264: IF (spec_element_exists(l_spec_id, l_char_id)) THEN
1265: fnd_message.set_name ('QA', 'QA_API_DUPLICATE_SPEC_ELEMENT');
1266: fnd_msg_pub.add();
1267: RAISE fnd_api.g_exc_error;
1268: END IF;
1269:

Line 1282: fnd_message.set_name('QA', 'QA_LSL_GREATER_THAN_USL');

1278: validate_datatype(p_lower_user_defined_limit, l_datatype);
1279:
1280: IF qltcompb.compare(p_upper_spec_limit, 6, p_lower_spec_limit, null,
1281: l_datatype) THEN
1282: fnd_message.set_name('QA', 'QA_LSL_GREATER_THAN_USL');
1283: fnd_msg_pub.add();
1284: RAISE fnd_api.g_exc_error;
1285: END IF;
1286:

Line 1289: fnd_message.set_name('QA', 'QA_LRL_GREATER_THAN_URL');

1285: END IF;
1286:
1287: IF qltcompb.compare(p_upper_reasonable_limit, 6, p_lower_reasonable_limit,
1288: null, l_datatype) THEN
1289: fnd_message.set_name('QA', 'QA_LRL_GREATER_THAN_URL');
1290: fnd_msg_pub.add();
1291: RAISE fnd_api.g_exc_error;
1292: END IF;
1293:

Line 1296: fnd_message.set_name('QA', 'QA_LUL_GREATER_THAN_UUL');

1292: END IF;
1293:
1294: IF qltcompb.compare(p_upper_user_defined_limit, 6,
1295: p_lower_user_defined_limit, null, l_datatype) THEN
1296: fnd_message.set_name('QA', 'QA_LUL_GREATER_THAN_UUL');
1297: fnd_msg_pub.add();
1298: RAISE fnd_api.g_exc_error;
1299: END IF;
1300:

Line 1447: fnd_message.set_name('QA', 'QA_API_INVALID_USER');

1443: x_return_status := fnd_api.g_ret_sts_success;
1444:
1445: l_user_id := get_user_id(p_user_name);
1446: IF l_user_id = -1 THEN
1447: fnd_message.set_name('QA', 'QA_API_INVALID_USER');
1448: fnd_msg_pub.add();
1449: raise fnd_api.g_exc_error;
1450: END IF;
1451:

Line 1568: fnd_message.set_name('QA', 'QA_API_INVALID_USER');

1564: x_return_status := fnd_api.g_ret_sts_success;
1565:
1566: l_user_id := get_user_id(p_user_name);
1567: IF l_user_id = -1 THEN
1568: fnd_message.set_name('QA', 'QA_API_INVALID_USER');
1569: fnd_msg_pub.add();
1570: raise fnd_api.g_exc_error;
1571: END IF;
1572:

Line 1577: fnd_message.set_name('QA', 'QA_CHILD_SPECS_EXIST');

1573: l_spec_id := get_spec_id(p_spec_name, p_organization_code);
1574:
1575: -- Perfect place to check for child specs
1576: IF child_spec_exists(l_spec_id) THEN
1577: fnd_message.set_name('QA', 'QA_CHILD_SPECS_EXIST');
1578: fnd_msg_pub.add();
1579: raise fnd_api.g_exc_error;
1580: END IF;
1581:

Line 1669: fnd_message.set_name('QA', 'QA_API_INVALID_USER');

1665: x_return_status := fnd_api.g_ret_sts_success;
1666:
1667: l_user_id := get_user_id(p_user_name);
1668: IF l_user_id = -1 THEN
1669: fnd_message.set_name('QA', 'QA_API_INVALID_USER');
1670: fnd_msg_pub.add();
1671: raise fnd_api.g_exc_error;
1672: END IF;
1673:

Line 1678: fnd_message.set_name('QA', 'QA_DELETE_SPEC_ELEM_ON_CHILD');

1674: l_spec_id := get_spec_id(p_spec_name, p_organization_code);
1675:
1676: -- We must be checking here if the spec is a child
1677: IF is_child_spec(l_spec_id) THEN
1678: fnd_message.set_name('QA', 'QA_DELETE_SPEC_ELEM_ON_CHILD');
1679: fnd_msg_pub.add();
1680: raise fnd_api.g_exc_error;
1681: END IF;
1682:

Line 1794: fnd_message.set_name('QA', 'QA_API_INVALID_USER');

1790: x_return_status := fnd_api.g_ret_sts_success;
1791:
1792: l_user_id := get_user_id(p_user_name);
1793: IF l_user_id = -1 THEN
1794: fnd_message.set_name('QA', 'QA_API_INVALID_USER');
1795: fnd_msg_pub.add();
1796: raise fnd_api.g_exc_error;
1797: END IF;
1798:

Line 1804: fnd_message.set_name('QA', 'QA_API_INVALID_ORG_CODE');

1800: l_org_id := organization_id(l_spec_id);
1801:
1802: l_to_org_id := qa_plans_api.get_org_id(p_to_organization_code);
1803: IF (l_to_org_id IS NULL) THEN
1804: fnd_message.set_name('QA', 'QA_API_INVALID_ORG_CODE');
1805: fnd_msg_pub.add();
1806: RAISE fnd_api.g_exc_error;
1807: END IF;
1808:

Line 1810: fnd_message.set_name('QA', 'QA_API_DUPLICATE_SPEC_NAME');

1806: RAISE fnd_api.g_exc_error;
1807: END IF;
1808:
1809: IF (spec_exists(p_to_spec_name)) THEN
1810: fnd_message.set_name('QA', 'QA_API_DUPLICATE_SPEC_NAME');
1811: fnd_msg_pub.add();
1812: RAISE fnd_api.g_exc_error;
1813: END IF;
1814:

Line 1829: fnd_message.set_name('QA', 'QA_SPEC_COMBINATION_EXISTS');

1825: IF (combination_exists(l_category_set_id, l_category_id, l_to_item_id,
1826: p_to_item_revision, l_org_id, l_vendor_id, l_customer_id, l_char_id,
1827: l_spec_element_value, l_existing_spec_name)) THEN
1828:
1829: fnd_message.set_name('QA', 'QA_SPEC_COMBINATION_EXISTS');
1830: fnd_message.set_token('ENTITY1', l_existing_spec_name);
1831: fnd_msg_pub.add();
1832: RAISE fnd_api.g_exc_error;
1833: END IF;

Line 1830: fnd_message.set_token('ENTITY1', l_existing_spec_name);

1826: p_to_item_revision, l_org_id, l_vendor_id, l_customer_id, l_char_id,
1827: l_spec_element_value, l_existing_spec_name)) THEN
1828:
1829: fnd_message.set_name('QA', 'QA_SPEC_COMBINATION_EXISTS');
1830: fnd_message.set_token('ENTITY1', l_existing_spec_name);
1831: fnd_msg_pub.add();
1832: RAISE fnd_api.g_exc_error;
1833: END IF;
1834: