182: OPEN CUR_VALIDATE_INT;
183: FETCH CUR_VALIDATE_INT INTO X_INTEGRATION_ID;
184: if (CUR_VALIDATE_INT%notfound) then
185: close CUR_VALIDATE_INT;
186: fnd_message.set_name('PER','PER_449955_OPT_INT_ID_ABSENT');
187: fnd_message.raise_error;
188: end if;
189: close CUR_VALIDATE_INT;
190:
183: FETCH CUR_VALIDATE_INT INTO X_INTEGRATION_ID;
184: if (CUR_VALIDATE_INT%notfound) then
185: close CUR_VALIDATE_INT;
186: fnd_message.set_name('PER','PER_449955_OPT_INT_ID_ABSENT');
187: fnd_message.raise_error;
188: end if;
189: close CUR_VALIDATE_INT;
190:
191: OPEN CUR_VALIDATE_OTY;
191: OPEN CUR_VALIDATE_OTY;
192: FETCH CUR_VALIDATE_OTY INTO X_OPTION_TYPE_ID;
193: if (CUR_VALIDATE_OTY%notfound) then
194: close CUR_VALIDATE_OTY;
195: fnd_message.set_name('PER','PER_449953_OPT_OP_TY_ID_ABSENT');
196: fnd_message.raise_error;
197: end if;
198: close CUR_VALIDATE_OTY;
199:
192: FETCH CUR_VALIDATE_OTY INTO X_OPTION_TYPE_ID;
193: if (CUR_VALIDATE_OTY%notfound) then
194: close CUR_VALIDATE_OTY;
195: fnd_message.set_name('PER','PER_449953_OPT_OP_TY_ID_ABSENT');
196: fnd_message.raise_error;
197: end if;
198: close CUR_VALIDATE_OTY;
199:
200: if X_OPTION_LEVEL=100 then
205: OPEN CUR_VALIDATE_LEVEL_APP;
206: FETCH CUR_VALIDATE_LEVEL_APP INTO X_OPTION_LEVEL_ID;
207: if (CUR_VALIDATE_LEVEL_APP%notfound) then
208: close CUR_VALIDATE_LEVEL_APP;
209: fnd_message.set_name('PER','PER_449958_OPT_OP_APP_ID_ERR');
210: fnd_message.raise_error;
211: end if;
212: close CUR_VALIDATE_LEVEL_APP;
213:
206: FETCH CUR_VALIDATE_LEVEL_APP INTO X_OPTION_LEVEL_ID;
207: if (CUR_VALIDATE_LEVEL_APP%notfound) then
208: close CUR_VALIDATE_LEVEL_APP;
209: fnd_message.set_name('PER','PER_449958_OPT_OP_APP_ID_ERR');
210: fnd_message.raise_error;
211: end if;
212: close CUR_VALIDATE_LEVEL_APP;
213:
214: elsif X_OPTION_LEVEL=60 then
215: OPEN CUR_VALIDATE_LEVEL_RESP;
216: FETCH CUR_VALIDATE_LEVEL_RESP INTO X_OPTION_LEVEL_ID;
217: if (CUR_VALIDATE_LEVEL_RESP%notfound) then
218: close CUR_VALIDATE_LEVEL_RESP;
219: fnd_message.set_name('PER','PER_449959_OPT_OP_RESP_ID_ERR');
220: fnd_message.raise_error;
221: end if;
222: close CUR_VALIDATE_LEVEL_RESP;
223:
216: FETCH CUR_VALIDATE_LEVEL_RESP INTO X_OPTION_LEVEL_ID;
217: if (CUR_VALIDATE_LEVEL_RESP%notfound) then
218: close CUR_VALIDATE_LEVEL_RESP;
219: fnd_message.set_name('PER','PER_449959_OPT_OP_RESP_ID_ERR');
220: fnd_message.raise_error;
221: end if;
222: close CUR_VALIDATE_LEVEL_RESP;
223:
224: elsif X_OPTION_LEVEL=20 then
225: OPEN CUR_VALIDATE_LEVEL_USR;
226: FETCH CUR_VALIDATE_LEVEL_USR INTO X_OPTION_LEVEL_ID;
227: if (CUR_VALIDATE_LEVEL_USR%notfound) then
228: close CUR_VALIDATE_LEVEL_USR;
229: fnd_message.set_name('PER','PER_449960_OPT_OP_US_ID_ERR');
230: fnd_message.raise_error;
231: end if;
232: close CUR_VALIDATE_LEVEL_USR;
233:
226: FETCH CUR_VALIDATE_LEVEL_USR INTO X_OPTION_LEVEL_ID;
227: if (CUR_VALIDATE_LEVEL_USR%notfound) then
228: close CUR_VALIDATE_LEVEL_USR;
229: fnd_message.set_name('PER','PER_449960_OPT_OP_US_ID_ERR');
230: fnd_message.raise_error;
231: end if;
232: close CUR_VALIDATE_LEVEL_USR;
233:
234: end if;