27: INVALID_DATATYPE Exception;
28:
29: Begin
30:
31: if( FND_LOG.LEVEL_STATEMENT>= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
32: logMessage := '[' || leftHandSide || operator || rightHandSide || valueDataType || ']';
33: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_OPERATORS_PVT.SATISFIED.KEY_VALS', logMessage);
34: end if;
35:
29: Begin
30:
31: if( FND_LOG.LEVEL_STATEMENT>= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
32: logMessage := '[' || leftHandSide || operator || rightHandSide || valueDataType || ']';
33: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_OPERATORS_PVT.SATISFIED.KEY_VALS', logMessage);
34: end if;
35:
36:
37: if valueDataType = 'S' then
182: return conditionSatisfied;
183:
184: EXCEPTION
185: When INVALID_DATATYPE then
186: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
187: errorMessage := '[' || leftHandSide || operator || rightHandSide || valueDataType || ']' || ' Invalid Datatype';
188: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_OPERATORS_PVT.SATISFIED.INVALID_DATATYPE', errorMessage);
189: end if;
190:
184: EXCEPTION
185: When INVALID_DATATYPE then
186: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
187: errorMessage := '[' || leftHandSide || operator || rightHandSide || valueDataType || ']' || ' Invalid Datatype';
188: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_OPERATORS_PVT.SATISFIED.INVALID_DATATYPE', errorMessage);
189: end if;
190:
191: conditionSatisfied := false;
192: return conditionSatisfied;
190:
191: conditionSatisfied := false;
192: return conditionSatisfied;
193: When VALUE_ERROR then
194: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
195: errorMessage := '[' || leftHandSide || operator || rightHandSide || valueDataType || ']' || ' Invalid Number Format';
196: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_OPERATORS_PVT.SATISFIED.VALUE_ERROR', errorMessage);
197: end if;
198:
192: return conditionSatisfied;
193: When VALUE_ERROR then
194: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
195: errorMessage := '[' || leftHandSide || operator || rightHandSide || valueDataType || ']' || ' Invalid Number Format';
196: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_OPERATORS_PVT.SATISFIED.VALUE_ERROR', errorMessage);
197: end if;
198:
199: conditionSatisfied := false;
200: return conditionSatisfied;
198:
199: conditionSatisfied := false;
200: return conditionSatisfied;
201: When others then
202: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
203: errorMessage := '[' || leftHandSide || operator || rightHandSide || valueDataType || '] ' || sqlerrm;
204: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_OPERATORS_PVT.SATISFIED.WHEN_OTHERS', errorMessage);
205: end if;
206:
200: return conditionSatisfied;
201: When others then
202: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
203: errorMessage := '[' || leftHandSide || operator || rightHandSide || valueDataType || '] ' || sqlerrm;
204: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_OPERATORS_PVT.SATISFIED.WHEN_OTHERS', errorMessage);
205: end if;
206:
207: conditionSatisfied := false;
208: return conditionSatisfied;