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: -- Bug 9582246
99: -- New variables for obtaining COMMENTS result String.
100: -- skolluku

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

189: ELSE
190: l_rescol_val := l_rescol_val || '@' || l_comments_rescol_val;
191: END IF;
192: END IF; -- End changes for bug 9582246
193: elements_db := qa_validation_api.result_to_array(l_rescol_val);
194:
195: -- Reinitialize the char_id variable since, the comparison
196: -- needs to be done here. So, looping again...
197: char_id:= elements.first;

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

226: -- actions based on it are not to be fired. So setting
227: -- the validation flag for this element accordingly
228: --
229: If NVL(input_val,'0') = NVL(saved_val,'0') THEN
230: elements(char_id).validation_flag := qa_validation_api.action_fired;
231: --
232: -- Bug 10431717
233: -- Since the element values are the same hence setting the element as
234: -- valid.

Line 249: RETURN qa_validation_api.get_error_message (code);

245: BEGIN
246: --
247: -- Should figure out the error message from dictionary.
248: --
249: RETURN qa_validation_api.get_error_message (code);
250: END get_error_code;
251:
252:
253: --

Line 258: p_errors IN qa_validation_api.ErrorArray,

254: -- Get the error messages and append them into an @-separated
255: -- string.
256: --
257: PROCEDURE get_error_messages(
258: p_errors IN qa_validation_api.ErrorArray,
259: p_plan_id IN NUMBER,
260: x_messages OUT NOCOPY VARCHAR2) IS
261:
262: separator CONSTANT VARCHAR2(1) := '@';

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

307: -- from the collection plan and put in the variable code. If the action
308: -- is not 'Reject the input' then the existing code is used.
309: -- ntunagre Tue Mar 28 08:04:54 PST 2006.
310: --
311: If p_errors(i).error_code = qa_validation_api.reject_an_entry_error then
312: OPEN cur_mesg(p_plan_id, p_errors(i).element_id);
313: FETCH cur_mesg INTO code;
314: CLOSE cur_mesg;
315: else

Line 332: msg_array IN qa_validation_api.MessageArray,

328: -- Get the action messages and append them into an @-separated
329: -- string.
330: --
331: PROCEDURE get_action_messages(
332: msg_array IN qa_validation_api.MessageArray,
333: plan_id IN NUMBER,
334: messages OUT NOCOPY VARCHAR2) IS
335:
336: separator CONSTANT VARCHAR2(1) := '@';

Line 393: elements qa_validation_api.ElementsArray;

389: x_enabled IN INTEGER,
390: x_committed IN INTEGER,
391: x_messages OUT NOCOPY VARCHAR2)
392: RETURN INTEGER IS
393: elements qa_validation_api.ElementsArray;
394: error_array qa_validation_api.ErrorArray;
395: message_array qa_validation_api.MessageArray;
396: return_status VARCHAR2(1);
397: action_result VARCHAR2(1);

Line 394: error_array qa_validation_api.ErrorArray;

390: x_committed IN INTEGER,
391: x_messages OUT NOCOPY VARCHAR2)
392: RETURN INTEGER IS
393: elements qa_validation_api.ElementsArray;
394: error_array qa_validation_api.ErrorArray;
395: message_array qa_validation_api.MessageArray;
396: return_status VARCHAR2(1);
397: action_result VARCHAR2(1);
398: msg_count NUMBER;

Line 395: message_array qa_validation_api.MessageArray;

391: x_messages OUT NOCOPY VARCHAR2)
392: RETURN INTEGER IS
393: elements qa_validation_api.ElementsArray;
394: error_array qa_validation_api.ErrorArray;
395: message_array qa_validation_api.MessageArray;
396: return_status VARCHAR2(1);
397: action_result VARCHAR2(1);
398: msg_count NUMBER;
399: msg_data VARCHAR2(2000);

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

443: --
444: -- First task is to decode this string into the row_element
445: -- array.
446: --
447: elements := qa_validation_api.result_to_array(x_result);
448: elements := qa_validation_api.id_to_array(x_result1, elements);
449: qa_validation_api.set_validation_flag(elements);
450:
451: --

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

444: -- First task is to decode this string into the row_element
445: -- array.
446: --
447: elements := qa_validation_api.result_to_array(x_result);
448: elements := qa_validation_api.id_to_array(x_result1, elements);
449: qa_validation_api.set_validation_flag(elements);
450:
451: --
452: -- Bug 2617638

Line 449: qa_validation_api.set_validation_flag(elements);

445: -- array.
446: --
447: elements := qa_validation_api.result_to_array(x_result);
448: elements := qa_validation_api.id_to_array(x_result1, elements);
449: qa_validation_api.set_validation_flag(elements);
450:
451: --
452: -- Bug 2617638
453: -- The follow statement is needed to process x_result1.

Line 479: IF qa_validation_api.no_errors(error_array) AND

475: x_message_array => message_array,
476: x_return_status => return_status,
477: x_action_result => action_result);
478:
479: IF qa_validation_api.no_errors(error_array) AND
480: return_status <> FND_API.G_RET_STS_ERROR AND
481: return_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
482: RETURN 0;
483: ELSE

Line 500: elements IN OUT NOCOPY qa_validation_api.ElementsArray)

496: -- important in case of Background result collection
497: -- ntungare Mon Mar 26 06:20:05 PDT 2007
498: --
499: PROCEDURE initialize_seq_elements(x_plan_id IN NUMBER,
500: elements IN OUT NOCOPY qa_validation_api.ElementsArray)
501: IS
502: TYPE seq_charid_tab_typ IS TABLE OF qa_chars.char_id%TYPE INDEX BY BINARY_INTEGER;
503: seq_charid_tab seq_charid_tab_typ;
504:

Line 556: elements qa_validation_api.ElementsArray;

552: x_committed IN INTEGER,
553: x_transaction_number IN NUMBER,
554: x_messages OUT NOCOPY VARCHAR2)
555: RETURN INTEGER IS
556: elements qa_validation_api.ElementsArray;
557: error_array qa_validation_api.ErrorArray;
558: message_array qa_validation_api.MessageArray;
559: return_status VARCHAR2(1);
560: action_result VARCHAR2(1);

Line 557: error_array qa_validation_api.ErrorArray;

553: x_transaction_number IN NUMBER,
554: x_messages OUT NOCOPY VARCHAR2)
555: RETURN INTEGER IS
556: elements qa_validation_api.ElementsArray;
557: error_array qa_validation_api.ErrorArray;
558: message_array qa_validation_api.MessageArray;
559: return_status VARCHAR2(1);
560: action_result VARCHAR2(1);
561: msg_count NUMBER;

Line 558: message_array qa_validation_api.MessageArray;

554: x_messages OUT NOCOPY VARCHAR2)
555: RETURN INTEGER IS
556: elements qa_validation_api.ElementsArray;
557: error_array qa_validation_api.ErrorArray;
558: message_array qa_validation_api.MessageArray;
559: return_status VARCHAR2(1);
560: action_result VARCHAR2(1);
561: msg_count NUMBER;
562: msg_data VARCHAR2(2000);

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

609: --
610: -- First task is to decode this string into the row_element
611: -- array.
612: --
613: elements := qa_validation_api.result_to_array(x_result);
614: elements := qa_validation_api.id_to_array(x_result1, elements);
615:
616: IF (x_transaction_number IS NOT NULL) AND (x_transaction_number > 0) THEN
617: qa_validation_api.set_validation_flag_txn(

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

610: -- First task is to decode this string into the row_element
611: -- array.
612: --
613: elements := qa_validation_api.result_to_array(x_result);
614: elements := qa_validation_api.id_to_array(x_result1, elements);
615:
616: IF (x_transaction_number IS NOT NULL) AND (x_transaction_number > 0) THEN
617: qa_validation_api.set_validation_flag_txn(
618: x_elements => elements,

Line 617: qa_validation_api.set_validation_flag_txn(

613: elements := qa_validation_api.result_to_array(x_result);
614: elements := qa_validation_api.id_to_array(x_result1, elements);
615:
616: IF (x_transaction_number IS NOT NULL) AND (x_transaction_number > 0) THEN
617: qa_validation_api.set_validation_flag_txn(
618: x_elements => elements,
619: p_plan_id => x_plan_id,
620: p_transaction_number => x_transaction_number,
621: p_plan_transaction_id => NULL);

Line 653: IF qa_validation_api.no_errors(error_array) AND

649: x_message_array => message_array,
650: x_return_status => return_status,
651: x_action_result => action_result);
652:
653: IF qa_validation_api.no_errors(error_array) AND
654: return_status <> FND_API.G_RET_STS_ERROR AND
655: return_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
656: get_action_messages(message_array, x_plan_id, x_messages);
657: RETURN 0;

Line 715: elements qa_validation_api.ElementsArray;

711: x_agg_val OUT NOCOPY VARCHAR2,
712: p_last_update_date IN DATE DEFAULT SYSDATE,
713: p_background_flag IN NUMBER DEFAULT 0)
714: RETURN INTEGER IS
715: elements qa_validation_api.ElementsArray;
716: error_array qa_validation_api.ErrorArray;
717: message_array qa_validation_api.MessageArray;
718: return_status VARCHAR2(1);
719: action_result VARCHAR2(1);

Line 716: error_array qa_validation_api.ErrorArray;

712: p_last_update_date IN DATE DEFAULT SYSDATE,
713: p_background_flag IN NUMBER DEFAULT 0)
714: RETURN INTEGER IS
715: elements qa_validation_api.ElementsArray;
716: error_array qa_validation_api.ErrorArray;
717: message_array qa_validation_api.MessageArray;
718: return_status VARCHAR2(1);
719: action_result VARCHAR2(1);
720: msg_count NUMBER;

Line 717: message_array qa_validation_api.MessageArray;

713: p_background_flag IN NUMBER DEFAULT 0)
714: RETURN INTEGER IS
715: elements qa_validation_api.ElementsArray;
716: error_array qa_validation_api.ErrorArray;
717: message_array qa_validation_api.MessageArray;
718: return_status VARCHAR2(1);
719: action_result VARCHAR2(1);
720: msg_count NUMBER;
721: msg_data VARCHAR2(2000);

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

807: --
808: -- First task is to decode this string into the row_element
809: -- array.
810: --
811: elements := qa_validation_api.result_to_array(x_result);
812: elements := qa_validation_api.id_to_array(x_result1, elements);
813:
814: IF (x_transaction_number IS NOT NULL) AND (x_transaction_number > 0) THEN
815: qa_validation_api.set_validation_flag_txn(

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

808: -- First task is to decode this string into the row_element
809: -- array.
810: --
811: elements := qa_validation_api.result_to_array(x_result);
812: elements := qa_validation_api.id_to_array(x_result1, elements);
813:
814: IF (x_transaction_number IS NOT NULL) AND (x_transaction_number > 0) THEN
815: qa_validation_api.set_validation_flag_txn(
816: x_elements => elements,

Line 815: qa_validation_api.set_validation_flag_txn(

811: elements := qa_validation_api.result_to_array(x_result);
812: elements := qa_validation_api.id_to_array(x_result1, elements);
813:
814: IF (x_transaction_number IS NOT NULL) AND (x_transaction_number > 0) THEN
815: qa_validation_api.set_validation_flag_txn(
816: x_elements => elements,
817: p_plan_id => x_plan_id,
818: p_transaction_number => x_transaction_number,
819: p_plan_transaction_id => NULL);

Line 875: IF qa_validation_api.no_errors(error_array) AND

871: x_action_result => action_result,
872: p_ssqr_operation => l_ssqr_operation,
873: p_last_update_date => p_last_update_date);
874:
875: IF qa_validation_api.no_errors(error_array) AND
876: return_status <> FND_API.G_RET_STS_ERROR AND
877: return_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
878: get_action_messages(message_array, x_plan_id, x_messages);
879:

Line 1037: elements qa_validation_api.ElementsArray;

1033: x_committed IN INTEGER,
1034: x_transaction_number IN NUMBER,
1035: x_messages OUT NOCOPY VARCHAR2)
1036: RETURN INTEGER IS
1037: elements qa_validation_api.ElementsArray;
1038: error_array qa_validation_api.ErrorArray;
1039: message_array qa_validation_api.MessageArray;
1040: return_status VARCHAR2(1);
1041: action_result VARCHAR2(1);

Line 1038: error_array qa_validation_api.ErrorArray;

1034: x_transaction_number IN NUMBER,
1035: x_messages OUT NOCOPY VARCHAR2)
1036: RETURN INTEGER IS
1037: elements qa_validation_api.ElementsArray;
1038: error_array qa_validation_api.ErrorArray;
1039: message_array qa_validation_api.MessageArray;
1040: return_status VARCHAR2(1);
1041: action_result VARCHAR2(1);
1042: msg_count NUMBER;

Line 1039: message_array qa_validation_api.MessageArray;

1035: x_messages OUT NOCOPY VARCHAR2)
1036: RETURN INTEGER IS
1037: elements qa_validation_api.ElementsArray;
1038: error_array qa_validation_api.ErrorArray;
1039: message_array qa_validation_api.MessageArray;
1040: return_status VARCHAR2(1);
1041: action_result VARCHAR2(1);
1042: msg_count NUMBER;
1043: msg_data VARCHAR2(2000);

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

1088: -- First task is to decode this string into the row_element
1089: -- array.
1090: --
1091:
1092: elements := qa_validation_api.result_to_array(x_result);
1093: elements := qa_validation_api.id_to_array(x_result1, elements);
1094:
1095: IF (x_transaction_number IS NOT NULL) AND (x_transaction_number > 0) THEN
1096: qa_validation_api.set_validation_flag_txn(

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

1089: -- array.
1090: --
1091:
1092: elements := qa_validation_api.result_to_array(x_result);
1093: elements := qa_validation_api.id_to_array(x_result1, elements);
1094:
1095: IF (x_transaction_number IS NOT NULL) AND (x_transaction_number > 0) THEN
1096: qa_validation_api.set_validation_flag_txn(
1097: x_elements => elements,

Line 1096: qa_validation_api.set_validation_flag_txn(

1092: elements := qa_validation_api.result_to_array(x_result);
1093: elements := qa_validation_api.id_to_array(x_result1, elements);
1094:
1095: IF (x_transaction_number IS NOT NULL) AND (x_transaction_number > 0) THEN
1096: qa_validation_api.set_validation_flag_txn(
1097: x_elements => elements,
1098: p_plan_id => x_plan_id,
1099: p_transaction_number => x_transaction_number,
1100: p_plan_transaction_id => NULL);

Line 1123: IF qa_validation_api.no_errors(error_array) THEN

1119: x_message_array => message_array,
1120: x_return_status => return_status,
1121: x_action_result => action_result);
1122:
1123: IF qa_validation_api.no_errors(error_array) THEN
1124:
1125: -- Bug 4057388. Display a message action was not firing in eam.
1126: -- message_array returned from qa_results_pub.update_row was
1127: -- not converted to output string x_mesasges.

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

1139: RETURN -1;
1140: END update_result;
1141:
1142:
1143: PROCEDURE post_error_messages (p_errors IN qa_validation_api.ErrorArray,
1144: plan_id NUMBER) IS
1145:
1146: l_message_name VARCHAR2(30);
1147: l_char_prompt VARCHAR2(100);

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

1183: -- description. This token would be replaced with the message added by
1184: -- the user in the collection plan setup for 'Reject the input' action.
1185: -- ntungare Tue Mar 28 08:10:23 PST 2006.
1186: --
1187: IF p_errors(i).error_code = qa_validation_api.reject_an_entry_error then
1188: OPEN cur_mesg(plan_id,p_errors(i).element_id);
1189: FETCH cur_mesg INTO l_mesg;
1190: CLOSE cur_mesg;
1191:

Line 1247: elements qa_validation_api.ElementsArray;

1243: x_agg_elements OUT NOCOPY VARCHAR2,
1244: x_agg_val OUT NOCOPY VARCHAR2,
1245: p_last_update_date IN DATE DEFAULT SYSDATE)
1246: RETURN INTEGER IS
1247: elements qa_validation_api.ElementsArray;
1248: error_array qa_validation_api.ErrorArray;
1249: message_array qa_validation_api.MessageArray;
1250: return_status VARCHAR2(1);
1251: action_result VARCHAR2(1);

Line 1248: error_array qa_validation_api.ErrorArray;

1244: x_agg_val OUT NOCOPY VARCHAR2,
1245: p_last_update_date IN DATE DEFAULT SYSDATE)
1246: RETURN INTEGER IS
1247: elements qa_validation_api.ElementsArray;
1248: error_array qa_validation_api.ErrorArray;
1249: message_array qa_validation_api.MessageArray;
1250: return_status VARCHAR2(1);
1251: action_result VARCHAR2(1);
1252: msg_count NUMBER;

Line 1249: message_array qa_validation_api.MessageArray;

1245: p_last_update_date IN DATE DEFAULT SYSDATE)
1246: RETURN INTEGER IS
1247: elements qa_validation_api.ElementsArray;
1248: error_array qa_validation_api.ErrorArray;
1249: message_array qa_validation_api.MessageArray;
1250: return_status VARCHAR2(1);
1251: action_result VARCHAR2(1);
1252: msg_count NUMBER;
1253: msg_data VARCHAR2(2000);

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

1331: --
1332: -- First task is to decode this string into the row_element
1333: -- array.
1334: --
1335: elements := qa_validation_api.result_to_array(x_result);
1336: elements := qa_validation_api.id_to_array(x_result1, elements);
1337:
1338: IF (x_transaction_number IS NOT NULL) AND (x_transaction_number > 0) THEN
1339: qa_validation_api.set_validation_flag_txn(

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

1332: -- First task is to decode this string into the row_element
1333: -- array.
1334: --
1335: elements := qa_validation_api.result_to_array(x_result);
1336: elements := qa_validation_api.id_to_array(x_result1, elements);
1337:
1338: IF (x_transaction_number IS NOT NULL) AND (x_transaction_number > 0) THEN
1339: qa_validation_api.set_validation_flag_txn(
1340: x_elements => elements,

Line 1339: qa_validation_api.set_validation_flag_txn(

1335: elements := qa_validation_api.result_to_array(x_result);
1336: elements := qa_validation_api.id_to_array(x_result1, elements);
1337:
1338: IF (x_transaction_number IS NOT NULL) AND (x_transaction_number > 0) THEN
1339: qa_validation_api.set_validation_flag_txn(
1340: x_elements => elements,
1341: p_plan_id => x_plan_id,
1342: p_transaction_number => x_transaction_number,
1343: p_plan_transaction_id => NULL);

Line 1375: IF qa_validation_api.no_errors(error_array) THEN

1371: x_action_result => action_result,
1372: p_ssqr_operation => 1,
1373: p_last_update_date => p_last_update_date);
1374:
1375: IF qa_validation_api.no_errors(error_array) THEN
1376:
1377: -- anagarwa Fri Jan 23 12:10:04 PST 2004
1378: -- Bug 3384986 Actions for CAR master not fired when child is updated
1379: -- update parent and also update parent txn id so that the actions like

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

1616:
1617:
1618: --
1619: -- Removed procedure wb_set_valid_flag entirely because
1620: -- the new qa_validation_api.set_validation_flag_txn is a superset.
1621: --
1622:
1623: --
1624: -- Used only by QWB and Fwk Integration

Line 1651: elements qa_validation_api.ElementsArray;

1647: x_charid_str OUT NOCOPY VARCHAR2,
1648: x_id_str out NOCOPY VARCHAR2)
1649: RETURN INTEGER IS
1650:
1651: elements qa_validation_api.ElementsArray;
1652: error_array qa_validation_api.ErrorArray;
1653: l_results_array qa_validation_api.ResultRecordArray;
1654: l_message_array qa_validation_api.MessageArray;
1655:

Line 1652: error_array qa_validation_api.ErrorArray;

1648: x_id_str out NOCOPY VARCHAR2)
1649: RETURN INTEGER IS
1650:
1651: elements qa_validation_api.ElementsArray;
1652: error_array qa_validation_api.ErrorArray;
1653: l_results_array qa_validation_api.ResultRecordArray;
1654: l_message_array qa_validation_api.MessageArray;
1655:
1656: --

Line 1653: l_results_array qa_validation_api.ResultRecordArray;

1649: RETURN INTEGER IS
1650:
1651: elements qa_validation_api.ElementsArray;
1652: error_array qa_validation_api.ErrorArray;
1653: l_results_array qa_validation_api.ResultRecordArray;
1654: l_message_array qa_validation_api.MessageArray;
1655:
1656: --
1657: -- Bug 5932426

Line 1654: l_message_array qa_validation_api.MessageArray;

1650:
1651: elements qa_validation_api.ElementsArray;
1652: error_array qa_validation_api.ErrorArray;
1653: l_results_array qa_validation_api.ResultRecordArray;
1654: l_message_array qa_validation_api.MessageArray;
1655:
1656: --
1657: -- Bug 5932426
1658: -- Checing if the Txn is an update Txn or an

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

1680:
1681: --clearing cache so that errors are not shown over and over again.
1682: fnd_msg_pub.Initialize();
1683: fnd_msg_pub.reset();
1684: elements := qa_validation_api.result_to_array(p_result);
1685: elements := qa_validation_api.id_to_array(p_result1, elements);
1686:
1687: --
1688: -- Bug 5932426

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

1681: --clearing cache so that errors are not shown over and over again.
1682: fnd_msg_pub.Initialize();
1683: fnd_msg_pub.reset();
1684: elements := qa_validation_api.result_to_array(p_result);
1685: elements := qa_validation_api.id_to_array(p_result1, elements);
1686:
1687: --
1688: -- Bug 5932426
1689: -- Updating the validation flag only if the

Line 1716: qa_validation_api.set_validation_flag_txn(

1712: -- wb_set_valid_flag(p_elements => elements,
1713: -- p_transaction_number => p_transaction_number);
1714: --
1715: IF (p_transaction_number IS NOT NULL) AND (p_transaction_number > 0) THEN
1716: qa_validation_api.set_validation_flag_txn(
1717: x_elements => elements,
1718: p_plan_id => p_plan_id,
1719: p_transaction_number => p_transaction_number,
1720: p_plan_transaction_id => NULL);

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

1724: -- Passing the value for the P_ssqr_operation flag as
1725: -- 1 to indicate that the online actions firing is
1726: -- not be done
1727: --
1728: error_array := qa_validation_api.validate_row(p_plan_id,
1729: p_spec_id, p_org_id, fnd_global.user_id, p_transaction_number,
1730: p_transaction_id, l_results_array, l_message_array,
1731: elements, 1);
1732:

Line 1760: IF qa_validation_api.no_errors(error_array) THEN

1756: x_Id_str := id_str;
1757:
1758: -- End of 12.1 QWB Usability Improvements
1759:
1760: IF qa_validation_api.no_errors(error_array) THEN
1761: get_action_messages(l_message_array, p_plan_id, x_messages);
1762: RETURN 0;
1763: ELSE
1764: get_error_messages(error_array, p_plan_id, x_messages);