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 853: fnd_message.set_name('QA', 'QA_API_INVALID_USER');

849: x_return_status := fnd_api.g_ret_sts_success;
850:
851: l_user_id := get_user_id(p_user_name);
852: IF l_user_id = -1 THEN
853: fnd_message.set_name('QA', 'QA_API_INVALID_USER');
854: fnd_msg_pub.add();
855: raise fnd_api.g_exc_error;
856: END IF;
857:

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

893: --
894: -- 8. insert the row
895:
896: IF (spec_exists(p_spec_name)) THEN
897: fnd_message.set_name('QA', 'QA_API_DUPLICATE_SPEC_NAME');
898: fnd_msg_pub.add();
899: RAISE fnd_api.g_exc_error;
900: END IF;
901:

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

900: END IF;
901:
902: -- See if the spec exists with p_common_spec_name
903: IF p_reference_spec IS NOT NULL AND NOT spec_exists(p_reference_spec) THEN
904: fnd_message.set_name('QA', 'QA_SPEC_NOT_EXISTS');
905: fnd_message.set_token('ENTITY1', p_reference_spec);
906: fnd_msg_pub.add();
907: RAISE fnd_api.g_exc_error;
908: END IF;

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

901:
902: -- See if the spec exists with p_common_spec_name
903: IF p_reference_spec IS NOT NULL AND NOT spec_exists(p_reference_spec) THEN
904: fnd_message.set_name('QA', 'QA_SPEC_NOT_EXISTS');
905: fnd_message.set_token('ENTITY1', p_reference_spec);
906: fnd_msg_pub.add();
907: RAISE fnd_api.g_exc_error;
908: END IF;
909:

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

908: END IF;
909:
910: -- Force not to reference a child spec if common_spec_name is passed
911: IF p_reference_spec IS NOT NULL AND is_child_spec(p_reference_spec) THEN
912: fnd_message.set_name('QA', 'QA_CANNOT_REFER_CHILD_SPEC');
913: fnd_msg_pub.add();
914: RAISE fnd_api.g_exc_error;
915: END IF;
916:

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

916:
917: l_org_id := qa_plans_api.get_org_id(p_organization_code);
918:
919: IF (l_org_id IS NULL) THEN
920: fnd_message.set_name('QA', 'QA_API_INVALID_ORG_CODE');
921: fnd_msg_pub.add();
922: RAISE fnd_api.g_exc_error;
923: END IF;
924:

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

923: END IF;
924:
925: IF (p_effective_to IS NOT NULL) THEN
926: IF (p_effective_to < p_effective_from) THEN
927: fnd_message.set_name('QA', 'QA_EFFECTIVE_DATE_RANGE');
928: fnd_msg_pub.add();
929: RAISE fnd_api.g_exc_error;
930: END IF;
931: END IF;

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

935:
936: ELSIF (p_assignment_type = g_spec_type_supplier) THEN
937: l_vendor_id := qa_plan_element_api.get_supplier_id(p_supplier_name);
938: IF (l_vendor_id IS NULL) THEN
939: fnd_message.set_name('QA', 'QA_API_INVALID_VENDOR_NAME');
940: fnd_msg_pub.add();
941: RAISE fnd_api.g_exc_error;
942: END IF;
943:

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

943:
944: ELSIF (p_assignment_type = g_spec_type_customer) THEN
945: l_customer_id := qa_plan_element_api.get_customer_id(p_customer_name);
946: IF (l_customer_id IS NULL) THEN
947: fnd_message.set_name('QA', 'QA_API_INVALID_CUSTOMER_NAME');
948: fnd_msg_pub.add();
949: RAISE fnd_api.g_exc_error;
950: END IF;
951:

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

949: RAISE fnd_api.g_exc_error;
950: END IF;
951:
952: ELSE
953: fnd_message.set_name('QA', 'QA_API_INVALID_ASSIGNMENT_TYPE');
954: fnd_msg_pub.add();
955: RAISE fnd_api.g_exc_error;
956: END IF;
957:

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

973: IF (l_char_id IS NOT NULL) THEN
974: l_datatype := qa_chars_api.datatype(l_char_id);
975: validate_datatype(l_sub_type_value, l_datatype);
976: ELSE
977: fnd_message.set_name('QA', 'QA_API_INVALID_ELEMENT');
978: fnd_msg_pub.add();
979: RAISE fnd_api.g_exc_error;
980: END IF;
981: ELSE

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

986: IF (combination_exists(l_category_set_id, l_category_id, l_item_id,
987: p_item_revision, l_org_id, l_vendor_id, l_customer_id, l_char_id,
988: l_sub_type_value, l_existing_spec_name)) THEN
989:
990: fnd_message.set_name('QA', 'QA_SPEC_COMBINATION_EXISTS');
991: fnd_message.set_token('ENTITY1', l_existing_spec_name);
992: fnd_msg_pub.add();
993: RAISE fnd_api.g_exc_error;
994: END IF;

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

987: p_item_revision, l_org_id, l_vendor_id, l_customer_id, l_char_id,
988: l_sub_type_value, l_existing_spec_name)) THEN
989:
990: fnd_message.set_name('QA', 'QA_SPEC_COMBINATION_EXISTS');
991: fnd_message.set_token('ENTITY1', l_existing_spec_name);
992: fnd_msg_pub.add();
993: RAISE fnd_api.g_exc_error;
994: END IF;
995:

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

1193: x_return_status := fnd_api.g_ret_sts_success;
1194:
1195: l_user_id := get_user_id(p_user_name);
1196: IF l_user_id = -1 THEN
1197: fnd_message.set_name('QA', 'QA_API_INVALID_USER');
1198: fnd_msg_pub.add();
1199: raise fnd_api.g_exc_error;
1200: END IF;
1201:

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

1203: l_spec_id := get_spec_id(p_spec_name, p_organization_code);
1204:
1205: -- See if the spec is a child and throw exception appropriately
1206: IF is_child_spec(l_spec_id) THEN
1207: fnd_message.set_name('QA', 'QA_SPEC_ELEM_TO_CHILD');
1208: fnd_msg_pub.add();
1209: raise fnd_api.g_exc_error;
1210: END IF;
1211:

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

1209: raise fnd_api.g_exc_error;
1210: END IF;
1211:
1212: IF (spec_element_exists(l_spec_id, l_char_id)) THEN
1213: fnd_message.set_name ('QA', 'QA_API_DUPLICATE_SPEC_ELEMENT');
1214: fnd_msg_pub.add();
1215: RAISE fnd_api.g_exc_error;
1216: END IF;
1217:

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

1226: validate_datatype(p_lower_user_defined_limit, l_datatype);
1227:
1228: IF qltcompb.compare(p_upper_spec_limit, 6, p_lower_spec_limit, null,
1229: l_datatype) THEN
1230: fnd_message.set_name('QA', 'QA_LSL_GREATER_THAN_USL');
1231: fnd_msg_pub.add();
1232: RAISE fnd_api.g_exc_error;
1233: END IF;
1234:

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

1233: END IF;
1234:
1235: IF qltcompb.compare(p_upper_reasonable_limit, 6, p_lower_reasonable_limit,
1236: null, l_datatype) THEN
1237: fnd_message.set_name('QA', 'QA_LRL_GREATER_THAN_URL');
1238: fnd_msg_pub.add();
1239: RAISE fnd_api.g_exc_error;
1240: END IF;
1241:

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

1240: END IF;
1241:
1242: IF qltcompb.compare(p_upper_user_defined_limit, 6,
1243: p_lower_user_defined_limit, null, l_datatype) THEN
1244: fnd_message.set_name('QA', 'QA_LUL_GREATER_THAN_UUL');
1245: fnd_msg_pub.add();
1246: RAISE fnd_api.g_exc_error;
1247: END IF;
1248:

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

1391: x_return_status := fnd_api.g_ret_sts_success;
1392:
1393: l_user_id := get_user_id(p_user_name);
1394: IF l_user_id = -1 THEN
1395: fnd_message.set_name('QA', 'QA_API_INVALID_USER');
1396: fnd_msg_pub.add();
1397: raise fnd_api.g_exc_error;
1398: END IF;
1399:

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

1512: x_return_status := fnd_api.g_ret_sts_success;
1513:
1514: l_user_id := get_user_id(p_user_name);
1515: IF l_user_id = -1 THEN
1516: fnd_message.set_name('QA', 'QA_API_INVALID_USER');
1517: fnd_msg_pub.add();
1518: raise fnd_api.g_exc_error;
1519: END IF;
1520:

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

1521: l_spec_id := get_spec_id(p_spec_name, p_organization_code);
1522:
1523: -- Perfect place to check for child specs
1524: IF child_spec_exists(l_spec_id) THEN
1525: fnd_message.set_name('QA', 'QA_CHILD_SPECS_EXIST');
1526: fnd_msg_pub.add();
1527: raise fnd_api.g_exc_error;
1528: END IF;
1529:

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

1613: x_return_status := fnd_api.g_ret_sts_success;
1614:
1615: l_user_id := get_user_id(p_user_name);
1616: IF l_user_id = -1 THEN
1617: fnd_message.set_name('QA', 'QA_API_INVALID_USER');
1618: fnd_msg_pub.add();
1619: raise fnd_api.g_exc_error;
1620: END IF;
1621:

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

1622: l_spec_id := get_spec_id(p_spec_name, p_organization_code);
1623:
1624: -- We must be checking here if the spec is a child
1625: IF is_child_spec(l_spec_id) THEN
1626: fnd_message.set_name('QA', 'QA_DELETE_SPEC_ELEM_ON_CHILD');
1627: fnd_msg_pub.add();
1628: raise fnd_api.g_exc_error;
1629: END IF;
1630:

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

1738: x_return_status := fnd_api.g_ret_sts_success;
1739:
1740: l_user_id := get_user_id(p_user_name);
1741: IF l_user_id = -1 THEN
1742: fnd_message.set_name('QA', 'QA_API_INVALID_USER');
1743: fnd_msg_pub.add();
1744: raise fnd_api.g_exc_error;
1745: END IF;
1746:

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

1748: l_org_id := organization_id(l_spec_id);
1749:
1750: l_to_org_id := qa_plans_api.get_org_id(p_to_organization_code);
1751: IF (l_to_org_id IS NULL) THEN
1752: fnd_message.set_name('QA', 'QA_API_INVALID_ORG_CODE');
1753: fnd_msg_pub.add();
1754: RAISE fnd_api.g_exc_error;
1755: END IF;
1756:

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

1754: RAISE fnd_api.g_exc_error;
1755: END IF;
1756:
1757: IF (spec_exists(p_to_spec_name)) THEN
1758: fnd_message.set_name('QA', 'QA_API_DUPLICATE_SPEC_NAME');
1759: fnd_msg_pub.add();
1760: RAISE fnd_api.g_exc_error;
1761: END IF;
1762:

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

1773: IF (combination_exists(l_category_set_id, l_category_id, l_to_item_id,
1774: p_to_item_revision, l_org_id, l_vendor_id, l_customer_id, l_char_id,
1775: l_spec_element_value, l_existing_spec_name)) THEN
1776:
1777: fnd_message.set_name('QA', 'QA_SPEC_COMBINATION_EXISTS');
1778: fnd_message.set_token('ENTITY1', l_existing_spec_name);
1779: fnd_msg_pub.add();
1780: RAISE fnd_api.g_exc_error;
1781: END IF;

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

1774: p_to_item_revision, l_org_id, l_vendor_id, l_customer_id, l_char_id,
1775: l_spec_element_value, l_existing_spec_name)) THEN
1776:
1777: fnd_message.set_name('QA', 'QA_SPEC_COMBINATION_EXISTS');
1778: fnd_message.set_token('ENTITY1', l_existing_spec_name);
1779: fnd_msg_pub.add();
1780: RAISE fnd_api.g_exc_error;
1781: END IF;
1782: