DBA Data[Home] [Help]

APPS.QA_RESULTS_PUB dependencies on QA_VALIDATION_API

Line 22: g_message_table(qa_validation_api.not_enabled_error) :=

18: PROCEDURE populate_message_table IS
19:
20: BEGIN
21:
22: g_message_table(qa_validation_api.not_enabled_error) :=
23: 'QA_API_NOT_ENABLED';
24: g_message_table(qa_validation_api.no_values_error) := 'QA_API_NO_VALUES';
25: g_message_table(qa_validation_api.mandatory_error) := 'QA_API_MANDATORY';
26: g_message_table(qa_validation_api.not_revision_controlled_error) :=

Line 24: g_message_table(qa_validation_api.no_values_error) := 'QA_API_NO_VALUES';

20: BEGIN
21:
22: g_message_table(qa_validation_api.not_enabled_error) :=
23: 'QA_API_NOT_ENABLED';
24: g_message_table(qa_validation_api.no_values_error) := 'QA_API_NO_VALUES';
25: g_message_table(qa_validation_api.mandatory_error) := 'QA_API_MANDATORY';
26: g_message_table(qa_validation_api.not_revision_controlled_error) :=
27: 'QA_API_REVISION_CONTROLLED';
28: g_message_table(qa_validation_api.mandatory_revision_error) :=

Line 25: g_message_table(qa_validation_api.mandatory_error) := 'QA_API_MANDATORY';

21:
22: g_message_table(qa_validation_api.not_enabled_error) :=
23: 'QA_API_NOT_ENABLED';
24: g_message_table(qa_validation_api.no_values_error) := 'QA_API_NO_VALUES';
25: g_message_table(qa_validation_api.mandatory_error) := 'QA_API_MANDATORY';
26: g_message_table(qa_validation_api.not_revision_controlled_error) :=
27: 'QA_API_REVISION_CONTROLLED';
28: g_message_table(qa_validation_api.mandatory_revision_error) :=
29: 'QA_API_MANDATORY_REVISION';

Line 26: g_message_table(qa_validation_api.not_revision_controlled_error) :=

22: g_message_table(qa_validation_api.not_enabled_error) :=
23: 'QA_API_NOT_ENABLED';
24: g_message_table(qa_validation_api.no_values_error) := 'QA_API_NO_VALUES';
25: g_message_table(qa_validation_api.mandatory_error) := 'QA_API_MANDATORY';
26: g_message_table(qa_validation_api.not_revision_controlled_error) :=
27: 'QA_API_REVISION_CONTROLLED';
28: g_message_table(qa_validation_api.mandatory_revision_error) :=
29: 'QA_API_MANDATORY_REVISION';
30: g_message_table(qa_validation_api.no_values_error) := 'QA_API_NO_VALUES';

Line 28: g_message_table(qa_validation_api.mandatory_revision_error) :=

24: g_message_table(qa_validation_api.no_values_error) := 'QA_API_NO_VALUES';
25: g_message_table(qa_validation_api.mandatory_error) := 'QA_API_MANDATORY';
26: g_message_table(qa_validation_api.not_revision_controlled_error) :=
27: 'QA_API_REVISION_CONTROLLED';
28: g_message_table(qa_validation_api.mandatory_revision_error) :=
29: 'QA_API_MANDATORY_REVISION';
30: g_message_table(qa_validation_api.no_values_error) := 'QA_API_NO_VALUES';
31: g_message_table(qa_validation_api.keyflex_error) := 'QA_API_KEYFLEX';
32: g_message_table(qa_validation_api.id_not_found_error) :=

Line 30: g_message_table(qa_validation_api.no_values_error) := 'QA_API_NO_VALUES';

26: g_message_table(qa_validation_api.not_revision_controlled_error) :=
27: 'QA_API_REVISION_CONTROLLED';
28: g_message_table(qa_validation_api.mandatory_revision_error) :=
29: 'QA_API_MANDATORY_REVISION';
30: g_message_table(qa_validation_api.no_values_error) := 'QA_API_NO_VALUES';
31: g_message_table(qa_validation_api.keyflex_error) := 'QA_API_KEYFLEX';
32: g_message_table(qa_validation_api.id_not_found_error) :=
33: 'QA_API_ID_NOT_FOUND';
34: g_message_table(qa_validation_api.spec_limit_error) := 'QA_API_SPEC_LIMIT';

Line 31: g_message_table(qa_validation_api.keyflex_error) := 'QA_API_KEYFLEX';

27: 'QA_API_REVISION_CONTROLLED';
28: g_message_table(qa_validation_api.mandatory_revision_error) :=
29: 'QA_API_MANDATORY_REVISION';
30: g_message_table(qa_validation_api.no_values_error) := 'QA_API_NO_VALUES';
31: g_message_table(qa_validation_api.keyflex_error) := 'QA_API_KEYFLEX';
32: g_message_table(qa_validation_api.id_not_found_error) :=
33: 'QA_API_ID_NOT_FOUND';
34: g_message_table(qa_validation_api.spec_limit_error) := 'QA_API_SPEC_LIMIT';
35: g_message_table(qa_validation_api.immediate_action_error) :=

Line 32: g_message_table(qa_validation_api.id_not_found_error) :=

28: g_message_table(qa_validation_api.mandatory_revision_error) :=
29: 'QA_API_MANDATORY_REVISION';
30: g_message_table(qa_validation_api.no_values_error) := 'QA_API_NO_VALUES';
31: g_message_table(qa_validation_api.keyflex_error) := 'QA_API_KEYFLEX';
32: g_message_table(qa_validation_api.id_not_found_error) :=
33: 'QA_API_ID_NOT_FOUND';
34: g_message_table(qa_validation_api.spec_limit_error) := 'QA_API_SPEC_LIMIT';
35: g_message_table(qa_validation_api.immediate_action_error) :=
36: 'QA_API_IMMEDIATE_ACTION';

Line 34: g_message_table(qa_validation_api.spec_limit_error) := 'QA_API_SPEC_LIMIT';

30: g_message_table(qa_validation_api.no_values_error) := 'QA_API_NO_VALUES';
31: g_message_table(qa_validation_api.keyflex_error) := 'QA_API_KEYFLEX';
32: g_message_table(qa_validation_api.id_not_found_error) :=
33: 'QA_API_ID_NOT_FOUND';
34: g_message_table(qa_validation_api.spec_limit_error) := 'QA_API_SPEC_LIMIT';
35: g_message_table(qa_validation_api.immediate_action_error) :=
36: 'QA_API_IMMEDIATE_ACTION';
37: g_message_table(qa_validation_api.lower_limit_error) :=
38: 'QA_API_LOWER_LIMIT';

Line 35: g_message_table(qa_validation_api.immediate_action_error) :=

31: g_message_table(qa_validation_api.keyflex_error) := 'QA_API_KEYFLEX';
32: g_message_table(qa_validation_api.id_not_found_error) :=
33: 'QA_API_ID_NOT_FOUND';
34: g_message_table(qa_validation_api.spec_limit_error) := 'QA_API_SPEC_LIMIT';
35: g_message_table(qa_validation_api.immediate_action_error) :=
36: 'QA_API_IMMEDIATE_ACTION';
37: g_message_table(qa_validation_api.lower_limit_error) :=
38: 'QA_API_LOWER_LIMIT';
39: g_message_table(qa_validation_api.upper_limit_error) :=

Line 37: g_message_table(qa_validation_api.lower_limit_error) :=

33: 'QA_API_ID_NOT_FOUND';
34: g_message_table(qa_validation_api.spec_limit_error) := 'QA_API_SPEC_LIMIT';
35: g_message_table(qa_validation_api.immediate_action_error) :=
36: 'QA_API_IMMEDIATE_ACTION';
37: g_message_table(qa_validation_api.lower_limit_error) :=
38: 'QA_API_LOWER_LIMIT';
39: g_message_table(qa_validation_api.upper_limit_error) :=
40: 'QA_API_UPPER_LIMIT';
41: g_message_table(qa_validation_api.value_not_in_sql_error) :=

Line 39: g_message_table(qa_validation_api.upper_limit_error) :=

35: g_message_table(qa_validation_api.immediate_action_error) :=
36: 'QA_API_IMMEDIATE_ACTION';
37: g_message_table(qa_validation_api.lower_limit_error) :=
38: 'QA_API_LOWER_LIMIT';
39: g_message_table(qa_validation_api.upper_limit_error) :=
40: 'QA_API_UPPER_LIMIT';
41: g_message_table(qa_validation_api.value_not_in_sql_error) :=
42: 'QA_API_VALUE_NOT_IN_SQL';
43: g_message_table(qa_validation_api.sql_validation_error) :=

Line 41: g_message_table(qa_validation_api.value_not_in_sql_error) :=

37: g_message_table(qa_validation_api.lower_limit_error) :=
38: 'QA_API_LOWER_LIMIT';
39: g_message_table(qa_validation_api.upper_limit_error) :=
40: 'QA_API_UPPER_LIMIT';
41: g_message_table(qa_validation_api.value_not_in_sql_error) :=
42: 'QA_API_VALUE_NOT_IN_SQL';
43: g_message_table(qa_validation_api.sql_validation_error) :=
44: 'QA_API_SQL_VALIDATION';
45: g_message_table(qa_validation_api.date_conversion_error) :=

Line 43: g_message_table(qa_validation_api.sql_validation_error) :=

39: g_message_table(qa_validation_api.upper_limit_error) :=
40: 'QA_API_UPPER_LIMIT';
41: g_message_table(qa_validation_api.value_not_in_sql_error) :=
42: 'QA_API_VALUE_NOT_IN_SQL';
43: g_message_table(qa_validation_api.sql_validation_error) :=
44: 'QA_API_SQL_VALIDATION';
45: g_message_table(qa_validation_api.date_conversion_error) :=
46: 'QA_API_INVALID_DATE';
47: g_message_table(qa_validation_api.data_type_error) := 'QA_API_DATA_TYPE';

Line 45: g_message_table(qa_validation_api.date_conversion_error) :=

41: g_message_table(qa_validation_api.value_not_in_sql_error) :=
42: 'QA_API_VALUE_NOT_IN_SQL';
43: g_message_table(qa_validation_api.sql_validation_error) :=
44: 'QA_API_SQL_VALIDATION';
45: g_message_table(qa_validation_api.date_conversion_error) :=
46: 'QA_API_INVALID_DATE';
47: g_message_table(qa_validation_api.data_type_error) := 'QA_API_DATA_TYPE';
48: g_message_table(qa_validation_api.number_conversion_error) :=
49: 'QA_API_INVALID_NUMBER';

Line 47: g_message_table(qa_validation_api.data_type_error) := 'QA_API_DATA_TYPE';

43: g_message_table(qa_validation_api.sql_validation_error) :=
44: 'QA_API_SQL_VALIDATION';
45: g_message_table(qa_validation_api.date_conversion_error) :=
46: 'QA_API_INVALID_DATE';
47: g_message_table(qa_validation_api.data_type_error) := 'QA_API_DATA_TYPE';
48: g_message_table(qa_validation_api.number_conversion_error) :=
49: 'QA_API_INVALID_NUMBER';
50: g_message_table(qa_validation_api.no_data_found_error) :=
51: 'QA_API_NO_DATA_FOUND';

Line 48: g_message_table(qa_validation_api.number_conversion_error) :=

44: 'QA_API_SQL_VALIDATION';
45: g_message_table(qa_validation_api.date_conversion_error) :=
46: 'QA_API_INVALID_DATE';
47: g_message_table(qa_validation_api.data_type_error) := 'QA_API_DATA_TYPE';
48: g_message_table(qa_validation_api.number_conversion_error) :=
49: 'QA_API_INVALID_NUMBER';
50: g_message_table(qa_validation_api.no_data_found_error) :=
51: 'QA_API_NO_DATA_FOUND';
52: g_message_table(qa_validation_api.not_locator_controlled_error) :=

Line 50: g_message_table(qa_validation_api.no_data_found_error) :=

46: 'QA_API_INVALID_DATE';
47: g_message_table(qa_validation_api.data_type_error) := 'QA_API_DATA_TYPE';
48: g_message_table(qa_validation_api.number_conversion_error) :=
49: 'QA_API_INVALID_NUMBER';
50: g_message_table(qa_validation_api.no_data_found_error) :=
51: 'QA_API_NO_DATA_FOUND';
52: g_message_table(qa_validation_api.not_locator_controlled_error) :=
53: 'QA_API_NOT_LOCATOR_CONTROLLED';
54: g_message_table(qa_validation_api.item_keyflex_error) :=

Line 52: g_message_table(qa_validation_api.not_locator_controlled_error) :=

48: g_message_table(qa_validation_api.number_conversion_error) :=
49: 'QA_API_INVALID_NUMBER';
50: g_message_table(qa_validation_api.no_data_found_error) :=
51: 'QA_API_NO_DATA_FOUND';
52: g_message_table(qa_validation_api.not_locator_controlled_error) :=
53: 'QA_API_NOT_LOCATOR_CONTROLLED';
54: g_message_table(qa_validation_api.item_keyflex_error) :=
55: 'QA_API_ITEM_KEYFLEX';
56: g_message_table(qa_validation_api.comp_item_keyflex_error) :=

Line 54: g_message_table(qa_validation_api.item_keyflex_error) :=

50: g_message_table(qa_validation_api.no_data_found_error) :=
51: 'QA_API_NO_DATA_FOUND';
52: g_message_table(qa_validation_api.not_locator_controlled_error) :=
53: 'QA_API_NOT_LOCATOR_CONTROLLED';
54: g_message_table(qa_validation_api.item_keyflex_error) :=
55: 'QA_API_ITEM_KEYFLEX';
56: g_message_table(qa_validation_api.comp_item_keyflex_error) :=
57: 'QA_API_COMP_ITEM_KEYFLEX';
58: g_message_table(qa_validation_api.locator_keyflex_error) :=

Line 56: g_message_table(qa_validation_api.comp_item_keyflex_error) :=

52: g_message_table(qa_validation_api.not_locator_controlled_error) :=
53: 'QA_API_NOT_LOCATOR_CONTROLLED';
54: g_message_table(qa_validation_api.item_keyflex_error) :=
55: 'QA_API_ITEM_KEYFLEX';
56: g_message_table(qa_validation_api.comp_item_keyflex_error) :=
57: 'QA_API_COMP_ITEM_KEYFLEX';
58: g_message_table(qa_validation_api.locator_keyflex_error) :=
59: 'QA_API_LOCATOR_KEYFLEX';
60: g_message_table(qa_validation_api.comp_locator_keyflex_error) :=

Line 58: g_message_table(qa_validation_api.locator_keyflex_error) :=

54: g_message_table(qa_validation_api.item_keyflex_error) :=
55: 'QA_API_ITEM_KEYFLEX';
56: g_message_table(qa_validation_api.comp_item_keyflex_error) :=
57: 'QA_API_COMP_ITEM_KEYFLEX';
58: g_message_table(qa_validation_api.locator_keyflex_error) :=
59: 'QA_API_LOCATOR_KEYFLEX';
60: g_message_table(qa_validation_api.comp_locator_keyflex_error) :=
61: 'QA_API_COMP_LOCATOR_KEYFLEX';
62: g_message_table(qa_validation_api.invalid_number_error) :=

Line 60: g_message_table(qa_validation_api.comp_locator_keyflex_error) :=

56: g_message_table(qa_validation_api.comp_item_keyflex_error) :=
57: 'QA_API_COMP_ITEM_KEYFLEX';
58: g_message_table(qa_validation_api.locator_keyflex_error) :=
59: 'QA_API_LOCATOR_KEYFLEX';
60: g_message_table(qa_validation_api.comp_locator_keyflex_error) :=
61: 'QA_API_COMP_LOCATOR_KEYFLEX';
62: g_message_table(qa_validation_api.invalid_number_error) :=
63: 'QA_API_INVALID_NUMBER';
64: g_message_table(qa_validation_api.invalid_date_error) :=

Line 62: g_message_table(qa_validation_api.invalid_number_error) :=

58: g_message_table(qa_validation_api.locator_keyflex_error) :=
59: 'QA_API_LOCATOR_KEYFLEX';
60: g_message_table(qa_validation_api.comp_locator_keyflex_error) :=
61: 'QA_API_COMP_LOCATOR_KEYFLEX';
62: g_message_table(qa_validation_api.invalid_number_error) :=
63: 'QA_API_INVALID_NUMBER';
64: g_message_table(qa_validation_api.invalid_date_error) :=
65: 'QA_API_INVALID_DATE';
66: g_message_table(qa_validation_api.spec_error) := 'QA_API_SPEC';

Line 64: g_message_table(qa_validation_api.invalid_date_error) :=

60: g_message_table(qa_validation_api.comp_locator_keyflex_error) :=
61: 'QA_API_COMP_LOCATOR_KEYFLEX';
62: g_message_table(qa_validation_api.invalid_number_error) :=
63: 'QA_API_INVALID_NUMBER';
64: g_message_table(qa_validation_api.invalid_date_error) :=
65: 'QA_API_INVALID_DATE';
66: g_message_table(qa_validation_api.spec_error) := 'QA_API_SPEC';
67: g_message_table(qa_validation_api.ok) := 'QA_API_NO_ERROR';
68: g_message_table(qa_validation_api.unknown_error) := 'QA_API_UNKNOWN';

Line 66: g_message_table(qa_validation_api.spec_error) := 'QA_API_SPEC';

62: g_message_table(qa_validation_api.invalid_number_error) :=
63: 'QA_API_INVALID_NUMBER';
64: g_message_table(qa_validation_api.invalid_date_error) :=
65: 'QA_API_INVALID_DATE';
66: g_message_table(qa_validation_api.spec_error) := 'QA_API_SPEC';
67: g_message_table(qa_validation_api.ok) := 'QA_API_NO_ERROR';
68: g_message_table(qa_validation_api.unknown_error) := 'QA_API_UNKNOWN';
69: g_message_table(qa_validation_api.reject_an_entry_error) :=
70: 'QA_API_REJECT_AN_ENTRY';

Line 67: g_message_table(qa_validation_api.ok) := 'QA_API_NO_ERROR';

63: 'QA_API_INVALID_NUMBER';
64: g_message_table(qa_validation_api.invalid_date_error) :=
65: 'QA_API_INVALID_DATE';
66: g_message_table(qa_validation_api.spec_error) := 'QA_API_SPEC';
67: g_message_table(qa_validation_api.ok) := 'QA_API_NO_ERROR';
68: g_message_table(qa_validation_api.unknown_error) := 'QA_API_UNKNOWN';
69: g_message_table(qa_validation_api.reject_an_entry_error) :=
70: 'QA_API_REJECT_AN_ENTRY';
71:

Line 68: g_message_table(qa_validation_api.unknown_error) := 'QA_API_UNKNOWN';

64: g_message_table(qa_validation_api.invalid_date_error) :=
65: 'QA_API_INVALID_DATE';
66: g_message_table(qa_validation_api.spec_error) := 'QA_API_SPEC';
67: g_message_table(qa_validation_api.ok) := 'QA_API_NO_ERROR';
68: g_message_table(qa_validation_api.unknown_error) := 'QA_API_UNKNOWN';
69: g_message_table(qa_validation_api.reject_an_entry_error) :=
70: 'QA_API_REJECT_AN_ENTRY';
71:
72:

Line 69: g_message_table(qa_validation_api.reject_an_entry_error) :=

65: 'QA_API_INVALID_DATE';
66: g_message_table(qa_validation_api.spec_error) := 'QA_API_SPEC';
67: g_message_table(qa_validation_api.ok) := 'QA_API_NO_ERROR';
68: g_message_table(qa_validation_api.unknown_error) := 'QA_API_UNKNOWN';
69: g_message_table(qa_validation_api.reject_an_entry_error) :=
70: 'QA_API_REJECT_AN_ENTRY';
71:
72:
73: -- Bug 3679762.Initialising the message array for the "missing assign a value target

Line 77: g_message_table(qa_validation_api.missing_assign_column) :=

73: -- Bug 3679762.Initialising the message array for the "missing assign a value target
74: -- column" error message.
75: -- srhariha.Wed Jun 16 06:54:06 PDT 2004
76:
77: g_message_table(qa_validation_api.missing_assign_column) :=
78: 'QA_MISSING_ASSIGN_COLUMN';
79:
80: END populate_message_table;
81:

Line 88: PROCEDURE post_error_messages (p_errors IN qa_validation_api.ErrorArray,plan_id NUMBER)

84: -- qa_plan_element_api.get_prompt and which in turn will be used
85: -- in the error messages shown to the user.
86: -- Bug 2910202.suramasw.Wed May 14 23:29:55 PDT 2003.
87:
88: PROCEDURE post_error_messages (p_errors IN qa_validation_api.ErrorArray,plan_id NUMBER)
89: IS
90:
91: l_message_name VARCHAR2(30);
92: l_char_prompt VARCHAR2(100);

Line 129: x_row_elements IN OUT NOCOPY qa_validation_api.ElementsArray,

125: p_who_created_by IN NUMBER := fnd_global.user_id,
126: p_who_last_update_login IN NUMBER := fnd_global.user_id,
127: p_enabled_flag IN NUMBER,
128: x_collection_id IN OUT NOCOPY NUMBER,
129: x_row_elements IN OUT NOCOPY qa_validation_api.ElementsArray,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,
133: x_occurrence IN OUT NOCOPY NUMBER,

Line 135: x_message_array OUT NOCOPY qa_validation_api.MessageArray,

131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,
133: x_occurrence IN OUT NOCOPY NUMBER,
134: x_action_result OUT NOCOPY VARCHAR2,
135: x_message_array OUT NOCOPY qa_validation_api.MessageArray,
136: x_error_array OUT NOCOPY qa_validation_api.ErrorArray,
137: p_txn_header_id IN NUMBER DEFAULT NULL,
138: p_ssqr_operation IN NUMBER DEFAULT NULL,
139: p_last_update_date IN DATE DEFAULT SYSDATE) IS

Line 136: x_error_array OUT NOCOPY qa_validation_api.ErrorArray,

132: x_msg_data OUT NOCOPY VARCHAR2,
133: x_occurrence IN OUT NOCOPY NUMBER,
134: x_action_result OUT NOCOPY VARCHAR2,
135: x_message_array OUT NOCOPY qa_validation_api.MessageArray,
136: x_error_array OUT NOCOPY qa_validation_api.ErrorArray,
137: p_txn_header_id IN NUMBER DEFAULT NULL,
138: p_ssqr_operation IN NUMBER DEFAULT NULL,
139: p_last_update_date IN DATE DEFAULT SYSDATE) IS
140:

Line 284: x_row_elements IN OUT NOCOPY qa_validation_api.ElementsArray,

280: p_who_last_update_login IN NUMBER := fnd_global.user_id,
281: p_enabled_flag IN NUMBER,
282: p_collection_id IN NUMBER,
283: p_occurrence IN NUMBER,
284: x_row_elements IN OUT NOCOPY qa_validation_api.ElementsArray,
285: x_return_status OUT NOCOPY VARCHAR2,
286: x_msg_count OUT NOCOPY NUMBER,
287: x_msg_data OUT NOCOPY VARCHAR2,
288: x_action_result OUT NOCOPY VARCHAR2,

Line 289: x_message_array OUT NOCOPY qa_validation_api.MessageArray,

285: x_return_status OUT NOCOPY VARCHAR2,
286: x_msg_count OUT NOCOPY NUMBER,
287: x_msg_data OUT NOCOPY VARCHAR2,
288: x_action_result OUT NOCOPY VARCHAR2,
289: x_message_array OUT NOCOPY qa_validation_api.MessageArray,
290: x_error_array OUT NOCOPY qa_validation_api.ErrorArray,
291: p_txn_header_id IN NUMBER DEFAULT NULL,
292: p_ssqr_operation IN NUMBER DEFAULT NULL,
293: p_last_update_date IN DATE DEFAULT SYSDATE) IS

Line 290: x_error_array OUT NOCOPY qa_validation_api.ErrorArray,

286: x_msg_count OUT NOCOPY NUMBER,
287: x_msg_data OUT NOCOPY VARCHAR2,
288: x_action_result OUT NOCOPY VARCHAR2,
289: x_message_array OUT NOCOPY qa_validation_api.MessageArray,
290: x_error_array OUT NOCOPY qa_validation_api.ErrorArray,
291: p_txn_header_id IN NUMBER DEFAULT NULL,
292: p_ssqr_operation IN NUMBER DEFAULT NULL,
293: p_last_update_date IN DATE DEFAULT SYSDATE) IS
294: