DBA Data[Home] [Help]

APPS.GMO_SWORKBENCH_PVT dependencies on FND_MESSAGE

Line 321: FND_MESSAGE.SET_NAME('GMO','GMO_UNEXPECTED_DB_ERR');

317: x_return_status := GMO_CONSTANTS_GRP.RETURN_STATUS_SUCCESS;
318: EXCEPTION
319: WHEN OTHERS THEN
320: X_RETURN_STATUS := GMO_CONSTANTS_GRP.RETURN_STATUS_UNEXP_ERROR;
321: FND_MESSAGE.SET_NAME('GMO','GMO_UNEXPECTED_DB_ERR');
322: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
323: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
324: X_MSG_DATA := fnd_message.get;
325: end; ---procedure;

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

318: EXCEPTION
319: WHEN OTHERS THEN
320: X_RETURN_STATUS := GMO_CONSTANTS_GRP.RETURN_STATUS_UNEXP_ERROR;
321: FND_MESSAGE.SET_NAME('GMO','GMO_UNEXPECTED_DB_ERR');
322: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
323: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
324: X_MSG_DATA := fnd_message.get;
325: end; ---procedure;
326:

Line 323: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);

319: WHEN OTHERS THEN
320: X_RETURN_STATUS := GMO_CONSTANTS_GRP.RETURN_STATUS_UNEXP_ERROR;
321: FND_MESSAGE.SET_NAME('GMO','GMO_UNEXPECTED_DB_ERR');
322: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
323: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
324: X_MSG_DATA := fnd_message.get;
325: end; ---procedure;
326:
327:

Line 324: X_MSG_DATA := fnd_message.get;

320: X_RETURN_STATUS := GMO_CONSTANTS_GRP.RETURN_STATUS_UNEXP_ERROR;
321: FND_MESSAGE.SET_NAME('GMO','GMO_UNEXPECTED_DB_ERR');
322: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
323: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
324: X_MSG_DATA := fnd_message.get;
325: end; ---procedure;
326:
327:
328:

Line 606: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

602: x_return_status := fnd_api.g_ret_sts_error;
603: WHEN OTHERS THEN
604: --ns_debug_call('create Mtl Reservation : ERROR_TEXT :'||SQLERRM);
605: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
606: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
607: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
608: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
609: END create_material_reservation;
610: PROCEDURE create_material_reservation (

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

603: WHEN OTHERS THEN
604: --ns_debug_call('create Mtl Reservation : ERROR_TEXT :'||SQLERRM);
605: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
606: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
607: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
608: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
609: END create_material_reservation;
610: PROCEDURE create_material_reservation (
611: p_matl_dtl_rec IN gme_material_details%ROWTYPE

Line 608: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);

604: --ns_debug_call('create Mtl Reservation : ERROR_TEXT :'||SQLERRM);
605: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
606: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
607: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
608: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
609: END create_material_reservation;
610: PROCEDURE create_material_reservation (
611: p_matl_dtl_rec IN gme_material_details%ROWTYPE
612: ,p_resv_qty IN NUMBER DEFAULT NULL