[Home] [Help]
112: x_return_status := FND_API.g_ret_sts_success;
113:
114: --Get a unique value for the execution detail id
115: BEGIN
116: SELECT DPP_EXECUTION_DETAIL_ID_SEQ.nextval
117: INTO l_exe_dtl_id
118: FROM dual;
119:
120: EXCEPTION
134: fnd_message.set_token('ERRNO', sqlcode);
135: fnd_message.set_token('REASON', sqlerrm);
136: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
137: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID');
138: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ');
139: FND_MSG_PUB.add;
140: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
141: END IF;
142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
819: fnd_message.set_token('ERRNO', sqlcode);
820: fnd_message.set_token('REASON', sqlerrm);
821: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
822: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID'); --To be modified
823: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ'); --To be modified
824: FND_MSG_PUB.add;
825: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
826: END IF;
827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;