389: EXCEPTION
390: WHEN UNEXPECTED_ERROR THEN
391: ROLLBACK;
392: --Diagnostics Start
393: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
394: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',NVL(L_ERROR_MSG,SQLERRM));
395: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_EINITIALS_PVT');
396: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','POST_SIGNATURE_DETAILS');
397: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
390: WHEN UNEXPECTED_ERROR THEN
391: ROLLBACK;
392: --Diagnostics Start
393: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
394: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',NVL(L_ERROR_MSG,SQLERRM));
395: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_EINITIALS_PVT');
396: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','POST_SIGNATURE_DETAILS');
397: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
398: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
391: ROLLBACK;
392: --Diagnostics Start
393: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
394: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',NVL(L_ERROR_MSG,SQLERRM));
395: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_EINITIALS_PVT');
396: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','POST_SIGNATURE_DETAILS');
397: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
398: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
399: 'edr.plsql.EDR_EINITIALS_PVT.POST_SIGNATURE_DETAILS',
392: --Diagnostics Start
393: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
394: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',NVL(L_ERROR_MSG,SQLERRM));
395: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_EINITIALS_PVT');
396: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','POST_SIGNATURE_DETAILS');
397: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
398: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
399: 'edr.plsql.EDR_EINITIALS_PVT.POST_SIGNATURE_DETAILS',
400: FALSE
405:
406: WHEN OTHERS THEN
407: ROLLBACK;
408: --Diagnostics Start
409: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
410: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
411: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_EINITIALS_PVT');
412: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','POST_SIGNATURE_DETAILS');
413: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
406: WHEN OTHERS THEN
407: ROLLBACK;
408: --Diagnostics Start
409: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
410: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
411: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_EINITIALS_PVT');
412: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','POST_SIGNATURE_DETAILS');
413: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
414: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
407: ROLLBACK;
408: --Diagnostics Start
409: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
410: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
411: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_EINITIALS_PVT');
412: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','POST_SIGNATURE_DETAILS');
413: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
414: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
415: 'edr.plsql.EDR_EINITIALS_PVT.POST_SIGNATURE_DETAILS',
408: --Diagnostics Start
409: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
410: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
411: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_EINITIALS_PVT');
412: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','POST_SIGNATURE_DETAILS');
413: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
414: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
415: 'edr.plsql.EDR_EINITIALS_PVT.POST_SIGNATURE_DETAILS',
416: FALSE
482: EXCEPTION
483: WHEN OTHERS THEN
484: ROLLBACK;
485: --Diagnostics Start
486: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
487: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
488: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_EINITIALS_PVT');
489: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','COMPLETE_SIGNATURE');
490: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
483: WHEN OTHERS THEN
484: ROLLBACK;
485: --Diagnostics Start
486: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
487: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
488: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_EINITIALS_PVT');
489: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','COMPLETE_SIGNATURE');
490: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
491: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
484: ROLLBACK;
485: --Diagnostics Start
486: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
487: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
488: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_EINITIALS_PVT');
489: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','COMPLETE_SIGNATURE');
490: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
491: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
492: 'edr.plsql.EDR_EINITIALS_PVT.COMPLETE_SIGNATURE',
485: --Diagnostics Start
486: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
487: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
488: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_EINITIALS_PVT');
489: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','COMPLETE_SIGNATURE');
490: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
491: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
492: 'edr.plsql.EDR_EINITIALS_PVT.COMPLETE_SIGNATURE',
493: FALSE
549: EXCEPTION
550: WHEN OTHERS THEN
551: ROLLBACK;
552: --Diagnostics Start
553: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
554: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
555: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_EINITIALS_PVT');
556: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','CANCEL_SIGNATURE');
557: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
550: WHEN OTHERS THEN
551: ROLLBACK;
552: --Diagnostics Start
553: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
554: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
555: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_EINITIALS_PVT');
556: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','CANCEL_SIGNATURE');
557: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
558: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
551: ROLLBACK;
552: --Diagnostics Start
553: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
554: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
555: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_EINITIALS_PVT');
556: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','CANCEL_SIGNATURE');
557: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
558: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
559: 'edr.plsql.EDR_EINITIALS_PVT.CANCEL_SIGNATURE',
552: --Diagnostics Start
553: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
554: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
555: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_EINITIALS_PVT');
556: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','CANCEL_SIGNATURE');
557: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
558: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
559: 'edr.plsql.EDR_EINITIALS_PVT.CANCEL_SIGNATURE',
560: FALSE