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_SS_RESULTS dependencies on QA_VALIDATION_API

Line 12: g_message_table(qa_validation_api.not_enabled_error) :=

8: PROCEDURE populate_message_table IS
9:
10: BEGIN
11:
12: g_message_table(qa_validation_api.not_enabled_error) :=
13: 'QA_API_NOT_ENABLED';
14: g_message_table(qa_validation_api.no_values_error) := 'QA_API_NO_VALUES';
15: g_message_table(qa_validation_api.mandatory_error) := 'QA_API_MANDATORY';
16: g_message_table(qa_validation_api.not_revision_controlled_error) :=

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

10: BEGIN
11:
12: g_message_table(qa_validation_api.not_enabled_error) :=
13: 'QA_API_NOT_ENABLED';
14: g_message_table(qa_validation_api.no_values_error) := 'QA_API_NO_VALUES';
15: g_message_table(qa_validation_api.mandatory_error) := 'QA_API_MANDATORY';
16: g_message_table(qa_validation_api.not_revision_controlled_error) :=
17: 'QA_API_REVISION_CONTROLLED';
18: g_message_table(qa_validation_api.mandatory_revision_error) :=

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

11:
12: g_message_table(qa_validation_api.not_enabled_error) :=
13: 'QA_API_NOT_ENABLED';
14: g_message_table(qa_validation_api.no_values_error) := 'QA_API_NO_VALUES';
15: g_message_table(qa_validation_api.mandatory_error) := 'QA_API_MANDATORY';
16: g_message_table(qa_validation_api.not_revision_controlled_error) :=
17: 'QA_API_REVISION_CONTROLLED';
18: g_message_table(qa_validation_api.mandatory_revision_error) :=
19: 'QA_API_MANDATORY_REVISION';

Line 16: g_message_table(qa_validation_api.not_revision_controlled_error) :=

12: g_message_table(qa_validation_api.not_enabled_error) :=
13: 'QA_API_NOT_ENABLED';
14: g_message_table(qa_validation_api.no_values_error) := 'QA_API_NO_VALUES';
15: g_message_table(qa_validation_api.mandatory_error) := 'QA_API_MANDATORY';
16: g_message_table(qa_validation_api.not_revision_controlled_error) :=
17: 'QA_API_REVISION_CONTROLLED';
18: g_message_table(qa_validation_api.mandatory_revision_error) :=
19: 'QA_API_MANDATORY_REVISION';
20: g_message_table(qa_validation_api.no_values_error) := 'QA_API_NO_VALUES';

Line 18: g_message_table(qa_validation_api.mandatory_revision_error) :=

14: g_message_table(qa_validation_api.no_values_error) := 'QA_API_NO_VALUES';
15: g_message_table(qa_validation_api.mandatory_error) := 'QA_API_MANDATORY';
16: g_message_table(qa_validation_api.not_revision_controlled_error) :=
17: 'QA_API_REVISION_CONTROLLED';
18: g_message_table(qa_validation_api.mandatory_revision_error) :=
19: 'QA_API_MANDATORY_REVISION';
20: g_message_table(qa_validation_api.no_values_error) := 'QA_API_NO_VALUES';
21: g_message_table(qa_validation_api.keyflex_error) := 'QA_API_KEYFLEX';
22: g_message_table(qa_validation_api.id_not_found_error) :=

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

16: g_message_table(qa_validation_api.not_revision_controlled_error) :=
17: 'QA_API_REVISION_CONTROLLED';
18: g_message_table(qa_validation_api.mandatory_revision_error) :=
19: 'QA_API_MANDATORY_REVISION';
20: g_message_table(qa_validation_api.no_values_error) := 'QA_API_NO_VALUES';
21: g_message_table(qa_validation_api.keyflex_error) := 'QA_API_KEYFLEX';
22: g_message_table(qa_validation_api.id_not_found_error) :=
23: 'QA_API_ID_NOT_FOUND';
24: g_message_table(qa_validation_api.spec_limit_error) := 'QA_API_SPEC_LIMIT';

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

17: 'QA_API_REVISION_CONTROLLED';
18: g_message_table(qa_validation_api.mandatory_revision_error) :=
19: 'QA_API_MANDATORY_REVISION';
20: g_message_table(qa_validation_api.no_values_error) := 'QA_API_NO_VALUES';
21: g_message_table(qa_validation_api.keyflex_error) := 'QA_API_KEYFLEX';
22: g_message_table(qa_validation_api.id_not_found_error) :=
23: 'QA_API_ID_NOT_FOUND';
24: g_message_table(qa_validation_api.spec_limit_error) := 'QA_API_SPEC_LIMIT';
25: g_message_table(qa_validation_api.immediate_action_error) :=

Line 22: g_message_table(qa_validation_api.id_not_found_error) :=

18: g_message_table(qa_validation_api.mandatory_revision_error) :=
19: 'QA_API_MANDATORY_REVISION';
20: g_message_table(qa_validation_api.no_values_error) := 'QA_API_NO_VALUES';
21: g_message_table(qa_validation_api.keyflex_error) := 'QA_API_KEYFLEX';
22: g_message_table(qa_validation_api.id_not_found_error) :=
23: 'QA_API_ID_NOT_FOUND';
24: g_message_table(qa_validation_api.spec_limit_error) := 'QA_API_SPEC_LIMIT';
25: g_message_table(qa_validation_api.immediate_action_error) :=
26: 'QA_API_IMMEDIATE_ACTION';

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

20: g_message_table(qa_validation_api.no_values_error) := 'QA_API_NO_VALUES';
21: g_message_table(qa_validation_api.keyflex_error) := 'QA_API_KEYFLEX';
22: g_message_table(qa_validation_api.id_not_found_error) :=
23: 'QA_API_ID_NOT_FOUND';
24: g_message_table(qa_validation_api.spec_limit_error) := 'QA_API_SPEC_LIMIT';
25: g_message_table(qa_validation_api.immediate_action_error) :=
26: 'QA_API_IMMEDIATE_ACTION';
27: g_message_table(qa_validation_api.lower_limit_error) :=
28: 'QA_API_LOWER_LIMIT';

Line 25: g_message_table(qa_validation_api.immediate_action_error) :=

21: g_message_table(qa_validation_api.keyflex_error) := 'QA_API_KEYFLEX';
22: g_message_table(qa_validation_api.id_not_found_error) :=
23: 'QA_API_ID_NOT_FOUND';
24: g_message_table(qa_validation_api.spec_limit_error) := 'QA_API_SPEC_LIMIT';
25: g_message_table(qa_validation_api.immediate_action_error) :=
26: 'QA_API_IMMEDIATE_ACTION';
27: g_message_table(qa_validation_api.lower_limit_error) :=
28: 'QA_API_LOWER_LIMIT';
29: g_message_table(qa_validation_api.upper_limit_error) :=

Line 27: g_message_table(qa_validation_api.lower_limit_error) :=

23: 'QA_API_ID_NOT_FOUND';
24: g_message_table(qa_validation_api.spec_limit_error) := 'QA_API_SPEC_LIMIT';
25: g_message_table(qa_validation_api.immediate_action_error) :=
26: 'QA_API_IMMEDIATE_ACTION';
27: g_message_table(qa_validation_api.lower_limit_error) :=
28: 'QA_API_LOWER_LIMIT';
29: g_message_table(qa_validation_api.upper_limit_error) :=
30: 'QA_API_UPPER_LIMIT';
31: g_message_table(qa_validation_api.value_not_in_sql_error) :=

Line 29: g_message_table(qa_validation_api.upper_limit_error) :=

25: g_message_table(qa_validation_api.immediate_action_error) :=
26: 'QA_API_IMMEDIATE_ACTION';
27: g_message_table(qa_validation_api.lower_limit_error) :=
28: 'QA_API_LOWER_LIMIT';
29: g_message_table(qa_validation_api.upper_limit_error) :=
30: 'QA_API_UPPER_LIMIT';
31: g_message_table(qa_validation_api.value_not_in_sql_error) :=
32: 'QA_API_VALUE_NOT_IN_SQL';
33: g_message_table(qa_validation_api.sql_validation_error) :=

Line 31: g_message_table(qa_validation_api.value_not_in_sql_error) :=

27: g_message_table(qa_validation_api.lower_limit_error) :=
28: 'QA_API_LOWER_LIMIT';
29: g_message_table(qa_validation_api.upper_limit_error) :=
30: 'QA_API_UPPER_LIMIT';
31: g_message_table(qa_validation_api.value_not_in_sql_error) :=
32: 'QA_API_VALUE_NOT_IN_SQL';
33: g_message_table(qa_validation_api.sql_validation_error) :=
34: 'QA_API_SQL_VALIDATION';
35: g_message_table(qa_validation_api.date_conversion_error) :=

Line 33: g_message_table(qa_validation_api.sql_validation_error) :=

29: g_message_table(qa_validation_api.upper_limit_error) :=
30: 'QA_API_UPPER_LIMIT';
31: g_message_table(qa_validation_api.value_not_in_sql_error) :=
32: 'QA_API_VALUE_NOT_IN_SQL';
33: g_message_table(qa_validation_api.sql_validation_error) :=
34: 'QA_API_SQL_VALIDATION';
35: g_message_table(qa_validation_api.date_conversion_error) :=
36: 'QA_API_INVALID_DATE';
37: g_message_table(qa_validation_api.data_type_error) := 'QA_API_DATA_TYPE';

Line 35: g_message_table(qa_validation_api.date_conversion_error) :=

31: g_message_table(qa_validation_api.value_not_in_sql_error) :=
32: 'QA_API_VALUE_NOT_IN_SQL';
33: g_message_table(qa_validation_api.sql_validation_error) :=
34: 'QA_API_SQL_VALIDATION';
35: g_message_table(qa_validation_api.date_conversion_error) :=
36: 'QA_API_INVALID_DATE';
37: g_message_table(qa_validation_api.data_type_error) := 'QA_API_DATA_TYPE';
38: g_message_table(qa_validation_api.number_conversion_error) :=
39: 'QA_API_INVALID_NUMBER';

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

33: g_message_table(qa_validation_api.sql_validation_error) :=
34: 'QA_API_SQL_VALIDATION';
35: g_message_table(qa_validation_api.date_conversion_error) :=
36: 'QA_API_INVALID_DATE';
37: g_message_table(qa_validation_api.data_type_error) := 'QA_API_DATA_TYPE';
38: g_message_table(qa_validation_api.number_conversion_error) :=
39: 'QA_API_INVALID_NUMBER';
40: g_message_table(qa_validation_api.no_data_found_error) :=
41: 'QA_API_NO_DATA_FOUND';

Line 38: g_message_table(qa_validation_api.number_conversion_error) :=

34: 'QA_API_SQL_VALIDATION';
35: g_message_table(qa_validation_api.date_conversion_error) :=
36: 'QA_API_INVALID_DATE';
37: g_message_table(qa_validation_api.data_type_error) := 'QA_API_DATA_TYPE';
38: g_message_table(qa_validation_api.number_conversion_error) :=
39: 'QA_API_INVALID_NUMBER';
40: g_message_table(qa_validation_api.no_data_found_error) :=
41: 'QA_API_NO_DATA_FOUND';
42: g_message_table(qa_validation_api.not_locator_controlled_error) :=

Line 40: g_message_table(qa_validation_api.no_data_found_error) :=

36: 'QA_API_INVALID_DATE';
37: g_message_table(qa_validation_api.data_type_error) := 'QA_API_DATA_TYPE';
38: g_message_table(qa_validation_api.number_conversion_error) :=
39: 'QA_API_INVALID_NUMBER';
40: g_message_table(qa_validation_api.no_data_found_error) :=
41: 'QA_API_NO_DATA_FOUND';
42: g_message_table(qa_validation_api.not_locator_controlled_error) :=
43: 'QA_API_NOT_LOCATOR_CONTROLLED';
44: g_message_table(qa_validation_api.item_keyflex_error) :=

Line 42: g_message_table(qa_validation_api.not_locator_controlled_error) :=

38: g_message_table(qa_validation_api.number_conversion_error) :=
39: 'QA_API_INVALID_NUMBER';
40: g_message_table(qa_validation_api.no_data_found_error) :=
41: 'QA_API_NO_DATA_FOUND';
42: g_message_table(qa_validation_api.not_locator_controlled_error) :=
43: 'QA_API_NOT_LOCATOR_CONTROLLED';
44: g_message_table(qa_validation_api.item_keyflex_error) :=
45: 'QA_API_ITEM_KEYFLEX';
46: g_message_table(qa_validation_api.comp_item_keyflex_error) :=

Line 44: g_message_table(qa_validation_api.item_keyflex_error) :=

40: g_message_table(qa_validation_api.no_data_found_error) :=
41: 'QA_API_NO_DATA_FOUND';
42: g_message_table(qa_validation_api.not_locator_controlled_error) :=
43: 'QA_API_NOT_LOCATOR_CONTROLLED';
44: g_message_table(qa_validation_api.item_keyflex_error) :=
45: 'QA_API_ITEM_KEYFLEX';
46: g_message_table(qa_validation_api.comp_item_keyflex_error) :=
47: 'QA_API_COMP_ITEM_KEYFLEX';
48: g_message_table(qa_validation_api.comp_locator_keyflex_error) :=

Line 46: g_message_table(qa_validation_api.comp_item_keyflex_error) :=

42: g_message_table(qa_validation_api.not_locator_controlled_error) :=
43: 'QA_API_NOT_LOCATOR_CONTROLLED';
44: g_message_table(qa_validation_api.item_keyflex_error) :=
45: 'QA_API_ITEM_KEYFLEX';
46: g_message_table(qa_validation_api.comp_item_keyflex_error) :=
47: 'QA_API_COMP_ITEM_KEYFLEX';
48: g_message_table(qa_validation_api.comp_locator_keyflex_error) :=
49: 'QA_API_COMP_LOCATOR_KEYFLEX';
50: g_message_table(qa_validation_api.invalid_number_error) :=

Line 48: g_message_table(qa_validation_api.comp_locator_keyflex_error) :=

44: g_message_table(qa_validation_api.item_keyflex_error) :=
45: 'QA_API_ITEM_KEYFLEX';
46: g_message_table(qa_validation_api.comp_item_keyflex_error) :=
47: 'QA_API_COMP_ITEM_KEYFLEX';
48: g_message_table(qa_validation_api.comp_locator_keyflex_error) :=
49: 'QA_API_COMP_LOCATOR_KEYFLEX';
50: g_message_table(qa_validation_api.invalid_number_error) :=
51: 'QA_API_INVALID_NUMBER';
52: g_message_table(qa_validation_api.invalid_date_error) :=

Line 50: g_message_table(qa_validation_api.invalid_number_error) :=

46: g_message_table(qa_validation_api.comp_item_keyflex_error) :=
47: 'QA_API_COMP_ITEM_KEYFLEX';
48: g_message_table(qa_validation_api.comp_locator_keyflex_error) :=
49: 'QA_API_COMP_LOCATOR_KEYFLEX';
50: g_message_table(qa_validation_api.invalid_number_error) :=
51: 'QA_API_INVALID_NUMBER';
52: g_message_table(qa_validation_api.invalid_date_error) :=
53: 'QA_API_INVALID_DATE';
54: g_message_table(qa_validation_api.spec_error) := 'QA_API_SPEC';

Line 52: g_message_table(qa_validation_api.invalid_date_error) :=

48: g_message_table(qa_validation_api.comp_locator_keyflex_error) :=
49: 'QA_API_COMP_LOCATOR_KEYFLEX';
50: g_message_table(qa_validation_api.invalid_number_error) :=
51: 'QA_API_INVALID_NUMBER';
52: g_message_table(qa_validation_api.invalid_date_error) :=
53: 'QA_API_INVALID_DATE';
54: g_message_table(qa_validation_api.spec_error) := 'QA_API_SPEC';
55: g_message_table(qa_validation_api.ok) := 'QA_API_NO_ERROR';
56: g_message_table(qa_validation_api.unknown_error) := 'QA_API_UNKNOWN';

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

50: g_message_table(qa_validation_api.invalid_number_error) :=
51: 'QA_API_INVALID_NUMBER';
52: g_message_table(qa_validation_api.invalid_date_error) :=
53: 'QA_API_INVALID_DATE';
54: g_message_table(qa_validation_api.spec_error) := 'QA_API_SPEC';
55: g_message_table(qa_validation_api.ok) := 'QA_API_NO_ERROR';
56: g_message_table(qa_validation_api.unknown_error) := 'QA_API_UNKNOWN';
57: g_message_table(qa_validation_api.reject_an_entry_error) :=
58: 'QA_API_REJECT_AN_ENTRY';

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

51: 'QA_API_INVALID_NUMBER';
52: g_message_table(qa_validation_api.invalid_date_error) :=
53: 'QA_API_INVALID_DATE';
54: g_message_table(qa_validation_api.spec_error) := 'QA_API_SPEC';
55: g_message_table(qa_validation_api.ok) := 'QA_API_NO_ERROR';
56: g_message_table(qa_validation_api.unknown_error) := 'QA_API_UNKNOWN';
57: g_message_table(qa_validation_api.reject_an_entry_error) :=
58: 'QA_API_REJECT_AN_ENTRY';
59:

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

52: g_message_table(qa_validation_api.invalid_date_error) :=
53: 'QA_API_INVALID_DATE';
54: g_message_table(qa_validation_api.spec_error) := 'QA_API_SPEC';
55: g_message_table(qa_validation_api.ok) := 'QA_API_NO_ERROR';
56: g_message_table(qa_validation_api.unknown_error) := 'QA_API_UNKNOWN';
57: g_message_table(qa_validation_api.reject_an_entry_error) :=
58: 'QA_API_REJECT_AN_ENTRY';
59:
60: -- Bug 3679762.Initialising the message array for the missing assign a value target

Line 57: g_message_table(qa_validation_api.reject_an_entry_error) :=

53: 'QA_API_INVALID_DATE';
54: g_message_table(qa_validation_api.spec_error) := 'QA_API_SPEC';
55: g_message_table(qa_validation_api.ok) := 'QA_API_NO_ERROR';
56: g_message_table(qa_validation_api.unknown_error) := 'QA_API_UNKNOWN';
57: g_message_table(qa_validation_api.reject_an_entry_error) :=
58: 'QA_API_REJECT_AN_ENTRY';
59:
60: -- Bug 3679762.Initialising the message array for the missing assign a value target
61: -- column error message.

Line 64: g_message_table(qa_validation_api.missing_assign_column) :=

60: -- Bug 3679762.Initialising the message array for the missing assign a value target
61: -- column error message.
62: -- srhariha.Wed Jun 16 06:54:06 PDT 2004
63:
64: g_message_table(qa_validation_api.missing_assign_column) :=
65: 'QA_MISSING_ASSIGN_COLUMN';
66:
67:
68: END populate_message_table;

Line 79: PROCEDURE update_validation_flg(elements IN OUT NOCOPY qa_validation_api.ElementsArray,

75: -- performed and so the action on that element wont
76: -- refire.
77: -- ntungare Sat Apr 14 00:51:48 PDT 2007
78: --
79: PROCEDURE update_validation_flg(elements IN OUT NOCOPY qa_validation_api.ElementsArray,
80: p_plan_id IN NUMBER,
81: p_collection_id IN NUMBER,
82: p_occurrence IN NUMBER) AS
83:

Line 96: elements_db qa_validation_api.ElementsArray;

92: l_append BOOLEAN := FALSE;
93: l_rescol VARCHAR2(30);
94: l_rescol_val VARCHAR2(32767);
95: l_sql_string VARCHAR2(32767);
96: elements_db qa_validation_api.ElementsArray;
97:
98:
99: BEGIN
100: char_id:= elements.first;

Line 146: elements_db := qa_validation_api.result_to_array(l_rescol_val);

142: -- Execute the statement and fetch the values into an array
143: -- using result_to_array.
144: l_sql_string := 'SELECT ' || l_sql_string || ' FROM QA_RESULTS_FULL_V WHERE plan_id = :2 and collection_id = :3 and occurrence = :4';
145: EXECUTE IMMEDIATE l_sql_string INTO l_rescol_val USING p_plan_id, p_collection_id, p_occurrence;
146: elements_db := qa_validation_api.result_to_array(l_rescol_val);
147:
148: -- Reinitialize the char_id variable since, the comparison
149: -- needs to be done here. So, looping again...
150: char_id:= elements.first;

Line 183: elements(char_id).validation_flag := qa_validation_api.action_fired;

179: -- actions based on it are not to be fired. So setting
180: -- the validation flag for this element accordingly
181: --
182: If NVL(input_val,'0') = NVL(saved_val,'0') THEN
183: elements(char_id).validation_flag := qa_validation_api.action_fired;
184: End If;
185:
186: char_id:= elements.next(char_id);
187: END LOOP;

Line 196: RETURN qa_validation_api.get_error_message (code);

192: BEGIN
193: --
194: -- Should figure out the error message from dictionary.
195: --
196: RETURN qa_validation_api.get_error_message (code);
197: END get_error_code;
198:
199:
200: --

Line 205: p_errors IN qa_validation_api.ErrorArray,

201: -- Get the error messages and append them into an @-separated
202: -- string.
203: --
204: PROCEDURE get_error_messages(
205: p_errors IN qa_validation_api.ErrorArray,
206: p_plan_id IN NUMBER,
207: x_messages OUT NOCOPY VARCHAR2) IS
208:
209: separator CONSTANT VARCHAR2(1) := '@';

Line 258: If p_errors(i).error_code = qa_validation_api.reject_an_entry_error then

254: -- from the collection plan and put in the variable code. If the action
255: -- is not 'Reject the input' then the existing code is used.
256: -- ntunagre Tue Mar 28 08:04:54 PST 2006.
257: --
258: If p_errors(i).error_code = qa_validation_api.reject_an_entry_error then
259: OPEN cur_mesg(p_plan_id, p_errors(i).element_id);
260: FETCH cur_mesg INTO code;
261: CLOSE cur_mesg;
262: else

Line 279: msg_array IN qa_validation_api.MessageArray,

275: -- Get the action messages and append them into an @-separated
276: -- string.
277: --
278: PROCEDURE get_action_messages(
279: msg_array IN qa_validation_api.MessageArray,
280: plan_id IN NUMBER,
281: messages OUT NOCOPY VARCHAR2) IS
282:
283: separator CONSTANT VARCHAR2(1) := '@';

Line 340: elements qa_validation_api.ElementsArray;

336: x_enabled IN INTEGER,
337: x_committed IN INTEGER,
338: x_messages OUT NOCOPY VARCHAR2)
339: RETURN INTEGER IS
340: elements qa_validation_api.ElementsArray;
341: error_array qa_validation_api.ErrorArray;
342: message_array qa_validation_api.MessageArray;
343: return_status VARCHAR2(1);
344: action_result VARCHAR2(1);

Line 341: error_array qa_validation_api.ErrorArray;

337: x_committed IN INTEGER,
338: x_messages OUT NOCOPY VARCHAR2)
339: RETURN INTEGER IS
340: elements qa_validation_api.ElementsArray;
341: error_array qa_validation_api.ErrorArray;
342: message_array qa_validation_api.MessageArray;
343: return_status VARCHAR2(1);
344: action_result VARCHAR2(1);
345: msg_count NUMBER;

Line 342: message_array qa_validation_api.MessageArray;

338: x_messages OUT NOCOPY VARCHAR2)
339: RETURN INTEGER IS
340: elements qa_validation_api.ElementsArray;
341: error_array qa_validation_api.ErrorArray;
342: message_array qa_validation_api.MessageArray;
343: return_status VARCHAR2(1);
344: action_result VARCHAR2(1);
345: msg_count NUMBER;
346: msg_data VARCHAR2(2000);

Line 394: elements := qa_validation_api.result_to_array(x_result);

390: --
391: -- First task is to decode this string into the row_element
392: -- array.
393: --
394: elements := qa_validation_api.result_to_array(x_result);
395: elements := qa_validation_api.id_to_array(x_result1, elements);
396: qa_validation_api.set_validation_flag(elements);
397:
398: --

Line 395: elements := qa_validation_api.id_to_array(x_result1, elements);

391: -- First task is to decode this string into the row_element
392: -- array.
393: --
394: elements := qa_validation_api.result_to_array(x_result);
395: elements := qa_validation_api.id_to_array(x_result1, elements);
396: qa_validation_api.set_validation_flag(elements);
397:
398: --
399: -- Bug 2617638

Line 396: qa_validation_api.set_validation_flag(elements);

392: -- array.
393: --
394: elements := qa_validation_api.result_to_array(x_result);
395: elements := qa_validation_api.id_to_array(x_result1, elements);
396: qa_validation_api.set_validation_flag(elements);
397:
398: --
399: -- Bug 2617638
400: -- The follow statement is needed to process x_result1.

Line 426: IF qa_validation_api.no_errors(error_array) AND

422: x_message_array => message_array,
423: x_return_status => return_status,
424: x_action_result => action_result);
425:
426: IF qa_validation_api.no_errors(error_array) AND
427: return_status <> FND_API.G_RET_STS_ERROR AND
428: return_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
429: RETURN 0;
430: ELSE

Line 447: elements IN OUT NOCOPY qa_validation_api.ElementsArray)

443: -- important in case of Background result collection
444: -- ntungare Mon Mar 26 06:20:05 PDT 2007
445: --
446: PROCEDURE initialize_seq_elements(x_plan_id IN NUMBER,
447: elements IN OUT NOCOPY qa_validation_api.ElementsArray)
448: IS
449: TYPE seq_charid_tab_typ IS TABLE OF qa_chars.char_id%TYPE INDEX BY BINARY_INTEGER;
450: seq_charid_tab seq_charid_tab_typ;
451:

Line 503: elements qa_validation_api.ElementsArray;

499: x_committed IN INTEGER,
500: x_transaction_number IN NUMBER,
501: x_messages OUT NOCOPY VARCHAR2)
502: RETURN INTEGER IS
503: elements qa_validation_api.ElementsArray;
504: error_array qa_validation_api.ErrorArray;
505: message_array qa_validation_api.MessageArray;
506: return_status VARCHAR2(1);
507: action_result VARCHAR2(1);

Line 504: error_array qa_validation_api.ErrorArray;

500: x_transaction_number IN NUMBER,
501: x_messages OUT NOCOPY VARCHAR2)
502: RETURN INTEGER IS
503: elements qa_validation_api.ElementsArray;
504: error_array qa_validation_api.ErrorArray;
505: message_array qa_validation_api.MessageArray;
506: return_status VARCHAR2(1);
507: action_result VARCHAR2(1);
508: msg_count NUMBER;

Line 505: message_array qa_validation_api.MessageArray;

501: x_messages OUT NOCOPY VARCHAR2)
502: RETURN INTEGER IS
503: elements qa_validation_api.ElementsArray;
504: error_array qa_validation_api.ErrorArray;
505: message_array qa_validation_api.MessageArray;
506: return_status VARCHAR2(1);
507: action_result VARCHAR2(1);
508: msg_count NUMBER;
509: msg_data VARCHAR2(2000);

Line 560: elements := qa_validation_api.result_to_array(x_result);

556: --
557: -- First task is to decode this string into the row_element
558: -- array.
559: --
560: elements := qa_validation_api.result_to_array(x_result);
561: elements := qa_validation_api.id_to_array(x_result1, elements);
562:
563: IF (x_transaction_number IS NOT NULL) AND (x_transaction_number > 0) THEN
564: qa_validation_api.set_validation_flag_txn(

Line 561: elements := qa_validation_api.id_to_array(x_result1, elements);

557: -- First task is to decode this string into the row_element
558: -- array.
559: --
560: elements := qa_validation_api.result_to_array(x_result);
561: elements := qa_validation_api.id_to_array(x_result1, elements);
562:
563: IF (x_transaction_number IS NOT NULL) AND (x_transaction_number > 0) THEN
564: qa_validation_api.set_validation_flag_txn(
565: x_elements => elements,

Line 564: qa_validation_api.set_validation_flag_txn(

560: elements := qa_validation_api.result_to_array(x_result);
561: elements := qa_validation_api.id_to_array(x_result1, elements);
562:
563: IF (x_transaction_number IS NOT NULL) AND (x_transaction_number > 0) THEN
564: qa_validation_api.set_validation_flag_txn(
565: x_elements => elements,
566: p_plan_id => x_plan_id,
567: p_transaction_number => x_transaction_number,
568: p_plan_transaction_id => NULL);

Line 600: IF qa_validation_api.no_errors(error_array) AND

596: x_message_array => message_array,
597: x_return_status => return_status,
598: x_action_result => action_result);
599:
600: IF qa_validation_api.no_errors(error_array) AND
601: return_status <> FND_API.G_RET_STS_ERROR AND
602: return_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
603: get_action_messages(message_array, x_plan_id, x_messages);
604: RETURN 0;

Line 657: elements qa_validation_api.ElementsArray;

653: x_agg_elements OUT NOCOPY VARCHAR2,
654: x_agg_val OUT NOCOPY VARCHAR2,
655: p_last_update_date IN DATE DEFAULT SYSDATE)
656: RETURN INTEGER IS
657: elements qa_validation_api.ElementsArray;
658: error_array qa_validation_api.ErrorArray;
659: message_array qa_validation_api.MessageArray;
660: return_status VARCHAR2(1);
661: action_result VARCHAR2(1);

Line 658: error_array qa_validation_api.ErrorArray;

654: x_agg_val OUT NOCOPY VARCHAR2,
655: p_last_update_date IN DATE DEFAULT SYSDATE)
656: RETURN INTEGER IS
657: elements qa_validation_api.ElementsArray;
658: error_array qa_validation_api.ErrorArray;
659: message_array qa_validation_api.MessageArray;
660: return_status VARCHAR2(1);
661: action_result VARCHAR2(1);
662: msg_count NUMBER;

Line 659: message_array qa_validation_api.MessageArray;

655: p_last_update_date IN DATE DEFAULT SYSDATE)
656: RETURN INTEGER IS
657: elements qa_validation_api.ElementsArray;
658: error_array qa_validation_api.ErrorArray;
659: message_array qa_validation_api.MessageArray;
660: return_status VARCHAR2(1);
661: action_result VARCHAR2(1);
662: msg_count NUMBER;
663: msg_data VARCHAR2(2000);

Line 753: elements := qa_validation_api.result_to_array(x_result);

749: --
750: -- First task is to decode this string into the row_element
751: -- array.
752: --
753: elements := qa_validation_api.result_to_array(x_result);
754: elements := qa_validation_api.id_to_array(x_result1, elements);
755:
756: IF (x_transaction_number IS NOT NULL) AND (x_transaction_number > 0) THEN
757: qa_validation_api.set_validation_flag_txn(

Line 754: elements := qa_validation_api.id_to_array(x_result1, elements);

750: -- First task is to decode this string into the row_element
751: -- array.
752: --
753: elements := qa_validation_api.result_to_array(x_result);
754: elements := qa_validation_api.id_to_array(x_result1, elements);
755:
756: IF (x_transaction_number IS NOT NULL) AND (x_transaction_number > 0) THEN
757: qa_validation_api.set_validation_flag_txn(
758: x_elements => elements,

Line 757: qa_validation_api.set_validation_flag_txn(

753: elements := qa_validation_api.result_to_array(x_result);
754: elements := qa_validation_api.id_to_array(x_result1, elements);
755:
756: IF (x_transaction_number IS NOT NULL) AND (x_transaction_number > 0) THEN
757: qa_validation_api.set_validation_flag_txn(
758: x_elements => elements,
759: p_plan_id => x_plan_id,
760: p_transaction_number => x_transaction_number,
761: p_plan_transaction_id => NULL);

Line 806: IF qa_validation_api.no_errors(error_array) AND

802: x_action_result => action_result,
803: p_ssqr_operation => l_ssqr_operation,
804: p_last_update_date => p_last_update_date);
805:
806: IF qa_validation_api.no_errors(error_array) AND
807: return_status <> FND_API.G_RET_STS_ERROR AND
808: return_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
809: get_action_messages(message_array, x_plan_id, x_messages);
810:

Line 968: elements qa_validation_api.ElementsArray;

964: x_committed IN INTEGER,
965: x_transaction_number IN NUMBER,
966: x_messages OUT NOCOPY VARCHAR2)
967: RETURN INTEGER IS
968: elements qa_validation_api.ElementsArray;
969: error_array qa_validation_api.ErrorArray;
970: message_array qa_validation_api.MessageArray;
971: return_status VARCHAR2(1);
972: action_result VARCHAR2(1);

Line 969: error_array qa_validation_api.ErrorArray;

965: x_transaction_number IN NUMBER,
966: x_messages OUT NOCOPY VARCHAR2)
967: RETURN INTEGER IS
968: elements qa_validation_api.ElementsArray;
969: error_array qa_validation_api.ErrorArray;
970: message_array qa_validation_api.MessageArray;
971: return_status VARCHAR2(1);
972: action_result VARCHAR2(1);
973: msg_count NUMBER;

Line 970: message_array qa_validation_api.MessageArray;

966: x_messages OUT NOCOPY VARCHAR2)
967: RETURN INTEGER IS
968: elements qa_validation_api.ElementsArray;
969: error_array qa_validation_api.ErrorArray;
970: message_array qa_validation_api.MessageArray;
971: return_status VARCHAR2(1);
972: action_result VARCHAR2(1);
973: msg_count NUMBER;
974: msg_data VARCHAR2(2000);

Line 1023: elements := qa_validation_api.result_to_array(x_result);

1019: -- First task is to decode this string into the row_element
1020: -- array.
1021: --
1022:
1023: elements := qa_validation_api.result_to_array(x_result);
1024: elements := qa_validation_api.id_to_array(x_result1, elements);
1025:
1026: IF (x_transaction_number IS NOT NULL) AND (x_transaction_number > 0) THEN
1027: qa_validation_api.set_validation_flag_txn(

Line 1024: elements := qa_validation_api.id_to_array(x_result1, elements);

1020: -- array.
1021: --
1022:
1023: elements := qa_validation_api.result_to_array(x_result);
1024: elements := qa_validation_api.id_to_array(x_result1, elements);
1025:
1026: IF (x_transaction_number IS NOT NULL) AND (x_transaction_number > 0) THEN
1027: qa_validation_api.set_validation_flag_txn(
1028: x_elements => elements,

Line 1027: qa_validation_api.set_validation_flag_txn(

1023: elements := qa_validation_api.result_to_array(x_result);
1024: elements := qa_validation_api.id_to_array(x_result1, elements);
1025:
1026: IF (x_transaction_number IS NOT NULL) AND (x_transaction_number > 0) THEN
1027: qa_validation_api.set_validation_flag_txn(
1028: x_elements => elements,
1029: p_plan_id => x_plan_id,
1030: p_transaction_number => x_transaction_number,
1031: p_plan_transaction_id => NULL);

Line 1054: IF qa_validation_api.no_errors(error_array) THEN

1050: x_message_array => message_array,
1051: x_return_status => return_status,
1052: x_action_result => action_result);
1053:
1054: IF qa_validation_api.no_errors(error_array) THEN
1055:
1056: -- Bug 4057388. Display a message action was not firing in eam.
1057: -- message_array returned from qa_results_pub.update_row was
1058: -- not converted to output string x_mesasges.

Line 1074: PROCEDURE post_error_messages (p_errors IN qa_validation_api.ErrorArray,

1070: RETURN -1;
1071: END update_result;
1072:
1073:
1074: PROCEDURE post_error_messages (p_errors IN qa_validation_api.ErrorArray,
1075: plan_id NUMBER) IS
1076:
1077: l_message_name VARCHAR2(30);
1078: l_char_prompt VARCHAR2(100);

Line 1118: IF p_errors(i).error_code = qa_validation_api.reject_an_entry_error then

1114: -- description. This token would be replaced with the message added by
1115: -- the user in the collection plan setup for 'Reject the input' action.
1116: -- ntungare Tue Mar 28 08:10:23 PST 2006.
1117: --
1118: IF p_errors(i).error_code = qa_validation_api.reject_an_entry_error then
1119: OPEN cur_mesg(plan_id,p_errors(i).element_id);
1120: FETCH cur_mesg INTO l_mesg;
1121: CLOSE cur_mesg;
1122:

Line 1178: elements qa_validation_api.ElementsArray;

1174: x_agg_elements OUT NOCOPY VARCHAR2,
1175: x_agg_val OUT NOCOPY VARCHAR2,
1176: p_last_update_date IN DATE DEFAULT SYSDATE)
1177: RETURN INTEGER IS
1178: elements qa_validation_api.ElementsArray;
1179: error_array qa_validation_api.ErrorArray;
1180: message_array qa_validation_api.MessageArray;
1181: return_status VARCHAR2(1);
1182: action_result VARCHAR2(1);

Line 1179: error_array qa_validation_api.ErrorArray;

1175: x_agg_val OUT NOCOPY VARCHAR2,
1176: p_last_update_date IN DATE DEFAULT SYSDATE)
1177: RETURN INTEGER IS
1178: elements qa_validation_api.ElementsArray;
1179: error_array qa_validation_api.ErrorArray;
1180: message_array qa_validation_api.MessageArray;
1181: return_status VARCHAR2(1);
1182: action_result VARCHAR2(1);
1183: msg_count NUMBER;

Line 1180: message_array qa_validation_api.MessageArray;

1176: p_last_update_date IN DATE DEFAULT SYSDATE)
1177: RETURN INTEGER IS
1178: elements qa_validation_api.ElementsArray;
1179: error_array qa_validation_api.ErrorArray;
1180: message_array qa_validation_api.MessageArray;
1181: return_status VARCHAR2(1);
1182: action_result VARCHAR2(1);
1183: msg_count NUMBER;
1184: msg_data VARCHAR2(2000);

Line 1266: elements := qa_validation_api.result_to_array(x_result);

1262: --
1263: -- First task is to decode this string into the row_element
1264: -- array.
1265: --
1266: elements := qa_validation_api.result_to_array(x_result);
1267: elements := qa_validation_api.id_to_array(x_result1, elements);
1268:
1269: IF (x_transaction_number IS NOT NULL) AND (x_transaction_number > 0) THEN
1270: qa_validation_api.set_validation_flag_txn(

Line 1267: elements := qa_validation_api.id_to_array(x_result1, elements);

1263: -- First task is to decode this string into the row_element
1264: -- array.
1265: --
1266: elements := qa_validation_api.result_to_array(x_result);
1267: elements := qa_validation_api.id_to_array(x_result1, elements);
1268:
1269: IF (x_transaction_number IS NOT NULL) AND (x_transaction_number > 0) THEN
1270: qa_validation_api.set_validation_flag_txn(
1271: x_elements => elements,

Line 1270: qa_validation_api.set_validation_flag_txn(

1266: elements := qa_validation_api.result_to_array(x_result);
1267: elements := qa_validation_api.id_to_array(x_result1, elements);
1268:
1269: IF (x_transaction_number IS NOT NULL) AND (x_transaction_number > 0) THEN
1270: qa_validation_api.set_validation_flag_txn(
1271: x_elements => elements,
1272: p_plan_id => x_plan_id,
1273: p_transaction_number => x_transaction_number,
1274: p_plan_transaction_id => NULL);

Line 1306: IF qa_validation_api.no_errors(error_array) THEN

1302: x_action_result => action_result,
1303: p_ssqr_operation => 1,
1304: p_last_update_date => p_last_update_date);
1305:
1306: IF qa_validation_api.no_errors(error_array) THEN
1307:
1308: -- anagarwa Fri Jan 23 12:10:04 PST 2004
1309: -- Bug 3384986 Actions for CAR master not fired when child is updated
1310: -- update parent and also update parent txn id so that the actions like

Line 1551: -- the new qa_validation_api.set_validation_flag_txn is a superset.

1547:
1548:
1549: --
1550: -- Removed procedure wb_set_valid_flag entirely because
1551: -- the new qa_validation_api.set_validation_flag_txn is a superset.
1552: --
1553:
1554: --
1555: -- Used only by QWB and Fwk Integration

Line 1582: elements qa_validation_api.ElementsArray;

1578: x_charid_str OUT NOCOPY VARCHAR2,
1579: x_id_str out NOCOPY VARCHAR2)
1580: RETURN INTEGER IS
1581:
1582: elements qa_validation_api.ElementsArray;
1583: error_array qa_validation_api.ErrorArray;
1584: l_results_array qa_validation_api.ResultRecordArray;
1585: l_message_array qa_validation_api.MessageArray;
1586:

Line 1583: error_array qa_validation_api.ErrorArray;

1579: x_id_str out NOCOPY VARCHAR2)
1580: RETURN INTEGER IS
1581:
1582: elements qa_validation_api.ElementsArray;
1583: error_array qa_validation_api.ErrorArray;
1584: l_results_array qa_validation_api.ResultRecordArray;
1585: l_message_array qa_validation_api.MessageArray;
1586:
1587: --

Line 1584: l_results_array qa_validation_api.ResultRecordArray;

1580: RETURN INTEGER IS
1581:
1582: elements qa_validation_api.ElementsArray;
1583: error_array qa_validation_api.ErrorArray;
1584: l_results_array qa_validation_api.ResultRecordArray;
1585: l_message_array qa_validation_api.MessageArray;
1586:
1587: --
1588: -- Bug 5932426

Line 1585: l_message_array qa_validation_api.MessageArray;

1581:
1582: elements qa_validation_api.ElementsArray;
1583: error_array qa_validation_api.ErrorArray;
1584: l_results_array qa_validation_api.ResultRecordArray;
1585: l_message_array qa_validation_api.MessageArray;
1586:
1587: --
1588: -- Bug 5932426
1589: -- Checing if the Txn is an update Txn or an

Line 1615: elements := qa_validation_api.result_to_array(p_result);

1611:
1612: --clearing cache so that errors are not shown over and over again.
1613: fnd_msg_pub.Initialize();
1614: fnd_msg_pub.reset();
1615: elements := qa_validation_api.result_to_array(p_result);
1616: elements := qa_validation_api.id_to_array(p_result1, elements);
1617:
1618: --
1619: -- Bug 5932426

Line 1616: elements := qa_validation_api.id_to_array(p_result1, elements);

1612: --clearing cache so that errors are not shown over and over again.
1613: fnd_msg_pub.Initialize();
1614: fnd_msg_pub.reset();
1615: elements := qa_validation_api.result_to_array(p_result);
1616: elements := qa_validation_api.id_to_array(p_result1, elements);
1617:
1618: --
1619: -- Bug 5932426
1620: -- Updating the validation flag only if the

Line 1647: qa_validation_api.set_validation_flag_txn(

1643: -- wb_set_valid_flag(p_elements => elements,
1644: -- p_transaction_number => p_transaction_number);
1645: --
1646: IF (p_transaction_number IS NOT NULL) AND (p_transaction_number > 0) THEN
1647: qa_validation_api.set_validation_flag_txn(
1648: x_elements => elements,
1649: p_plan_id => p_plan_id,
1650: p_transaction_number => p_transaction_number,
1651: p_plan_transaction_id => NULL);

Line 1659: error_array := qa_validation_api.validate_row(p_plan_id,

1655: -- Passing the value for the P_ssqr_operation flag as
1656: -- 1 to indicate that the online actions firing is
1657: -- not be done
1658: --
1659: error_array := qa_validation_api.validate_row(p_plan_id,
1660: p_spec_id, p_org_id, fnd_global.user_id, p_transaction_number,
1661: p_transaction_id, l_results_array, l_message_array,
1662: elements, 1);
1663:

Line 1691: IF qa_validation_api.no_errors(error_array) THEN

1687: x_Id_str := id_str;
1688:
1689: -- End of 12.1 QWB Usability Improvements
1690:
1691: IF qa_validation_api.no_errors(error_array) THEN
1692: get_action_messages(l_message_array, p_plan_id, x_messages);
1693: RETURN 0;
1694: ELSE
1695: get_error_messages(error_array, p_plan_id, x_messages);