149: AddUserToAdHocRole(p_role, l_name);
150: l_count := l_count + 1;
151: EXCEPTION
152: WHEN OTHERS THEN
153: IF ( fnd_log.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
154: fnd_log.string(fnd_log.level_exception,
155: g_package_name || '.add_user_to_role_from_cur',
156: 'AddUserToAdHocRole failed with error '
157: || sqlerrm);
150: l_count := l_count + 1;
151: EXCEPTION
152: WHEN OTHERS THEN
153: IF ( fnd_log.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
154: fnd_log.string(fnd_log.level_exception,
155: g_package_name || '.add_user_to_role_from_cur',
156: 'AddUserToAdHocRole failed with error '
157: || sqlerrm);
158: END IF;
158: END IF;
159: END;
160: END LOOP;
161: CLOSE p_refcur;
162: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
163: fnd_log.string(fnd_log.level_statement,
164: g_log_module || '.add_user_to_role_from_cur',
165: 'count is ' || l_count);
166: END IF;
159: END;
160: END LOOP;
161: CLOSE p_refcur;
162: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
163: fnd_log.string(fnd_log.level_statement,
164: g_log_module || '.add_user_to_role_from_cur',
165: 'count is ' || l_count);
166: END IF;
167: x_count := l_count;
3124:
3125: EXCEPTION
3126: WHEN OTHERS THEN
3127: wf_core.context(g_package_name,'notify_bank_aprv_supp_aprv',l_itemtype,l_itemkey);
3128: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3129: FND_LOG.string(fnd_log.level_error, 'pos_spm_wf_pkg1' , 'Call to notify_bank_aprv_supp_aprv failed');
3130: END IF;
3131: END notify_bank_aprv_supp_aprv;
3132: -- notify the supplier that his/her supplier registration is approved
3125: EXCEPTION
3126: WHEN OTHERS THEN
3127: wf_core.context(g_package_name,'notify_bank_aprv_supp_aprv',l_itemtype,l_itemkey);
3128: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3129: FND_LOG.string(fnd_log.level_error, 'pos_spm_wf_pkg1' , 'Call to notify_bank_aprv_supp_aprv failed');
3130: END IF;
3131: END notify_bank_aprv_supp_aprv;
3132: -- notify the supplier that his/her supplier registration is approved
3133: -- when the user (primary contact) already exists in OID and auto-link of username is enabled
3504: WHEN OTHERS THEN
3505:
3506: wf_core.context(g_package_name,'bc_recert_workflow',l_itemtype,l_itemkey);
3507:
3508: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3509: FND_LOG.string(fnd_log.level_error, 'pos_spm_wf_pkg1' , 'Call to the workflow process for sending reminder notifications for Business Classification Re-Certification failed.');
3510: END IF;
3511:
3512: END bc_recert_workflow;
3505:
3506: wf_core.context(g_package_name,'bc_recert_workflow',l_itemtype,l_itemkey);
3507:
3508: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3509: FND_LOG.string(fnd_log.level_error, 'pos_spm_wf_pkg1' , 'Call to the workflow process for sending reminder notifications for Business Classification Re-Certification failed.');
3510: END IF;
3511:
3512: END bc_recert_workflow;
3513: