DBA Data[Home] [Help]

APPS.QA_PLANS_PUB dependencies on FND_MESSAGE

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

264: IF p_datatype = qa_ss_const.number_datatype THEN
265: BEGIN
266: temp_number := to_number(p_value);
267: EXCEPTION WHEN OTHERS THEN
268: fnd_message.set_name('QA','QA_INVALID_NUMBER');
269: fnd_msg_pub.add();
270: RAISE fnd_api.g_exc_error;
271: END;
272:

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

273: ELSIF p_datatype = qa_ss_const.date_datatype THEN
274: BEGIN
275: temp_date := qltdate.any_to_date(p_value);
276: EXCEPTION WHEN OTHERS THEN
277: fnd_message.set_name('QA','QA_INVALID_DATE');
278: fnd_msg_pub.add();
279: RAISE fnd_api.g_exc_error;
280: END;
281: END IF;

Line 447: fnd_message.set_name('QA', 'QA_CHAR_REGENERATE_INDEX');

443: --
444: dummy NUMBER;
445: BEGIN
446: dummy := qa_char_indexes_pkg.disable_index(p_char_id);
447: fnd_message.set_name('QA', 'QA_CHAR_REGENERATE_INDEX');
448: fnd_message.set_token('ELEMENT_NAME',
449: qa_chars_api.get_element_name(p_char_id));
450: fnd_msg_pub.add;
451: END disable_index_private;

Line 448: fnd_message.set_token('ELEMENT_NAME',

444: dummy NUMBER;
445: BEGIN
446: dummy := qa_char_indexes_pkg.disable_index(p_char_id);
447: fnd_message.set_name('QA', 'QA_CHAR_REGENERATE_INDEX');
448: fnd_message.set_token('ELEMENT_NAME',
449: qa_chars_api.get_element_name(p_char_id));
450: fnd_msg_pub.add;
451: END disable_index_private;
452:

Line 742: fnd_message.set_name ('QA', 'QA_DEPENDENT_LOT_ON_ITEM');

738:
739: IF (item_flag = 2) THEN
740:
741: IF (lot_number_flag = 1) THEN
742: fnd_message.set_name ('QA', 'QA_DEPENDENT_LOT_ON_ITEM');
743: fnd_msg_pub.add();
744: RAISE fnd_api.g_exc_error;
745: END IF;
746:

Line 748: fnd_message.set_name ('QA', 'QA_DEPENDENT_SERIAL_ON_ITEM');

744: RAISE fnd_api.g_exc_error;
745: END IF;
746:
747: IF (serial_number_flag = 1) THEN
748: fnd_message.set_name ('QA', 'QA_DEPENDENT_SERIAL_ON_ITEM');
749: fnd_msg_pub.add();
750: RAISE fnd_api.g_exc_error;
751: END IF;
752:

Line 754: fnd_message.set_name ('QA', 'QA_DEPENDENT_WIP_LINE_ON_ITEM');

750: RAISE fnd_api.g_exc_error;
751: END IF;
752:
753: IF (wip_line_flag = 1) THEN
754: fnd_message.set_name ('QA', 'QA_DEPENDENT_WIP_LINE_ON_ITEM');
755: fnd_msg_pub.add();
756: RAISE fnd_api.g_exc_error;
757: END IF;
758:

Line 760: fnd_message.set_name ('QA', 'QA_DEPENDENT_REV_ON_ITEM');

756: RAISE fnd_api.g_exc_error;
757: END IF;
758:
759: IF (revision_flag = 1) THEN
760: fnd_message.set_name ('QA', 'QA_DEPENDENT_REV_ON_ITEM');
761: fnd_msg_pub.add();
762: RAISE fnd_api.g_exc_error;
763: END IF;
764:

Line 766: fnd_message.set_name ('QA', 'QA_DEPENDENT_SUBINV_ON_ITEM');

762: RAISE fnd_api.g_exc_error;
763: END IF;
764:
765: IF (subinv_flag = 1) THEN
766: fnd_message.set_name ('QA', 'QA_DEPENDENT_SUBINV_ON_ITEM');
767: fnd_msg_pub.add();
768: RAISE fnd_api.g_exc_error;
769: END IF;
770:

Line 772: fnd_message.set_name ('QA', 'QA_DEPENDENT_UOM_ON_ITEM');

768: RAISE fnd_api.g_exc_error;
769: END IF;
770:
771: IF (uom_flag = 1) THEN
772: fnd_message.set_name ('QA', 'QA_DEPENDENT_UOM_ON_ITEM');
773: fnd_msg_pub.add();
774: RAISE fnd_api.g_exc_error;
775: END IF;
776:

Line 784: fnd_message.set_name ('QA', 'QA_DEPENDENT_COMP_LOT_ITEM');

780:
781: IF (comp_item_flag = 2) THEN
782:
783: IF (comp_lot_number_flag = 1) THEN
784: fnd_message.set_name ('QA', 'QA_DEPENDENT_COMP_LOT_ITEM');
785: fnd_msg_pub.add();
786: RAISE fnd_api.g_exc_error;
787: END IF;
788:

Line 790: fnd_message.set_name ('QA', 'QA_DEPENDENT_COMP_SERIAL_ITEM');

786: RAISE fnd_api.g_exc_error;
787: END IF;
788:
789: IF (comp_serial_number_flag = 1) THEN
790: fnd_message.set_name ('QA', 'QA_DEPENDENT_COMP_SERIAL_ITEM');
791: fnd_msg_pub.add();
792: RAISE fnd_api.g_exc_error;
793: END IF;
794:

Line 796: fnd_message.set_name ('QA', 'QA_DEPENDENT_COMP_REV_ITEM');

792: RAISE fnd_api.g_exc_error;
793: END IF;
794:
795: IF (comp_revision_flag = 1) THEN
796: fnd_message.set_name ('QA', 'QA_DEPENDENT_COMP_REV_ITEM');
797: fnd_msg_pub.add();
798: RAISE fnd_api.g_exc_error;
799: END IF;
800:

Line 802: fnd_message.set_name ('QA', 'QA_DEPENDENT_COMP_SUBINV_ITEM');

798: RAISE fnd_api.g_exc_error;
799: END IF;
800:
801: IF (comp_subinv_flag = 1) THEN
802: fnd_message.set_name ('QA', 'QA_DEPENDENT_COMP_SUBINV_ITEM');
803: fnd_msg_pub.add();
804: RAISE fnd_api.g_exc_error;
805: END IF;
806:

Line 808: fnd_message.set_name ('QA', 'QA_DEPENDENT_COMP_UOM_ITEM');

804: RAISE fnd_api.g_exc_error;
805: END IF;
806:
807: IF (comp_uom_flag = 1) THEN
808: fnd_message.set_name ('QA', 'QA_DEPENDENT_COMP_UOM_ITEM');
809: fnd_msg_pub.add();
810: RAISE fnd_api.g_exc_error;
811: END IF;
812:

Line 821: fnd_message.set_name ('QA', 'QA_DEPENDENT_OPSEQ_ON_JOB');

817:
818: IF (job_name_flag = 2 AND wip_line_flag = 2) THEN
819:
820: IF (to_op_seq_flag = 1 OR from_op_seq_flag = 1) THEN
821: fnd_message.set_name ('QA', 'QA_DEPENDENT_OPSEQ_ON_JOB');
822: fnd_msg_pub.add();
823: RAISE fnd_api.g_exc_error;
824: END IF;
825:

Line 844: fnd_message.set_name ('QA', 'QA_DEPENDENT_INTRAOP_ON_OPSEQ');

840: --
841: AND (scrap_op_seq_flag = 2) THEN
842:
843: IF (to_intraop_step_flag = 1) THEN
844: fnd_message.set_name ('QA', 'QA_DEPENDENT_INTRAOP_ON_OPSEQ');
845: fnd_msg_pub.add();
846: RAISE fnd_api.g_exc_error;
847: END IF;
848:

Line 864: fnd_message.set_name ('QA', 'QA_DEPENDENT_INTRAOP_ON_OPSEQ');

860: --
861: AND (scrap_op_seq_flag = 2) THEN
862:
863: IF (from_intraop_step_flag = 1) THEN
864: fnd_message.set_name ('QA', 'QA_DEPENDENT_INTRAOP_ON_OPSEQ');
865: fnd_msg_pub.add();
866: RAISE fnd_api.g_exc_error;
867: END IF;
868:

Line 877: fnd_message.set_name ('QA', 'QA_DEPENDENT_LOCATOR_ON_SUB');

873:
874: IF (subinv_flag = 2) THEN
875:
876: IF (locator_flag = 1) THEN
877: fnd_message.set_name ('QA', 'QA_DEPENDENT_LOCATOR_ON_SUB');
878: fnd_msg_pub.add();
879: RAISE fnd_api.g_exc_error;
880: END IF;
881:

Line 889: fnd_message.set_name ('QA', 'QA_DEPENDENT_COMP_LOCATOR_SUB');

885:
886: IF (comp_subinv_flag = 2) THEN
887:
888: IF (comp_locator_flag = 1) THEN
889: fnd_message.set_name ('QA', 'QA_DEPENDENT_COMP_LOCATOR_SUB');
890: fnd_msg_pub.add();
891: RAISE fnd_api.g_exc_error;
892: END IF;
893:

Line 902: fnd_message.set_name ('QA', 'QA_DEPENDENT_PO_LINE_ON_HEADER');

898:
899: IF (po_number_flag = 2) THEN
900:
901: IF (po_line_flag = 1) THEN
902: fnd_message.set_name ('QA', 'QA_DEPENDENT_PO_LINE_ON_HEADER');
903: fnd_msg_pub.add();
904: RAISE fnd_api.g_exc_error;
905: END IF;
906:

Line 908: fnd_message.set_name ('QA', 'QA_DEPENDENT_PO_REL_ON_HEADER');

904: RAISE fnd_api.g_exc_error;
905: END IF;
906:
907: IF (po_rel_number_flag = 1) THEN
908: fnd_message.set_name ('QA', 'QA_DEPENDENT_PO_REL_ON_HEADER');
909: fnd_msg_pub.add();
910: RAISE fnd_api.g_exc_error;
911: END IF;
912:

Line 921: fnd_message.set_name ('QA', 'QA_DEPENDENT_SO_LINE_ON_HEADER');

917:
918: IF (so_number_flag = 2) THEN
919:
920: IF (so_line_flag = 1) THEN
921: fnd_message.set_name ('QA', 'QA_DEPENDENT_SO_LINE_ON_HEADER');
922: fnd_msg_pub.add();
923: RAISE fnd_api.g_exc_error;
924: END IF;
925:

Line 931: fnd_message.set_name ('QA', 'QA_PROJECT_TASK_DEPEND');

927:
928: IF (project_num_flag = 2) THEN
929:
930: IF (task_num_flag = 1) THEN
931: fnd_message.set_name ('QA', 'QA_PROJECT_TASK_DEPEND');
932: fnd_msg_pub.add();
933: RAISE fnd_api.g_exc_error;
934: END IF;
935:

Line 942: fnd_message.set_name ('QA', 'QA_DEPENDENT_PLAN_CHARS');

938: -- R12 OPM Deviations. Bug 4345503 Start
939:
940: IF (process_resource_flag = 2) THEN
941: IF (process_parameter_flag = 1) THEN
942: fnd_message.set_name ('QA', 'QA_DEPENDENT_PLAN_CHARS');
943: fnd_message.set_token('CHILD_ELEMENT',
944: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.process_parameter));
945: fnd_message.set_token('ELEMENT_LIST',
946: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.process_batch_num));

Line 943: fnd_message.set_token('CHILD_ELEMENT',

939:
940: IF (process_resource_flag = 2) THEN
941: IF (process_parameter_flag = 1) THEN
942: fnd_message.set_name ('QA', 'QA_DEPENDENT_PLAN_CHARS');
943: fnd_message.set_token('CHILD_ELEMENT',
944: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.process_parameter));
945: fnd_message.set_token('ELEMENT_LIST',
946: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.process_batch_num));
947: fnd_msg_pub.add();

Line 945: fnd_message.set_token('ELEMENT_LIST',

941: IF (process_parameter_flag = 1) THEN
942: fnd_message.set_name ('QA', 'QA_DEPENDENT_PLAN_CHARS');
943: fnd_message.set_token('CHILD_ELEMENT',
944: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.process_parameter));
945: fnd_message.set_token('ELEMENT_LIST',
946: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.process_batch_num));
947: fnd_msg_pub.add();
948: RAISE fnd_api.g_exc_error;
949: END IF;

Line 954: fnd_message.set_name ('QA', 'QA_DEPENDENT_PLAN_CHARS');

950: END IF;
951:
952: IF (process_activity_flag = 2) THEN
953: IF (process_resource_flag = 1) THEN
954: fnd_message.set_name ('QA', 'QA_DEPENDENT_PLAN_CHARS');
955: fnd_message.set_token('CHILD_ELEMENT',
956: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.process_resource));
957: fnd_message.set_token('ELEMENT_LIST',
958: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.process_batch_num));

Line 955: fnd_message.set_token('CHILD_ELEMENT',

951:
952: IF (process_activity_flag = 2) THEN
953: IF (process_resource_flag = 1) THEN
954: fnd_message.set_name ('QA', 'QA_DEPENDENT_PLAN_CHARS');
955: fnd_message.set_token('CHILD_ELEMENT',
956: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.process_resource));
957: fnd_message.set_token('ELEMENT_LIST',
958: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.process_batch_num));
959: fnd_msg_pub.add();

Line 957: fnd_message.set_token('ELEMENT_LIST',

953: IF (process_resource_flag = 1) THEN
954: fnd_message.set_name ('QA', 'QA_DEPENDENT_PLAN_CHARS');
955: fnd_message.set_token('CHILD_ELEMENT',
956: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.process_resource));
957: fnd_message.set_token('ELEMENT_LIST',
958: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.process_batch_num));
959: fnd_msg_pub.add();
960: RAISE fnd_api.g_exc_error;
961: END IF;

Line 966: fnd_message.set_name ('QA', 'QA_DEPENDENT_PLAN_CHARS');

962: END IF;
963:
964: IF (process_batchstep_num_flag = 2) THEN
965: IF (process_activity_flag = 1) THEN
966: fnd_message.set_name ('QA', 'QA_DEPENDENT_PLAN_CHARS');
967: fnd_message.set_token('CHILD_ELEMENT',
968: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.process_activity));
969: fnd_message.set_token('ELEMENT_LIST',
970: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.process_batch_num));

Line 967: fnd_message.set_token('CHILD_ELEMENT',

963:
964: IF (process_batchstep_num_flag = 2) THEN
965: IF (process_activity_flag = 1) THEN
966: fnd_message.set_name ('QA', 'QA_DEPENDENT_PLAN_CHARS');
967: fnd_message.set_token('CHILD_ELEMENT',
968: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.process_activity));
969: fnd_message.set_token('ELEMENT_LIST',
970: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.process_batch_num));
971: fnd_msg_pub.add();

Line 969: fnd_message.set_token('ELEMENT_LIST',

965: IF (process_activity_flag = 1) THEN
966: fnd_message.set_name ('QA', 'QA_DEPENDENT_PLAN_CHARS');
967: fnd_message.set_token('CHILD_ELEMENT',
968: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.process_activity));
969: fnd_message.set_token('ELEMENT_LIST',
970: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.process_batch_num));
971: fnd_msg_pub.add();
972: RAISE fnd_api.g_exc_error;
973: END IF;

Line 978: fnd_message.set_name ('QA', 'QA_DEPENDENT_PLAN_CHARS');

974: END IF;
975:
976: IF (process_batchstep_num_flag = 2) THEN
977: IF (process_operation_flag = 1) THEN
978: fnd_message.set_name ('QA', 'QA_DEPENDENT_PLAN_CHARS');
979: fnd_message.set_token('CHILD_ELEMENT',
980: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.process_operation));
981: fnd_message.set_token('ELEMENT_LIST',
982: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.process_batch_num));

Line 979: fnd_message.set_token('CHILD_ELEMENT',

975:
976: IF (process_batchstep_num_flag = 2) THEN
977: IF (process_operation_flag = 1) THEN
978: fnd_message.set_name ('QA', 'QA_DEPENDENT_PLAN_CHARS');
979: fnd_message.set_token('CHILD_ELEMENT',
980: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.process_operation));
981: fnd_message.set_token('ELEMENT_LIST',
982: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.process_batch_num));
983: fnd_msg_pub.add();

Line 981: fnd_message.set_token('ELEMENT_LIST',

977: IF (process_operation_flag = 1) THEN
978: fnd_message.set_name ('QA', 'QA_DEPENDENT_PLAN_CHARS');
979: fnd_message.set_token('CHILD_ELEMENT',
980: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.process_operation));
981: fnd_message.set_token('ELEMENT_LIST',
982: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.process_batch_num));
983: fnd_msg_pub.add();
984: RAISE fnd_api.g_exc_error;
985: END IF;

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

986: END IF;
987:
988: IF (process_batch_num_flag = 2) THEN
989: IF (process_batchstep_num_flag = 1) THEN
990: fnd_message.set_name ('QA', 'QA_DEPENDENT_PLAN_CHARS');
991: fnd_message.set_token('CHILD_ELEMENT',
992: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.process_batchstep_num));
993: fnd_message.set_token('ELEMENT_LIST',
994: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.process_batch_num));

Line 991: fnd_message.set_token('CHILD_ELEMENT',

987:
988: IF (process_batch_num_flag = 2) THEN
989: IF (process_batchstep_num_flag = 1) THEN
990: fnd_message.set_name ('QA', 'QA_DEPENDENT_PLAN_CHARS');
991: fnd_message.set_token('CHILD_ELEMENT',
992: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.process_batchstep_num));
993: fnd_message.set_token('ELEMENT_LIST',
994: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.process_batch_num));
995: fnd_msg_pub.add();

Line 993: fnd_message.set_token('ELEMENT_LIST',

989: IF (process_batchstep_num_flag = 1) THEN
990: fnd_message.set_name ('QA', 'QA_DEPENDENT_PLAN_CHARS');
991: fnd_message.set_token('CHILD_ELEMENT',
992: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.process_batchstep_num));
993: fnd_message.set_token('ELEMENT_LIST',
994: qa_plan_element_api.get_prompt(p_plan_id, qa_ss_const.process_batch_num));
995: fnd_msg_pub.add();
996: RAISE fnd_api.g_exc_error;
997: END IF;

Line 1013: fnd_message.set_name('QA', 'QA_QPLAN_MUST_HAVE_CHARS');

1009:
1010: l_request_id NUMBER;
1011: BEGIN
1012: IF NOT mandatory_element_exists(p_plan_id) THEN
1013: fnd_message.set_name('QA', 'QA_QPLAN_MUST_HAVE_CHARS');
1014: fnd_msg_pub.add();
1015: RAISE fnd_api.g_exc_error;
1016: END IF;
1017:

Line 1273: fnd_message.set_name('QA', 'QA_EXCEEDED_COLUMN_COUNT');

1269: FOR pc IN c LOOP
1270:
1271: IF pc.result_column_name LIKE 'CHARACTER%' THEN
1272: IF l_char_sequence > g_max_char_columns THEN
1273: fnd_message.set_name('QA', 'QA_EXCEEDED_COLUMN_COUNT');
1274: fnd_msg_pub.add();
1275: raise fnd_api.g_exc_error;
1276: END IF;
1277: l_result_column := 'CHARACTER' || l_char_sequence;

Line 1585: fnd_message.set_name('QA', 'QA_EXCEEDED_COLUMN_COUNT');

1581: --
1582: result_column_names(i) := suggest_result_column(p_copy_to_plan_id,
1583: char_ids(i));
1584: IF result_column_names(i) IS NULL THEN
1585: fnd_message.set_name('QA', 'QA_EXCEEDED_COLUMN_COUNT');
1586: fnd_msg_pub.add();
1587: raise fnd_api.g_exc_error;
1588: END IF;
1589: mark_result_column(result_column_names(i));

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

2694: init_result_column_array(-1);
2695:
2696: l_user_id := get_user_id(p_user_name);
2697: IF l_user_id = -1 THEN
2698: fnd_message.set_name('QA', 'QA_API_INVALID_USER');
2699: fnd_msg_pub.add();
2700: raise fnd_api.g_exc_error;
2701: END IF;
2702:

Line 2705: fnd_message.set_name('QA', 'QA_NAME_SPECIAL_CHARS');

2701: END IF;
2702:
2703: l_plan_name := upper(p_plan_name);
2704: IF (illegal_chars(l_plan_name)) THEN
2705: fnd_message.set_name('QA', 'QA_NAME_SPECIAL_CHARS');
2706: fnd_msg_pub.add();
2707: raise fnd_api.g_exc_error;
2708: END IF;
2709:

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

2708: END IF;
2709:
2710: l_org_id := qa_plans_api.get_org_id(p_organization_code);
2711: IF (l_org_id IS NULL) THEN
2712: fnd_message.set_name('QA', 'QA_API_INVALID_ORG_CODE');
2713: fnd_msg_pub.add();
2714: raise fnd_api.g_exc_error;
2715: END IF;
2716:

Line 2718: fnd_message.set_name('QA', 'QA_API_INVALID_PLAN_TYPE');

2714: raise fnd_api.g_exc_error;
2715: END IF;
2716:
2717: IF NOT valid_plan_type(p_plan_type) THEN
2718: fnd_message.set_name('QA', 'QA_API_INVALID_PLAN_TYPE');
2719: fnd_msg_pub.add();
2720: raise fnd_api.g_exc_error;
2721: ELSE
2722: l_plan_type_code := get_plan_type_code(p_plan_type);

Line 2730: fnd_message.set_name('QA', 'QA_PLAN_RECORD_EXISTS');

2726: -- If the name passed as the plan name already exists then
2727: -- generate an error.
2728:
2729: IF plan_exists(l_plan_name) > 0 THEN
2730: fnd_message.set_name('QA', 'QA_PLAN_RECORD_EXISTS');
2731: fnd_msg_pub.add();
2732: raise fnd_api.g_exc_error;
2733: END IF;
2734:

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

2732: raise fnd_api.g_exc_error;
2733: END IF;
2734:
2735: IF (p_effective_to < p_effective_from) THEN
2736: fnd_message.set_name('QA', 'QA_EFFECTIVE_DATE_RANGE');
2737: fnd_msg_pub.add();
2738: raise fnd_api.g_exc_error;
2739: END IF;
2740:

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

2957: -- *** start of logic ***
2958:
2959: l_user_id := get_user_id(p_user_name);
2960: IF l_user_id = -1 THEN
2961: fnd_message.set_name('QA', 'QA_API_INVALID_USER');
2962: fnd_msg_pub.add();
2963: raise fnd_api.g_exc_error;
2964: END IF;
2965:

Line 2968: fnd_message.set_name('QA', 'QA_API_INVALID_PLAN');

2964: END IF;
2965:
2966: l_plan_id := qa_plans_api.plan_id(upper(p_plan_name));
2967: IF (l_plan_id IS NULL) THEN
2968: fnd_message.set_name('QA', 'QA_API_INVALID_PLAN');
2969: fnd_msg_pub.add();
2970: raise fnd_api.g_exc_error;
2971: END IF;
2972:

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

2971: END IF;
2972:
2973: l_char_id := qa_chars_api.get_element_id(p_element_name);
2974: IF (l_char_id IS NULL) THEN
2975: fnd_message.set_name('QA', 'QA_API_INVALID_ELEMENT');
2976: fnd_msg_pub.add();
2977: raise fnd_api.g_exc_error;
2978: END IF;
2979:

Line 2981: fnd_message.set_name('QA', 'QA_API_ELEMENT_ALREADY_ADDED');

2977: raise fnd_api.g_exc_error;
2978: END IF;
2979:
2980: IF element_exists(l_plan_id, l_char_id) THEN
2981: fnd_message.set_name('QA', 'QA_API_ELEMENT_ALREADY_ADDED');
2982: fnd_msg_pub.add();
2983: raise fnd_api.g_exc_error;
2984: END IF;
2985:

Line 3015: fnd_message.set_name('QA', 'QA_API_INVALID_PROMPT_SEQUENCE');

3011: IF p_prompt_sequence IS NULL THEN
3012: l_prompt_sequence := get_next_sequence(l_plan_id);
3013: ELSE
3014: IF prompt_sequence_exists(l_plan_id, p_prompt_sequence) THEN
3015: fnd_message.set_name('QA', 'QA_API_INVALID_PROMPT_SEQUENCE');
3016: fnd_msg_pub.add();
3017: RAISE fnd_api.g_exc_error;
3018: END IF;
3019: l_prompt_sequence := p_prompt_sequence;

Line 3051: fnd_message.set_name('QA', 'QA_EXCEEDED_COLUMN_COUNT');

3047: l_result_column_name := suggest_result_column(l_plan_id, l_char_id);
3048: END IF;
3049:
3050: IF l_result_column_name IS NULL THEN
3051: fnd_message.set_name('QA', 'QA_EXCEEDED_COLUMN_COUNT');
3052: fnd_msg_pub.add();
3053: raise fnd_api.g_exc_error;
3054: END IF;
3055: ELSE

Line 3076: fnd_message.set_name('WIP', 'WIP_WS_NO_LICENSE');

3072: l_override_flag := convert_flag(p_override_flag);
3073:
3074: IF FND_PROFILE.VALUE('WIP_MES_OPS_FLAG') <> 1
3075: AND (p_device_flag IS NOT NULL AND p_override_flag IS NOT NULL OR p_device_name IS NOT NULL OR p_sensor_alias IS NOT NULL) THEN
3076: fnd_message.set_name('WIP', 'WIP_WS_NO_LICENSE');
3077: fnd_msg_pub.add();
3078: raise fnd_api.g_exc_error;
3079: END IF;
3080:

Line 3082: fnd_message.set_name('QA', 'QA_API_INVALID_DEVICE_FLAG');

3078: raise fnd_api.g_exc_error;
3079: END IF;
3080:
3081: IF l_device_flag = 2 AND (l_override_flag = 1 OR p_device_name IS NOT NULL OR p_sensor_alias IS NOT NULL) THEN
3082: fnd_message.set_name('QA', 'QA_API_INVALID_DEVICE_FLAG');
3083: fnd_msg_pub.add();
3084: raise fnd_api.g_exc_error;
3085: END IF;
3086:

Line 3088: fnd_message.set_name('QA', 'QA_API_INVALID_DEVICE_NAME');

3084: raise fnd_api.g_exc_error;
3085: END IF;
3086:
3087: IF l_device_flag = 1 AND (p_device_name IS NULL OR p_sensor_alias IS NULL) THEN
3088: fnd_message.set_name('QA', 'QA_API_INVALID_DEVICE_NAME');
3089: fnd_msg_pub.add();
3090: raise fnd_api.g_exc_error;
3091: END IF;
3092:

Line 3097: fnd_message.set_name('QA', 'QA_API_INVALID_DEVICE_DETAILS');

3093: IF l_device_flag = 1 AND p_device_name IS NOT NULL AND p_sensor_alias IS NOT NULL THEN
3094: get_device_details(trim(p_device_name), trim(p_sensor_alias), x_device_id, x_override_flag);
3095:
3096: IF (x_device_id IS NULL) THEN
3097: fnd_message.set_name('QA', 'QA_API_INVALID_DEVICE_DETAILS');
3098: fnd_msg_pub.add();
3099: raise fnd_api.g_exc_error;
3100: END IF;
3101: END IF;

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

3261: -- *** start of logic ***
3262:
3263: l_user_id := get_user_id(p_user_name);
3264: IF l_user_id = -1 THEN
3265: fnd_message.set_name('QA', 'QA_API_INVALID_USER');
3266: fnd_msg_pub.add();
3267: raise fnd_api.g_exc_error;
3268: END IF;
3269:

Line 3273: fnd_message.set_name('QA', 'QA_API_INVALID_PLAN');

3269:
3270: l_plan_name := upper(p_plan_name);
3271: l_plan_id := qa_plans_api.plan_id(l_plan_name);
3272: IF (l_plan_id IS NULL) THEN
3273: fnd_message.set_name('QA', 'QA_API_INVALID_PLAN');
3274: fnd_msg_pub.add();
3275: raise fnd_api.g_exc_error;
3276: END IF;
3277:

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

3369: -- *** start of logic ***
3370:
3371: l_user_id := get_user_id(p_user_name);
3372: IF l_user_id = -1 THEN
3373: fnd_message.set_name('QA', 'QA_API_INVALID_USER');
3374: fnd_msg_pub.add();
3375: raise fnd_api.g_exc_error;
3376: END IF;
3377:

Line 3387: fnd_message.set_name('QA', 'QA_API_INVALID_PLAN');

3383: l_from_plan_id := qa_plans_api.plan_id(p_plan_name);
3384: IF (l_from_plan_id IS NULL) THEN
3385: l_from_plan_id := qa_plans_api.plan_id(upper(p_plan_name));
3386: IF (l_from_plan_id IS NULL) THEN
3387: fnd_message.set_name('QA', 'QA_API_INVALID_PLAN');
3388: fnd_msg_pub.add();
3389: raise fnd_api.g_exc_error;
3390: END IF;
3391: END IF;

Line 3395: fnd_message.set_name('QA', 'QA_NAME_SPECIAL_CHARS');

3391: END IF;
3392:
3393: l_to_plan_name := upper(p_to_plan_name);
3394: IF (illegal_chars(l_to_plan_name)) THEN
3395: fnd_message.set_name('QA', 'QA_NAME_SPECIAL_CHARS');
3396: fnd_msg_pub.add();
3397: raise fnd_api.g_exc_error;
3398: END IF;
3399:

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

3398: END IF;
3399:
3400: l_to_org_id := qa_plans_api.get_org_id(p_to_organization_code);
3401: IF (l_to_org_id IS NULL) THEN
3402: fnd_message.set_name('QA', 'QA_API_INVALID_ORG_CODE');
3403: fnd_msg_pub.add();
3404: raise fnd_api.g_exc_error;
3405: END IF;
3406:

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

3528: -- *** start of logic ***
3529:
3530: l_user_id := get_user_id(p_user_name);
3531: IF l_user_id = -1 THEN
3532: fnd_message.set_name('QA', 'QA_API_INVALID_USER');
3533: fnd_msg_pub.add();
3534: raise fnd_api.g_exc_error;
3535: END IF;
3536:

Line 3540: fnd_message.set_name('QA', 'QA_API_INVALID_PLAN');

3536:
3537: l_plan_name := upper(p_plan_name);
3538: l_plan_id := qa_plans_api.plan_id(l_plan_name);
3539: IF (l_plan_id IS NULL) THEN
3540: fnd_message.set_name('QA', 'QA_API_INVALID_PLAN');
3541: fnd_msg_pub.add();
3542: RAISE fnd_api.g_exc_error;
3543: END IF;
3544:

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

3543: END IF;
3544:
3545: l_element_id := qa_chars_api.get_element_id(p_element_name);
3546: IF (l_element_id IS NULL) THEN
3547: fnd_message.set_name('QA', 'QA_API_INVALID_ELEMENT');
3548: fnd_msg_pub.add();
3549: RAISE fnd_api.g_exc_error;
3550: END IF;
3551:

Line 3553: fnd_message.set_name('QA', 'QA_API_ELEMENT_NOT_IN_PLAN');

3549: RAISE fnd_api.g_exc_error;
3550: END IF;
3551:
3552: IF NOT element_exists(l_plan_id, l_element_id) THEN
3553: fnd_message.set_name('QA', 'QA_API_ELEMENT_NOT_IN_PLAN');
3554: fnd_msg_pub.add();
3555: RAISE fnd_api.g_exc_error;
3556: END IF;
3557:

Line 3559: fnd_message.set_name('QA', 'QA_RESULTS_EXIST_FOR_PLANCHAR');

3555: RAISE fnd_api.g_exc_error;
3556: END IF;
3557:
3558: IF results_exist(l_plan_id, l_element_id) THEN
3559: fnd_message.set_name('QA', 'QA_RESULTS_EXIST_FOR_PLANCHAR');
3560: fnd_msg_pub.add();
3561: RAISE fnd_api.g_exc_error;
3562: END IF;
3563:

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

3648: -- *** start of logic ***
3649:
3650: l_user_id := get_user_id(p_user_name);
3651: IF l_user_id = -1 THEN
3652: fnd_message.set_name('QA', 'QA_API_INVALID_USER');
3653: fnd_msg_pub.add();
3654: raise fnd_api.g_exc_error;
3655: END IF;
3656:

Line 3660: fnd_message.set_name('QA', 'QA_API_INVALID_PLAN');

3656:
3657: l_plan_name := upper(p_plan_name);
3658: l_plan_id := qa_plans_api.plan_id(l_plan_name);
3659: IF l_plan_id IS NULL THEN
3660: fnd_message.set_name('QA', 'QA_API_INVALID_PLAN');
3661: fnd_msg_pub.add();
3662: raise fnd_api.g_exc_error;
3663: END IF;
3664:

Line 3666: fnd_message.set_name('QA', 'QA_CANT_DELETE_QPLAN');

3662: raise fnd_api.g_exc_error;
3663: END IF;
3664:
3665: IF results_exist(l_plan_id) THEN
3666: fnd_message.set_name('QA', 'QA_CANT_DELETE_QPLAN');
3667: fnd_msg_pub.add();
3668: RAISE fnd_api.g_exc_error;
3669: END IF;
3670: