190: RULEDESCRIPTIONSOUT=> l_rulenames
191: );
192: EXCEPTION
193: WHEN OTHERS THEN
194: FND_MESSAGE.SET_NAME('EDR','EDR_AME_SETUP_ERR');
195: FND_MESSAGE.SET_TOKEN('TXN_TYPE',nvl(l_ame_transaction_type,evt.getEventName()));
196: FND_MESSAGE.SET_TOKEN('ERR_MSG',sqlerrm);
197: APP_EXCEPTION.RAISE_EXCEPTION;
198: END;
191: );
192: EXCEPTION
193: WHEN OTHERS THEN
194: FND_MESSAGE.SET_NAME('EDR','EDR_AME_SETUP_ERR');
195: FND_MESSAGE.SET_TOKEN('TXN_TYPE',nvl(l_ame_transaction_type,evt.getEventName()));
196: FND_MESSAGE.SET_TOKEN('ERR_MSG',sqlerrm);
197: APP_EXCEPTION.RAISE_EXCEPTION;
198: END;
199: --Bug 5287504: End
192: EXCEPTION
193: WHEN OTHERS THEN
194: FND_MESSAGE.SET_NAME('EDR','EDR_AME_SETUP_ERR');
195: FND_MESSAGE.SET_TOKEN('TXN_TYPE',nvl(l_ame_transaction_type,evt.getEventName()));
196: FND_MESSAGE.SET_TOKEN('ERR_MSG',sqlerrm);
197: APP_EXCEPTION.RAISE_EXCEPTION;
198: END;
199: --Bug 5287504: End
200:
261: EXCEPTION
262: WHEN MULTIPLE_ERES_SUBSCRIPTIONS THEN
263: p_status:=false;
264: ROLLBACK TO PSIG_REQUIRED;
265: FND_MESSAGE.SET_NAME('EDR','EDR_MULTI_ERES_SUBSCRP_ERR');
266: fnd_message.set_token( 'EVENT', p_event);
267: RAISE;
268: WHEN OTHERS THEN
269: p_status:=false;
262: WHEN MULTIPLE_ERES_SUBSCRIPTIONS THEN
263: p_status:=false;
264: ROLLBACK TO PSIG_REQUIRED;
265: FND_MESSAGE.SET_NAME('EDR','EDR_MULTI_ERES_SUBSCRP_ERR');
266: fnd_message.set_token( 'EVENT', p_event);
267: RAISE;
268: WHEN OTHERS THEN
269: p_status:=false;
270: ROLLBACK TO PSIG_REQUIRED;
267: RAISE;
268: WHEN OTHERS THEN
269: p_status:=false;
270: ROLLBACK TO PSIG_REQUIRED;
271: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
272: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
273: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_STANDARD');
274: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PSIG_REQUIRED');
275: RAISE;
268: WHEN OTHERS THEN
269: p_status:=false;
270: ROLLBACK TO PSIG_REQUIRED;
271: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
272: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
273: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_STANDARD');
274: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PSIG_REQUIRED');
275: RAISE;
276: END PSIG_REQUIRED;
269: p_status:=false;
270: ROLLBACK TO PSIG_REQUIRED;
271: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
272: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
273: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_STANDARD');
274: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PSIG_REQUIRED');
275: RAISE;
276: END PSIG_REQUIRED;
277:
270: ROLLBACK TO PSIG_REQUIRED;
271: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
272: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
273: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_STANDARD');
274: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PSIG_REQUIRED');
275: RAISE;
276: END PSIG_REQUIRED;
277:
278: /* eRecord Requirement. This Procedure returns signature requirement for a given event.
434: RULEDESCRIPTIONSOUT=> l_rulenames
435: );
436: EXCEPTION
437: WHEN OTHERS THEN
438: FND_MESSAGE.SET_NAME('EDR','EDR_AME_SETUP_ERR');
439: FND_MESSAGE.SET_TOKEN('TXN_TYPE',nvl(l_ame_transaction_type,evt.getEventName()));
440: FND_MESSAGE.SET_TOKEN('ERR_MSG',sqlerrm);
441: APP_EXCEPTION.RAISE_EXCEPTION;
442: END;
435: );
436: EXCEPTION
437: WHEN OTHERS THEN
438: FND_MESSAGE.SET_NAME('EDR','EDR_AME_SETUP_ERR');
439: FND_MESSAGE.SET_TOKEN('TXN_TYPE',nvl(l_ame_transaction_type,evt.getEventName()));
440: FND_MESSAGE.SET_TOKEN('ERR_MSG',sqlerrm);
441: APP_EXCEPTION.RAISE_EXCEPTION;
442: END;
443: --bug 5287504: End
436: EXCEPTION
437: WHEN OTHERS THEN
438: FND_MESSAGE.SET_NAME('EDR','EDR_AME_SETUP_ERR');
439: FND_MESSAGE.SET_TOKEN('TXN_TYPE',nvl(l_ame_transaction_type,evt.getEventName()));
440: FND_MESSAGE.SET_TOKEN('ERR_MSG',sqlerrm);
441: APP_EXCEPTION.RAISE_EXCEPTION;
442: END;
443: --bug 5287504: End
444:
506: EXCEPTION
507: WHEN MULTIPLE_ERES_SUBSCRIPTIONS THEN
508: p_status:=false;
509: ROLLBACK TO EREC_REQUIRED;
510: FND_MESSAGE.SET_NAME('EDR','EDR_MULTI_ERES_SUBSCRP_ERR');
511: fnd_message.set_token( 'EVENT', p_event);
512: RAISE;
513: WHEN OTHERS THEN
514: p_status:=false;
507: WHEN MULTIPLE_ERES_SUBSCRIPTIONS THEN
508: p_status:=false;
509: ROLLBACK TO EREC_REQUIRED;
510: FND_MESSAGE.SET_NAME('EDR','EDR_MULTI_ERES_SUBSCRP_ERR');
511: fnd_message.set_token( 'EVENT', p_event);
512: RAISE;
513: WHEN OTHERS THEN
514: p_status:=false;
515: ROLLBACK TO EREC_REQUIRED;
512: RAISE;
513: WHEN OTHERS THEN
514: p_status:=false;
515: ROLLBACK TO EREC_REQUIRED;
516: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
517: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
518: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_STANDARD');
519: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','EREC_REQUIRED');
520: raise;
513: WHEN OTHERS THEN
514: p_status:=false;
515: ROLLBACK TO EREC_REQUIRED;
516: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
517: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
518: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_STANDARD');
519: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','EREC_REQUIRED');
520: raise;
521: END EREC_REQUIRED;
514: p_status:=false;
515: ROLLBACK TO EREC_REQUIRED;
516: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
517: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
518: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_STANDARD');
519: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','EREC_REQUIRED');
520: raise;
521: END EREC_REQUIRED;
522:
515: ROLLBACK TO EREC_REQUIRED;
516: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
517: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
518: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_STANDARD');
519: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','EREC_REQUIRED');
520: raise;
521: END EREC_REQUIRED;
522:
523: FUNCTION PSIG_QUERY(p_eventQuery EDR_STANDARD.eventQuery) return number IS PRAGMA AUTONOMOUS_TRANSACTION;
940: P_ERR_CODE:=0;
941: EXCEPTION
942: WHEN BAD_FORWARD then
943: P_ERR_CODE:= 20001;
944: FND_MESSAGE.SET_NAME('EDR','EDR_BAD_NTF_RULE');
945: FND_MESSAGE.SET_TOKEN('NAME',WF_Directory.GetRoleDisplayName(p_original_recipient));
946: P_ERR_MSG:= FND_MESSAGE.GET;
947:
948: END FIND_WF_NTF_RECIPIENT;
941: EXCEPTION
942: WHEN BAD_FORWARD then
943: P_ERR_CODE:= 20001;
944: FND_MESSAGE.SET_NAME('EDR','EDR_BAD_NTF_RULE');
945: FND_MESSAGE.SET_TOKEN('NAME',WF_Directory.GetRoleDisplayName(p_original_recipient));
946: P_ERR_MSG:= FND_MESSAGE.GET;
947:
948: END FIND_WF_NTF_RECIPIENT;
949:
942: WHEN BAD_FORWARD then
943: P_ERR_CODE:= 20001;
944: FND_MESSAGE.SET_NAME('EDR','EDR_BAD_NTF_RULE');
945: FND_MESSAGE.SET_TOKEN('NAME',WF_Directory.GetRoleDisplayName(p_original_recipient));
946: P_ERR_MSG:= FND_MESSAGE.GET;
947:
948: END FIND_WF_NTF_RECIPIENT;
949:
950: /*******************************************************************************
1477: END IF;
1478:
1479: EXCEPTION
1480: WHEN errors_received THEN
1481: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1482: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',fnd_flex_descval.error_message);
1483: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_STANDARD');
1484: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','GET_DESC_FLEX_ALL_VALUES');
1485: raise;
1478:
1479: EXCEPTION
1480: WHEN errors_received THEN
1481: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1482: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',fnd_flex_descval.error_message);
1483: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_STANDARD');
1484: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','GET_DESC_FLEX_ALL_VALUES');
1485: raise;
1486: END GET_DESC_FLEX_ALL_VALUES;
1479: EXCEPTION
1480: WHEN errors_received THEN
1481: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1482: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',fnd_flex_descval.error_message);
1483: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_STANDARD');
1484: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','GET_DESC_FLEX_ALL_VALUES');
1485: raise;
1486: END GET_DESC_FLEX_ALL_VALUES;
1487:
1480: WHEN errors_received THEN
1481: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1482: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',fnd_flex_descval.error_message);
1483: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_STANDARD');
1484: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','GET_DESC_FLEX_ALL_VALUES');
1485: raise;
1486: END GET_DESC_FLEX_ALL_VALUES;
1487:
1488: -- Bug 4501520 :rvsingh:end