APPS.FND_FLEX_DIAGNOSE dependencies on FND_FLEX_VALIDATION_EVENTS

Line 20: SUBTYPE vst_evt_type IS fnd_flex_validation_events%ROWTYPE;

16: SUBTYPE rsp_type IS fnd_responsibility%ROWTYPE;
17:
18: SUBTYPE vst_set_type IS fnd_flex_value_sets%ROWTYPE;
19: SUBTYPE vst_tbl_type IS fnd_flex_validation_tables%ROWTYPE;
20: SUBTYPE vst_evt_type IS fnd_flex_validation_events%ROWTYPE;
21: SUBTYPE vst_scr_type IS fnd_flex_value_rules%ROWTYPE;
22: SUBTYPE vst_scl_type IS fnd_flex_value_rule_lines%ROWTYPE;
23: SUBTYPE vst_scu_type IS fnd_flex_value_rule_usages%ROWTYPE;
24: SUBTYPE vst_rlg_type IS fnd_flex_hierarchies%ROWTYPE;

Line 264: FROM fnd_flex_validation_events

260: IS
261: BEGIN
262: SELECT *
263: INTO x_vst_evt
264: FROM fnd_flex_validation_events
265: WHERE flex_value_set_id = p_vst_set.flex_value_set_id
266: AND event_code = p_event_code;
267: RETURN(TRUE);
268: EXCEPTION

Line 270: x_message := msg_uts('FND_FLEX_VALIDATION_EVENTS',

266: AND event_code = p_event_code;
267: RETURN(TRUE);
268: EXCEPTION
269: WHEN OTHERS THEN
270: x_message := msg_uts('FND_FLEX_VALIDATION_EVENTS',
271: 'flex_value_set_id', p_vst_set.flex_value_set_id,
272: 'event_code', p_event_code);
273: RETURN(FALSE);
274: END fetch_vst_evt;

Line 1176: FROM fnd_flex_validation_events fve, fnd_lookups fl

1172: SELECT fve.event_code || '/' ||
1173: fl.meaning || '/',
1174: fve.user_exit
1175: INTO l_return, l_user_exit
1176: FROM fnd_flex_validation_events fve, fnd_lookups fl
1177: WHERE fl.lookup_type = 'FLEX_VALIDATION_EVENTS'
1178: AND fl.lookup_code = fve.event_code
1179: AND fve.flex_value_set_id = p_flex_value_set_id
1180: AND fve.event_code = p_event_code;

Line 1715: FROM fnd_flex_validation_events

1711: END IF;
1712:
1713: BEGIN
1714: SELECT COUNT(*) INTO l_count
1715: FROM fnd_flex_validation_events
1716: WHERE flex_value_set_id = l_vst_set.flex_value_set_id;
1717: EXCEPTION
1718: WHEN OTHERS THEN
1719: x_message :=

Line 1720: 'Unable to count FND_FLEX_VALIDATION_EVENTS. ' || Sqlerrm;

1716: WHERE flex_value_set_id = l_vst_set.flex_value_set_id;
1717: EXCEPTION
1718: WHEN OTHERS THEN
1719: x_message :=
1720: 'Unable to count FND_FLEX_VALIDATION_EVENTS. ' || Sqlerrm;
1721: GOTO return_error;
1722: END;
1723:
1724: IF (l_count > 0) THEN

Line 1896: FROM fnd_flex_validation_events fve

1892: -- Events without set.
1893: --
1894: BEGIN
1895: DELETE
1896: FROM fnd_flex_validation_events fve
1897: WHERE flex_value_set_id = p_flex_value_set_id
1898: AND event_code = p_event_code
1899: AND NOT EXISTS
1900: (SELECT null

Line 1909: 'Unable to delete from FND_FLEX_VALIDATION_EVENTS. ' || Sqlerrm;

1905: GOTO return_success;
1906: EXCEPTION
1907: WHEN OTHERS THEN
1908: x_message :=
1909: 'Unable to delete from FND_FLEX_VALIDATION_EVENTS. ' || Sqlerrm;
1910: GOTO return_error;
1911: END;
1912: END IF;
1913:

Line 1935: FROM fnd_flex_validation_events fve

1931: IF (NOT lookup_code_exists('FLEX_VALIDATION_EVENTS',
1932: l_vst_evt.event_code)) THEN
1933: BEGIN
1934: DELETE
1935: FROM fnd_flex_validation_events fve
1936: WHERE flex_value_set_id = l_vst_evt.flex_value_set_id
1937: AND event_code = l_vst_evt.event_code;
1938: x_message := SQL%rowcount || ' row(s) deleted.';
1939: GOTO return_success;

Line 1943: 'Unable to delete from FND_FLEX_VALIDATION_EVENTS. ' ||

1939: GOTO return_success;
1940: EXCEPTION
1941: WHEN OTHERS THEN
1942: x_message :=
1943: 'Unable to delete from FND_FLEX_VALIDATION_EVENTS. ' ||
1944: Sqlerrm;
1945: GOTO return_error;
1946: END;
1947: END IF;