[Home] [Help]
3139: AND grants.instance_pk5_value = '*NULL*'
3140: and granted_menu.menu_name = 'AMW_ORG_PROC_OWNER_ROLE';
3141:
3142: BEGIN
3143: l_return_status := FND_API.G_RET_STS_SUCCESS;
3144:
3145: IF (p_user_id IS NULL or p_role_name IS NULL) THEN
3146: RETURN;
3147: END IF;
3235: END LOOP; --end of for: violated_cst_rev_id_list.COUNT
3236: EXCEPTION
3237: WHEN OTHERS THEN
3238: fnd_file.put_line(fnd_file.LOG,'unexpected error in Send_Notif_To_Affected_Process: '||sqlerrm);
3239: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3240: END Send_Notif_To_Affected_Process;
3241:
3242: -- ===============================================================
3243: -- Procedure name
3300: 'SELECT u.user_name '
3301: ||' FROM '||G_AMW_USER ||' u '
3302: ||' WHERE u.user_id = :1 ';
3303: BEGIN
3304: x_return_status := FND_API.G_RET_STS_SUCCESS;
3305:
3306: open c_constraint(p_constraint_rev_id);
3307: fetch c_constraint into l_constraint_name;
3308: close c_constraint;
3321: p_display_name => l_display_role_name );
3322:
3323: IF l_to_role_name IS NULL THEN
3324:
3325: x_return_status := FND_API.G_RET_STS_ERROR;
3326: FND_MESSAGE.set_name('AMW','AMW_APPR_INVALID_ROLE');
3327: FND_MSG_PUB.ADD;
3328: fnd_file.put_line(fnd_file.LOG, 'to_role is null');
3329: ELSE
3337: FND_MESSAGE.set_token('CONSTRAINT_NAME', l_constraint_name, TRUE);
3338: FND_MESSAGE.set_token('USER_NAME', l_user_name, TRUE);
3339: FND_MSG_PUB.add;
3340: l_subject := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_LAST,
3341: p_encoded => fnd_api.g_false);
3342:
3343: l_notif_id := WF_NOTIFICATION.send(
3344: role => l_to_role_name,
3345: msg_type => p_item_type,
3355: END LOOP; --end of for: emp_id_list.COUNT
3356: EXCEPTION
3357: WHEN OTHERS THEN
3358: fnd_file.put_line(fnd_file.LOG,'unexpected error in Send_Notif_To_Process_Owner: '||sqlerrm);
3359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3360: END;
3361:
3362:
3363: -- ===============================================================