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.FND_FLEX_DIAGNOSE dependencies on FND_FLEX_VALIDATION_RULES

Line 40: SUBTYPE kff_cvr_type IS fnd_flex_validation_rules%ROWTYPE;

36: SUBTYPE kff_flq_type IS fnd_segment_attribute_types%ROWTYPE;
37: SUBTYPE kff_qlv_type IS fnd_segment_attribute_values%ROWTYPE;
38: SUBTYPE kff_sgq_type IS fnd_value_attribute_types%ROWTYPE;
39: SUBTYPE kff_sha_type IS fnd_shorthand_flex_aliases%ROWTYPE;
40: SUBTYPE kff_cvr_type IS fnd_flex_validation_rules%ROWTYPE;
41: SUBTYPE kff_cvl_type IS fnd_flex_validation_rule_lines%ROWTYPE;
42: SUBTYPE kff_cvi_type IS fnd_flex_include_rule_lines%ROWTYPE;
43: SUBTYPE kff_cve_type IS fnd_flex_exclude_rule_lines%ROWTYPE;
44: SUBTYPE kff_fwp_type IS fnd_flex_workflow_processes%ROWTYPE;

Line 657: FROM fnd_flex_validation_rules

653: IS
654: BEGIN
655: SELECT *
656: INTO x_kff_cvr
657: FROM fnd_flex_validation_rules
658: WHERE application_id = p_kff_str.application_id
659: AND id_flex_code = p_kff_str.id_flex_code
660: AND id_flex_num = p_kff_str.id_flex_num
661: AND flex_validation_rule_name = p_flex_validation_rule_name;

Line 665: x_message := msg_uts('FND_FLEX_VALIDATION_RULES',

661: AND flex_validation_rule_name = p_flex_validation_rule_name;
662: RETURN(TRUE);
663: EXCEPTION
664: WHEN OTHERS THEN
665: x_message := msg_uts('FND_FLEX_VALIDATION_RULES',
666: 'application_id', p_kff_str.application_id,
667: 'id_flex_code', p_kff_str.id_flex_code,
668: 'id_flex_num', p_kff_str.id_flex_num,
669: 'flex_validation_rule_name', p_flex_validation_rule_name);

Line 3966: FROM fnd_flex_validation_rules

3962:
3963: BEGIN
3964: SELECT COUNT(*)
3965: INTO l_r_count
3966: FROM fnd_flex_validation_rules
3967: WHERE application_id = p_kff_str.application_id
3968: AND id_flex_code = p_kff_str.id_flex_code
3969: AND id_flex_num = p_kff_str.id_flex_num;
3970: EXCEPTION

Line 3973: 'Unable to count FND_FLEX_VALIDATION_RULES. ' || Sqlerrm;

3969: AND id_flex_num = p_kff_str.id_flex_num;
3970: EXCEPTION
3971: WHEN OTHERS THEN
3972: x_message :=
3973: 'Unable to count FND_FLEX_VALIDATION_RULES. ' || Sqlerrm;
3974: GOTO return_error;
3975: END;
3976:
3977: BEGIN

Line 4900: FROM fnd_flex_validation_rules fvr

4896: -- CVRs without Structure.
4897: --
4898: BEGIN
4899: DELETE
4900: FROM fnd_flex_validation_rules fvr
4901: WHERE application_id = p_application_id
4902: AND id_flex_code = p_id_flex_code
4903: AND id_flex_num = p_id_flex_num
4904: AND flex_validation_rule_name = p_flex_validation_rule_name

Line 4916: 'Unable to delete from FND_FLEX_VALIDATION_RULES. ' || Sqlerrm;

4912: GOTO return_success;
4913: EXCEPTION
4914: WHEN OTHERS THEN
4915: x_message :=
4916: 'Unable to delete from FND_FLEX_VALIDATION_RULES. ' || Sqlerrm;
4917: GOTO return_error;
4918: END;
4919: END IF;
4920:

Line 4960: UPDATE fnd_flex_validation_rules SET

4956: GOTO return_error;
4957: END IF;
4958:
4959: BEGIN
4960: UPDATE fnd_flex_validation_rules SET
4961: error_segment_column_name = NULL,
4962: last_update_date = Sysdate,
4963: last_updated_by = 1
4964: WHERE application_id = p_application_id

Line 4972: x_message := 'Unable to update FND_FLEX_VALIDATION_RULES. ' ||

4968: x_message := SQL%rowcount || ' row(s) updated.';
4969: GOTO return_success;
4970: EXCEPTION
4971: WHEN OTHERS THEN
4972: x_message := 'Unable to update FND_FLEX_VALIDATION_RULES. ' ||
4973: Sqlerrm;
4974: GOTO return_error;
4975: END;
4976: END IF;

Line 4994: UPDATE fnd_flex_validation_rules SET

4990: l_kff_cvr.end_date_active := l_kff_cvr.start_date_active;
4991: END IF;
4992:
4993: BEGIN
4994: UPDATE fnd_flex_validation_rules SET
4995: enabled_flag = l_kff_cvr.enabled_flag,
4996: start_date_active = l_kff_cvr.start_date_active,
4997: end_date_active = l_kff_cvr.end_date_active,
4998: last_update_date = Sysdate,

Line 5009: 'Unable to update FND_FLEX_VALIDATION_RULES. ' || Sqlerrm;

5005: GOTO return_success;
5006: EXCEPTION
5007: WHEN OTHERS THEN
5008: x_message :=
5009: 'Unable to update FND_FLEX_VALIDATION_RULES. ' || Sqlerrm;
5010: GOTO return_error;
5011: END;
5012: END IF;
5013:

Line 5039: UPDATE fnd_flex_validation_rules SET

5035: END IF;
5036:
5037:
5038: BEGIN
5039: UPDATE fnd_flex_validation_rules SET
5040: enabled_flag = 'N',
5041: last_update_date = Sysdate,
5042: last_updated_by = 1
5043: WHERE application_id = l_kff_cvr.application_id

Line 5052: 'Unable to delete from FND_FLEX_VALIDATION_RULES. ' || Sqlerrm;

5048: GOTO return_success;
5049: EXCEPTION
5050: WHEN OTHERS THEN
5051: x_message :=
5052: 'Unable to delete from FND_FLEX_VALIDATION_RULES. ' || Sqlerrm;
5053: GOTO return_error;
5054: END;
5055: END IF;
5056:

Line 5094: FROM fnd_flex_validation_rules fvr

5090: AND flex_validation_rule_name = p_flex_validation_rule_name
5091: AND rule_line_id = p_rule_line_id
5092: AND NOT EXISTS
5093: (SELECT null
5094: FROM fnd_flex_validation_rules fvr
5095: WHERE fvr.application_id = fvrl.application_id
5096: AND fvr.id_flex_code = fvrl.id_flex_code
5097: AND fvr.id_flex_num = fvrl.id_flex_num
5098: AND fvr.flex_validation_rule_name =fvrl.flex_validation_rule_name);