DBA Data[Home] [Help]

APPS.HR_KI_OPT_LOAD_API dependencies on FND_MESSAGE

Line 186: fnd_message.set_name('PER','PER_449955_OPT_INT_ID_ABSENT');

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:

Line 187: fnd_message.raise_error;

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;

Line 195: fnd_message.set_name('PER','PER_449953_OPT_OP_TY_ID_ABSENT');

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:

Line 196: fnd_message.raise_error;

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

Line 209: fnd_message.set_name('PER','PER_449958_OPT_OP_APP_ID_ERR');

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:

Line 210: fnd_message.raise_error;

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

Line 219: fnd_message.set_name('PER','PER_449959_OPT_OP_RESP_ID_ERR');

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:

Line 220: fnd_message.raise_error;

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

Line 229: fnd_message.set_name('PER','PER_449960_OPT_OP_US_ID_ERR');

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:

Line 230: fnd_message.raise_error;

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;