23:
24: EXCEPTION
25: WHEN OTHERS THEN
26: ROLLBACK;
27: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
28: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
29: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_XDOC_UTIL_PKG');
30: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','DELETE_TEMP_PARAMS');
31: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
24: EXCEPTION
25: WHEN OTHERS THEN
26: ROLLBACK;
27: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
28: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
29: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_XDOC_UTIL_PKG');
30: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','DELETE_TEMP_PARAMS');
31: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
32: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
25: WHEN OTHERS THEN
26: ROLLBACK;
27: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
28: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
29: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_XDOC_UTIL_PKG');
30: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','DELETE_TEMP_PARAMS');
31: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
32: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
33: 'edr.plsql.EDR_XDOC_UTIL_PKG.DELETE_TEMP_PARAMS',
26: ROLLBACK;
27: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
28: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
29: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_XDOC_UTIL_PKG');
30: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','DELETE_TEMP_PARAMS');
31: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
32: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
33: 'edr.plsql.EDR_XDOC_UTIL_PKG.DELETE_TEMP_PARAMS',
34: FALSE
229:
230: EXCEPTION
231: WHEN OTHERS THEN
232: ROLLBACK;
233: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
234: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
235: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_XDOC_UTIL_PKG');
236: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','SET_TEMP_PARAMS');
237: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
230: EXCEPTION
231: WHEN OTHERS THEN
232: ROLLBACK;
233: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
234: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
235: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_XDOC_UTIL_PKG');
236: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','SET_TEMP_PARAMS');
237: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
238: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
231: WHEN OTHERS THEN
232: ROLLBACK;
233: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
234: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
235: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_XDOC_UTIL_PKG');
236: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','SET_TEMP_PARAMS');
237: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
238: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
239: 'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',
232: ROLLBACK;
233: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
234: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
235: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_XDOC_UTIL_PKG');
236: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','SET_TEMP_PARAMS');
237: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
238: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
239: 'edr.plsql.EDR_XDOC_UTIL_PKG.SET_TEMP_PARAMS',
240: FALSE
436: X_ERROR_CODE := 505;
437: END;
438: WHEN PROFILE_ERROR THEN
439: BEGIN
440: fnd_message.set_name('EDR','EDR_PROFILE_CHECK_FAILURE');
441: fnd_message.set_token('PROFILENAME','FND_DB_WALLET_DIR');
442: X_ERROR_MSG := FND_MESSAGE.GET;
443: X_ERROR_CODE := 100;
444: END;
437: END;
438: WHEN PROFILE_ERROR THEN
439: BEGIN
440: fnd_message.set_name('EDR','EDR_PROFILE_CHECK_FAILURE');
441: fnd_message.set_token('PROFILENAME','FND_DB_WALLET_DIR');
442: X_ERROR_MSG := FND_MESSAGE.GET;
443: X_ERROR_CODE := 100;
444: END;
445: WHEN REQUEST_FAIL THEN
438: WHEN PROFILE_ERROR THEN
439: BEGIN
440: fnd_message.set_name('EDR','EDR_PROFILE_CHECK_FAILURE');
441: fnd_message.set_token('PROFILENAME','FND_DB_WALLET_DIR');
442: X_ERROR_MSG := FND_MESSAGE.GET;
443: X_ERROR_CODE := 100;
444: END;
445: WHEN REQUEST_FAIL THEN
446: BEGIN
613: x_document_type in out nocopy varchar2
614: )
615: Is
616: Begin
617: fnd_message.set_name('EDR','EDR_EREC_ATT_NTF_BODY');
618: fnd_message.set_token('ERECORD_ID',p_document_id);
619: x_document := fnd_message.get;
620: x_document_type := 'text/plain';
621: End GET_NTF_MESSAGE_BODY;
614: )
615: Is
616: Begin
617: fnd_message.set_name('EDR','EDR_EREC_ATT_NTF_BODY');
618: fnd_message.set_token('ERECORD_ID',p_document_id);
619: x_document := fnd_message.get;
620: x_document_type := 'text/plain';
621: End GET_NTF_MESSAGE_BODY;
622:
615: Is
616: Begin
617: fnd_message.set_name('EDR','EDR_EREC_ATT_NTF_BODY');
618: fnd_message.set_token('ERECORD_ID',p_document_id);
619: x_document := fnd_message.get;
620: x_document_type := 'text/plain';
621: End GET_NTF_MESSAGE_BODY;
622:
623: -- Bug 3950047 : Start