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.ECE_RULES_PKG dependencies on ECE_RULE_VIOLATIONS

Line 78: -- insert new violation information into ece_rule_violations table.

74:
75: ec_utils.g_ext_levels(p_level).status := l_new_status;
76:
77: xProgress := 'ECERULEB-10-1020';
78: -- insert new violation information into ece_rule_violations table.
79:
80: l_cur_index := g_rule_violation_tbl.count + 1;
81: select ece_rule_violations_s.nextval into l_seq from dual;
82:

Line 81: select ece_rule_violations_s.nextval into l_seq from dual;

77: xProgress := 'ECERULEB-10-1020';
78: -- insert new violation information into ece_rule_violations table.
79:
80: l_cur_index := g_rule_violation_tbl.count + 1;
81: select ece_rule_violations_s.nextval into l_seq from dual;
82:
83: if SQL%NOTFOUND then
84: ec_debug.pl (0, 'EC', 'ECE_GET_NEXT_SEQ_FAILED',
85: 'PROGRESS_LEVEL', xProgress,

Line 86: 'SEQ', 'ECE_RULE_VIOLATIONS_S');

82:
83: if SQL%NOTFOUND then
84: ec_debug.pl (0, 'EC', 'ECE_GET_NEXT_SEQ_FAILED',
85: 'PROGRESS_LEVEL', xProgress,
86: 'SEQ', 'ECE_RULE_VIOLATIONS_S');
87: end if;
88:
89: g_rule_violation_tbl(l_cur_index).violation_id := l_seq;
90: g_rule_violation_tbl(l_cur_index).document_id := p_document_id;

Line 163: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;

159: l_action_code ece_process_rules.action_code%TYPE;
160: l_valid_rule VARCHAR2(1):= 'Y';
161: l_tp_detail_id NUMBER;
162: l_violation_level VARCHAR2(10) := g_process_rule;
163: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;
164: l_msg_text ece_rule_violations.message_text%TYPE;
165: no_process_rule_info EXCEPTION;
166:
167: CURSOR c_rule_info(

Line 164: l_msg_text ece_rule_violations.message_text%TYPE;

160: l_valid_rule VARCHAR2(1):= 'Y';
161: l_tp_detail_id NUMBER;
162: l_violation_level VARCHAR2(10) := g_process_rule;
163: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;
164: l_msg_text ece_rule_violations.message_text%TYPE;
165: no_process_rule_info EXCEPTION;
166:
167: CURSOR c_rule_info(
168: p_rule_type VARCHAR2,

Line 180: from ece_rule_violations

176: CURSOR c_ignore_flag(
177: p_document_id NUMBER,
178: p_rule_id NUMBER) IS
179: select ignore_flag
180: from ece_rule_violations
181: where document_id = p_document_id and
182: rule_id = p_rule_id and
183: violation_level = l_violation_level;
184:

Line 727: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;

723: l_rule_type ece_column_rules.rule_type%TYPE;
724: l_rule_id NUMBER;
725: l_action_code ece_column_rules.action_code%TYPE;
726: l_valid_rule VARCHAR2(1):= 'Y';
727: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;
728: l_violation_level VARCHAR2(10):= g_column_rule;
729: l_msg_text ece_rule_violations.message_text%TYPE;
730: l_existing_rule VARCHAR2(1) := 'Y';
731: l_temp_status VARCHAR2(10);

Line 729: l_msg_text ece_rule_violations.message_text%TYPE;

725: l_action_code ece_column_rules.action_code%TYPE;
726: l_valid_rule VARCHAR2(1):= 'Y';
727: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;
728: l_violation_level VARCHAR2(10):= g_column_rule;
729: l_msg_text ece_rule_violations.message_text%TYPE;
730: l_existing_rule VARCHAR2(1) := 'Y';
731: l_temp_status VARCHAR2(10);
732: i pls_integer; -- Bug 2708573
733:

Line 749: from ece_rule_violations

745: p_interface_column_id NUMBER,
746: p_stage_id NUMBER,
747: p_rule_id NUMBER) IS
748: select ignore_flag
749: from ece_rule_violations
750: where document_id = p_document_id and
751: interface_column_id = p_interface_column_id and
752: stage_id = p_stage_id and
753: rule_id = p_rule_id and

Line 2614: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;

2610: n_region1_pos NUMBER := NULL;
2611: n_region2_pos NUMBER := NULL;
2612: n_region3_pos NUMBER := NULL;
2613: l_action_code ece_process_rules.action_code%TYPE;
2614: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;
2615: l_address VARCHAR2(50) := 'ship to';
2616:
2617: BEGIN
2618:

Line 2792: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;

2788: n_region1_pos NUMBER := NULL;
2789: n_region2_pos NUMBER := NULL;
2790: n_region3_pos NUMBER := NULL;
2791: l_action_code ece_process_rules.action_code%TYPE;
2792: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;
2793: l_address VARCHAR2(50) := 'bill to';
2794:
2795: BEGIN
2796:

Line 2966: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;

2962: n_region1_pos NUMBER := NULL;
2963: n_region2_pos NUMBER := NULL;
2964: n_region3_pos NUMBER := NULL;
2965: l_action_code ece_process_rules.action_code%TYPE;
2966: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;
2967: l_address VARCHAR2(50) := 'Sold to';
2968:
2969: BEGIN
2970:

Line 3144: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;

3140: n_region1_pos NUMBER := NULL;
3141: n_region2_pos NUMBER := NULL;
3142: n_region3_pos NUMBER := NULL;
3143: l_action_code ece_process_rules.action_code%TYPE;
3144: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;
3145: l_address VARCHAR2(50) := 'ship from';
3146:
3147: BEGIN
3148:

Line 3310: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;

3306: n_region1_pos NUMBER := NULL;
3307: n_region2_pos NUMBER := NULL;
3308: n_region3_pos NUMBER := NULL;
3309: l_action_code ece_process_rules.action_code%TYPE;
3310: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;
3311: l_address VARCHAR2(50) := 'bill from';
3312:
3313: BEGIN
3314:

Line 3476: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;

3472: n_region1_pos NUMBER := NULL;
3473: n_region2_pos NUMBER := NULL;
3474: n_region3_pos NUMBER := NULL;
3475: l_action_code ece_process_rules.action_code%TYPE;
3476: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;
3477: l_address VARCHAR2(50) := 'ship to intrmd';
3478:
3479: BEGIN
3480:

Line 3640: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;

3636: n_region1_pos NUMBER := NULL;
3637: n_region2_pos NUMBER := NULL;
3638: n_region3_pos NUMBER := NULL;
3639: l_action_code ece_process_rules.action_code%TYPE;
3640: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;
3641: l_address VARCHAR2(50) := 'ship to internal';
3642:
3643: BEGIN
3644:

Line 3794: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;

3790: n_region1_pos NUMBER := NULL;
3791: n_region2_pos NUMBER := NULL;
3792: n_region3_pos NUMBER := NULL;
3793: l_action_code ece_process_rules.action_code%TYPE;
3794: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;
3795: l_address VARCHAR2(50) := 'bill to internal';
3796:
3797: BEGIN
3798:

Line 3948: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;

3944: n_region1_pos NUMBER := NULL;
3945: n_region2_pos NUMBER := NULL;
3946: n_region3_pos NUMBER := NULL;
3947: l_action_code ece_process_rules.action_code%TYPE;
3948: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;
3949: l_address VARCHAR2(50) := 'ship from internal';
3950:
3951: BEGIN
3952:

Line 4113: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;

4109: n_region1_pos NUMBER := NULL;
4110: n_region2_pos NUMBER := NULL;
4111: n_region3_pos NUMBER := NULL;
4112: l_action_code ece_process_rules.action_code%TYPE;
4113: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;
4114: l_address VARCHAR2(50) := 'bill from internal';
4115:
4116: BEGIN
4117:

Line 4314: from ece_rule_violations

4310: CURSOR c_ignore_flag(
4311: p_document_id NUMBER,
4312: p_rule_id NUMBER) IS
4313: select ignore_flag
4314: from ece_rule_violations
4315: where document_id = p_document_id and
4316: rule_id = p_rule_id and
4317: violation_level = l_violation_level;
4318: