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_MSG_PUB

Line 282: fnd_msg_pub.add();

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:
286: CLOSE c;

Line 317: fnd_msg_pub.add();

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:
321: END check_for_spec_element;

Line 358: fnd_msg_pub.add();

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);
362: IF (l_revision_flag = 1) THEN

Line 366: fnd_msg_pub.add();

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:
370: ELSIF (l_revision_flag = 2) and (p_item_revision IS NULL) THEN

Line 372: fnd_msg_pub.add();

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
376: IF NOT qa_plan_element_api.validate_revision(p_org_id,

Line 379: fnd_msg_pub.add();

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;
383: END IF;

Line 406: fnd_msg_pub.add();

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:
410: ELSIF p_datatype = qa_ss_const.date_datatype THEN

Line 415: fnd_msg_pub.add();

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;
419:

Line 487: fnd_msg_pub.add();

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:
491: RETURN l_category_set_id;

Line 534: fnd_msg_pub.add();

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:
538: RETURN l_category_id;

Line 564: fnd_msg_pub.add();

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:
568: CLOSE c;

Line 856: fnd_msg_pub.initialize;

852: END IF;
853:
854: -- Initialize message list if p_init_msg_list is set to TRUE.
855: IF fnd_api.to_boolean(p_init_msg_list) THEN
856: fnd_msg_pub.initialize;
857: END IF;
858:
859:
860: -- Initialize API return status to success

Line 866: fnd_msg_pub.add();

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:
870: -- Algorithm

Line 910: fnd_msg_pub.add();

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:
914: -- See if the spec exists with p_common_spec_name

Line 918: fnd_msg_pub.add();

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:
922: -- Force not to reference a child spec if common_spec_name is passed

Line 925: fnd_msg_pub.add();

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:
929: l_org_id := qa_plans_api.get_org_id(p_organization_code);

Line 933: fnd_msg_pub.add();

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:
937: IF (p_effective_to IS NOT NULL) THEN

Line 940: fnd_msg_pub.add();

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;
944:

Line 971: fnd_msg_pub.add();

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:
975: ELSIF (p_assignment_type = g_spec_type_customer) THEN

Line 1000: fnd_msg_pub.add();

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:
1004: ELSE

Line 1006: fnd_msg_pub.add();

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:
1010: IF (p_item_name IS NOT NULL) THEN

Line 1030: fnd_msg_pub.add();

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
1034: l_char_id := -1;

Line 1044: fnd_msg_pub.add();

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:
1048: SELECT qa_specs_s.nextval INTO x_spec_id FROM DUAL;

Line 1142: fnd_msg_pub.count_and_get(

1138:
1139: WHEN fnd_api.g_exc_error THEN
1140: ROLLBACK TO create_specification_pub;
1141: x_return_status := fnd_api.g_ret_sts_error;
1142: fnd_msg_pub.count_and_get(
1143: p_count => x_msg_count,
1144: p_data => x_msg_data
1145: );
1146:

Line 1150: fnd_msg_pub.count_and_get(

1146:
1147: WHEN fnd_api.g_exc_unexpected_error THEN
1148: ROLLBACK TO create_specification_pub;
1149: x_return_status := fnd_api.g_ret_sts_unexp_error;
1150: fnd_msg_pub.count_and_get(
1151: p_count => x_msg_count,
1152: p_data => x_msg_data
1153: );
1154:

Line 1159: IF fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1155: WHEN OTHERS THEN
1156: -- dbms_output.put_line(SQLCODE || SQLERRM);
1157: ROLLBACK TO create_specification_pub;
1158: x_return_status := fnd_api.g_ret_sts_unexp_error;
1159: IF fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1160: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);
1161: END IF;
1162: fnd_msg_pub.count_and_get(
1163: p_count => x_msg_count,

Line 1160: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);

1156: -- dbms_output.put_line(SQLCODE || SQLERRM);
1157: ROLLBACK TO create_specification_pub;
1158: x_return_status := fnd_api.g_ret_sts_unexp_error;
1159: IF fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1160: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);
1161: END IF;
1162: fnd_msg_pub.count_and_get(
1163: p_count => x_msg_count,
1164: p_data => x_msg_data

Line 1162: fnd_msg_pub.count_and_get(

1158: x_return_status := fnd_api.g_ret_sts_unexp_error;
1159: IF fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1160: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);
1161: END IF;
1162: fnd_msg_pub.count_and_get(
1163: p_count => x_msg_count,
1164: p_data => x_msg_data
1165: );
1166:

Line 1241: fnd_msg_pub.initialize;

1237: END IF;
1238:
1239: -- Initialize message list if p_init_msg_list is set to TRUE.
1240: IF fnd_api.to_boolean(p_init_msg_list) THEN
1241: fnd_msg_pub.initialize;
1242: END IF;
1243:
1244: -- Initialize API return status to success
1245: x_return_status := fnd_api.g_ret_sts_success;

Line 1250: fnd_msg_pub.add();

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:
1254: l_char_id := get_context_element_id(p_element_name);

Line 1260: fnd_msg_pub.add();

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:
1264: IF (spec_element_exists(l_spec_id, l_char_id)) THEN

Line 1266: fnd_msg_pub.add();

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:
1270: l_datatype := qa_chars_api.datatype(l_char_id);

Line 1283: fnd_msg_pub.add();

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:
1287: IF qltcompb.compare(p_upper_reasonable_limit, 6, p_lower_reasonable_limit,

Line 1290: fnd_msg_pub.add();

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:
1294: IF qltcompb.compare(p_upper_user_defined_limit, 6,

Line 1297: fnd_msg_pub.add();

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:
1301: l_enabled_flag := convert_flag(p_enabled_flag);

Line 1381: fnd_msg_pub.count_and_get(

1377:
1378: WHEN fnd_api.g_exc_error THEN
1379: ROLLBACK TO add_spec_element;
1380: x_return_status := fnd_api.g_ret_sts_error;
1381: fnd_msg_pub.count_and_get(
1382: p_count => x_msg_count,
1383: p_data => x_msg_data
1384: );
1385:

Line 1389: fnd_msg_pub.count_and_get(

1385:
1386: WHEN fnd_api.g_exc_unexpected_error THEN
1387: ROLLBACK TO add_spec_element;
1388: x_return_status := fnd_api.g_ret_sts_unexp_error;
1389: fnd_msg_pub.count_and_get(
1390: p_count => x_msg_count,
1391: p_data => x_msg_data
1392: );
1393:

Line 1397: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1393:
1394: WHEN OTHERS THEN
1395: ROLLBACK TO add_spec_element;
1396: x_return_status := fnd_api.g_ret_sts_unexp_error;
1397: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1398: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1399: END IF;
1400: fnd_msg_pub.count_and_get(
1401: p_count => x_msg_count,

Line 1398: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1394: WHEN OTHERS THEN
1395: ROLLBACK TO add_spec_element;
1396: x_return_status := fnd_api.g_ret_sts_unexp_error;
1397: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1398: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1399: END IF;
1400: fnd_msg_pub.count_and_get(
1401: p_count => x_msg_count,
1402: p_data => x_msg_data

Line 1400: fnd_msg_pub.count_and_get(

1396: x_return_status := fnd_api.g_ret_sts_unexp_error;
1397: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1398: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1399: END IF;
1400: fnd_msg_pub.count_and_get(
1401: p_count => x_msg_count,
1402: p_data => x_msg_data
1403: );
1404:

Line 1439: fnd_msg_pub.initialize;

1435: END IF;
1436:
1437: -- Initialize message list if p_init_msg_list is set to TRUE.
1438: IF fnd_api.to_boolean(p_init_msg_list) THEN
1439: fnd_msg_pub.initialize;
1440: END IF;
1441:
1442: -- Initialize API return status to success
1443: x_return_status := fnd_api.g_ret_sts_success;

Line 1448: fnd_msg_pub.add();

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:
1452: l_spec_id := get_spec_id(p_spec_name, p_organization_code);

Line 1464: fnd_msg_pub.count_and_get(

1460:
1461: WHEN fnd_api.g_exc_error THEN
1462: ROLLBACK TO complete_spec_definition;
1463: x_return_status := fnd_api.g_ret_sts_error;
1464: fnd_msg_pub.count_and_get(
1465: p_count => x_msg_count,
1466: p_data => x_msg_data
1467: );
1468:

Line 1472: fnd_msg_pub.count_and_get(

1468:
1469: WHEN fnd_api.g_exc_unexpected_error THEN
1470: ROLLBACK TO complete_spec_definition;
1471: x_return_status := fnd_api.g_ret_sts_unexp_error;
1472: fnd_msg_pub.count_and_get(
1473: p_count => x_msg_count,
1474: p_data => x_msg_data
1475: );
1476:

Line 1480: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1476:
1477: WHEN OTHERS THEN
1478: ROLLBACK TO complete_spec_definition;
1479: x_return_status := fnd_api.g_ret_sts_unexp_error;
1480: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1481: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1482: END IF;
1483: fnd_msg_pub.count_and_get(
1484: p_count => x_msg_count,

Line 1481: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1477: WHEN OTHERS THEN
1478: ROLLBACK TO complete_spec_definition;
1479: x_return_status := fnd_api.g_ret_sts_unexp_error;
1480: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1481: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1482: END IF;
1483: fnd_msg_pub.count_and_get(
1484: p_count => x_msg_count,
1485: p_data => x_msg_data

Line 1483: fnd_msg_pub.count_and_get(

1479: x_return_status := fnd_api.g_ret_sts_unexp_error;
1480: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1481: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1482: END IF;
1483: fnd_msg_pub.count_and_get(
1484: p_count => x_msg_count,
1485: p_data => x_msg_data
1486: );
1487:

Line 1560: fnd_msg_pub.initialize;

1556: END IF;
1557:
1558: -- Initialize message list if p_init_msg_list is set to TRUE.
1559: IF fnd_api.to_boolean(p_init_msg_list) THEN
1560: fnd_msg_pub.initialize;
1561: END IF;
1562:
1563: -- Initialize API return status to success
1564: x_return_status := fnd_api.g_ret_sts_success;

Line 1569: fnd_msg_pub.add();

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:
1573: l_spec_id := get_spec_id(p_spec_name, p_organization_code);

Line 1578: fnd_msg_pub.add();

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:
1582: delete_spec_private(l_spec_id);

Line 1593: fnd_msg_pub.count_and_get(

1589:
1590: WHEN fnd_api.g_exc_error THEN
1591: ROLLBACK TO delete_specification;
1592: x_return_status := fnd_api.g_ret_sts_error;
1593: fnd_msg_pub.count_and_get(
1594: p_count => x_msg_count,
1595: p_data => x_msg_data
1596: );
1597:

Line 1601: fnd_msg_pub.count_and_get(

1597:
1598: WHEN fnd_api.g_exc_unexpected_error THEN
1599: ROLLBACK TO delete_specification;
1600: x_return_status := fnd_api.g_ret_sts_unexp_error;
1601: fnd_msg_pub.count_and_get(
1602: p_count => x_msg_count,
1603: p_data => x_msg_data
1604: );
1605:

Line 1609: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1605:
1606: WHEN OTHERS THEN
1607: ROLLBACK TO delete_specification;
1608: x_return_status := fnd_api.g_ret_sts_unexp_error;
1609: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1610: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);
1611: END IF;
1612: fnd_msg_pub.count_and_get(
1613: p_count => x_msg_count,

Line 1610: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);

1606: WHEN OTHERS THEN
1607: ROLLBACK TO delete_specification;
1608: x_return_status := fnd_api.g_ret_sts_unexp_error;
1609: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1610: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);
1611: END IF;
1612: fnd_msg_pub.count_and_get(
1613: p_count => x_msg_count,
1614: p_data => x_msg_data

Line 1612: fnd_msg_pub.count_and_get(

1608: x_return_status := fnd_api.g_ret_sts_unexp_error;
1609: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1610: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);
1611: END IF;
1612: fnd_msg_pub.count_and_get(
1613: p_count => x_msg_count,
1614: p_data => x_msg_data
1615: );
1616:

Line 1661: fnd_msg_pub.initialize;

1657: END IF;
1658:
1659: -- Initialize message list if p_init_msg_list is set to TRUE.
1660: IF fnd_api.to_boolean(p_init_msg_list) THEN
1661: fnd_msg_pub.initialize;
1662: END IF;
1663:
1664: -- Initialize API return status to success
1665: x_return_status := fnd_api.g_ret_sts_success;

Line 1670: fnd_msg_pub.add();

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:
1674: l_spec_id := get_spec_id(p_spec_name, p_organization_code);

Line 1679: fnd_msg_pub.add();

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:
1683: l_char_id := get_context_element_id(p_element_name);

Line 1696: fnd_msg_pub.count_and_get(

1692:
1693: WHEN fnd_api.g_exc_error THEN
1694: ROLLBACK TO delete_spec_element;
1695: x_return_status := fnd_api.g_ret_sts_error;
1696: fnd_msg_pub.count_and_get(
1697: p_count => x_msg_count,
1698: p_data => x_msg_data
1699: );
1700:

Line 1704: fnd_msg_pub.count_and_get(

1700:
1701: WHEN fnd_api.g_exc_unexpected_error THEN
1702: ROLLBACK TO delete_spec_element;
1703: x_return_status := fnd_api.g_ret_sts_unexp_error;
1704: fnd_msg_pub.count_and_get(
1705: p_count => x_msg_count,
1706: p_data => x_msg_data
1707: );
1708:

Line 1712: IF fnd_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1708:
1709: WHEN OTHERS THEN
1710: ROLLBACK TO delete_spec_element;
1711: x_return_status := fnd_api.g_ret_sts_unexp_error;
1712: IF fnd_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1713: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1714: END IF;
1715: fnd_msg_pub.count_and_get(
1716: p_count => x_msg_count,

Line 1713: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1709: WHEN OTHERS THEN
1710: ROLLBACK TO delete_spec_element;
1711: x_return_status := fnd_api.g_ret_sts_unexp_error;
1712: IF fnd_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1713: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1714: END IF;
1715: fnd_msg_pub.count_and_get(
1716: p_count => x_msg_count,
1717: p_data => x_msg_data

Line 1715: fnd_msg_pub.count_and_get(

1711: x_return_status := fnd_api.g_ret_sts_unexp_error;
1712: IF fnd_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1713: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1714: END IF;
1715: fnd_msg_pub.count_and_get(
1716: p_count => x_msg_count,
1717: p_data => x_msg_data
1718: );
1719:

Line 1786: fnd_msg_pub.initialize;

1782: END IF;
1783:
1784: -- Initialize message list if p_init_msg_list is set to TRUE.
1785: IF fnd_api.to_boolean(p_init_msg_list) THEN
1786: fnd_msg_pub.initialize;
1787: END IF;
1788:
1789: -- Initialize API return status to success
1790: x_return_status := fnd_api.g_ret_sts_success;

Line 1795: fnd_msg_pub.add();

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:
1799: l_spec_id := get_spec_id(p_spec_name, p_organization_code);

Line 1805: fnd_msg_pub.add();

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:
1809: IF (spec_exists(p_to_spec_name)) THEN

Line 1811: fnd_msg_pub.add();

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:
1815: l_to_item_id := process_item_and_revision(p_to_item_name,

Line 1831: fnd_msg_pub.add();

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:
1835: SELECT qa_specs_s.nextval INTO x_spec_id FROM DUAL;

Line 1946: fnd_msg_pub.count_and_get(

1942:
1943: WHEN fnd_api.g_exc_error THEN
1944: ROLLBACK TO copy_specification;
1945: x_return_status := fnd_api.g_ret_sts_error;
1946: fnd_msg_pub.count_and_get(
1947: p_count => x_msg_count,
1948: p_data => x_msg_data
1949: );
1950:

Line 1954: fnd_msg_pub.count_and_get(

1950:
1951: WHEN fnd_api.g_exc_unexpected_error THEN
1952: ROLLBACK TO copy_specification;
1953: x_return_status := fnd_api.g_ret_sts_unexp_error;
1954: fnd_msg_pub.count_and_get(
1955: p_count => x_msg_count,
1956: p_data => x_msg_data
1957: );
1958:

Line 1962: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1958:
1959: WHEN OTHERS THEN
1960: ROLLBACK TO copy_specification;
1961: x_return_status := fnd_api.g_ret_sts_unexp_error;
1962: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1963: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);
1964: END IF;
1965: fnd_msg_pub.count_and_get(
1966: p_count => x_msg_count,

Line 1963: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);

1959: WHEN OTHERS THEN
1960: ROLLBACK TO copy_specification;
1961: x_return_status := fnd_api.g_ret_sts_unexp_error;
1962: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1963: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);
1964: END IF;
1965: fnd_msg_pub.count_and_get(
1966: p_count => x_msg_count,
1967: p_data => x_msg_data

Line 1965: fnd_msg_pub.count_and_get(

1961: x_return_status := fnd_api.g_ret_sts_unexp_error;
1962: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1963: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_api_name);
1964: END IF;
1965: fnd_msg_pub.count_and_get(
1966: p_count => x_msg_count,
1967: p_data => x_msg_data
1968: );
1969: