110: then
111: --
112: if p_val > p_mx_elcn_val then
113: --
114: fnd_message.set_name('BEN','BEN_92984_CWB_VAL_NOT_IN_RANGE');
115: fnd_message.set_token('VAL',p_val);
116: fnd_message.set_token('MIN',p_mn_elcn_val);
117: fnd_message.set_token('MAX',p_mx_elcn_val);
118: fnd_message.set_token('PERSON',l_person_name);
111: --
112: if p_val > p_mx_elcn_val then
113: --
114: fnd_message.set_name('BEN','BEN_92984_CWB_VAL_NOT_IN_RANGE');
115: fnd_message.set_token('VAL',p_val);
116: fnd_message.set_token('MIN',p_mn_elcn_val);
117: fnd_message.set_token('MAX',p_mx_elcn_val);
118: fnd_message.set_token('PERSON',l_person_name);
119: fnd_message.raise_error;
112: if p_val > p_mx_elcn_val then
113: --
114: fnd_message.set_name('BEN','BEN_92984_CWB_VAL_NOT_IN_RANGE');
115: fnd_message.set_token('VAL',p_val);
116: fnd_message.set_token('MIN',p_mn_elcn_val);
117: fnd_message.set_token('MAX',p_mx_elcn_val);
118: fnd_message.set_token('PERSON',l_person_name);
119: fnd_message.raise_error;
120: --
113: --
114: fnd_message.set_name('BEN','BEN_92984_CWB_VAL_NOT_IN_RANGE');
115: fnd_message.set_token('VAL',p_val);
116: fnd_message.set_token('MIN',p_mn_elcn_val);
117: fnd_message.set_token('MAX',p_mx_elcn_val);
118: fnd_message.set_token('PERSON',l_person_name);
119: fnd_message.raise_error;
120: --
121: end if;
114: fnd_message.set_name('BEN','BEN_92984_CWB_VAL_NOT_IN_RANGE');
115: fnd_message.set_token('VAL',p_val);
116: fnd_message.set_token('MIN',p_mn_elcn_val);
117: fnd_message.set_token('MAX',p_mx_elcn_val);
118: fnd_message.set_token('PERSON',l_person_name);
119: fnd_message.raise_error;
120: --
121: end if;
122: --
115: fnd_message.set_token('VAL',p_val);
116: fnd_message.set_token('MIN',p_mn_elcn_val);
117: fnd_message.set_token('MAX',p_mx_elcn_val);
118: fnd_message.set_token('PERSON',l_person_name);
119: fnd_message.raise_error;
120: --
121: end if;
122: --
123: end if;
127: then
128: --
129: if p_val < p_mn_elcn_val then
130: --
131: fnd_message.set_name('BEN','BEN_92984_CWB_VAL_NOT_IN_RANGE');
132: fnd_message.set_token('VAL',p_val);
133: fnd_message.set_token('MIN',p_mn_elcn_val);
134: fnd_message.set_token('MAX',p_mx_elcn_val);
135: fnd_message.set_token('PERSON',l_person_name);
128: --
129: if p_val < p_mn_elcn_val then
130: --
131: fnd_message.set_name('BEN','BEN_92984_CWB_VAL_NOT_IN_RANGE');
132: fnd_message.set_token('VAL',p_val);
133: fnd_message.set_token('MIN',p_mn_elcn_val);
134: fnd_message.set_token('MAX',p_mx_elcn_val);
135: fnd_message.set_token('PERSON',l_person_name);
136: fnd_message.raise_error;
129: if p_val < p_mn_elcn_val then
130: --
131: fnd_message.set_name('BEN','BEN_92984_CWB_VAL_NOT_IN_RANGE');
132: fnd_message.set_token('VAL',p_val);
133: fnd_message.set_token('MIN',p_mn_elcn_val);
134: fnd_message.set_token('MAX',p_mx_elcn_val);
135: fnd_message.set_token('PERSON',l_person_name);
136: fnd_message.raise_error;
137: --
130: --
131: fnd_message.set_name('BEN','BEN_92984_CWB_VAL_NOT_IN_RANGE');
132: fnd_message.set_token('VAL',p_val);
133: fnd_message.set_token('MIN',p_mn_elcn_val);
134: fnd_message.set_token('MAX',p_mx_elcn_val);
135: fnd_message.set_token('PERSON',l_person_name);
136: fnd_message.raise_error;
137: --
138: end if;
131: fnd_message.set_name('BEN','BEN_92984_CWB_VAL_NOT_IN_RANGE');
132: fnd_message.set_token('VAL',p_val);
133: fnd_message.set_token('MIN',p_mn_elcn_val);
134: fnd_message.set_token('MAX',p_mx_elcn_val);
135: fnd_message.set_token('PERSON',l_person_name);
136: fnd_message.raise_error;
137: --
138: end if;
139: --
132: fnd_message.set_token('VAL',p_val);
133: fnd_message.set_token('MIN',p_mn_elcn_val);
134: fnd_message.set_token('MAX',p_mx_elcn_val);
135: fnd_message.set_token('PERSON',l_person_name);
136: fnd_message.raise_error;
137: --
138: end if;
139: --
140: end if;
144: then
145: --
146: if p_iss_val > p_mx_elcn_val then
147: --
148: fnd_message.set_name('BEN','BEN_92984_CWB_VAL_NOT_IN_RANGE');
149: fnd_message.set_token('VAL',p_iss_val);
150: fnd_message.set_token('MIN',p_mn_elcn_val);
151: fnd_message.set_token('MAX',p_mx_elcn_val);
152: fnd_message.set_token('PERSON',l_person_name);
145: --
146: if p_iss_val > p_mx_elcn_val then
147: --
148: fnd_message.set_name('BEN','BEN_92984_CWB_VAL_NOT_IN_RANGE');
149: fnd_message.set_token('VAL',p_iss_val);
150: fnd_message.set_token('MIN',p_mn_elcn_val);
151: fnd_message.set_token('MAX',p_mx_elcn_val);
152: fnd_message.set_token('PERSON',l_person_name);
153: fnd_message.raise_error;
146: if p_iss_val > p_mx_elcn_val then
147: --
148: fnd_message.set_name('BEN','BEN_92984_CWB_VAL_NOT_IN_RANGE');
149: fnd_message.set_token('VAL',p_iss_val);
150: fnd_message.set_token('MIN',p_mn_elcn_val);
151: fnd_message.set_token('MAX',p_mx_elcn_val);
152: fnd_message.set_token('PERSON',l_person_name);
153: fnd_message.raise_error;
154: --
147: --
148: fnd_message.set_name('BEN','BEN_92984_CWB_VAL_NOT_IN_RANGE');
149: fnd_message.set_token('VAL',p_iss_val);
150: fnd_message.set_token('MIN',p_mn_elcn_val);
151: fnd_message.set_token('MAX',p_mx_elcn_val);
152: fnd_message.set_token('PERSON',l_person_name);
153: fnd_message.raise_error;
154: --
155: end if;
148: fnd_message.set_name('BEN','BEN_92984_CWB_VAL_NOT_IN_RANGE');
149: fnd_message.set_token('VAL',p_iss_val);
150: fnd_message.set_token('MIN',p_mn_elcn_val);
151: fnd_message.set_token('MAX',p_mx_elcn_val);
152: fnd_message.set_token('PERSON',l_person_name);
153: fnd_message.raise_error;
154: --
155: end if;
156: --
149: fnd_message.set_token('VAL',p_iss_val);
150: fnd_message.set_token('MIN',p_mn_elcn_val);
151: fnd_message.set_token('MAX',p_mx_elcn_val);
152: fnd_message.set_token('PERSON',l_person_name);
153: fnd_message.raise_error;
154: --
155: end if;
156: --
157: end if;
161: then
162: --
163: if p_iss_val < p_mn_elcn_val then
164: --
165: fnd_message.set_name('BEN','BEN_92984_CWB_VAL_NOT_IN_RANGE');
166: fnd_message.set_token('VAL',p_iss_val);
167: fnd_message.set_token('MIN',p_mn_elcn_val);
168: fnd_message.set_token('MAX',p_mx_elcn_val);
169: fnd_message.set_token('PERSON',l_person_name);
162: --
163: if p_iss_val < p_mn_elcn_val then
164: --
165: fnd_message.set_name('BEN','BEN_92984_CWB_VAL_NOT_IN_RANGE');
166: fnd_message.set_token('VAL',p_iss_val);
167: fnd_message.set_token('MIN',p_mn_elcn_val);
168: fnd_message.set_token('MAX',p_mx_elcn_val);
169: fnd_message.set_token('PERSON',l_person_name);
170: fnd_message.raise_error;
163: if p_iss_val < p_mn_elcn_val then
164: --
165: fnd_message.set_name('BEN','BEN_92984_CWB_VAL_NOT_IN_RANGE');
166: fnd_message.set_token('VAL',p_iss_val);
167: fnd_message.set_token('MIN',p_mn_elcn_val);
168: fnd_message.set_token('MAX',p_mx_elcn_val);
169: fnd_message.set_token('PERSON',l_person_name);
170: fnd_message.raise_error;
171: --
164: --
165: fnd_message.set_name('BEN','BEN_92984_CWB_VAL_NOT_IN_RANGE');
166: fnd_message.set_token('VAL',p_iss_val);
167: fnd_message.set_token('MIN',p_mn_elcn_val);
168: fnd_message.set_token('MAX',p_mx_elcn_val);
169: fnd_message.set_token('PERSON',l_person_name);
170: fnd_message.raise_error;
171: --
172: end if;
165: fnd_message.set_name('BEN','BEN_92984_CWB_VAL_NOT_IN_RANGE');
166: fnd_message.set_token('VAL',p_iss_val);
167: fnd_message.set_token('MIN',p_mn_elcn_val);
168: fnd_message.set_token('MAX',p_mx_elcn_val);
169: fnd_message.set_token('PERSON',l_person_name);
170: fnd_message.raise_error;
171: --
172: end if;
173: --
166: fnd_message.set_token('VAL',p_iss_val);
167: fnd_message.set_token('MIN',p_mn_elcn_val);
168: fnd_message.set_token('MAX',p_mx_elcn_val);
169: fnd_message.set_token('PERSON',l_person_name);
170: fnd_message.raise_error;
171: --
172: end if;
173: --
174: end if;
180: if (mod(p_iss_val,p_incrmt_elcn_val)<>0) then
181: --
182: -- raise error is not multiple of increment
183: --
184: fnd_message.set_name('BEN','BEN_92985_CWB_VAL_NOT_INCRMNT');
185: fnd_message.set_token('VAL',p_iss_val);
186: fnd_message.set_token('INCREMENT', p_incrmt_elcn_val);
187: fnd_message.set_token('PERSON',l_person_name);
188: fnd_message.raise_error;
181: --
182: -- raise error is not multiple of increment
183: --
184: fnd_message.set_name('BEN','BEN_92985_CWB_VAL_NOT_INCRMNT');
185: fnd_message.set_token('VAL',p_iss_val);
186: fnd_message.set_token('INCREMENT', p_incrmt_elcn_val);
187: fnd_message.set_token('PERSON',l_person_name);
188: fnd_message.raise_error;
189: --
182: -- raise error is not multiple of increment
183: --
184: fnd_message.set_name('BEN','BEN_92985_CWB_VAL_NOT_INCRMNT');
185: fnd_message.set_token('VAL',p_iss_val);
186: fnd_message.set_token('INCREMENT', p_incrmt_elcn_val);
187: fnd_message.set_token('PERSON',l_person_name);
188: fnd_message.raise_error;
189: --
190: end if;
183: --
184: fnd_message.set_name('BEN','BEN_92985_CWB_VAL_NOT_INCRMNT');
185: fnd_message.set_token('VAL',p_iss_val);
186: fnd_message.set_token('INCREMENT', p_incrmt_elcn_val);
187: fnd_message.set_token('PERSON',l_person_name);
188: fnd_message.raise_error;
189: --
190: end if;
191: --
184: fnd_message.set_name('BEN','BEN_92985_CWB_VAL_NOT_INCRMNT');
185: fnd_message.set_token('VAL',p_iss_val);
186: fnd_message.set_token('INCREMENT', p_incrmt_elcn_val);
187: fnd_message.set_token('PERSON',l_person_name);
188: fnd_message.raise_error;
189: --
190: end if;
191: --
192: end if;
198: if (mod(p_val,p_incrmt_elcn_val)<>0) then
199: --
200: -- raise error is not multiple of increment
201: --
202: fnd_message.set_name('BEN','BEN_92985_CWB_VAL_NOT_INCRMNT');
203: fnd_message.set_token('VAL',p_val);
204: fnd_message.set_token('INCREMENT', p_incrmt_elcn_val);
205: fnd_message.set_token('PERSON',l_person_name);
206: fnd_message.raise_error;
199: --
200: -- raise error is not multiple of increment
201: --
202: fnd_message.set_name('BEN','BEN_92985_CWB_VAL_NOT_INCRMNT');
203: fnd_message.set_token('VAL',p_val);
204: fnd_message.set_token('INCREMENT', p_incrmt_elcn_val);
205: fnd_message.set_token('PERSON',l_person_name);
206: fnd_message.raise_error;
207: --
200: -- raise error is not multiple of increment
201: --
202: fnd_message.set_name('BEN','BEN_92985_CWB_VAL_NOT_INCRMNT');
203: fnd_message.set_token('VAL',p_val);
204: fnd_message.set_token('INCREMENT', p_incrmt_elcn_val);
205: fnd_message.set_token('PERSON',l_person_name);
206: fnd_message.raise_error;
207: --
208: end if;
201: --
202: fnd_message.set_name('BEN','BEN_92985_CWB_VAL_NOT_INCRMNT');
203: fnd_message.set_token('VAL',p_val);
204: fnd_message.set_token('INCREMENT', p_incrmt_elcn_val);
205: fnd_message.set_token('PERSON',l_person_name);
206: fnd_message.raise_error;
207: --
208: end if;
209: --
202: fnd_message.set_name('BEN','BEN_92985_CWB_VAL_NOT_INCRMNT');
203: fnd_message.set_token('VAL',p_val);
204: fnd_message.set_token('INCREMENT', p_incrmt_elcn_val);
205: fnd_message.set_token('PERSON',l_person_name);
206: fnd_message.raise_error;
207: --
208: end if;
209: --
210: end if;