117: BEGIN
118:
119: IF UPPER(p_optimize_level) NOT IN ('FAST','FULL')
120: THEN
121: fnd_message.set_name('JTF', 'JTF_NOTES_BAD_PARAMETER_VALUE');
122: fnd_message.set_token('VALUE', NVL(p_optimize_level,'NULL'));
123: fnd_message.set_token('PARAMETER', 'p_optimize_level');
124: RAISE_APPLICATION_ERROR(-20000,fnd_message.get);
125: END IF;
118:
119: IF UPPER(p_optimize_level) NOT IN ('FAST','FULL')
120: THEN
121: fnd_message.set_name('JTF', 'JTF_NOTES_BAD_PARAMETER_VALUE');
122: fnd_message.set_token('VALUE', NVL(p_optimize_level,'NULL'));
123: fnd_message.set_token('PARAMETER', 'p_optimize_level');
124: RAISE_APPLICATION_ERROR(-20000,fnd_message.get);
125: END IF;
126:
119: IF UPPER(p_optimize_level) NOT IN ('FAST','FULL')
120: THEN
121: fnd_message.set_name('JTF', 'JTF_NOTES_BAD_PARAMETER_VALUE');
122: fnd_message.set_token('VALUE', NVL(p_optimize_level,'NULL'));
123: fnd_message.set_token('PARAMETER', 'p_optimize_level');
124: RAISE_APPLICATION_ERROR(-20000,fnd_message.get);
125: END IF;
126:
127: IF (p_runtime IS NOT NULL)
120: THEN
121: fnd_message.set_name('JTF', 'JTF_NOTES_BAD_PARAMETER_VALUE');
122: fnd_message.set_token('VALUE', NVL(p_optimize_level,'NULL'));
123: fnd_message.set_token('PARAMETER', 'p_optimize_level');
124: RAISE_APPLICATION_ERROR(-20000,fnd_message.get);
125: END IF;
126:
127: IF (p_runtime IS NOT NULL)
128: THEN
130: or (p_runtime < 0)
131: or (p_runtime > ctx_ddl.maxtime_unlimited)
132: )
133: THEN
134: fnd_message.set_name('JTF', 'JTF_NOTES_BAD_PARAMETER_VALUE');
135: fnd_message.set_token('VALUE', NVL(p_runtime,'NULL'));
136: fnd_message.set_token('PARAMETER', 'p_runtime');
137: RAISE_APPLICATION_ERROR(-20000,fnd_message.get);
138: END IF;
131: or (p_runtime > ctx_ddl.maxtime_unlimited)
132: )
133: THEN
134: fnd_message.set_name('JTF', 'JTF_NOTES_BAD_PARAMETER_VALUE');
135: fnd_message.set_token('VALUE', NVL(p_runtime,'NULL'));
136: fnd_message.set_token('PARAMETER', 'p_runtime');
137: RAISE_APPLICATION_ERROR(-20000,fnd_message.get);
138: END IF;
139: END IF;
132: )
133: THEN
134: fnd_message.set_name('JTF', 'JTF_NOTES_BAD_PARAMETER_VALUE');
135: fnd_message.set_token('VALUE', NVL(p_runtime,'NULL'));
136: fnd_message.set_token('PARAMETER', 'p_runtime');
137: RAISE_APPLICATION_ERROR(-20000,fnd_message.get);
138: END IF;
139: END IF;
140:
133: THEN
134: fnd_message.set_name('JTF', 'JTF_NOTES_BAD_PARAMETER_VALUE');
135: fnd_message.set_token('VALUE', NVL(p_runtime,'NULL'));
136: fnd_message.set_token('PARAMETER', 'p_runtime');
137: RAISE_APPLICATION_ERROR(-20000,fnd_message.get);
138: END IF;
139: END IF;
140:
141: --