DBA Data[Home] [Help]

APPS.GMO_SWORKBENCH_PVT dependencies on FND_MESSAGE

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

203: x_return_status := GMO_CONSTANTS_GRP.RETURN_STATUS_SUCCESS;
204: EXCEPTION
205: WHEN OTHERS THEN
206: X_RETURN_STATUS := GMO_CONSTANTS_GRP.RETURN_STATUS_UNEXP_ERROR;
207: FND_MESSAGE.SET_NAME('GMO','GMO_UNEXPECTED_DB_ERR');
208: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
209: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
210: X_MSG_DATA := fnd_message.get;
211: end; ---procedure;

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

204: EXCEPTION
205: WHEN OTHERS THEN
206: X_RETURN_STATUS := GMO_CONSTANTS_GRP.RETURN_STATUS_UNEXP_ERROR;
207: FND_MESSAGE.SET_NAME('GMO','GMO_UNEXPECTED_DB_ERR');
208: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
209: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
210: X_MSG_DATA := fnd_message.get;
211: end; ---procedure;
212:

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

205: WHEN OTHERS THEN
206: X_RETURN_STATUS := GMO_CONSTANTS_GRP.RETURN_STATUS_UNEXP_ERROR;
207: FND_MESSAGE.SET_NAME('GMO','GMO_UNEXPECTED_DB_ERR');
208: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
209: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
210: X_MSG_DATA := fnd_message.get;
211: end; ---procedure;
212:
213:

Line 210: X_MSG_DATA := fnd_message.get;

206: X_RETURN_STATUS := GMO_CONSTANTS_GRP.RETURN_STATUS_UNEXP_ERROR;
207: FND_MESSAGE.SET_NAME('GMO','GMO_UNEXPECTED_DB_ERR');
208: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
209: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
210: X_MSG_DATA := fnd_message.get;
211: end; ---procedure;
212:
213:
214:

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

488: x_return_status := fnd_api.g_ret_sts_error;
489: WHEN OTHERS THEN
490: --ns_debug_call('create Mtl Reservation : ERROR_TEXT :'||SQLERRM);
491: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
492: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
493: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
494: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
495: END create_material_reservation;
496: PROCEDURE create_material_reservation (

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

489: WHEN OTHERS THEN
490: --ns_debug_call('create Mtl Reservation : ERROR_TEXT :'||SQLERRM);
491: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
492: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
493: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
494: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
495: END create_material_reservation;
496: PROCEDURE create_material_reservation (
497: p_matl_dtl_rec IN gme_material_details%ROWTYPE

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

490: --ns_debug_call('create Mtl Reservation : ERROR_TEXT :'||SQLERRM);
491: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
492: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
493: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
494: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
495: END create_material_reservation;
496: PROCEDURE create_material_reservation (
497: p_matl_dtl_rec IN gme_material_details%ROWTYPE
498: ,p_resv_qty IN NUMBER DEFAULT NULL