142: RULEDESCRIPTIONSOUT=> l_rulenames
143: );
144: EXCEPTION
145: WHEN OTHERS THEN
146: FND_MESSAGE.SET_NAME('EDR','EDR_AME_SETUP_ERR');
147: FND_MESSAGE.SET_TOKEN('TXN_TYPE',nvl(l_ame_transaction_type,evt.getEventName()));
148: FND_MESSAGE.SET_TOKEN('ERR_MSG',sqlerrm);
149: APP_EXCEPTION.RAISE_EXCEPTION;
150: END;
143: );
144: EXCEPTION
145: WHEN OTHERS THEN
146: FND_MESSAGE.SET_NAME('EDR','EDR_AME_SETUP_ERR');
147: FND_MESSAGE.SET_TOKEN('TXN_TYPE',nvl(l_ame_transaction_type,evt.getEventName()));
148: FND_MESSAGE.SET_TOKEN('ERR_MSG',sqlerrm);
149: APP_EXCEPTION.RAISE_EXCEPTION;
150: END;
151: --Bug 5287504: End
144: EXCEPTION
145: WHEN OTHERS THEN
146: FND_MESSAGE.SET_NAME('EDR','EDR_AME_SETUP_ERR');
147: FND_MESSAGE.SET_TOKEN('TXN_TYPE',nvl(l_ame_transaction_type,evt.getEventName()));
148: FND_MESSAGE.SET_TOKEN('ERR_MSG',sqlerrm);
149: APP_EXCEPTION.RAISE_EXCEPTION;
150: END;
151: --Bug 5287504: End
152:
212: x_isRequired_checklist:='N';
213: x_checklist_name:=NULL;
214: x_checklist_ver:=NULL;
215: ROLLBACK TO CHECKLIST_REQUIRED;
216: FND_MESSAGE.SET_NAME('EDR','EDR_MULTI_ERES_SUBSCRP_ERR');
217: fnd_message.set_token( 'EVENT', p_event_name);
218: --Bug 4162993: Start
219: APP_EXCEPTION.RAISE_EXCEPTION;
220: --Bug 4162993: End
213: x_checklist_name:=NULL;
214: x_checklist_ver:=NULL;
215: ROLLBACK TO CHECKLIST_REQUIRED;
216: FND_MESSAGE.SET_NAME('EDR','EDR_MULTI_ERES_SUBSCRP_ERR');
217: fnd_message.set_token( 'EVENT', p_event_name);
218: --Bug 4162993: Start
219: APP_EXCEPTION.RAISE_EXCEPTION;
220: --Bug 4162993: End
221: WHEN OTHERS THEN
222: x_isRequired_checklist:='N';
223: x_checklist_name:=NULL;
224: x_checklist_ver:=NULL;
225: ROLLBACK TO CHECKLIST_REQUIRED;
226: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
227: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
228: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_ISIGN_CHECKLIST_PVT');
229: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','IS_CHECKLIST_REQUIRED ');
230: --Bug 4162993: Start
223: x_checklist_name:=NULL;
224: x_checklist_ver:=NULL;
225: ROLLBACK TO CHECKLIST_REQUIRED;
226: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
227: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
228: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_ISIGN_CHECKLIST_PVT');
229: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','IS_CHECKLIST_REQUIRED ');
230: --Bug 4162993: Start
231: APP_EXCEPTION.RAISE_EXCEPTION;
224: x_checklist_ver:=NULL;
225: ROLLBACK TO CHECKLIST_REQUIRED;
226: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
227: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
228: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_ISIGN_CHECKLIST_PVT');
229: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','IS_CHECKLIST_REQUIRED ');
230: --Bug 4162993: Start
231: APP_EXCEPTION.RAISE_EXCEPTION;
232: --Bug 4162993: End
225: ROLLBACK TO CHECKLIST_REQUIRED;
226: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
227: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
228: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_ISIGN_CHECKLIST_PVT');
229: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','IS_CHECKLIST_REQUIRED ');
230: --Bug 4162993: Start
231: APP_EXCEPTION.RAISE_EXCEPTION;
232: --Bug 4162993: End
233: END IS_CHECKLIST_REQUIRED;