DBA Data[Home] [Help]

APPS.GMO_OPER_CERT_PUB dependencies on FND_MESSAGE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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