DBA Data[Home] [Help]

APPS.GMO_OPER_CERT_PUB dependencies on FND_MESSAGE

Line 170: fnd_message.set_name ('INV', 'INV_INT_USRCODE');

166: EXCEPTION
167: WHEN invalid_user THEN
168:
169: -- message that user is not defined in hrms
170: fnd_message.set_name ('INV', 'INV_INT_USRCODE');
171: fnd_msg_pub.ADD;
172: x_return_status := fnd_api.g_ret_sts_error ;
173: RETURN 0;
174:

Line 192: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

188: RETURN -1;
189: END IF;
190:
191: WHEN OTHERS THEN
192: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
193: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
194: x_return_status := fnd_api.g_ret_sts_unexp_error;
195: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
196: RETURN 0;

Line 193: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

189: END IF;
190:
191: WHEN OTHERS THEN
192: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
193: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
194: x_return_status := fnd_api.g_ret_sts_unexp_error;
195: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
196: RETURN 0;
197: END check_certification;

Line 332: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

328:
329: x_return_status := fnd_api.g_ret_sts_error;
330:
331: WHEN OTHERS THEN
332: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
333: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
334: x_return_status := fnd_api.g_ret_sts_unexp_error;
335:
336: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 333: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

329: x_return_status := fnd_api.g_ret_sts_error;
330:
331: WHEN OTHERS THEN
332: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
333: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
334: x_return_status := fnd_api.g_ret_sts_unexp_error;
335:
336: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
337:

Line 377: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

373: WHEN FND_API.g_exc_error THEN
374:
375: x_return_status := fnd_api.g_ret_sts_error;
376: WHEN OTHERS THEN
377: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
378: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
379: x_return_status := fnd_api.g_ret_sts_unexp_error;
380:
381:

Line 378: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

374:
375: x_return_status := fnd_api.g_ret_sts_error;
376: WHEN OTHERS THEN
377: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
378: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
379: x_return_status := fnd_api.g_ret_sts_unexp_error;
380:
381:
382: END Update_erecord;

Line 430: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

426: EXCEPTION
427: WHEN FND_API.g_exc_error THEN
428: x_return_status := fnd_api.g_ret_sts_error;
429: WHEN OTHERS THEN
430: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
431: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
432: x_return_status := fnd_api.g_ret_sts_unexp_error;
433: END update_cert_record;
434:

Line 431: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

427: WHEN FND_API.g_exc_error THEN
428: x_return_status := fnd_api.g_ret_sts_error;
429: WHEN OTHERS THEN
430: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
431: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
432: x_return_status := fnd_api.g_ret_sts_unexp_error;
433: END update_cert_record;
434:
435:

Line 567: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

563: EXCEPTION
564: WHEN FND_API.g_exc_error THEN
565: x_return_status := fnd_api.g_ret_sts_error;
566: WHEN OTHERS THEN
567: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
568: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
569: x_return_status := fnd_api.g_ret_sts_unexp_error;
570:
571: END cert_details;

Line 568: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

564: WHEN FND_API.g_exc_error THEN
565: x_return_status := fnd_api.g_ret_sts_error;
566: WHEN OTHERS THEN
567: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
568: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
569: x_return_status := fnd_api.g_ret_sts_unexp_error;
570:
571: END cert_details;
572: