513:
514: EXCEPTION
515: WHEN OTHERS
516: THEN
517: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
518: THEN
519: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
520: 'fun.plsql.fun_wf_common.get_ame_contacts',
521: SQLERRM || ' Error occurred '||
515: WHEN OTHERS
516: THEN
517: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
518: THEN
519: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
520: 'fun.plsql.fun_wf_common.get_ame_contacts',
521: SQLERRM || ' Error occurred '||
522: ' for transaction ' || l_transaction_id);
523: END IF;
640:
641: EXCEPTION
642: WHEN OTHERS
643: THEN
644: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
645: THEN
646: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
647: 'fun.plsql.fun_wf_common.get_ame_approvers',
648: SQLERRM || ' Error occurred '||
642: WHEN OTHERS
643: THEN
644: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
645: THEN
646: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
647: 'fun.plsql.fun_wf_common.get_ame_approvers',
648: SQLERRM || ' Error occurred '||
649: 'for transaction ' || l_transaction_id);
650: END IF;
863:
864: IF l_invalid_users IS NOT NULL
865: OR l_users IS NULL
866: THEN
867: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
868: THEN
869: fnd_log.string(FND_LOG.LEVEL_ERROR,
870: 'fun.plsql.fun_wf_common.get_ame_role_list',
871: ' Invalid users found without access to org ' ||
865: OR l_users IS NULL
866: THEN
867: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
868: THEN
869: fnd_log.string(FND_LOG.LEVEL_ERROR,
870: 'fun.plsql.fun_wf_common.get_ame_role_list',
871: ' Invalid users found without access to org ' ||
872: 'for transaction ' || p_transaction_id);
873: END IF;
926: EXCEPTION
927:
928: WHEN OTHERS
929: THEN
930: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
931: THEN
932: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
933: 'fun.plsql.fun_wf_common.get_ame_role_list',
934: SQLERRM || ' Error occurred '||
928: WHEN OTHERS
929: THEN
930: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
931: THEN
932: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
933: 'fun.plsql.fun_wf_common.get_ame_role_list',
934: SQLERRM || ' Error occurred '||
935: 'for transaction ' || p_transaction_id);
936: END IF;
1173:
1174: EXCEPTION
1175: WHEN OTHERS
1176: THEN
1177: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1178: THEN
1179: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
1180: 'fun.plsql.fun_wf_common.set_invoice_reqd_flag',
1181: SQLERRM || ' Error occurred '||
1175: WHEN OTHERS
1176: THEN
1177: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1178: THEN
1179: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
1180: 'fun.plsql.fun_wf_common.set_invoice_reqd_flag',
1181: SQLERRM || ' Error occurred '||
1182: 'for batch ' || p_batch_id);
1183: END IF;